question on auto_explain
От | Karsten Hilbert |
---|---|
Тема | question on auto_explain |
Дата | |
Msg-id | trinity-606c746c-267c-4492-a262-bb6b287e7490-1691080184980@3c-app-gmx-bs14 обсуждение исходный текст |
Ответы |
Re: question on auto_explain
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: