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