Promhub Logo Prom hub

Postgresql dead locks
warning

Description PostgreSQL has dead-locks
Query 
>>>
	
				
					
					
						increase
					
				
			
				
					(
				
			
				
					
				
			
				
					{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.

Get Alert✕
Download
Copy to Clipboard