Anybody have a clever way to quickly find whether there are any unused indexes in a PG DB? One way I have done is to take queries from the DB log, prepend an explain to each and grep the results, but I am wondering if there are either any index usage stats maintained somewhere inside Postgres or if there is a slicker/less cumbersome way of doing it. Also indexes used by functions are hard to simulate that way.
George ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
