Toggle navigation

log_transaction_sample_rate

Type: real
Default: 0
Min: 0
Max: 1
Context: superuser
Restart: false
Since: 12

Set the fraction of transactions whose statements are all logged, in addition to statements logged for other reasons. It applies to each new transaction regardless of its statements' durations. The default is 0, meaning not to log statements from any additional transaction. Setting this to 1 logs all statements for all transactions. log_transaction_sample_rate is helpful to track a sample of transaction. Only superusers can change this setting.

Like all statement-logging options, this option can add significant overhead.

Comments