log_min_duration_sample

A configuration parameter determining the minimum duration of statements to be logged by log_statement_sample_rate

log_min_duration_sample is a configuration parameter determining the minimum duration of statements to be logged by log_statement_sample_rate.

log_min_duration_sample was added in PostgreSQL 13 (commit 6e3e6cc0).

Default

The default value for log_min_duration_sample is: -1.

Applying changes

Changes to log_min_duration_sample can be applied with pg_reload_conf(), pg_ctl reload or SIGHUP.

Details

PostgreSQL 13

postgres=# SELECT * FROM pg_settings WHERE name='log_min_duration_sample';
-[ RECORD 1 ]---+------------------------------------------------------------------------------------ name | log_min_duration_sample setting | -1 unit | ms category | Reporting and Logging / When to Log short_desc | Sets the minimum execution time above which a sample of statements will be logged. | Sampling is determined by log_statement_sample_rate. extra_desc | Zero log a sample of all queries. -1 turns this feature off. context | superuser vartype | integer source | default min_val | -1 max_val | 2147483647 enumvals | boot_val | -1 reset_val | -1 sourcefile | sourceline | pending_restart | f

Change history

Categories

Configuration, Logging

See also

log_statement_sample_rate, log_min_duration_statement