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?