Unused indices - Mailing list pgsql-performance

From Benjamin Krajmalnik
Subject Unused indices
Date
Msg-id F4E6A2751A2823418A21D4A160B689887B0F8E@fletch.stackdump.local
Whole thread Raw
Responses Re: Unused indices
List pgsql-performance

I am trying to clean up our schema by removing any indices which are not being used frequently or at all.

Using pgadmin, looking at the statistics for an index, I see various pieces of information:

 

Index Scans, Index Tuples Read, Index Tuples Fetched, Index Blocks Read, and Index Blocks Hit.

I have on index with the following statistics:

 

Index Scans        0             

Index Tuples Read           0             

Index Tuples Fetched    0             

Index Blocks Read           834389 

Index Blocks Hit                247283300          

Index Size           1752 kB

 

 

Since there are no index scans, would it be safe to remove this one?

 

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Exhaustive list of what takes what locks
Next
From: Mathieu De Zutter
Date:
Subject: NULLS LAST performance