Useful queries

Access useful ClickHouse queries, from finding database size, missing blocks, checking table metadata in Zookeeper, and more.
Check table metadata in zookeeper

Check table metadata in zookeeper.

Debug hunging thing

Debug hunging / freezing things

Handy queries for a system.query_log

Handy queries for a system.query_log.

Ingestion metrics from system.part_log

Query to gather information about ingestion rate from system.part_log.

Can detached parts be dropped?

Database Size - Table - Column size


Number of active parts in a partition

Parts consistency

Last modified 2022.02.18: Update (36fe670)