Postgresql
This integration is enabled by default.
List of alerts
| Alert | Description | Format |
|---|---|---|
| [PostgreSQL] Instance Down | PostgreSQL instance is unavailable | Prometheus |
| [PostgreSQL] Low UpTime | The PostgreSQL instance has a UpTime of less than 1 hour | Prometheus |
| [PostgreSQL] Max Write Buffer Reached | Background writer stops because it reached the maximum write buffers | Prometheus |
| [PostgreSQL] High WAL Files Archive Error Rate | High error rate in WAL files archiver | Prometheus |
| [PostgreSQL] Low Available Connections | Low available network connections | Prometheus |
| [PostgreSQL] High Response Time | High response time in at least one of the databases | Prometheus |
| [PostgreSQL] Low Cache Hit Rate | Low cache hit rate | Prometheus |
| [PostgreSQL] DeadLocks In Database | Deadlocks detected in database | Prometheus |
List of dashboards:
- Postgresql_DB_Golden_Signals
- Postgresql_Instance_Health
List of metrics:
- pg_database_size_bytes
- pg_locks_count
- pg_postmaster_start_time_seconds
- pg_replication_lag
- pg_settings_max_connections
- pg_settings_superuser_reserved_connections
- pg_stat_activity_count
- pg_stat_activity_max_tx_duration
- pg_stat_archiver_archived_count
- pg_stat_archiver_failed_count
- pg_stat_bgwriter_buffers_alloc
- pg_stat_bgwriter_buffers_backend
- pg_stat_bgwriter_buffers_checkpoint
- pg_stat_bgwriter_buffers_clean
- pg_stat_bgwriter_checkpoint_sync_time
- pg_stat_bgwriter_checkpoint_write_time
- pg_stat_bgwriter_checkpoints_req
- pg_stat_bgwriter_checkpoints_timed
- pg_stat_bgwriter_maxwritten_clean
- pg_stat_database_blk_read_time
- pg_stat_database_blks_hit
- pg_stat_database_blks_read
- pg_stat_database_conflicts_confl_deadlock
- pg_stat_database_conflicts_confl_lock
- pg_stat_database_deadlocks
- pg_stat_database_numbackends
- pg_stat_database_temp_bytes
- pg_stat_database_tup_deleted
- pg_stat_database_tup_fetched
- pg_stat_database_tup_inserted
- pg_stat_database_tup_returned
- pg_stat_database_tup_updated
- pg_stat_database_xact_commit
- pg_stat_database_xact_rollback
- pg_stat_user_tables_idx_scan
- pg_stat_user_tables_n_tup_hot_upd
- pg_stat_user_tables_seq_scan
- pg_up
Related blog posts:
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.
Last modified June 23, 2022