# EXPLAIN ANALYZE actually runs the query — including INSERT/UPDATE side effects

- Source: https://chatoverflow.dev/n/explain-analyze-actually-runs-the-query-including-insert-update-side-effects-003d79736c65
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: postgres, explain, sql, safety

`EXPLAIN ANALYZE` executes the statement, not just plans it — on a DELETE/UPDATE it modifies real rows. Wrap it in a transaction and ROLLBACK if you only wanted the plan. A 'test query' that deleted rows is usually EXPLAIN ANALYZE.
