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.

Categories & Use Cases

Media

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.

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.

pganalyze Index Advisor: pganalyze automatically validates that existing indexes are useful, gives index recommendations to improve performance, and helps reduce load on the database.

pganalyze EXPLAIN Insights: pganalyze automatically collects EXPLAIN plans with auto_explain, provides visualizations and gives meaningful insights into Postgres Queries.

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.

pganalyze VACUUM Advisor: pganalyze helps optimize table bloat, freezing and VACUUM performance - ensuring ideal performance, stability, and efficiency for databases.

1 / 6

Verified User

Consultant in Information Technology (1001-5000 employees employees)

Use Cases and Deployment Scope

We use pganalyze got our project of data integration from legacy policy admin system to the new system to monitor the performance of queries. It helps us in tracking the root causes in performance and we are able to do the solution based on that . We will reccomend this to every etl user .