4 ms·
Agreed. Learn how to use EXPLAIN and interpret using whatever tools you prefer. Also monitor your queries. Something I did in a previous start up was install Pg
by layoric 2y ago
Agreed. Learn how to use EXPLAIN and interpret using whatever tools you prefer. Also monitor your queries. Something I did in a previous start up was install PgHero, and man did that tool help me optimise and prioritise performance.
- password4321 2y agoPgHero 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.)