v.23.5Improvement
New 'partitions' Field Added to system.query_log for Calculation Participation Tracking
A new fieldpartitionstosystem.query_logis used to indicate which partitions are participating in the calculation. #49779 (helifu).
Why it matters
This feature provides detailed visibility into the specific table partitions accessed during query processing. It helps users understand query performance and troubleshoot data partitioning-related issues more effectively by knowing exactly which partitions contribute to the query results.How to use it
Users can query thesystem.query_log table and include the new partitions field in their SELECT statements to see the partitions involved in each query execution.