Query phase timing reveals specific performance bottleneck types

Query execution phases (Queued, Analysis, Planning, Execution) indicate where performance bottlenecks occur. High Queued time indicates resource contention, high Analysis time indicates complex metadata operations, high Planning time indicates optimizer complexity, high Execution time indicates data processing or transfer bottlenecks.

For high Queued time: check resource group limits and increase worker capacity or adjust queue priorities. For high Analysis time: review table metadata complexity, partition counts, and metastore performance. For high Planning time: simplify query structure, update optimizer statistics, or check cost-based optimizer configuration. For high Execution time: investigate fragment-level blocked time and CPU usage.