|
|
|
|
|
|
by layoric
636 days 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. |
|
|
https://github.com/ankane/pghero
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
(NOTE: Not sure how free-but-pushy it is these days, but years ago it wasn't bad.)