Re: Making auto_explain more useful / convenient

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
>