Promhub Logo promhub_

Postgresql replication lag
warning
Get Alert

Description The PostgreSQL replication lag is high (> 5s)
Query for 30s
>>>
	
				
					pg_replication_lag_seconds
				
			
				
					 > 5
				
			
    
Query Explanation

The rule checks the metric pg_replication_lag_seconds and triggers when it exceeds 5 seconds for a replica. In other words, any PostgreSQL replica reporting a replication lag greater than 5 s will fire the alert.

Source Awesome Prometheus Alerts

Exporters Used

  • PostgreSQL exporter

Related Alerts

  • PostgreSQLCacheHitRatio

  • PostgreSQLDown

  • PostgreSQLHighConnections

  • PostgreSQLMaxConnectionsReached

  • PostgreSQLQPS

  • PostgreSQLSlowQueries

  • Postgresql SSL compression active

  • Postgresql bloat index high (> 80%)

  • Postgresql bloat table high (> 80%)

  • Postgresql commit rate low

  • Postgresql configuration changed

  • Postgresql dead locks

  • Postgresql down

  • Postgresql exporter error

  • Postgresql high rate deadlock

  • Postgresql high rate statement timeout

  • Postgresql high rollback rate

  • Postgresql invalid index

  • Postgresql low XID consumption

  • Postgresql not enough connections

  • Postgresql restarted

  • Postgresql table not auto analyzed

  • Postgresql table not auto vacuumed

  • Postgresql too many connections

  • Postgresql too many dead tuples

  • Postgresql too many locks acquired

  • Postgresql unused replication slot

Get Alert✕
Download
Copy to Clipboard
Promhub Logo promhub_
Overview Alerts 639 Dashboards 2000 Exporters 215 Metrics 2283
Shortcuts
Search /
Move jk
Open ⏎l
Back h
Copy YAML y

Built for the Prometheus community