Benjamin Krajmalnik wrote:
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?
Yes. The block usage you're seeing there reflects the activity from maintaining the index. But since it isn't ever being used for queries, with zero scans and zero rows it's delivered to clients, it's not doing you any good. Might as well reclaim your 1.7MB of disk space and reduce overhead by removing it.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books