{"Entry":{"collection":"catalog","key":"pg_stat_autovacuum_scores","name":"pg_stat_autovacuum_scores","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","order":false,"removed":[],"status":"added","to":"19","types":[]}],"column_count":12,"content_hash":"788275f1d5f4a8928db5b40421e592012f8ace880902f45eec268bf9bbd7bd76","first_version":"19","imported_at":"2026-09-30T00:40:55.884479+08:00","kind":"statistics","last_version":"20","name":"pg_stat_autovacuum_scores","position":85,"present_in":["19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:6a33cf8193b74791d8ab910490cef262eb7ceb39c50a604a2db38b65cff214c6","summary":"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.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_autovacuum_scores","SourceDatabase":"center","Version":"20","SourceTable":"catalog","SourceKey":"pg_stat_autovacuum_scores","SourceRevision":"english-manuals:6a33cf8193b74791d8ab910490cef262eb7ceb39c50a604a2db38b65cff214c6","Facts":{"columns":[{"description":"Oid of the table.","description_zh":"","documented":true,"documented_name":"relid","hidden":false,"name":"relid","references":"","type":"oid"},{"description":"Name of the schema that the table is in.","description_zh":"","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","references":"","type":"name"},{"description":"Name of the table.","description_zh":"","documented":true,"documented_name":"relname","hidden":false,"name":"relname","references":"","type":"name"},{"description":"Maximum value of all component scores. This is the value that autovacuum would use to sort the list of tables to process.","description_zh":"","documented":true,"documented_name":"score","hidden":false,"name":"score","references":"","type":"double precision"},{"description":"Transaction ID age component score. Scores greater than autovacuum_freeze_score_weight indicate that autovacuum would vacuum the table for transaction ID wraparound prevention.","description_zh":"","documented":true,"documented_name":"xid_score","hidden":false,"name":"xid_score","references":"","type":"double precision"},{"description":"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.","description_zh":"","documented":true,"documented_name":"mxid_score","hidden":false,"name":"mxid_score","references":"","type":"double precision"},{"description":"Vacuum component score. Scores greater than autovacuum_vacuum_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).","description_zh":"","documented":true,"documented_name":"vacuum_score","hidden":false,"name":"vacuum_score","references":"","type":"double precision"},{"description":"Vacuum insert component score. Scores greater than autovacuum_vacuum_insert_score_weight indicate that autovacuum would vacuum the table (unless autovacuum is disabled).","description_zh":"","documented":true,"documented_name":"vacuum_insert_score","hidden":false,"name":"vacuum_insert_score","references":"","type":"double precision"},{"description":"Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled).","description_zh":"","documented":true,"documented_name":"analyze_score","hidden":false,"name":"analyze_score","references":"","type":"double precision"},{"description":"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.","description_zh":"","documented":true,"documented_name":"do_vacuum","hidden":false,"name":"do_vacuum","references":"","type":"bool"},{"description":"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.","description_zh":"","documented":true,"documented_name":"do_analyze","hidden":false,"name":"do_analyze","references":"","type":"bool"},{"description":"Whether autovacuum would vacuum the table for wraparound prevention.","description_zh":"","documented":true,"documented_name":"for_wraparound","hidden":false,"name":"for_wraparound","references":"","type":"bool"}],"description":"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.","description_zh":"","doc":{"anchor":"PG-STAT-AUTOVACUUM-SCORES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"},"kind":"statistics","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-AUTOVACUUM-SCORES-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_autovacuum_scores","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_stat_autovacuum_scores","Summary":"pg_stat_autovacuum_scores视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，显示该表当前的自动清理评分。对符合处理条件的表，自动清理会根据 score 确定优先级，分数越高优先级越高。更多信息请参阅第 24.1.6.1 节。\n\n该视图的结果生成方式与自动清理工作进程相同，但它使用的是当前源信息，而这可能与自动清理工作进程收集待处理表列表时看到的源信息不同。因此，这个视图并不能完全可靠地指示自动清理会处理哪些表以及处理顺序。","BodyHTML":"\u003cp\u003epg_stat_autovacuum_scores视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，显示该表当前的自动清理评分。对符合处理条件的表，自动清理会根据 score 确定优先级，分数越高优先级越高。更多信息请参阅第 24.1.6.1 节。\n\n该视图的结果生成方式与自动清理工作进程相同，但它使用的是当前源信息，而这可能与自动清理工作进程收集待处理表列表时看到的源信息不同。因此，这个视图并不能完全可靠地指示自动清理会处理哪些表以及处理顺序。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"01978d3a143017981bc64e278c6361d5a8b4a4bd3b8ac1a55f4c69dda58f6232","Payload":{"columns":[{"description_zh":"表的 OID。","name":"relid","type":"oid","zh_from":"doc"},{"description_zh":"表所在模式的名称。","name":"schemaname","type":"name","zh_from":"doc"},{"description_zh":"表名。","name":"relname","type":"name","zh_from":"doc"},{"description_zh":"所有分量评分中的最大值。这也是自动清理用来排序待处理表列表的值。","name":"score","type":"double precision","zh_from":"doc"},{"description_zh":"事务 ID 年龄分量评分。大于autovacuum_freeze_score_weight的分数表示自动清理会为防止事务 ID 回卷而清理该表。","name":"xid_score","type":"double precision","zh_from":"doc"},{"description_zh":"多事务 ID 年龄分量评分。大于autovacuum_multixact_freeze_score_weight的分数表示自动清理会为防止多事务 ID 回卷而清理该表。","name":"mxid_score","type":"double precision","zh_from":"doc"},{"description_zh":"清理分量评分。大于autovacuum_vacuum_score_weight的分数表示自动清理会清理该表（除非自动清理被禁用）。","name":"vacuum_score","type":"double precision","zh_from":"doc"},{"description_zh":"由插入触发的清理分量评分。大于autovacuum_vacuum_insert_score_weight的分数表示自动清理会清理该表（除非自动清理被禁用）。","name":"vacuum_insert_score","type":"double precision","zh_from":"doc"},{"description_zh":"分析分量评分。大于autovacuum_analyze_score_weight的分数表示自动清理会分析该表（除非自动清理被禁用）。","name":"analyze_score","type":"double precision","zh_from":"doc"},{"description_zh":"自动清理是否会清理该表。请注意，即使分量评分表明自动清理会清理该表，如果自动清理被禁用，这里也可能是 false。","name":"do_vacuum","type":"boolean","zh_from":"doc"},{"description_zh":"自动清理是否会分析该表。请注意，即使分量评分表明自动清理会分析该表，如果自动清理被禁用，这里也可能是 false。","name":"do_analyze","type":"boolean","zh_from":"doc"},{"description_zh":"自动清理是否会为了防止回卷而清理该表。","name":"for_wraparound","type":"boolean","zh_from":"doc"}],"description_zh":"pg_stat_autovacuum_scores视图将为当前数据库中的每个表（包括 TOAST 表）包含一行，显示该表当前的自动清理评分。对符合处理条件的表，自动清理会根据 score 确定优先级，分数越高优先级越高。更多信息请参阅第 24.1.6.1 节。\n\n该视图的结果生成方式与自动清理工作进程相同，但它使用的是当前源信息，而这可能与自动清理工作进程收集待处理表列表时看到的源信息不同。因此，这个视图并不能完全可靠地指示自动清理会处理哪些表以及处理顺序。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}