Intermediate
Database Management Systems
Q75 / 100
What is the purpose of the EXPLAIN ANALYZE command compared to plain EXPLAIN?
Correct! Well done.
Incorrect.
The correct answer is B) EXPLAIN ANALYZE actually executes the query and reports real row counts and timings alongside the planner's estimates, helping spot inaccurate statistics
B
Correct Answer
EXPLAIN ANALYZE actually executes the query and reports real row counts and timings alongside the planner's estimates, helping spot inaccurate statistics
Explanation
Plain EXPLAIN shows only estimated costs and row counts from the optimizer. EXPLAIN ANALYZE runs the query and adds actual elapsed time and row counts, making it possible to see where estimates diverge sharply from reality, often the root cause of a bad plan.
Progress
75/100