pganalyze makes it much easier to monitor and tune PostgreSQL performance. The query insights and index recommendations are very accurate and save a lot of manual debugging time. Its dashboards give a clear overview of performance trends, and the tool helps uncover issues that would otherwise be hard to detect. It’s a reliable solution for database teams that want better visibility and proactive performance management. Review collected by and hosted on G2.com.

Some features feel a bit advanced for new users, and it takes time to fully explore the platform’s capabilities. Pricing may be a little high for smaller teams, and having more flexible plans could make it even more accessible. The learning curve is there, but with better onboarding materials and tutorials, the experience would be even smoother. Review collected by and hosted on G2.com.

It provides deep query analysis and helps identify slow queries with actionable recommendations.

Indexing suggestions are very useful for performance tuning.

The integration with PostgreSQL 18 is smooth, and it captures all the important stats like vacuum/analyze, query plans, and lock monitoring.

The UI is clean and makes it easier to monitor database health in real-time.

Alerts and notifications help in proactive issue detection before they impact production. Review collected by and hosted on G2.com.

Can feel a bit overwhelming for beginners because of the amount of data it shows.

Some advanced features require the enterprise plan, which may be expensive for small teams. Review collected by and hosted on G2.com.

It makes it easy to monitor and optimize PostgreSQL. The insights are clear and help improve performance quickly. It is very easy to Implementation. Review collected by and hosted on G2.com.

Sometimes it feels a bit complex for beginners, and the advanced features can take time to understand. When i was beginner i felt. Review collected by and hosted on G2.com.

pganalyze makes it very easy to identify slow queries and understand what’s happening inside Postgres without heavy manual debugging. I like the clear recommendations on indexes and query tuning, as well as the visibility it provides into query plans and workload patterns. The setup was straightforward, and once running, it quickly became part of our daily monitoring workflow. Review collected by and hosted on G2.com.

While the insights are valuable, the pricing can feel high for smaller teams. The interface, though powerful, can be a little overwhelming at first with the amount of information shown. Also, some advanced recommendations could benefit from more context or examples to make them easier to act on. Review collected by and hosted on G2.com.

I like the ease of setup with pganalyze; the setup process was smooth and straightforward. It has a significant impact on database support by identifying several missing indexes, which is super helpful for optimization. The customer support is excellent, with fast response times, typically within a few hours. Review collected by and hosted on G2.com.

Pricing can be a bit opaque and there's a lack of support for advanced features like custom query tagging. Review collected by and hosted on G2.com.

I like the clean and intuitive layout of pganalyze, which makes navigation efficient and facilitates the quick identification of issues. The use of visual graphs is a great help, as it highlights the main information clearly, allowing for more effective data analysis. Additionally, I appreciate the ease of initial setup of pganalyze, which provided me with a hassle-free experience from the start. The combination of these features makes me value pganalyze as an effective tool for learning and better understanding the Postgres database. Review collected by and hosted on G2.com.

Price Review collected by and hosted on G2.com.

First of all it is very easy to setup and use. I am tracking multiple databases (aws rds) using postgres and it provides me with separate details of each database. I really like the overall view of database where it shows all queries by users with time (average or percentiles). Apart from this I like other features like index advisor and it also suggests unused index that I can remove. It's a features that I didn't knew I needed. I have been able to solve multiple performance issues with the help of pganalyze. I have event setup alerts to be sent to slack in case there are slow queries and this integration with slack was also very easy to setup. I was an early user and now my whole team is using it regularly. Haven't had a requirement to contact the support team yet so can't comment on that. Review collected by and hosted on G2.com.

One of the thing I would like for pganalyze to do better would be index advisor for jsonb columns and the fact that it requires steep learning curve for new users. Review collected by and hosted on G2.com.

The latest pganalyze updates make database optimization smarter and faster, with real-time dashboards, automatic query insights, and seamless integrations for easy monitoring. Review collected by and hosted on G2.com.

While strong in monitoring and insights, pganalyze could improve with clearer query details, advanced alerts, multi-database views, and more accessible pricing. Review collected by and hosted on G2.com.

Query detection and analysis works well and runs efficiently. It gives correct results even for complex queries. Review collected by and hosted on G2.com.

While pganalyze is powerful and efficient, its complexity makes some logic hard to detect correctly at runtime or compile time. Also, it can feel a bit heavy to configure and understand for new users. Review collected by and hosted on G2.com.

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.