Wiki / 配置参数

Sets 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. Sampling is stochastic, for example 0.1 means there is statistically one chance in ten that any given transaction will be logged. log_transaction_sample_rate can be helpful to construct a sample of transactions. The default is 0, meaning not to log statements from any additional transactions. Setting this to 1 logs all statements of all transactions. Only superusers and users with the appropriate SET privilege can change this setting. Note Like all statement-logging options, this option can add significant overhead.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

0

category

Reporting and Logging / When to Log

context

superuser

documented

true

enumvals

未知

extra desc

Use a value between 0.0 (never log) and 1.0 (log all statements for all transactions).

lang

en

max val

1

metadata version

18

min val

0

name

log_transaction_sample_rate

short desc

Sets the fraction of transactions from which to log all statements.

source

pg-settings-source-snapshot

unit

未知

vartype

real