Promhub Logo promhub_

Postgresql dead locks
warning
Get Alert

Description PostgreSQL has dead-locks
Query
>>>
	
				
					
					
						increase
					
				
			
				
					(
				
			
				
					pg_stat_database_deadlocks
				
			
				
					{datname!~"template.*|postgres"}[1m]) > 5
				
			
    
Query Explanation

The rule watches the pg_stat_database_deadlocks metric (excluding template and postgres databases) and counts how many dead‑locks occurred in the last minute (increase(...[1m])). If more than 5 dead‑locks are detected within that minute, the alert fires.

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 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 replication lag

  • 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