Add Database Information and Fields to System Query Log

Why it matters

This feature improves query diagnostics and auditing by providing detailed insights into the exact databases, tables, and columns accessed by each query. The inclusion of query_kind helps categorize queries, while normalized_query_hash allows efficient grouping of similar queries despite minor differences. This aids in performance analysis, troubleshooting, and query monitoring.

How to use it

Users can access the extended query details by querying the system.query_log table as usual. The new fields query_kind and normalized_query_hash are available alongside existing columns, requiring no special configuration to start collecting this enriched metadata.