Wiki / 配置参数

Causes each action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs all autovacuum actions. -1 disables logging autovacuum actions. If this value is specified without units, it is taken as milliseconds. For example, if you set this to 250ms then all automatic vacuums and analyzes that run 250ms or longer will be logged. In addition, when this parameter is set to any value other than -1, a message will be logged if an autovacuum action is skipped due to a conflicting lock or a concurrently dropped relation. The default is 10min. Enabling this parameter can be helpful in tracking autovacuum activity. This parameter can only be set in the postgresql.conf file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters.

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

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

boot val

600000

category

Reporting and Logging / What to Log

context

sighup

documented

true

enumvals

未知

extra desc

-1 disables logging autovacuum actions. 0 means log all autovacuum actions.

lang

en

max val

2147483647

metadata version

18

min val

-1

name

log_autovacuum_min_duration

short desc

Sets the minimum execution time above which autovacuum actions will be logged.

source

pg-settings-source-snapshot

unit

ms

vartype

integer