What does EXPLAIN ANALYZE do in PostgreSQL?
spaceto flip
EXPLAIN shows the planned query execution path. ANALYZE actually runs the query and shows real execution times, row counts, and buffer usage alongside the plan. Always use EXPLAIN (ANALYZE, BUFFERS) for real performance debugging -- the planner's estimates can be wildly wrong.