list of indexes with index scans

pawurb / node-postgres-extras

NodeJS PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

MIT License

71 stars 3 forks source link

list of indexes with index scans #6

Open joprice opened 2 years ago

joprice commented 2 years ago

After making use of unused_indexes, I started wondering about which indexes were being used, and to what extent. There are some other queries for index usage relative to a table, but it might be nice to have a similar query to unused_indexes, but without the limit of 50.

pawurb commented 2 years ago

Hi. https://github.com/pawurb/ruby-pg-extras Ruby version of this library has support for query arguments, that would allow changing the limit. I'm no longer actively developing this version, but if you're interested in submitting a PR with this feature I'll be glad to release it.