Search SSWUG.ORG:



DATABASES

New Finding Unused Indexes Query This is an off-site link.  Please review our Terms of Service for additional information.


(Josh Berkus) As long as we're overhauling standard monitoring queries for PostgreSQL, here's another one. This query helps you find indexes which are relatively unused, and as a result could probably be dropped. I wrote a more complex (yes, really) version for our internal Performance Health Check suite, but the linked version is usable by anyone.

Read this article..







comments powered by Disqus