{"Entry":{"collection":"metric","key":"pg_stat_autovacuum_scores-analyze_score","name":"pg_stat_autovacuum_scores.analyze_score","aliases":["analyze_score","pg_stat_autovacuum_scores"],"metadata":{"aliases":["analyze_score","pg_stat_autovacuum_scores"],"category":"pg_stat_autovacuum_scores","content_hash":"d8c36ac08f51a272241a5c4b5f9c1a77ec2cefcf7e18c405b9bf6384271573d9","imported_at":"2026-09-30T00:40:45.436736+08:00","name":"pg_stat_autovacuum_scores.analyze_score","name_zh":"","slug":"pg_stat_autovacuum_scores-analyze_score","summary":"Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled)."}},"Definition":{"Collection":"metric","Key":"pg_stat_autovacuum_scores-analyze_score","SourceDatabase":"center","Version":"20","SourceTable":"statistics_metric","SourceKey":"pg_stat_autovacuum_scores-analyze_score","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","Facts":{"comparison_data":{"field":"analyze_score","sql_type":"double precision","units_mentioned":[],"view":"pg_stat_autovacuum_scores"},"comparison_hash":"5bf929ea14d1a5fe5c402f343f013c84030b2389eb19cb45cfab1b2a084230f0","description":["Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled)."],"documented":true,"facts":[{"label":"View","value":"pg_stat_autovacuum_scores"},{"label":"Field","value":"analyze_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":"analyze_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 analyze_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 analyze_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-analyze_score","SourceDatabase":"center","Version":"20","Locale":"en","Title":"pg_stat_autovacuum_scores.analyze_score","Summary":"Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled).","BodyHTML":"\u003cp\u003eAnalyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze the table (unless autovacuum is disabled).\u003c/p\u003e","SourceRevision":"4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41","ContentHash":"fa8878699072ae8dcffcd772d532f27dd32371fd0b23e4526455a977bb1a0cbc","Payload":{"description":["Analyze component score. Scores greater than autovacuum_analyze_score_weight indicate that autovacuum would analyze 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 analyze_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}