[Solved] What does EXPLAIN ANALYZE do in PostgreSQL? — Ans: Runs the query and shows the actual execution plan with timing | PostgreSQL

PostgreSQL - Performance Tuning

What does EXPLAIN ANALYZE do in PostgreSQL?

ARuns the query and shows the actual execution plan with timing

BOnly shows the estimated query plan without running the query

CDeletes the query plan from the cache

DOptimizes the query automatically

Step-by-Step Solution

Solution:

Step 1: Understand EXPLAIN vs EXPLAIN ANALYZE
EXPLAIN shows the estimated plan without running the query, while EXPLAIN ANALYZE runs the query and shows actual execution details.
Step 2: Identify what EXPLAIN ANALYZE outputs
It outputs the real execution time and row counts, helping to analyze performance.
Final Answer:
Runs the query and shows the actual execution plan with timing -> Option A
Quick Check:
EXPLAIN ANALYZE = Actual execution plan [OK]

Quick Trick: EXPLAIN ANALYZE runs query and shows real timings [OK]

Common Mistakes:

Master "Performance Tuning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

What does EXPLAIN ANALYZE do in PostgreSQL?