Before you begin monitoring your PostgreSQL with NRDOT, ensure your environment meets these requirements.
Prerequisites
Before you begin, ensure you have the following:
- PostgreSQL 14 or later
- A valid New Relic license key
- Network connectivity between the NRDOT Collector and your database
- PostgreSQL's additional supplied modules must be installed. For most installations, this is included by default, but less conventional installations might require an additional installation of your version of the postgresql-contrib package
Recommended server parameters
Configure the following parameters and then restart the server for the settings to take effect. For more information about these parameters, see the Postgres documentation.
Self-hosted
Configure these parameters in the postgresql.conf file.
Required parameters
Parameter | Recommended value | Why |
|---|---|---|
|
| Enables collection of query metrics using the pg_stat_statements extension |
|
| Required for collection of larger queries. Increases the size of SQL text in |
|
| Enables tracking of statements within stored procedures and functions |
|
| Increases the number of normalized queries tracked in |
|
| Saves statistics across server restarts |
|
| Required for |
Optional parameters
Parameter | Recommended value | Why |
|---|---|---|
|
| Disables tracking of utility commands like |
RDS/Aurora
Configure these parameters in the DB parameter group.
Required parameters
Parameter | Recommended value | Why |
|---|---|---|
|
| Enables collection of query metrics using the pg_stat_statements extension |
|
| Required for collection of larger queries. Increases the size of SQL text in |
|
| Enables tracking of statements within stored procedures and functions |
|
| Increases the number of normalized queries tracked in |
|
| Saves statistics across server restarts |
|
| Required for |
Optional parameters
Parameter | Recommended value | Why |
|---|---|---|
|
| Disables tracking of utility commands like |
중요
On RDS/Aurora, track_activity_query_size and pg_stat_statements.max are static parameters. Even when applying them via a parameter group at instance creation, AWS requires apply_method: pending-reboot for them (immediate apply fails with InvalidParameterCombination). A reboot is required for these two to take effect either way.
중요
On Aurora, the DB parameter group family name encodes the major version (for example, aurora-postgresql14, aurora-postgresql16) and must match the cluster or instance's engine version exactly. AWS rejects instance creation with InvalidParameterCombination if they don't match. There is no single family that works across versions.
Next steps
Once you've verified your environment meets these prerequisites:
- Choose your installation method:
- Review the available metrics that will be collected
- Check our troubleshooting guide for common issues