Unused indexes

Поиск
Список
Период
Сортировка
От Ron
Тема Unused indexes
Дата
Msg-id df259502-5c03-6f4a-93de-7706924a97b0@gmail.com
обсуждение исходный текст
Ответы Re: Unused indexes
Re: Unused indexes
Список pgsql-general
For indexes that existed before the cluster was last started, and for which 
REINDEX hasn't been run on them since the cluster was last started... is it 
valid to say that an index has not been used since the cluster was started 
if these three pg_stat_all_indexes fields all have a value of 0?

idx_scan
idx_tup_read
idx_tup_fetch

If it matters, the version is 9.6.6.

Thanks

-- 
Angular momentum makes the world go 'round.


В списке pgsql-general по дате отправления:

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: surprising query optimisation
Следующее
От: PegoraroF10
Дата:
Сообщение: Transition Tables doesn´t have OID