Wiki / Predefined Roles / Monitoring and statistics

pg_read_all_settings

pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers.

Reading PostgreSQL 18.6.

Description

pg_read_all_settings allows reading all configuration variables, even those normally visible only to superusers.

Name: pg_read_all_settings
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

Compare versions

PostgreSQL 13 → 14: changed.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -6,7 +6,7 @@
     },
     {
       "label": "Manual terminology",
-      "value": "Default roles"
+      "value": "Predefined roles"
     }
   ],
   "signature": null,

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

pg_monitorpg_monitor
pg_read_all_statspg_read_all_stats
pg_stat_scan_tablespg_stat_scan_tables

Export JSON · Back to Predefined Roles · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.