Re: Unused indices

[Greg Smith <greg@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxx   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books