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

Useful queries for analyzing query performance, resource usage, and overall query statistics

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

Queries to analyze size and compression rates across tables and columns

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