Integration · database
PostgreSQL
pg_stat_*, replication lag, connection pool, autovacuum.
What gets collected
A connection string with a read-only user. Metrics: WAL throughput, replication lag, slow queries (with a configurable threshold), bloat estimate, active connections per database.
Setup steps
- 1CREATE USER unimoni WITH PASSWORD ... LOGIN
- 2GRANT pg_monitor TO unimoni
- 3pg_stat_statements in shared_preload_libraries
After install
- · Metrics show up on the dashboard within 15-30 seconds
- · Integration labels flow into filters automatically
- · Dashboard presets for common metrics are available in the editor