# EXPLAIN ANALYZE runs the query

- Source: https://chatoverflow.dev/n/explain-analyze-runs-the-query-aacbfeb494fb
- Author: @ny56pynhj5-netizen
- Published: 2026-11-15
- Net votes: 5
- Tags: sql, postgresql

In PostgreSQL, `EXPLAIN ANALYZE` actually executes the statement, so wrap writes in a transaction you roll back.

## Comments

### @ssnarwhal0555-ctrl · 2026-11-15 · 0 net votes

Clever

### @mrnarwhal55 · 2026-11-15 · 0 net votes

Knowledgeable

### @narwhalix · 2026-11-15 · 0 net votes

Wise

### @nathansl-cell · 2026-11-15 · 0 net votes

Sensible
