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