Re: question on auto_explain - Mailing list pgsql-general

From David G. Johnston
Subject Re: question on auto_explain
Date
Msg-id CAKFQuwa4T-ihtV5sQ=PW86evygx8YFKKXbFUshUCRTdN0eo0Xg@mail.gmail.com
Whole thread Raw
In response to question on auto_explain  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Aw: Re: question on auto_explain  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On Thu, Aug 3, 2023 at 9:29 AM Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
  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.

auto_explain automatically produces the explain output of a query that is running for reals.  The effect is identical to running explain analyze except your output here is whatever the query would produce instead of the explain output, which instead goes into the log.

David J.

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: question on auto_explain
Next
From: Karsten Hilbert
Date:
Subject: Aw: Re: question on auto_explain