{"Entry":{"collection":"role","key":"pg_monitor","name":"pg_monitor","aliases":[],"metadata":{"aliases":[],"category":"Monitoring and statistics","content_hash":"9ffded9bcb2385bda86d0823231d45934eb73d4aa9c118f0fce1c28ec38e7f57","derived_content_hash":"b3d665824c8e554cfbda055340481ba7f3add229b76740a451b29ec414cc6c3e","imported_at":"2026-09-27T17:57:59.051792+08:00","name":"pg_monitor","name_zh":"pg_monitor","repair_provenance":{"original_source_revision":"","receipt_sha256":"1bbb53a1d35191e0fdf88a71dc27602c5f7f20ddb97adb52d5836f3271b2aea9","repair":"wiki-repair-20261023"},"slug":"pg_monitor","source_rev":"wiki-repair-20261023:62887cdc5a3c73df6ed2ac97a7815a5a8f0434ff9ab5a6d124892d12bd7241f0","summary":"pg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."}},"Definition":{"Collection":"role","Key":"pg_monitor","SourceDatabase":"center","Version":"18","SourceTable":"predefined_role","SourceKey":"pg_monitor","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","Facts":{"description":["pg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."],"description_zh":"这些角色旨在让管理员能够方便地为监控数据库服务器配置一个角色。它们授予一组常见权限，使该角色能够读取各种有用的配置设置、统计信息以及其他通常仅限超级用户查看的系统信息。","description_zh_html":"\u003cp\u003e\n       这些角色旨在让管理员能够方便地为监控数据库服务器配置一个角色。它们授予一组常见权限，使该角色能够读取各种有用的配置设置、统计信息以及其他通常仅限超级用户查看的系统信息。\n      \u003c/p\u003e\u003cp\u003e\n\u003ccode class=\"literal\"\u003epg_monitor\u003c/code\u003e 允许读取或执行各种监控视图和函数。该角色是 \u003ccode class=\"literal\"\u003epg_read_all_settings\u003c/code\u003e、\u003ccode class=\"literal\"\u003epg_read_all_stats\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003epg_stat_scan_tables\u003c/code\u003e 的成员。\n      \u003c/p\u003e","facts":[{"label":"Name","value":"pg_monitor"},{"label":"Manual terminology","value":"Predefined roles"}],"related":[],"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"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/predefined-roles.html","sha256":"99e1fbd83b1da2cf9da5823238b31d78c953c6118ecc61939808d2bf32f9b56d"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-pgdoc"},"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_monitor","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_monitor","Summary":"pg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables .","BodyHTML":"\u003cp\u003epg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables .\u003c/p\u003e","SourceRevision":"b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75","ContentHash":"53462baf012282eb219ef976a5bd7813a5fa734d5586108db9f66669bda47a31","Payload":{"description":["pg_monitor allows reading/executing various monitoring views and functions. This role is a member of pg_read_all_settings , pg_read_all_stats and pg_stat_scan_tables ."],"related":[],"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":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}