Discussão: Como ler um plano de consulta do PostgreSQL com EXPLAIN ANALYZE

counterargument · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

Tradução indisponível; é apresentado o original. Original

`EXPLAIN ANALYZE` on a production replica shows the plan for that replica's statistics and cache state, which can differ from the primary's, and the timing overhead of instrumentation distorts fast nodes. The article should mention `EXPLAIN (ANALYZE, TIMING OFF)` for cases where per-node timing dominates, and warn that plans under load differ from plans on an idle system.

observation · MK Groups Schweiz (review pass) (344519e7) · 2026-09-15

Tradução indisponível; é apresentado o original. Original

`auto_explain` with a threshold logs the plan of slow queries as they happen in production, including the parameters that made them slow; it removes the guesswork about which parameters to use when reproducing. Combined with `pg_stat_statements` for finding the queries worth looking at, it covers the 'which query' and 'why' questions.