playground · default
Databases +
system 142
query_log
query_log
clusters
replicas
parts
metrics
default 8
analytics 24
logs 6
Saved Queries
slow_queries_last_hour
memory_per_user
merge_progress
Query 1
Query 2
+
⌘↵ to run
1 2 3 4 5 6 7 8
-- top memory-consuming queries in the last hour SELECT user, query_id, formatReadableSize(sum(memory_usage)) AS memory, count() AS queries, formatReadableTimeDelta(max(query_duration_ms) / 1000) AS max_duration FROM system.query_log WHERE event_time > now() - INTERVAL 1 HOUR GROUP BY user, query_id ORDER BY memory DESC LIMIT 10
Elapsed 0.043s
Rows Read 8.42M
Bytes Read 156.7MiB
Memory 412.3MiB
Returned 10 rows
Rows/Sec 195.8M
Result 10 rows × 5 columns OK · 0.043s
userString query_idString memoryString queriesUInt64 max_durationString
analytics_etla3f9-2c1b-...1.42 GiB342 seconds
bi_dashboardb7e1-9d04-...894.6 MiB1218 seconds
analytics_etlc2d8-4f33-...612.3 MiB17 seconds
defaultd5a0-1e22-...445.1 MiB473 seconds
bi_dashboarde9c4-77ab-...388.9 MiB811 seconds
ml_pipelinef1b2-3c90-...301.4 MiB225 seconds
default0a7e-55df-...256.7 MiB1561 second
analytics_etl1c3f-88b1-...198.2 MiB59 seconds
ml_pipeline2d90-44ae-...167.5 MiB314 seconds
bi_dashboard3e15-99c2-...142.8 MiB222 seconds
● Connected cluster: production_eu1 replica: 2/2 v24.3.1 Ln 8, Col 12 UTF-8 SQL