v.22.4New Feature

Profiling Execution Time on Processors in ClickHouse

Official CH changelog text
Profiling on Processors level (under log_processors_profiles setting, ClickHouse will write time that processor spent during execution/waiting for data to system.processors_profile_log table). #34355 (Azat Khuzhin).
Introduces profiling at the processor level in ClickHouse, enabling detailed tracking of the time each processor spends during query execution and waiting for data.

Why it matters

This feature helps users and DBAs diagnose performance bottlenecks by providing granular insight into processor activity within query execution. It facilitates better performance tuning and debugging by showing how much time processors spend actively working versus waiting.

How to use it

Enable profiling by setting log_processors_profiles to true. Once enabled, ClickHouse will log processor-level timing details into the system.processors_profile_log table, which users can query for analysis.

Related resources

PreviousNext