{"Entry":{"collection":"role","key":"pg_stat_scan_tables","name":"pg_stat_scan_tables","aliases":[],"metadata":{"aliases":[],"category":"Monitoring and statistics","content_hash":"02d8b39ab1178693e7d01101c4cad60e4749e97dff1287001352d0b576fc0ac2","imported_at":"2026-09-27T17:57:59.063031+08:00","name":"pg_stat_scan_tables","name_zh":"pg_stat_scan_tables","slug":"pg_stat_scan_tables","summary":"pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."}},"Definition":{"Collection":"role","Key":"pg_stat_scan_tables","SourceDatabase":"center","Version":"18","SourceTable":"predefined_role","SourceKey":"pg_stat_scan_tables","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","Facts":{"description":["pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."],"facts":[{"label":"Name","value":"pg_stat_scan_tables"},{"label":"Manual terminology","value":"Predefined roles"}],"related":[{"label":"pgrowlocks","url":"/docs/18/pgrowlocks.html"}],"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sections":[{"paragraphs":["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."],"title":"Privileges and scope"}],"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR"}]},"ManualEvidence":{"release":{"channel":"stable","label":"18.6","major":"18","ref":"PostgreSQL 18.6 Documentation","revision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75"},"sources":[{"label":"PostgreSQL 18.6 Documentation","sha256":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","url":"/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR"},{"label":"PostgreSQL 18 online manual","url":"https://www.postgresql.org/docs/18/predefined-roles.html#PREDEFINED-ROLE-PG-MONITOR"}]},"MeasuredEvidence":{}},"Text":{"Collection":"role","Key":"pg_stat_scan_tables","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_stat_scan_tables","Summary":"pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension).","BodyHTML":"\u003cp\u003epg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension).\u003c/p\u003e","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","ContentHash":"faee70843f9979e8025a1e64602e626f7210ec3699795511ab91bf058967ef41","Payload":{"description":["pg_stat_scan_tables allows executing monitoring functions that may take ACCESS SHARE locks on tables, potentially for a long time (e.g., pgrowlocks(text) in the pgrowlocks extension)."],"related":[{"label":"pgrowlocks","url":"/docs/18/pgrowlocks.html"}],"sections":[{"paragraphs":["These roles are intended to allow administrators to easily configure a role for the purpose of monitoring the database server. They grant a set of common privileges allowing the role to read various useful configuration settings, statistics, and other system information normally restricted to superusers."],"title":"Privileges and scope"}]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}