check out pg_stat_user_indexes, you will need to turn on the stats collection in your postgresql.conf file first.
Jim ---------- Original Message ----------- From: "George Pavlov" <[EMAIL PROTECTED]> To: <pgsql-sql@postgresql.org> Sent: Tue, 1 Aug 2006 09:05:34 -0700 Subject: [SQL] finding unused indexes? > 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 ------- End of Original Message ------- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
