4 ms·

I have a project that uses Heroku Postgres because they handle high-availability and backups, and because they have some fancy metrics that help find areas for

I have a project that uses Heroku Postgres because they handle high-availability and backups, and because they have some fancy metrics that help find areas for potential optimization[1]. Does anyone have recommendations for an alternative with similar features? As far as I can tell RDS should handle the HA stuff, but it doesn't look like they have query-level metrics. I'm open to looking at a separate dashboard of some kind for query metrics if necessary, but I pretty much need the reliability features to be abstracted away. This product needs to be reliable to be worth anything, and I handle development/deployments/infrastructure by myself so I don't have the required knowledge or time to build out a proper solution myself. 1: https://devcenter.heroku.com/articles/expensive-queries https://devcenter.heroku.com/articles/expensive-queries

alanfranz 4y ago
Take a look at Aiven for Postgresql. Disclosure: current employee.
TheTaytay 4y ago
Crunchy Bridge is staffed with a lot of former Herokai and some Postgres core committers. You can use PGAnalyze as a (fantastic) secondary service to give you statement/query visibility. I get the impression Crunchy is trying to build what Postgres data is (and what it could have been). I do business with PGAnalyze but have only talked with Crunchy. I have heard good things about Aiven as well.
Shorn 4y ago
Isn't that about the same things as "performance insights"? (genuine question, I'd be interested in hearing what features I'm missing out on) https://aws.amazon.com/rds/performance-insights/ https://aws.amazon.com/rds/performance-insights/