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

Поиск
Список
Период
Сортировка
От Denis Lishtovny
Тема How to determine which indexes are not using or using seldom in database
Дата
Msg-id 20070402081739.696D19FB609@postgresql.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: scalablility problem
Следующее
От: Thomas Pundt
Дата:
Сообщение: Re: How to determine which indexes are not using or using seldom in database