top of page
Волнистый абстрактный фон

PostgreSQL: unused indexes

List of PostgreSQL cluster indexes that have not been hit or their number is less than specified in the " show indices with hit less " field

​

PostgreSQL not using index

select * from pg_catalog.pg_stat_all_indexes
 where idx_scan < $$NUMBER
   and schemaname not in ('pg_toast','pg_catalog')
order by idx_scan  

bottom of page