Thank you, that answers the first part of my question.
On Sat, Nov 11, 2023 at 2:43 AM Sergei Kornilov <sk(at)zsrv(dot)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
>