Re: question on auto_explain

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: question on auto_explain
Дата
Msg-id ZMzpulU5HNg0zlzX@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: question on auto_explain  (Julien Rouhaud <rjuju123@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Kalit Inani
Дата:
Сообщение: Re: PITR based recovery failing due to difference in max_connections
Следующее
От: Don Seiler
Дата:
Сообщение: Re: Runaway Initial Table Syncs in Logical Replication?