This tool has been really helpful for me, especially with the Query Analysis feature that shows query execution plans and costs. I also like the Index Usage Analysis, which helps identify and remove unused indexes. More importantly, it shows how indexes are being used, so I can adjust column order in indexes for better optimization.

Another big plus is that it works with my Citus DB, which already has a large number of functions and handles massive amounts of data. This makes it much easier to analyze those functions without getting lost in the complexity. Review collected by and hosted on G2.com.

The only downside I’ve noticed is that it sometimes struggles to properly analyze functions that include recursive CTEs across multiple distributed tables and schemas. Many of my DB functions also use nested CASE WHEN statements, creating multiple conditional branches, and that’s where it still needs improvement.

Other than that, it’s a great tool for developers and saves a lot of time in day-to-day optimization work. Review collected by and hosted on G2.com.

What I like best about pganalyze is how it makes understanding database performance so much easier. Instead of digging through logs and queries manually, it gives clear insights and recommendations that save time and help keep things running smoothly. I also appreciate how user-friendly the dashboards are — it feels like I’m getting expert guidance without needing to be a DBA myself. Review collected by and hosted on G2.com.

One thing I dislike about pganalyze is that the amount of detail can feel overwhelming at first, and it takes a little time to figure out which metrics matter most. Also, the pricing can feel a bit high for smaller teams. That said, once you get past the learning curve, the insights are really valuable Review collected by and hosted on G2.com.

EXPLAIN visualizer simplifies query analysis; historical data aids trend detection. Review collected by and hosted on G2.com.

UI is dense; lacks cloud cost recommendations. Review collected by and hosted on G2.com.

The ease of which it helps identify system issues, including performance problems. We have recently migrated multiple databases from SQL Server to AWS Aurora Postgres and this tool has been invaluable in our testing to help identify missing indexes, configuration changes, and reviewing logs easily. It has become part of our daily toolset during this migration and we will continue to use it after we are in production. Review collected by and hosted on G2.com.

There are occasional issues with large/long queries not capturing missing indexes or query plans. You also need to have additional tooling for real-time monitoring, as that is not something this tool will be able to accomplish. Review collected by and hosted on G2.com.

I have been using PGAnalyze for a while now. It helps me focus on the unoptimized queries which is impacting the database the more in terms of CPU & I/O usage. It also gives me detailed analysis on the query plan, the missing indexes and the recommendations on creating appropriate indexes. In short PGAnalyze helped me run my database workloads in the most optimized way possible and improve the overall application performance. Review collected by and hosted on G2.com.

Nothing in particular. They keep adding new features that helps optimize the database performance. Review collected by and hosted on G2.com.

Straightforward setup and intuitive dashboards.

Deep visibility into slow queries and helpful index suggestions.

Proactive alerts that highlight issues before they escalate.

Great time-saver when identifying performance bottlenecks. Review collected by and hosted on G2.com.

Cost may feel high for smaller teams.

Some advanced features assume a good understanding of PostgreSQL internals. Review collected by and hosted on G2.com.

pganalyze gives deep visibility into PostgreSQL performance without having to dig through logs or manually run queries. I especially appreciate the automatic EXPLAIN plan analysis and index suggestions, they've helped optimize several slow queries in production. Integration with alerting tools and easy-to-read dashboards also saves a lot of time during incident response. Review collected by and hosted on G2.com.

The pricing can be a bit steep for smaller teams or side projects. Also, while the UI is generally good, some parts of the navigation feel a bit clunky when jumping between query details and historical trends. It would be great to have more flexible filters for long-term query analysis. Review collected by and hosted on G2.com.

I like how pganalyze gives deep insights into Postgres performance with clear recommendations, making it easier to detect and fix issues quickly. Review collected by and hosted on G2.com.

Sometimes the tool feels a bit complex at first, and it takes time to fully understand all the features and settings. Review collected by and hosted on G2.com.

Good Visualizations: The dashboards make it easier to understand performance metrics and trends. Review collected by and hosted on G2.com.

Pricing Can Be High: Might feel expensive for smaller teams or low-traffic databases. Review collected by and hosted on G2.com.

Its Good for tuning Queries, and good for heavy Load Queries and UI is user friendly Review collected by and hosted on G2.com.

It should be open to integrate more tools or services related to Data Review collected by and hosted on G2.com.