PostgreSQL monitor: unused indexes
[EN]
List of PostgreSQL cluster indexes that have not been accessed or their number is less than specified in the "show indices with hit less" field
select * from pg_catalog.pg_stat_all_indexes
where idx_scan < $$NUMBER
and schemaname not in ('pg_toast','pg_catalog')
order by idx_scan
[RU]
Список индексов кластера PostgreSQL к которым не было обращений или их количество меньше заданного в поле "show indices with hit less"
select * from pg_catalog.pg_stat_all_indexes
where idx_scan < $$NUMBER
and schemaname not in ('pg_toast','pg_catalog')
order by idx_scan
14 просмотров