pg_stat_autovacuum_scores

The pg_stat_autovacuum_scores view will contain one row for each table in the current database (including TOAST tables), showing the current autovacuum scores for that specific table.

Reading PG 20devel·documented in 2 of 24 versions, 19 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Development snapshot. These definitions may change before release.

Kind: Statistics views
Columns in this snapshot: 12
Definition source: English manual

Columns 12

As listed in the PostgreSQL 20 devel manual.

Column	Type	Description / reference
`relid`	`oid`	Oid of the table.
`schemaname`	`name`	Name of the schema that the table is in.
`relname`	`name`	Name of the table.
`score`	`double precision`	Maximum value of all component scores. This is the value that autovacuum would use to sort the list of tables to process.
`xid_score`	`double precision`	Transaction ID age component score. Scores greater than autovacuum_freeze_score_weight indicate that autovacuum would vacuum the table for transaction ID wraparound prevention.
`mxid_score`	`double precision`	Multixact ID age component score. Scores greater than autovacuum_multixact_freeze_score_weight indicate that autovacuum would vacuum the table for multixact ID wraparound prevention.
`vacuum_score`	`double precision`	Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).
`vacuum_insert_score`	`double precision`	Vacuum insert component score. Scores greater than autovacuum_vacuum_insert_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).
`analyze_score`	`double precision`	Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled).
`do_vacuum`	`bool`	Whether autovacuum would vacuum the table. Note that even if the component scores indicate that autovacuum would vacuum the table, this may be false if autovacuum is disabled.
`do_analyze`	`bool`	Whether autovacuum would analyze the table. Note that even if the component scores indicate that autovacuum would analyze the table, this may be false if autovacuum is disabled.
`for_wraparound`	`bool`	Whether autovacuum would vacuum the table for wraparound prevention.