Hacker News Reader

Slightly off-topic but what tools do folks use for optimizing/analyzing/debugging indexes on Postgres.

You can't go wrong with https://pgmustard.com. It's helped me so many times. All you need is the output of EXPLAIN (ANALYZE, VERBOSE, BUFFERS, FORMAT JSON).

pghero and/or 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

Reply on news.ycombinator.com