TrustRadius: an HG Insights company

pganalyze

Score9 out of 10

1 Reviews and Ratings

What is pganalyze?

Founded in 2012, pganalyze provides actionable insights into Postgres.

Specializing in PostgreSQL database monitoring and optimization, pganalyze gives automatic insights into Postgres query plans, helps improve Postgres query performance with its Index Advisor and VACUUM Advisor, and lets the user perform query drill-down analysis, observe per-query statistics and conduct trend analysis in a platform that integrates with both self-managed Postgres servers as well as Database-as-a-service providers like Amazon RDS.

DBAs and developers use pganalyze to identify the root cause of performance issues, to optimize queries, and to get alerts about critical issues. pganalyze surfaces opportunities to optimize Postgres performance and gives recommendations that help speed up queries. It comes with security features like PII filtering and SSO integration.

The service boasts hundreds of customers with teams ranging from 5 to thousands of engineers are using pganalyze in the cloud or on-premise.

Screenshots

Screenshot of Query Performance Overview: pganalyze provides access to historic query data and provides tools to help with optimizing and performance tuning of Postgres databases, including trend analysis, and config tuning recommendations.
Screenshot of Query Details Page: Displays detailed statistics on a per-query basis so users can learn what to focus on. pganalyze can also be used to perform query drill-down analysis and observe per-query statistics.
Screenshot of pganalyze Index Advisor: pganalyze automatically validates that existing indexes are useful, gives index recommendations to improve performance, and helps reduce load on the database.
Screenshot of pganalyze EXPLAIN Insights: pganalyze automatically collects EXPLAIN plans with auto_explain, provides visualizations and gives meaningful insights into Postgres Queries.
Screenshot of pganalyze Log Insights: PostgreSQL logs often contain critical details about whats going on in an associated database. pganalyze Log Insights automatically extracts the logs into structured data, and filters any sensitive information.
Screenshot of pganalyze VACUUM Advisor: pganalyze helps optimize table bloat, freezing and VACUUM performance - ensuring ideal performance, stability, and efficiency for  databases.

1 / 6

Screenshot of Query Performance Overview: pganalyze provides access to historic query data and provides tools to help with optimizing and performance tuning of Postgres databases, including trend analysis, and config tuning recommendations.

FAQs

How much does pganalyze cost?
pganalyze starts at $149.
What are pganalyze's top competitors?
Datadog, SolarWinds Database Performance Monitor, and Amazon RDS Performance Insights are common alternatives for pganalyze.
Who uses pganalyze?
The most common users of pganalyze are from Small-Business.