{"Entry":{"collection":"metric","key":"pg_stat_autovacuum_scores-for_wraparound","name":"pg_stat_autovacuum_scores.for_wraparound","aliases":["for_wraparound","pg_stat_autovacuum_scores"],"metadata":{"aliases":["for_wraparound","pg_stat_autovacuum_scores"],"category":"pg_stat_autovacuum_scores","content_hash":"09a6c24dca974393a5141d513326f8009374fac5d42653777699163f9adc304a","imported_at":"2026-09-30T00:40:45.443343+08:00","name":"pg_stat_autovacuum_scores.for_wraparound","name_zh":"","slug":"pg_stat_autovacuum_scores-for_wraparound","summary":"Whether autovacuum would vacuum the table for wraparound prevention."}},"Definition":{"Collection":"metric","Key":"pg_stat_autovacuum_scores-for_wraparound","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_autovacuum_scores-for_wraparound","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"for_wraparound","sql_type":"bool","units_mentioned":[],"view":"pg_stat_autovacuum_scores"},"comparison_hash":"104b7c07888eba8d59a04a1254c0ec4a7c231677de6b8843cd37af705a53cd36","description":["Whether autovacuum would vacuum the table for wraparound prevention."],"documented":true,"facts":[{"label":"View","value":"pg_stat_autovacuum_scores"},{"label":"Field","value":"for_wraparound"},{"label":"SQL type","value":"bool"},{"label":"Units named in the field definition","value":"Not specified"},{"label":"Reset observation","value":"No stats_reset field is documented for this view"}],"field":"for_wraparound","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 for_wraparound FROM pg_catalog.pg_stat_autovacuum_scores;","paragraphs":["Example query; no execution result or measured value is asserted."],"title":"Inspect this field"}],"signature":"SELECT for_wraparound 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":"bool","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-for_wraparound","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_autovacuum_scores.for_wraparound","Summary":"Whether autovacuum would vacuum the table for wraparound prevention.","BodyHTML":"\u003cp\u003eWhether autovacuum would vacuum the table for wraparound prevention.\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"1b398aac6a710d5361f769239637279243505557c7a42c9340a8c37787e2b69b","Payload":{"description":["Whether autovacuum would vacuum the table for 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 for_wraparound 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}