Re: question on auto_explain - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: question on auto_explain
Date
Msg-id ZMzpulU5HNg0zlzX@hermes.hilbert.loc
Whole thread Raw
In response to Re: question on auto_explain  (Julien Rouhaud <rjuju123@gmail.com>)
List 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



pgsql-general by date:

Previous
From: Kalit Inani
Date:
Subject: Re: PITR based recovery failing due to difference in max_connections
Next
From: Don Seiler
Date:
Subject: Re: Runaway Initial Table Syncs in Logical Replication?