Promhub Logo promhub_

Postgresql high rate deadlock
critical
Get Alert

Description Postgres detected deadlocks
Query
>>>
	
				
					
					
						increase
					
				
			
				
					(
				
			
				
					postgresql_errors_total
				
			
				
					{type="deadlock_detected"}[1m]) > 1
				
			
    
Query Explanation

The query counts how many deadlock errors occurred in the last minute (increase(postgresql_errors_total{type=\"deadlock_detected\"}[1m])). If that count exceeds 1 (i.e., more than one deadlock detected in a 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 dead locks

  • Postgresql down

  • Postgresql exporter error

  • 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