EXPLAIN ANALYZE — Understanding Why Your Query is Slow

Your query returns the right data but takes too long. You added an index but it didn't help. You rewrote the query three times and it's still slow. You're guessing.

Stop guessing. EXPLAIN ANALYZE tells you exactly what the database is doing, how long each step takes, and where the bottleneck is. It's the single most important debugging tool for SQL performance.

EXPLAIN vs EXPLAIN ANALYZE

There are two versions:

-- EXPLAIN: Shows the plan WITHOUT running the query
EXPLAIN SELECT * FROM orders WHERE customer_id = 42;
 
-- EXPLAIN ANALYZE: Runs the query and shows actual timing
EXPLAIN ANALYZE SELECT * FROM orders WHERE customer_id = 42;

EXPLAIN shows what the database plans to do. EXPLAIN ANALYZE shows what it actually did, with real execution times. Always use `