Idea #13007
Updated by Peter Amstutz over 6 years ago
We create a lot of indexes in our database setup, but it's not clear which ones actually get used. This blog post and sample query use postgres stats to report rarely used indexes:
http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html
https://gist.github.com/jberkus/6b1bcaf7724dfc2a54f3