How to determine which indexes are not using or using seldom in database - Mailing list pgsql-performance

From Denis Lishtovny
Subject How to determine which indexes are not using or using seldom in database
Date
Msg-id 20070402081739.696D19FB609@postgresql.org
Whole thread Raw
Responses Re: How to determine which indexes are not using or using seldom in database  (Thomas Pundt <mlists@rp-online.de>)
Re: How to determine which indexes are not using or using seldom in database  (Andreas Kostyrka <andreas@kostyrka.org>)
List 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.

pgsql-performance by date:

Previous
From: Dave Cramer
Date:
Subject: Re: scalablility problem
Next
From: Thomas Pundt
Date:
Subject: Re: How to determine which indexes are not using or using seldom in database