Skip to main content
TrustRadius
pganalyze

pganalyze

Overview

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…

Read more

Learn from top reviewers

you can rely on Pganalyze

Rating: 9 out of 10
December 12, 2022
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Verified user
Consultant
pganalyze2 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing

Production

$149

Cloud
per month for 1 database server

Scale

$399

Cloud
per month for up to 4 database servers ($100/mo for each additional billable server)

Enterprise Cloud

Contact us

Cloud
per year per database server

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttps://pganalyze.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $149 per month per database server
Return to navigation

Product Details

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.

pganalyze Features

  • Supported: Query Performance Optimization
  • Supported: Postgres Query Analysis
  • Supported: pganalyze Index Advisor
  • Supported: pganalyze EXPLAIN Insights
  • Supported: pganalyze Log Insights with careful PII handling
  • Supported: Vacuum Activity Monitor
  • Supported: Automated Health Checks
  • Supported: Team Collaboration
  • Supported: Single sign-on (SSO) + role based access control
  • Supported: 100+ Preconfigured Log Event Filters
  • Supported: Share production statistics without sharing database access
  • Supported: Pre-Configured Email Alerts
  • Supported: Customizable Alerts and Notifications

pganalyze 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.

pganalyze Integrations

pganalyze Competitors

pganalyze Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsLinux, Mac
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

pganalyze Downloadables

pganalyze Customer Size Distribution

Consumers0%
Small Businesses (1-50 employees)75%
Mid-Size Companies (51-500 employees)20%
Enterprises (more than 500 employees)5%
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(1)

Reviews

(1-1 of 1)
Companies can't remove reviews or game the system. Here's why

you can rely on Pganalyze

Rating: 9 out of 10
Incentivized
December 12, 2022
Verified User
Vetted Review
Verified User
pganalyze
2 years of experience
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 .
Pros and Cons
  • User and role setup
  • Performance tuning
  • Tracking of queries
Likelihood to Recommend
pganalyze works great with the postgresql and gives a good alternatives to the existing producsts available out there like Slick or basic as microsoft SQL server manaagement studio. We have used in our projects of data migration and integration of enterprise data warehouseing and reporting . And it has provides us satisfactory results.

Most Important Features
  • Query analysis
  • Query montioring
  • Performance tuning
Return on Investment
  • Efficient product
  • Good value for money
  • You dont have to depend on external services
Alternatives Considered
  • SQL Server Management Studio (SSMS)
It is better in terms of results provided. We were using Microsoft SQL Server Management Studio so far and relying only on that but some one recommend to us to use pganalyze to do the query analysis and we started using it for one project and we liked it much that we have started recomended to all projects teams ..
Return to navigation