Horton

Re:Making auto_explain more useful / convenient

Sergei Kornilov <sk@zsrv.org>

View thread
From: Sergei Kornilov <sk@zsrv.org>
To: Vladimir Churyukin <vladimir@churyukin.com>
Cc: pghackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-11-11T10:43:47Z
Lists: pgsql-hackers 
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