Wiki / 统计与指标

The mode in which the current VACUUM operation is running. See Section 24.1.5 for details of each mode. Possible values are: normal: The operation is performing a standard vacuum. It is neither required to run in aggressive mode nor operating in failsafe mode. aggressive: The operation is running an aggressive vacuum, which must scan every page that is not marked all-frozen. The parameters vacuum_freeze_table_age and vacuum_multixact_freeze_table_age determine when a table requires aggressive vacuuming. failsafe: The vacuum has entered failsafe mode, in which it performs only the minimum work necessary to avoid transaction ID or multixact ID wraparound failure. The parameters vacuum_failsafe_age and vacuum_multixact_failsafe_age determine when the vacuum enters failsafe mode. The vacuum may start in this mode or switch to it while running; the value of the mode column may transition from another mode to failsafe during the operation.

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

View

pg_stat_progress_vacuum

Field

mode

SQL type

text

Units named in the field definition

Not specified

Reset observation

No stats_reset field is documented for this view

documented

true

field

mode

manual path

/docs/devel/progress-reporting.html

signature

SELECT mode FROM pg_catalog.pg_stat_progress_vacuum;

source only

false

sql type

text

units mentioned

未知

view

pg_stat_progress_vacuum