4 ms·
Slightly off-topic but what tools do folks use for optimizing/analyzing/debugging indexes on Postgres.
by whinvik 2y ago
Slightly off-topic but what tools do folks use for optimizing/analyzing/debugging indexes on Postgres.
- hijinks 2y agopghero and/or https://github.com/supabase/index_advisor https://github.com/supabase/index_advisor If you want to pay for a saas then pganalyze is like $400 a month for 4 dbs is a pretty good pricing model
- ezekg 2y agoYou can't go wrong with https://pgmustard.com https://pgmustard.com. It's helped me so many times. All you need is the output of EXPLAIN (ANALYZE, VERBOSE, BUFFERS, FORMAT JSON).