Promhub Logo Prom hub

Postgresql bloat index high (> 80%)
warning

Description The index {{ $labels.idxname }} is bloated. You should execute `REINDEX INDEX CONCURRENTLY {{ $labels.idxname }};`
Query for 1h 
>>>
	
				
					
				
			
				
					 > 80 and on (idxname) (
				
			
				
					
				
			
				
					 > 100000000)
Query Explanation

The alert fires when an index’s bloat percentage (pg_bloat_btree_bloat_pct) exceeds 80 % and the same index’s actual size (pg_bloat_btree_real_size) is larger than 100 MB; when both conditions are true for the same idxname, the rule triggers, recommending a REINDEX INDEX CONCURRENTLY for that index.

Get Alert✕
Download
Copy to Clipboard