Step 1: Configure RDS Instance

In order to setup pganalyze monitoring for Amazon RDS or Amazon Aurora for Postgres you'll need to enable the pg_stat_statements extension for collecting query statistics.

Enabling pg_stat_statements

Connect to your database as an RDS superuser (usually the credentials you created the database with), e.g. using psql.

Run the following SQL commands to enable the extension, and make sure it was installed correctly:

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
SELECT * FROM pg_stat_statements LIMIT 1;

This should return one row of query statistics information.

Important: If you get the error pg_stat_statements must be loaded via shared_preload_libraries, follow the troubleshooting document.

Review pg_stat_statements configuration parameters

See Configure PostgreSQL section of Enabling pg_stat_statements for some change recommendations of the pg_stat_statements settings.

With RDS, you can apply these changes with the Parameter Group. for your database and apply the settings above.

Enable Enhanced Monitoring

We also highly recommend turning on Enhanced Monitoring, if you haven't already - it will give you more detailed system-level statistics that can be helpful, e.g. to debug I/O issues.

If Enhanced Monitoring is enabled, pganalyze will automatically collect and show this additional information in the dashboard as well.