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:
|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:
- Navigate to Environment > All Objects > PostgreSQL.
- Double-click on the desired object (resource).
- Select the Details tab, then Views.
The available views for that resource are listed and can be selected.