How to tell which indexes are not being used

15 votes

2 answers

14102 views

postgresql index postgresql-9.3 index-statistics

                          Postgresql 9.3
Debian 7

I have a lot of huge indexes in a legacy database I'm trying to optimize. Thinking about dropping all the useless ones, but how can I tell how often they are used and if they are not used at all.

Is there any usage statistics somewhere or some trick query to do that?

Asked by Ivan De Sousa Paz (561 rep)

Aug 25, 2014, 06:08 PM
Last activity: Dec 30, 2022, 11:55 AM

How to tell which indexes are not being used

Related Questions