question on auto_explain

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

Responses

Browse pgsql-general by date

  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