Re: Making auto_explain more useful / convenient - Mailing list pgsql-hackers

From Vladimir Churyukin
Subject Re: Making auto_explain more useful / convenient
Date
Msg-id CAFSGpE1L1wy6o78jMDQ1w_PRuwQ9507N5WZu+db_AWe=Oa79Gw@mail.gmail.com
Whole thread Raw
In response to Re:Making auto_explain more useful / convenient  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-hackers
Thank you, that answers the first part of my question.

On Sat, Nov 11, 2023 at 2:43 AM Sergei Kornilov <sk@zsrv.org> wrote:
Hello

auto_explain.log_level is available since postgresql 12.

postgres=# load 'auto_explain';
LOAD
postgres=# set auto_explain.log_min_duration to 0;
SET
postgres=# set auto_explain.log_level to 'notice';
SET
postgres=# select 1;
NOTICE:  duration: 0.010 ms  plan:
Query Text: select 1;
Result  (cost=0.00..0.01 rows=1 width=4)
 ?column?
----------
        1

regards, Sergei

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Making auto_explain more useful / convenient
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_basebackup check vs Windows file path limits