The Management Pack for PostgreSQL creates Resource Kinds and Relationships (associations) for critical resources in your PostgreSQL environment.
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 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