diff options
| author | Oscar Najera <hi@oscarnajera.com> | 2025-02-09 20:05:48 +0100 |
|---|---|---|
| committer | Oscar Najera <hi@oscarnajera.com> | 2025-02-09 20:05:48 +0100 |
| commit | 5db6afef2702a9ad0e175df8675dee4607d8476f (patch) | |
| tree | 323aade86b52da60515df63c79078eb3e5e1de45 /webstats/queries.sql | |
| parent | 87ef3a1635aae064bfcfac0be532b9904bdd927d (diff) | |
| download | scratch-5db6afef2702a9ad0e175df8675dee4607d8476f.tar.gz scratch-5db6afef2702a9ad0e175df8675dee4607d8476f.tar.bz2 scratch-5db6afef2702a9ad0e175df8675dee4607d8476f.zip | |
plot site visits
Diffstat (limited to 'webstats/queries.sql')
| -rw-r--r-- | webstats/queries.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/webstats/queries.sql b/webstats/queries.sql index 2a3f762..5e16da0 100644 --- a/webstats/queries.sql +++ b/webstats/queries.sql @@ -19,3 +19,14 @@ DROP TABLE IF EXISTS STATS -- Insert a data point INSERT INTO STATS (click, page, referrer, ip, user_agent, title) VALUES (:click, :page, :referer, :ip, :user_agent, :title) + + +-- name: activity-stats +-- timeseries of activity +SELECT + (timestamp / 600) * 600 AS time, + count(*) +FROM + STATS +GROUP BY + 1; |