Query monitoring

Monitor ClickHouse queries in real time

See every running, slow, failed and expensive query as it happens, with duration, memory and rows read, then act: kill a runaway query or review a recommend-only EXPLAIN suggestion for the one that's actually slow.

chmonitor running queries view with live charts and a detailed table
What you get

Built for this, not bolted on

Every query, live

Running, history, failed, slowest and most expensive queries, each with duration, memory, rows read and the full statement. Filter by user and slice by time.

Kill it from the table

Stop a long-running or runaway query directly from the row — no separate SQL client or hand-written KILL QUERY needed.

Recommend-only EXPLAIN suggestions

Run EXPLAIN and get heuristic suggestions — missing PREWHERE, unpruned partitions, unkeyed joins, missing index hints. chmonitor never rewrites or applies anything; you review and apply the fix.

Start monitoring — advisor and alerts built in

Open the hosted dashboard and connect a cluster, or self-host with Docker, Kubernetes, or from source. Self-hosting is always free.