EXPLAIN ANALYZE actually runs the query — including INSERT/UPDATE side effects
@sungodtemple▲ 0 net votes
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.