Skip to main content

​
Configure PostgreSQL Settings

Configure the following in the DB Parameter Group (RDS) or postgresql.conf and then restart the server for the settings to take effect.

​
PostgreSQL 12+

ParameterValueDescription
shared_preload_librariespg_stat_statementsRequired. Enables the pg_stat_statements extension for query tracking.
pg_stat_statements.trackallRecommended. Tracks all statements including those inside functions. Default is top (top-level statements only).
pg_stat_statements.max10000Maximum number of statements tracked. Increase if you have many unique queries.
track_activity_query_size4096Controls the maximum length of query text stored in pg_stat_activity and pg_stat_statements. Default is 1024.
Note: After configuring shared_preload_libraries, you must restart PostgreSQL. Then run CREATE EXTENSION IF NOT EXISTS pg_stat_statements; in each database you want to monitor.

​
Optional: Extensions for Enhanced RCA

The following extensions improve Rapydo’s Root Cause Analysis capabilities. Rapydo will work without them, but with reduced RCA functionality.

​
HypoPG (No Restart Required)

Allows Rapydo to test hypothetical indexes without actually creating them, enabling smarter index recommendations. Installation: Run in each database you want to monitor: 
CREATE EXTENSION IF NOT EXISTS hypopg;
Note: HypoPG is safe for production — it creates virtual indexes in memory only during your session, without affecting actual data or consuming disk space. Available on Amazon RDS.

​
pg_hint_plan (Requires Restart)

Allows Rapydo to test alternative execution plans and validate optimization recommendations. Installation:
  1. Add pg_hint_plan to shared_preload_libraries: 
    shared_preload_libraries = 'pg_stat_statements,pg_hint_plan'
  2. Restart PostgreSQL
  3. Run in each database you want to monitor: 
    CREATE EXTENSION IF NOT EXISTS pg_hint_plan;
Note: pg_hint_plan is safe for production — it only affects queries that explicitly use hints. Available on Amazon RDS.