v.20.7Improvement

Add QueryTimeMicroseconds Metrics to system.events

Add QueryTimeMicroseconds, SelectQueryTimeMicroseconds and InsertQueryTimeMicroseconds to system.events, along with system.metrics, processes, query_log, etc. #13028 (ianton-ru).
Added QueryTimeMicroseconds, SelectQueryTimeMicroseconds, and InsertQueryTimeMicroseconds to the system.events table, enhancing timing metrics available alongside system.metrics, processes, and query_log.

Why it matters

This feature provides more granular query timing metrics in microseconds, enabling users to better monitor and analyze the performance of queries, specifically select and insert operations, directly through the system.events system table.

How to use it

Users can query the system.events table to access the new timing metrics QueryTimeMicroseconds, SelectQueryTimeMicroseconds, and InsertQueryTimeMicroseconds to measure query execution times with microsecond precision. No additional configuration is required.