v.24.3Improvement

Enable Default Processors Profiling for ClickHouse

Enable processors profiling (time spent/in and out bytes for sorting, aggregation, ...) by default. #61096 (Azat Khuzhin).
Enable processors profiling by default to track time spent and byte counts (in and out) for operations such as sorting, aggregation, and more.

Why it matters

This feature provides detailed profiling metrics for internal CPU processors in ClickHouse, including the time consumed and bytes processed during key stages like sorting and aggregation. Enabling this by default helps users to better understand query performance bottlenecks and resource usage without additional configuration.

How to use it

Processors profiling is now enabled by default, so users do not need to take any extra steps to benefit from this feature. Profiling data can be accessed through existing system tables and logs used for performance diagnostics.