Postgresql too many dead tuples
warning

Description PostgreSQL dead tuples is too large
Query for 2m
>>>
	
				
					((
				
			
				
					
				
			
				
					 > 10000) / (
				
			
				
					
				
			
				
					 + 
				
			
				
					
				
			
				
					)) >= 0.1
				
			
    
Query Explanation

The rule evaluates each user table and triggers when the number of dead tuples is over 10,000 and those dead tuples make up at least 10 % of the total rows (dead + live). In other words, if (dead / (live + dead)) >= 0.1 while dead > 10000, the alert fires.

Get Alert
Download
Copy to Clipboard