On fim, 2006-02-23 at 14:15 +0100, Dragan Matic wrote: > We have a 50 GB database (currently using postgresql 8.1.1) with a few > hundred tables. There are a few larger (2-5 million rows) tables with > multiple indexes on them, some being unique, some not. Now, I am pretty > sure some of the indexes are pretty useless and are never used but is > there a way to see which indexes have been used on a table (and how many > times) and which haven't? Statistics is turned on for a database, I can > see number of sequential scans and index scans for instance, but I would > like to know which indexes have been used and how many times. select * from pg_stat_user_indexes ; > Tnx in advance > > Dragan Matic > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >
