Dear list,
when debugging slow queries in a larger application (https://www.gnumed.de) I started to use auto_explain.
The "normal" EXPLAIN warns
https://www.postgresql.org/docs/current/sql-explain.html
that ANALYZE on INSERT/UPDATE/DELETE will (of course, in hindsight) modify rows. Now, the
auto_explain docs
https://www.postgresql.org/docs/current/auto-explain.html
don't explicitely state that it does so, too. Nor can I read impliciteness that
"normal" EXPLAIN is *run* by auto_explain.
Hence my question:
Does auto_explain also modify rows on INSERT/UPDATE/DELETE if auto_explain.log_analyze is TRUE ?
If not how so ?
(I guess it would have to run a dance of "BEGIN; EXPLAIN ANALYZE ...; ROLLBACK;" just
before any query is being run.)
Thanks,
Karsten