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

From: Thomas Pundt
Subject: Re: How to determine which indexes are not using or using seldom in database
Date: ,
Msg-id: 200704021045.13239.mlists@rp-online.de
(view: Whole thread, Raw)
In response to: How to determine which indexes are not using or using seldom in database  ("Denis Lishtovny")
List: pgsql-performance


Hi,

On Monday 02 April 2007 10:12, Denis Lishtovny wrote:
| 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.

Try "select * from pg_stat_user_indexes;" - that should give you a good start
to look at.

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

Deleting indexes won't reduce backup size noticeably (but has impact on
restore speed), if you use pg_dump for backup.

Ciao,
Thomas

--
Thomas Pundt <> ---- http://rp-online.de/ ----


pgsql-performance by date:

From:
Date:
Subject: Providing user based previleges to Postgres DB
From: Carlos Moreno
Date:
Subject: Re: Providing user based previleges to Postgres DB