Promhub Logo Prom hub

PostgreSQLQPS

Description PostgreSQL high number of queries per second on {{ $labels.cluster }} for database {{ $labels.datname }} with a value of {{ $value }}
Query for 5m 
>>>
	
				
					
					
						avg
					
				
			
				
					(
				
			
				
					
					
						irate
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*"}[5m]) + 
				
			
				
					
					
						irate
					
				
			
				
					(
				
			
				
					
				
			
				
					{datname!~"template.*"}[5m])) by (datname) > 10000
Query Explanation

The rule computes the average queries‑per‑second for each database by adding the per‑second commit and rollback rates (irate over 5 minutes) and then averaging them; if this average exceeds 10 000 QPS for a particular datname, the alert fires, signalling a high query load on that database in the indicated cluster.

Exporters Used

Related Alerts

Get Alert✕
Download
Copy to Clipboard