PgHero looks great (props for linking to related projects!), though somehow not discussed here much previously. https://github.com/ankane/pghero https://github

PgHero looks great (props for linking to related projects!), though somehow not discussed here much previously. https://github.com/ankane/pghero https://github.com/ankane/pghero https://news.ycombinator.com/item?id=41299148#41300220 https://news.ycombinator.com/item?id=41299148#41300220 (mentioned among the author's other helpful tools and Ruby gems) > helpful to identify slow queries in production, remove duplicate indexes, see missing indexes, keep an eye on table size, etc -- I haven't recently put in the effort to find a copy of SQL Sentry from back when the full-featured edition was briefly free but even the "always free" version was helpful working with MSSQL query plans. https://www.solarwinds.com/free-tools/plan-explorer https://www.solarwinds.com/free-tools/plan-explorer (NOTE: Not sure how free-but-pushy it is these days, but years ago it wasn't bad.)