27 ms·
Surprised the list doesn't mention PGHero (https://github.com/ankane/pghero https://github.com/ankane/pghero). It's been really useful at our company to find sl
by theodorton 9y ago
Surprised the list doesn't mention PGHero (https://github.com/ankane/pghero https://github.com/ankane/pghero). It's been really useful at our company to find slow queries and identify missing indices.
- lm2s 9y agoWhoa. This seems very nice. I'm on my phone now and can fully check it, this works directly with PostgreSQL, right? It doesn't matter if the application layer is Rails or Django or whatever, correct?
- sudhirj 9y agoCorrect. Works directly off pg stats. It's one of the first items on the deployment checklist for every product or service in the company.
- duncanawoods 9y ago> It doesn't matter if the application layer is Rails or Django or whatever, correct? >> Correct. Works directly off pg stats Huh - PgHero is a rails app isn't it?
- MichaelBurge 9y agoThere are two applications in scope: The application whose database is being monitored, and the application displaying the dashboard.
- masklinn 9y ago> 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.
- thejosh 9y agoThat's awesome! So many great tools coming out in the past few years. Do you (or anyone else) have any recommendations/tips for other tools? I really love Postgres.
- kawsper 9y agoI really like that you can just embed it into a Rails project.