Documentation / Predefined Roles / Monitoring and statistics
pg_stat_scan_tables
pg_stat_scan_tables
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).
Reading PostgreSQL 18.6.
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).
- Name
- pg_stat_scan_tables
- 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.
Related entries
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_read_all_statspg_read_all_stats
Back to Predefined Roles · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.