I had no idea what was going on under the hood but used PGAnalyze for about 6 months after launching a new product. It was excellent at suggesting indexes and monitoring unused ones.
However, after a few months the ROI crept down until it wasn't worth it anymore (access patterns stabilized). I'm tempted to bring it back once and a while but the price tag keeps me from having it always on.
That makes sense, if the structure of your queries is largely static per commit of your codebase. You'd probably get more benefit out of a tool like this by running it as part of a CI pipeline, since that's the best time to test code changes including new queries. But then the challenge becomes simulating user activity and traffic levels during the CI pipeline. That's a solvable problem, but it's not as easy as just observing the real traffic in your prod network.
Exactly the same experience. And I wish it wasn’t. I also believe the pricing is wrong. I’d continue using it at $100/mo. But otherwise I’m just cancelling.
You can find our pricing on the website [0] - generally $100/month per instance (though note our smallest plan is $150/mo). pganalyze Index Advisor, which is the subject of the post is available with all plans.
Generally I (Founder and CEO) feel the pricing is fair for the value provided for production databases, and it allows us to run the business as an independent company without external investors, whilst continuing to invest in product improvements. That said, it may not be a good fit if you have a small production database, or only make database-related changes infrequently.
Seeing as you're here, the reason the price is too high for us is that "SCALE" plan is too much for us and the "PRODUCTION" plan is too little. I'd happily pay $200/month for two servers, but can't justify $400/month for two (we only have two right now).
Thanks, thats good feedback! And agreed, two servers is a bit of a gap in our pricing right now. If you're open to paying annual instead of monthly, we have a bit more flexibility since we can set them up as custom contracts (feel free to reach out)
However, after a few months the ROI crept down until it wasn't worth it anymore (access patterns stabilized). I'm tempted to bring it back once and a while but the price tag keeps me from having it always on.