summaryrefslogtreecommitdiffstats
path: root/example-scripts/report-demo.lnav
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--example-scripts/report-demo.lnav4
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