From: | Ragnar <gnari(at)hive(dot)is> |
---|---|
To: | Dragan Matic <mlists(at)panforma(dot)co(dot)yu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a way to check which indexes are being used |
Date: | 2006-02-23 13:47:13 |
Message-ID: | 1140702433.5728.43.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Oliva | 2006-02-23 13:54:36 | ExclusiveLock without a relation in pg_locks |
Previous Message | Dragan Matic | 2006-02-23 13:15:07 | Is there a way to check which indexes are being used for a table |