PostgreSQL system requirements
PostgreSQL database requirements
You must enable the
pg_stats_statements extension to capture query performance statistics for all versions of PostgreSQL.
For Amazon RDS:
The monitoring user must have the
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;
SUPERUSER privilege is required to:
fetch data from
show EXPLAIN / execution plans
show lock metrics
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.