v.18.12New Feature

System Query Log and Processes Tables Updated with Thread Count Information

Official CH changelog text
The system.query_log and system.processes tables now show information about the number of threads that are participating in query execution (see the thread_numbers column). #2482
The system.query_log and system.processes tables have been enhanced to include a new thread_numbers column that shows the count of threads involved in query execution.

Why it matters

This feature provides insight into the parallelism and threading behavior of queries, allowing users to better monitor and analyze query execution performance across multiple threads.

How to use it

Users can query the system.query_log and system.processes tables and include the thread_numbers column in their SELECT statements to see how many threads are used for each query.

Related resources

PreviousNext