Surprised the list doesn't mention PGHero (https://github.com/ankane/pghero). It's been really useful at our company to find slow queries and identify missing indices.
>> Correct. Works directly off pg stats
Huh - PgHero is a rails app isn't it?
pghero is a rails app but it just tracks a postgres db, you don't have to embed it into a rails application (though that's an option) you can run it independently.
Do you (or anyone else) have any recommendations/tips for other tools? I really love Postgres.