Documentation forSolarWinds Observability

PostgreSQL system requirements

PostgreSQL database requirements

You must enable the pg_stats_statements extension to capture query performance statistics for all versions of PostgreSQL.

Monitoring privileges

For Amazon RDS:

The monitoring user must have the SUPERUSER, rds_superuser, or pg_monitor role. Use the following statements to create a user with these roles on your PostgreSQL instance:

CREATE ROLE dbo NOCREATEDB NOCREATEROLE INHERIT LOGIN PASSWORD '<password here>';
GRANT rds_superuser TO dbo;
GRANT ALL privileges ON ALL TABLES IN SCHEMA public to rds_superuser;

The SUPERUSER privilege is required to:

  • fetch data from pg_stat_activity

  • show EXPLAIN / execution plans

  • show lock metrics

SUPERUSER or rds_superuser is required for remote monitoring because the pg_stat_statements extension requires this privilege to view query text for all users.

For non-RDS PostgreSQL:

The following script can be used to create a user:

CREATE ROLE dbo SUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN PASSWORD '<password here>';

The scripts are not supported under any SolarWinds support program or service. The scripts are provided AS IS without warranty of any kind. SolarWinds further disclaims all warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The risk arising out of the use or performance of the scripts and documentation stays with you. In no event shall SolarWinds or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the scripts or documentation.