pganalyze for PostgreSQL
pganalyzeReviews from AWS customer
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
34 reviews
from
External reviews are not included in the AWS star rating for the product.
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
Best tool for monitoring and optimizing PostgreSQL database
What do you like best about the product?
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.
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.
What do you dislike about the product?
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.
What problems is the product solving and how is that benefiting you?
Optimizing slow queries
Find your slow query
What do you like best about the product?
Finding inefficient queries in simple way
What do you dislike about the product?
It's not a cheapest option. For now i didn't find any serious dislikes
What problems is the product solving and how is that benefiting you?
Monitoring and analyzing the performance of PostgresSQL help as to find slow queries and serve faster responses from our api for our clients
showing 21 - 30