Re: question on auto_explain

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: question on auto_explain
Date: 2023-08-04 12:06:18
Message-ID: ZMzpulU5HNg0zlzX@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Fri, Aug 04, 2023 at 01:33:19PM +0800 schrieb Julien Rouhaud:

> > explicit hint towards write query side effects.
>
> The docs says that it automatically shows the execution plans, not that it's
> itself doing an EXPLAIN.

Yep, so maybe _that_ point warrants being pointed out: that
auto_explain *doesn't* suffer from plain EXPLAIN write-query
"side effects" because it instruments normally-run queries
and just outputs to the log extra information (the plans).

Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Don Seiler 2023-08-04 14:28:48 Re: Runaway Initial Table Syncs in Logical Replication?
Previous Message Kalit Inani 2023-08-04 08:57:13 Re: PITR based recovery failing due to difference in max_connections