SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_autovacuum_scores
Read PG 20 devel manual ↗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.
Development snapshot. These definitions may change before release.
- Kind
- Statistics views
- Columns in this snapshot
- 12
- Definition source
- English manual
Columns 12
| 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. |
Column history across versions
| Column | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
relid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
schemaname | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
relname | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
xid_score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
mxid_score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
vacuum_score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
vacuum_insert_score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
analyze_score | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
do_vacuum | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
do_analyze | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
for_wraparound | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 1
- PG 18 → 19added
Definition snapshot: english-manuals:ba40679c022b0516d8fec41dd7d… · English manual source