Promhub Logo Prom hub

Postgresql invalid index
warning

Description The table {{ $labels.relname }} has an invalid index: {{ $labels.indexrelname }}. You should execute `DROP INDEX {{ $labels.indexrelname }};`
Query for 6h 
>>>
	
				
					
				
			
				
					{indexrelname=~".*ccnew.*"}
Query Explanation

The PromQL query pg_general_index_info_pg_relation_size{indexrelname=~".*ccnew.*"} returns the size of any PostgreSQL index whose name contains the substring ccnew. If this query returns any series (i.e., at least one matching index exists), the alert fires, indicating that the corresponding table has an invalid index that should be dropped.

Get Alert✕
Download
Copy to Clipboard