The Management Pack for PostgreSQL creates views that allow the user to view statistics of metrics for various PostgreSQL resources. The views help give a broad picture of the entire system, as opposed to a more in depth view.

The following views are available in the Management Pack:

View Type Description
PostgreSQL Database Overview List Provides a overview of database performance metrics.
PostgreSQL Instance Overview List Provides an overview of instance performance metrics.
PostgreSQL Slowest Queries List Provides a list of slowest queries metrics.
PostgreSQL Throughput List Provides a list of throughput metrics.

To access the Management Pack views:

  1. Navigate to Environment > All Objects > PostgreSQL.
  2. Double-click on the desired object (resource).
  3. Select the Details tab, then Views.

The available views for that resource are listed and can be selected.

Accessing Views