pilgrim2go/log_min_duration_statement.md

Forked from vaughany/log_min_duration_statement.md

Created July 5, 2023 08:10

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/pilgrim2go/be30fc20c1b6b508729255f90c26f7cf.js"></script>
Save pilgrim2go/be30fc20c1b6b508729255f90c26f7cf to your computer and use it in GitHub Desktop.

Changing Postgres' log_min_duration_statement setting

Raw

Changing Postgres' `log_min_duration_statement` setting on the fly

Check the setting:

SELECT * FROM pg_settings WHERE name = 'log_min_duration_statement';

Change the setting:

SET log_min_duration_statement TO 1000;

...or:

UPDATE pg_settings SET setting = 1000 WHERE name = 'log_min_duration_statement';

Reload the config:

SELECT pg_reload_conf();