v.25.9New Feature

Adds a new system.aggregated_zookeeper_log table

Official CH changelog text
Adds a new system.aggregated_zookeeper_log table. The table contains statistics (e.g. number of operations, average latency, errors) of ZooKeeper operations grouped by session id, parent path and operation type, and periodically flushed to disk. #85102 #87208 (Miсhael Stetsyuk).
Introduces a new system.aggregated_zookeeper_log table that provides aggregated statistics on ZooKeeper operations such as operation counts, average latency, and error rates, grouped by session ID, parent path, and operation type.

Why it matters

This feature helps users monitor and analyze the performance and reliability of ZooKeeper interactions within ClickHouse by aggregating key metrics. It enables easier identification of operational issues and performance bottlenecks related to ZooKeeper, improving observability and troubleshooting.

How to use it

Users can query the system.aggregated_zookeeper_log table to retrieve aggregated ZooKeeper statistics. The data is periodically flushed to disk automatically, requiring no manual configuration to enable the feature.

Related resources

PreviousNext