v.21.2New Features
Add Feature Usage Information to system.query_log
Add information about used features (functions, table engines, etc) into system.query_log. #18495. #19371 (Kseniia Sumarokova).
Why it matters
This feature enhances query logging by including metadata about the specific ClickHouse features utilized during query execution. It helps users and administrators better understand query behavior, optimize performance, and troubleshoot issues by providing richer contextual information in the query log.How to use it
After upgrading to the version containing this feature, users can query thesystem.query_log table as usual. The new columns with information about used functions, table engines, and other features will be automatically populated for each query entry without requiring additional configuration.