diff options
Diffstat (limited to '')
| -rw-r--r-- | example-scripts/report-demo.lnav | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/example-scripts/report-demo.lnav b/example-scripts/report-demo.lnav index aeb0040..aa80d4c 100644 --- a/example-scripts/report-demo.lnav +++ b/example-scripts/report-demo.lnav @@ -17,7 +17,7 @@ ;SELECT printf('\n%d total requests', count(1)) AS msg FROM access_log :echo $msg -;WITH top_paths AS ( +;WITH top_paths AS MATERIALIZED ( SELECT cs_uri_stem, count(1) AS total_hits, @@ -28,7 +28,7 @@ GROUP BY cs_uri_stem ORDER BY total_hits DESC LIMIT 50), - weekly_hits_with_gaps AS ( + weekly_hits_with_gaps AS MATERIALIZED ( SELECT timeslice(log_time_msecs, '1w') AS week, cs_uri_stem, count(1) AS weekly_hits |