Useful queries

Check table metadata in zookeeper

Check table metadata in zookeeper.

Compare query_log for 2 intervals

Compare query performance across different time periods

Debug hanging thing

Debug hanging / freezing things

Handy queries for 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.

Remove block numbers from zookeeper for removed partitions

Removing tasks in the replication queue related to empty partitions

Can detached parts in ClickHouse® be dropped?

Cleaning up detached parts without data loss

Database Size - Table - Column size

Notes on Various Errors with respect to replication and distributed connections

Notes on errors related to replication and distributed connections

Number of active parts in a partition

Parts consistency