Documentation / Predefined Roles / Monitoring and statistics
pg_monitor
pg_monitor
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 .
Reading PostgreSQL 18.6.
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 .
- Name
- pg_monitor
- Manual terminology
- Predefined roles
Privileges and scope
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.
Documentation and source
Source build
- Version
- 18.6
- Build
- PostgreSQL 18.6 Documentation
- Source fingerprint
b7ebd726e6017f55081b4034b96d6a3289ae7937a26adaf72e58b9a08e009c75
Related entries
pg_read_all_settingspg_read_all_settingspg_read_all_statspg_read_all_statspg_stat_scan_tablespg_stat_scan_tables
Back to Predefined Roles · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.