PostgreSQL monitoring
This extension documentation is now deprecated and will no longer be updated. We recommend using the new PostgresDB extension for improved functionality and support.
Dynatrace PostgreSQL monitoring provides you with deep visibility into the performance of your PostgreSQL databases.
Prerequisites
- See list of supported PostgreSQL versions
Viewing PostgreSQL monitoring metrics
Captured PostgreSQL metrics are displayed on each PostgreSQL Process page. Click the infographic or the PostgreSQL metrics and Further details tabs to view metric details.
Collected metrics
Enabling PostgreSQL monitoring
To enable PostgreSQL monitoring globally:
- Go to Settings.
- Select Monitoring > Monitored technologies.
- Find PostgreSQL and enter your PostgreSQL server Database name, User, and Password credentials.
No special privileges are required, just user “Can login” privileges. - Turn on the PostgreSQL switch to enable monitoring with the plugin.
- Select Save.
Dynatrace will verify the credentials and begin collecting PostgreSQL metrics.
With PostgreSQL monitoring enabled globally, when a new host running PostgreSQL is detected in your environment, Dynatrace automatically collects PostgreSQL metrics, assuming that the same credentials are used by the PostgreSQL server or a new DB.
Dynatrace also allows you to enable PostgreSQL monitoring for specific hosts rather than globally. To do this, first disable the global PostgreSQL monitoring setting explained above. Then click the Host settings link and select a host you want to start PostgreSQL monitoring on. Follow the same steps as for global configuration.