Databases · Middle · Question 11 of 75

What is the difference between `EXPLAIN` and `EXPLAIN ANALYZE`?

1EXPLAIN ANALYZE only checks syntax
2They are identical
✓Correct answer: EXPLAIN shows the planned execution with estimates; EXPLAIN ANALYZE actually runs the query and shows real times and row counts

Explanation

Because ANALYZE runs the query, wrap data-changing statements in BEGIN ... ROLLBACK. Add BUFFERS to see how much data was read.

Further reading

PostgreSQL: Using EXPLAIN ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.