diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-07 04:48:35 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-05-07 04:48:35 +0000 |
| commit | 207df6fc406e81bfeebdff7f404bd242ff3f099f (patch) | |
| tree | a1a796b056909dd0a04ffec163db9363a8757808 /example-scripts | |
| parent | Releasing progress-linux version 0.11.2-1~progress7.99u1. (diff) | |
| download | lnav-207df6fc406e81bfeebdff7f404bd242ff3f099f.tar.xz lnav-207df6fc406e81bfeebdff7f404bd242ff3f099f.zip | |
Merging upstream version 0.12.2.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'example-scripts')
| -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 |