The Management Pack for PostgreSQL creates Resource Kinds and Relationships (associations) for critical resources in your PostgreSQL environment.
Resource Kinds
Performance data, relationships, and events are collected for the following PostgreSQL resource kinds:
- PostgreSQL Instance
- PostgreSQL Database
- PostgreSQL Table
- Indexes(if disabled, index and trigger instance metric groups will not be returned)
- PostgreSQL Query (requires ‘pg_stat_statments’ to be enabled)
- PostgreSQL Function (requires ‘pg_stat_user_functions’ to be enabled)
Relationships
Relationships among discovered resources are also created by the Management Pack. The hierarchical structure of those relationships is depicted in the diagram below.
PostgreSQL Relationships Diagram
