What additional information does EXPLAIN ANALYZE provide compared to EXPLAIN in Presto?
Select an answer to reveal the explanation.
Short Explanation and Infographic
EXPLAIN ANALYZE runs the actual query and augments the execution plan with real metrics — actual row counts; wall clock time; and CPU time per stage — enabling precise identification of performance bottlenecks.
Full explanation below image
Full Explanation
EXPLAIN ANALYZE runs the actual query and augments the execution plan with real metrics — actual row counts; wall clock time; and CPU time per stage — enabling precise identification of performance bottlenecks. The incorrect options ("EXPLAIN ANALYZE generates the table DDL while EXPLAIN shows only the query plan", "EXPLAIN ANALYZE rewrites the query for better performance before displaying the plan", "EXPLAIN ANALYZE validates query syntax without accessing any data") are distractors that don't fully capture the concept described.