v.20.7Improvement
Add QueryTimeMicroseconds Metrics to system.events
AddQueryTimeMicroseconds,SelectQueryTimeMicrosecondsandInsertQueryTimeMicrosecondstosystem.events, along with system.metrics, processes, query_log, etc. #13028 (ianton-ru).
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 thesystem.events system table.How to use it
Users can query thesystem.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.