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).
Added detailed information about used features such as functions and table engines into the system.query_log table.

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 the system.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.