{"Entry":{"collection":"metric","key":"pg_stat_autovacuum_scores-mxid_score","name":"pg_stat_autovacuum_scores.mxid_score","aliases":["mxid_score","pg_stat_autovacuum_scores"],"metadata":{"aliases":["mxid_score","pg_stat_autovacuum_scores"],"category":"pg_stat_autovacuum_scores","content_hash":"cebc72c795050942427f90257491a263698ea67008c64c35a840bec1e231ec01","imported_at":"2026-09-30T00:40:45.445602+08:00","name":"pg_stat_autovacuum_scores.mxid_score","name_zh":"","slug":"pg_stat_autovacuum_scores-mxid_score","summary":"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."}},"Definition":{"Collection":"metric","Key":"pg_stat_autovacuum_scores-mxid_score","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_autovacuum_scores-mxid_score","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"mxid_score","sql_type":"double precision","units_mentioned":[],"view":"pg_stat_autovacuum_scores"},"comparison_hash":"1ba3c9e4bf422f335f273fe489cc2363171636a9f771cff3784ecab2bb39ce42","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."],"documented":true,"facts":[{"label":"View","value":"pg_stat_autovacuum_scores"},{"label":"Field","value":"mxid_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":"mxid_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 mxid_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 mxid_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-mxid_score","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_autovacuum_scores.mxid_score","Summary":"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.","BodyHTML":"\u003cp\u003eMultixact ID age component score. Scores greater than autovacuum_multixact_freeze_score_weight indicate that autovacuum would vacuum the table for multixact ID wraparound prevention.\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"d694a1ed399b405fbe3f99a1f4c48977fa615357969c9c758b41844c2be432ef","Payload":{"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."],"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 mxid_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}