What does 'EXPLAIN ANALYZE' reveal that 'EXPLAIN' alone does not?
- A The estimated row count
- B Actual execution times and row counts from really running the query (correct answer)
- C The index definitions
- D The lock modes taken
Shortcut: EXPLAIN shows the planner's estimates; EXPLAIN ANALYZE executes the statement and reports real timings and row counts, exposing bad estimates and missing indexes.