I'm Michael, one of the creators of Perfalytics. Perfalytics is a performance monitoring dashboard for Postgres. It collects the query plans for your queries as they run, then gives you a dashboard you can use to analyze this data. You can think of it as kind of like PGHero + auto_explain.
The primary Perfalytics functionality includes:
- Finding your slow queries and looking up the query plans for those queries. - Searching your query plans. You can search for potential "bad plans". Plans containing index scans likely imply you're missing indexes. - Recommendations. Since Perfalytics collects the query plans for all your queries, Perfalytics is able to give you specific recommendations on how to optimize your queries.
Normally Perfalytics would cost $500/month, but if you're willing to try it out and give feedback, I'll let you use it for free for three months.
If you are interested or have any questions, feel free to reach out to me at michael@perfalytics.com.