Icon

Comments have been closed on this page. Please use AppMon & UEM Open Q & A forum for questions about this plugin.

Overview

 

 

PostgreSQL monitor Plugin allows you to monitor the values in key statistics PostgreSQL database. All captured data are provided by dynaTrace as Measures, enabling the assembly of its database monitoring dashboards. You can view statistics tables, database activities, I / O, Indexes, Sequences, and Cache Hit Rate and Usage Index.

Name and Version

PostgreSQL Plugin 1.0.0

Supported dynaTrace Versions

>= dynaTrace 6.1

Supported PostgreSQL Versions

This plugin has been tested in PostgreSQL version 9.3.

Author

Fernando Lewandowski Albuquerque (fernando.albuquerque@elosoft.com.br). Thanks to Marcelo Colleta (dynaTrace Team - Brazil)

License

dynaTrace BSD

 

Support Level

 

Not Supported

Release history2014-12-17 1.0.0 Initial Release

Download

com.dynatrace.postmon_1.0.0.jar

Contribution

Feel free to contribute any changes on Github

Installation

Import the Plugin into the dynaTrace Server via Settings menu -> dynaTrace Server Settings  -> Plugins -> Install Plugin. For details how to do this please refer to the dynaTrace Documentation.

To use the provided dashboard please leave the default name of the Monitor as "MyFavoriteDB", then open the Dashboard and set the Data Source accordingly.

Usage

Provided Measures

  • Tables Statistics;
  • Activities Statistics
  •  Tables I/O Statistics
  •  Indexes Statistics
  •  Indexes I/O Statistics
  •  Sequences I/O Statistics
  •  Cache and Hit Rate
  •  Index Usage
  •  Index Cache and Hit Rate

Configuration PostgreSQL Monitor

The monitor requires the following configuration settings:

  • hostName: Host name of the PostgreSQL Database Instance
  • dbName: Database Instance Name
  • dbUsername: Username that is used to access the database
  • dbPassword: Password that is used to access the database
  • dbPort: PostgreSQL Database Port for JDBC Connections (default: 5432

Screenshots

Figure 1 - Installed Plugin

Figure 2 - Plugin Configuration

Figure 3 - Plugin Development

Figure 4 - General Setup Plugin

Figure 5 - Configuring Plugin properties

Figure 6 - Configuring Plugin properties

Figure 7 - Configuring Plugin metrics

Figure 8 - Monitor Configuration based on the Plugin

Figure 9 - Monitor Configuration based on the Plugin

Figure 10 - Monitor Configuration based on the Plugin

  1. Anonymous (login to see details)

    Hi

    I am trying to implement PostgreSQL Monitor Plugin, the plug in seems to work successfully, but not able to collect values

    Please find the configuration screen capture and Plugin logs for your perusal, can you check and let us know where we are going wrong

  2. Anonymous (login to see details)

    Hi Mohammed

    Hi

    Have you applied the permissions on the Postgresql Statistics Collector Table to your user used to connect? You need READ permissions in the Statistics Tables from Postgresql Database.

    If yes, verify if your dynatrace collector plugin have permission to connect on the Postgresql Service/Database.
    Check it on the file pg_hba.conf. The line is like that:

    host all postgres 127.0.0.1/32 trust
    host all all 10.3.18.40/24 trust

    I had the same problem and the solution was add the IP from my Dynatrace Collector used to execute plugins.

    Regards.

     

    Kleber