Re: question on auto_explain

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: question on auto_explain
Date: 2023-08-03 16:35:12
Message-ID: CAKFQuwa4T-ihtV5sQ=PW86evygx8YFKKXbFUshUCRTdN0eo0Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 3, 2023 at 9:29 AM Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2023-08-03 16:53:28 Aw: Re: question on auto_explain
Previous Message Karsten Hilbert 2023-08-03 16:29:45 question on auto_explain