Find unused indexes in Postgresql
SELECT *, (pg_relation_size(indexrelname))
FROM pg_stat_all_indexes
WHERE schemaname = 'public'
ORDER BY pg_relation_size(indexrelname) DESC, idx_scan ASC
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}
Categories: Postgresql
Home
> Postgresql > Find unused indexes in Postgresql
Comments (0)
Leave a comment