{"Entry":{"collection":"metric","key":"pg_stat_autovacuum_scores-vacuum_score","name":"pg_stat_autovacuum_scores.vacuum_score","aliases":["vacuum_score","pg_stat_autovacuum_scores"],"metadata":{"aliases":["vacuum_score","pg_stat_autovacuum_scores"],"category":"pg_stat_autovacuum_scores","content_hash":"ffc017981dfdd5decf92a30f6b83dc3431ee3ad69d60c3c554f7e4ca42b7342a","imported_at":"2026-09-30T00:40:45.457208+08:00","name":"pg_stat_autovacuum_scores.vacuum_score","name_zh":"","slug":"pg_stat_autovacuum_scores-vacuum_score","summary":"Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled)."}},"Definition":{"Collection":"metric","Key":"pg_stat_autovacuum_scores-vacuum_score","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_autovacuum_scores-vacuum_score","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"vacuum_score","sql_type":"double precision","units_mentioned":[],"view":"pg_stat_autovacuum_scores"},"comparison_hash":"7f8fbdb54820194344ccc527cf3b3811fe9ef7a71d958763777e57946f741234","description":["Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled)."],"documented":true,"facts":[{"label":"View","value":"pg_stat_autovacuum_scores"},{"label":"Field","value":"vacuum_score"},{"label":"SQL type","value":"double precision"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"vacuum_score","manual_html":"","manual_path":"/docs/devel/monitoring-stats.html","related":[{"label":"pg_stat_autovacuum_scores columns","url":"/wiki/catalog/pg_stat_autovacuum_scores/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sections":[{"paragraphs":["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. Autovacuum prioritizes tables deemed eligible for processing based on their score, with higher scores indicating higher priority. See Section 24.1.6.1 for more information.\n\nWhile this view generates its results the same way that autovacuum workers do, it does so using the current source information, which might differ from the source information that an autovacuum worker sees when it gathers its list of tables to process. Therefore, this view is not a completely reliable indicator of which tables autovacuum will process and what order it will process them."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT vacuum_score FROM pg_catalog.pg_stat_autovacuum_scores;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT vacuum_score FROM pg_catalog.pg_stat_autovacuum_scores;","source_only":false,"sources":[{"label":"PostgreSQL 20 English manual","path":"monitoring-stats.html","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","url":"/docs/devel/monitoring-stats.html#PG-STAT-AUTOVACUUM-SCORES-VIEW"}],"sql_type":"double precision","tables":[],"units_mentioned":[],"view":"pg_stat_autovacuum_scores"},"ManualEvidence":{"manual_path":"/docs/devel/monitoring-stats.html","release":{"channel":"devel","label":"20devel","major":"20","ref":"https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2","revision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"},"sources":[{"label":"PostgreSQL 20 English manual","path":"monitoring-stats.html","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","url":"/docs/devel/monitoring-stats.html#PG-STAT-AUTOVACUUM-SCORES-VIEW"}]},"MeasuredEvidence":{}},"Text":{"Collection":"metric","Key":"pg_stat_autovacuum_scores-vacuum_score","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_autovacuum_scores.vacuum_score","Summary":"Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).","BodyHTML":"\u003cp\u003eVacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"d5a1dfbe71a68a8d37e2156c832867ca99743e2845a3ff732e13f042380739dd","Payload":{"description":["Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled)."],"manual_html":"","related":[{"label":"pg_stat_autovacuum_scores columns","url":"/wiki/catalog/pg_stat_autovacuum_scores/?v=20"},{"label":"Statistics collection and reset functions","url":"/docs/devel/monitoring-stats.html"}],"sections":[{"paragraphs":["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. Autovacuum prioritizes tables deemed eligible for processing based on their score, with higher scores indicating higher priority. See Section 24.1.6.1 for more information.\n\nWhile this view generates its results the same way that autovacuum workers do, it does so using the current source information, which might differ from the source information that an autovacuum worker sees when it gathers its list of tables to process. Therefore, this view is not a completely reliable indicator of which tables autovacuum will process and what order it will process them."],"title":"View semantics"},{"paragraphs":["Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name."],"title":"Collection and reset context"},{"code":"SELECT vacuum_score FROM pg_catalog.pg_stat_autovacuum_scores;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}