From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | question on auto_explain |
Date: | 2023-08-03 16:29:45 |
Message-ID: | trinity-606c746c-267c-4492-a262-bb6b287e7490-1691080184980@3c-app-gmx-bs14 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-08-03 16:35:12 | Re: question on auto_explain |
Previous Message | Ron | 2023-08-02 15:51:01 | Re: Different releases in the same server |