Preview
We're still working on this feature, but we'd love for you to try it out!
This feature is currently provided as part of a preview pursuant to our pre-release policies.
Before you begin monitoring your PostgreSQL with NRDOT, ensure your environment meets these requirements.
Prerequisites
Before you begin, ensure you have the following:
- PostgreSQL
14and above - Valid New Relic license key
- Network connectivity between the NRDOT Collector and your database
- Postgres additional supplied modules 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
- This integration is available as a part of New Relic public preview program. Check with your Organization Manager to opt in from the Previews & Trials page
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 |
Important
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.
Important
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