PostgreSQL

PostgreSQL

This integration is enabled by default.

List of Alerts:

AlertDescriptionFormat
[PostgreSQL] Instance DownPostgreSQL instance is unavailablePrometheus
[PostgreSQL] Low UpTimeThe PostgreSQL instance has a UpTime of less than 1 hourPrometheus
[PostgreSQL] Max Write Buffer ReachedBackground writer stops because it reached the maximum write buffersPrometheus
[PostgreSQL] High WAL Files Archive Error RateHigh error rate in WAL files archiverPrometheus
[PostgreSQL] Low Available ConnectionsLow available network connectionsPrometheus
[PostgreSQL] High Response TimeHigh response time in at least one of the databasesPrometheus
[PostgreSQL] Low Cache Hit RateLow cache hit ratePrometheus
[PostgreSQL] DeadLocks In DatabaseDeadlocks detected in databasePrometheus

List of Dashboards:

  • PostgreSQL Instance Health PostgreSQL Instance Health
  • PostgreSQL Database Details PostgreSQL Database Details

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


Last modified September 23, 2022