How to determine which indexes are not using or using seldom in database

From: "Denis Lishtovny" <d(dot)lishtovny(at)chronopay(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: How to determine which indexes are not using or using seldom in database
Date: 2007-04-02 08:12:52
Message-ID: 20070402081739.696D19FB609@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello All.

I have a lot of tables and indexes in database. I must to determine which
indexes are not using or using seldon in databese . I enabled all posible
statistics in config but a can`t uderstand how to do this.
Thanks.

p.s for example i need this to reduce database size for increase backup and
restore speed.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Pundt 2007-04-02 08:45:13 Re: How to determine which indexes are not using or using seldom in database
Previous Message Andreas Kostyrka 2007-04-02 07:45:21 Re: How to determine which indexes are not using or using seldom in database