Promhub Logo Prom hub

Postgresql commit rate low
critical

Description Postgresql seems to be processing very few transactions
Query for 2m 
>>>
	
				
					
					
						increase
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*|postgres",datid!="0"}[5m]) < 5
Query Explanation

The rule measures the number of committed transactions (pg_stat_database_xact_commit) that occurred in the past 5 minutes for all regular databases (excluding template*, postgres and the internal datid=0). If fewer than 5 commits are observed in that window, the alert fires, indicating a very low commit rate.

Get Alert✕
Download
Copy to Clipboard