I like how pganalyze makes it easy to monitor PostgreSQL performance with clear insights and actionable recommendations Review collected by and hosted on G2.com.

I wish the setup and configuration were a little more straightforward. Review collected by and hosted on G2.com.

What I like most about pganalyze is how effortlessly it helps me spot and fix database issues before they become real problems. Review collected by and hosted on G2.com.

pganalyze works great, but at first it can feel a bit tricky to set up and fully understand what’s happening behind the scenes. Review collected by and hosted on G2.com.

• Easy to set up and user-friendly interface

• Excellent query performance insights and index recommendations

• Reliable alerts and notifications

• Saves time in database troubleshooting Review collected by and hosted on G2.com.

• Pricing can be a bit high for small teams/startups

• Requires some PostgreSQL knowledge to make the most of all features Review collected by and hosted on G2.com.

Pg analyze provides a set of configuration recommendations and visibility into vacuuming state that it's not found anywhere. Index recommendations for heavy writes/heavy reads is something we've grown to love. Review collected by and hosted on G2.com.

UI and frontend sometimes have issues and tables loading can be a bit slow. Review collected by and hosted on G2.com.

The product goes to the right direction. It's full of great views about indexes, current running queries, performances. Auto-explain view is perfect to understand why a query was slow. Team is super reactive on feature request or misunderstanding. It's great to have technical people that answer you. We use it daily and we do not have dba. It's used by developers and more experienced PostgreSQL users. Review collected by and hosted on G2.com.

Because it is used by all type of database, it's sometimes not the perfect tool for I/O bound DB from AWS. Sometime we need to look at Performance Insight on AWS then switch back on PgAnalyze to get more details and continue our investigation. Review collected by and hosted on G2.com.

It helps me understand my database's behavior in detail in eastt of use matter.

It enables smarter decisions like tuning queries or adjusting configurations instead of simply scaling up instance sizes, this approach not only saves costs but also improves overall efficiency and reliability. Review collected by and hosted on G2.com.

The amount of RDS logs it can process daily. My database generates a high volume of logs, and unfortunately, not all of them are processed by pganalyze, which can leave some insights or issues overlooked. Review collected by and hosted on G2.com.

I believe its most appealing aspect is its ability to provide actionable insights into PostgreSQL query performance. By analyzing query plans, identifying slow queries, and suggesting optimizations, pganalyze empowers database administrators to proactively tune their systems and ensure optimal performance. Review collected by and hosted on G2.com.

Performance Optimization: By identifying slow queries and suggesting optimizations, pganalyzer helps database administrators improve overall system efficiency.

Proactive Monitoring: pganalyzer can be used to continuously monitor database performance and detect potential issues before they impact operations.

Complexity: pganalyzer's features and analysis can be complex for users who are not familiar with PostgreSQL internals and performance optimization techniques.

Resource Requirements: Running pganalyzer may require additional system resources, especially for large or heavily loaded databases. Review collected by and hosted on G2.com.

The visualization of the actionable items. Review collected by and hosted on G2.com.

Having to set it up as it is not a part of the core offering. Review collected by and hosted on G2.com.

It bridges the gap between database performance issues and actionable insights Review collected by and hosted on G2.com.

As a PostgreSQL specific tool its not suitable for teams running multiple database environment Review collected by and hosted on G2.com.

it's easy to use and helps us support our customers with monitoring and analyzing postgres issues which they do very frequently.

we use pganalyze to improve query performence and monitor long queries to the db Review collected by and hosted on G2.com.

it was kind of difficult to implement and integrate into our environment and the docs were sub par Review collected by and hosted on G2.com.