Enhanced Setup

Once you've created the pgTop role and added the database you can use pgTop. However, depending on your database configuration some of the commands might not work correctly. You may need to run a few extra commands.

If you have any question, feedback or need help, don't hesitate to get in touch at pgtop@alby.fr

Enabling pg_stat_statements

pg_stat_statements is a helpful extension usually shipped with PostgreSQL. pgTop relies on the extension for some of it's commands. You'll need to enable in your database, if you haven't already done so.

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

ERROR: pg_stat_statements must be loaded via shared_preload_libraries

You may be getting this error as an Amazon RDS user. In AWS, shared libraries msut be configured to install the extension.
See AWS instructions to enable pg_stat_statements.