You could take a look at pg_statio_user_indexes and/or
pg_stat_user_indexes, if you have stats enabled....
On Tue, 16 Oct 2007, Bryan Murphy wrote:
Is there a way I can track index usage over a long period of time?
Specifically, I'd like to identify indexes that aren't being regularly
used and drop them.
Bryan
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
