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