# What are all of the query time stats in SELECT?

URL: https://select.dev/docs/reference/faq/using-select/what-are-all-of-the-query-time-stats-in-select
Index of all SELECT docs: https://select.dev/docs/llms.txt

> Defines Execution, Compilation, and Queued time metrics, why Execution Time and Total Duration differ, and which one to optimize.

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.