[whinvik]

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

[ezekg]

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).

[hijinks]

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