pganalyze for PostgreSQL
pganalyzeReviews from AWS customer
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
36 reviews
from
External reviews are not included in the AWS star rating for the product.
pganalyze sort logic is efficient but too complex to detect correctly at runtime or compile time.
What do you like best about the product?
Query detection and analysis works well and runs efficiently. It gives correct results even for complex queries.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
pganalyze helps detect slow or inefficient queries, deadlocks, and performance bottlenecks. It saves time by giving clear insights into database behavior, which makes optimization faster and more reliable.
pganalyze helps detect and fix slow or inefficient SQL queries automatically. It improves PostgreSQL performance and saves time on manual query tuning.
pganalyze helps detect and fix slow or inefficient SQL queries automatically. It improves PostgreSQL performance and saves time on manual query tuning.
⏺ PGAnalyze identifies slow queries, recommends missing indexes, and optimizes database performance.
What do you like best about the product?
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.
What do you dislike about the product?
Nothing in particular. They keep adding new features that helps optimize the database performance.
What problems is the product solving and how is that benefiting you?
PGAnalyze identifies poorly performing queries with high CPU and I/O impact. It provides query plan analysis, missing index detection, and index creation recommendations, helping optimize database workloads and improve overall application performance.
Only postgres observability solution you need
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
- In depth monitoring/observability for database
- Alerting
- Performance optimizations and validations
- Alerting
- Performance optimizations and validations
pganalyzer is a top choice for PostgreSQL users who want to go beyond basic monitoring
What do you like best about the product?
It bridges the gap between database performance issues and actionable insights
What do you dislike about the product?
As a PostgreSQL specific tool its not suitable for teams running multiple database environment
What problems is the product solving and how is that benefiting you?
Pganalyzer identifies missing or unused indexes and can flag redundant ones helping DBA maintain optimal index strategies without bloating the system
Helps me stay on top of Postgres performance issues with minimal effort
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
pganalyze helps us find slow queries and performance problems in our PostgreSQL databases. It shows query plans and helpful suggestions, so we don’t need to check logs manually. This saves time and helps us improve app speed and stability
Absolute must to identify performance issues quickly.
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
Our development shop had very little Postgres experience before our current project. This tool has been indispensable in helping us learn how Postgres differs from SQL Server (indexes, parallelism, etc) and it allows us to quickly resolve performance issues, even before they are reported by our end-users.
Postgres is a solid database
What do you like best about the product?
PGAnalyse is a great tool that we use to monitor our postgresdb. We get alerts and insights into slow queries and have used it to tune our sql
What do you dislike about the product?
I'm not sure about all the features. There is a lot of manual setup that you have to do to get it integrated.
What problems is the product solving and how is that benefiting you?
It's helping us monitor the performance of our database. It was especially useful when we were upgrading our postgresdb 2 versions from 15 to 17. That is not for the feint of heart. pganalyze helped us find some bottlenecks with the upgrade and we were able to work around them.
Pg Analyze at fleetio
What do you like best about the product?
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.
What do you dislike about the product?
UI and frontend sometimes have issues and tables loading can be a bit slow.
What problems is the product solving and how is that benefiting you?
Helps us get monitoring on areas of the database that other products like datadog don't cover. Presents the schema data usage in a very nice easy to understand representation, the times an index has been accessed, and also write/read usage data.
A stellar product and team - the experts of Postgres in the field.
What do you like best about the product?
The visualization of the actionable items.
What do you dislike about the product?
Having to set it up as it is not a part of the core offering.
What problems is the product solving and how is that benefiting you?
The analytics and visualization into how my cluster is running.
a great tool to monitor performance
What do you like best about the product?
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
we use pganalyze to improve query performence and monitor long queries to the db
What do you dislike about the product?
it was kind of difficult to implement and integrate into our environment and the docs were sub par
What problems is the product solving and how is that benefiting you?
we had performance issues with the db
showing 21 - 30