Promhub Logo Prom hub

Postgresql high rollback rate
warning

Description Ratio of transactions being aborted compared to committed is > 2 %
Query 
>>>
	
				
					sum by (namespace,datname) ((
				
			
				
					
					
						rate
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*|postgres",datid!="0"}[3m])) / ((
				
			
				
					
					
						rate
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*|postgres",datid!="0"}[3m])) + (
				
			
				
					
					
						rate
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*|postgres",datid!="0"}[3m])))) > 0.02
Source Awesome Prometheus Alerts
Export Alert✕
Download
Copy to Clipboard