Changing Postgres' log_min_duration_statement setting

log_min_duration_statement.md

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();