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
>