Documentation / Predefined Roles / Monitoring and statistics
pg_read_all_stats
pg_read_all_stats
pg_read_all_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers.
Reading PostgreSQL 18.6.
Description
pg_read_all_stats allows reading all pg_stat_* views and use various statistics related extensions, even those normally visible only to superusers.
- Name
- pg_read_all_stats
- 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_monitorpg_monitorpg_read_all_settingspg_read_all_settingspg_stat_scan_tablespg_stat_scan_tables
Back to Predefined Roles · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.