v.18.12New Feature
Added ProfileEvents Counters for System Metrics and Taskstats Information
Added ProfileEventscounters that contain the system metrics from rusage (you can use them to get information about CPU usage in userspace and the kernel, page faults, and context switches), as well as taskstats metrics (use these to obtain information about I/O wait time, CPU wait time, and the amount of data read and recorded, both with and without page cache). #2482Why it matters
This feature allows users to monitor detailed system-level resource usage and performance metrics within ClickHouse queries, helping to diagnose and optimize workload execution by exposing CPU times, page faults, context switches, and I/O statistics.How to use it
Users can access these newProfileEvents counters directly in query profiling and monitoring tools to obtain insights about CPU user/system time, page faults, context switches, I/O wait time, and data read/write amounts, both with and without page cache. No additional configuration is required once the feature is available in the ClickHouse version.