What are all of the query time stats in SELECT?

SELECT includes several time-based metrics across different views.

Metric Definitions

Query History Page

• Execution Time – Actual time spent processing or running the query

• Compilation Time – Time spent parsing and optimizing the query before execution

• Queued Provisioning Time – Time waiting for the warehouse to start up or scale

• Queued Repair Time – Time waiting while warehouse infrastructure is being repaired

• Queued Overload Time – Time waiting because the warehouse is overloaded with queries

• Transaction Blocked Time – Time waiting for transaction locks to release

Workloads Page

The workloads page offers similar metrics which average the time across historical runs of the workload.

For example, Average Execution Time, averages the execution duration across all historical runs of the workload.

Why doesn’t Execution Time equal Total Duration?

Execution Time only measures active query processing.
Total Duration includes all waiting periods (queuing and compilation) in addition to execution.
For example, a query might execute in 5 seconds but have a total duration of 30 seconds if it spent 25 seconds waiting for the warehouse to start.

Which time metric should I optimize?

We recommend focusing on Query Execution time as the best mechanism to reduce Snowflake spend.