v.21.7New Feature

query_log Introduces Initial Query Start Time Columns

Official CH changelog text
Now query_log has two new columns: initial_query_start_time, initial_query_start_time_microsecond that record the starting time of a distributed query if any. #25022 (Amos Bird).
The query_log system table now includes two new columns: initial_query_start_time and initial_query_start_time_microsecond, which capture the start time of a distributed query.

Why it matters

These new columns provide users with precise timing information about when a distributed query originally started, helping to better analyze query execution timings and performance in distributed environments.

How to use it

Users can access the new columns by querying the query_log table as usual. The columns initial_query_start_time and initial_query_start_time_microsecond will contain the start time of the distributed query if applicable.

Related resources

PreviousNext