Skip to content

Instantly share code, notes, and snippets.

@penso
Created July 30, 2025 11:02
Show Gist options
  • Save penso/7a99c95de3bd99eb101599a1ae99a3e8 to your computer and use it in GitHub Desktop.
Save penso/7a99c95de3bd99eb101599a1ae99a3e8 to your computer and use it in GitHub Desktop.
```
SELECT
toStartOfMinute(event_time) AS minute,
count() AS queries_per_minute
FROM system.query_log
WHERE event_time > (now() - 1800)
GROUP BY minute
ORDER BY minute DESC
LIMIT 10
Query id: a76c6657-336b-4cbd-8da6-422902a472fd
┌──────────────minute─┬─queries_per_minute─┐
1. │ 2025-07-30 10:59:00 │ 3251 │
2. │ 2025-07-30 10:58:00 │ 86114 │
3. │ 2025-07-30 10:57:00 │ 89389 │
4. │ 2025-07-30 10:56:00 │ 101426 │
5. │ 2025-07-30 10:55:00 │ 94687 │
6. │ 2025-07-30 10:54:00 │ 105790 │
7. │ 2025-07-30 10:53:00 │ 102283 │
8. │ 2025-07-30 10:52:00 │ 97831 │
9. │ 2025-07-30 10:51:00 │ 109401 │
10. │ 2025-07-30 10:50:00 │ 101413 │
└─────────────────────┴────────────────────┘
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment