PostgreSQL default checks and policies
Agent Client Collector provides the following default checks and policies for PostgreSQL health monitoring.
| Type | Check | Description | Command |
|---|---|---|---|
| Event | postgresql.check-alive | Triggers an alert on the status of the PostgreSQL database. | commonchecks check-postgres-alive -d {{.labels.params_database}} -p {{.labels.params_port}} -H {{.labels.params_host}} |
| Event | postgresql.check-connections | Triggers an alert on the total connection load on the PostgreSQL database, based on the configured threshold. | commonchecks check-postgres-connections -d {{.labels.params_database}} -c {{.labels.params_critical}} -p {{.labels.params_port}} -H {{.labels.params_host}} -w {{.labels.params_warning}} -a
{{.labels.params_use_percentage}} |
| Metric | postgresql.metric-active-connections | Provides metrics on the total active connection on the PostgreSQL database. | commonchecks metric-postgres-connections -p {{.labels.params_port}} -d {{.labels.params_database}} -H {{.labels.params_host}} |
| Metric | postgresql.metric-dbsize | Provides metrics on the total size for each of the server's PostgreSQL databases. | commonchecks metric-postgres-dbsize -d {{.labels.params_database}} -H {{.labels.params_host}} -p {{.labels.params_port}} |
| Metric | postgresql.metric-locks | Provides metrics on the locks in the PostgreSQL database/tables. | commonchecks metric-postgres-locks -p {{.labels.params_port}} -d {{.labels.params_database}} -H {{.labels.params_host}} |
| Metric | postgresql.metric-relation-size | Provides metrics on the database table size on the server. | commonchecks metric-postgres-relation-size -p {{.labels.params_port}} -l {{.labels.params_limit}} -H {{.labels.params_host}} -d {{.labels.params_database}} |
| Metric | postgresql.metric-statsbgwriter | Provides metrics related to buffer allocations. | commonchecks metric-postgres-statsbgwriter -p {{.labels.params_port}} -d {{.labels.params_database}} -H {{.labels.params_host}} |
| Metric | postgresql.metric-statsdb | Provides metrics related to commits/ rollbacks/tuples transactions / deadlocks/query conflicts count. | commonchecks metric-postgres-statsdb -d {{.labels.params_database}} -H {{.labels.params_host}} -p {{.labels.params_port}} |
| Metric | postgresql.metric-statsio | Provides table based metrics related index reads/total hits to a table index. | commonchecks metric-postgres-statsio -s {{.labels.params_scope}} -H {{.labels.params_host}} -p {{.labels.params_port}} -d {{.labels.params_database}} |
| Metric | postgresql.metric-statstable | Provides metrics related to CRUD operations. | commonchecks metric-postgres-statstable -d {{.labels.params_database}} -H {{.labels.params_host}} -s {{.labels.params_scope}} -p {{.labels.params_port}} |