pg_stat_all_indexes understand

Поиск
Список
Период
Сортировка
От Nicolas Paris
Тема pg_stat_all_indexes understand
Дата
Msg-id CA+ssMOSO0Attq05RJmux8U0Sp3SQt9N=H2dDnbxCqzoMZ_jQCg@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_stat_all_indexes understand
Список pgsql-performance
Дерево обсуждения
Hello,

I wonder how understanding pg_stat_all_indexes working

When I run an explain, some index are not used, but pg_stat_all_indexes.idx_scan is incremented for those indexes.

Does this mean idx_scan is incremented each time the planner check if an index could be use whenever it won't use it ?

Is there a better way to check which index could be delete ?

Thanks by advance.

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?