Check out our new Resources section: Read through our eBooks and learn how customers are using pganalyze. See all resources

Deep insights into Postgres

Other monitoring tools show you what happened. pganalyze tells you why.

Atlassian
DoorDash
Moody's
fuboTv
SeniorLink
Salsify
CounterPath
Ipsy

Automatic Insights into Postgres Query Plans

Learn more about Automatic Collection and Insights into Postgres Query Plans →

Visualization of query plans

pganalyze visualizes EXPLAIN output in a convenient tree view as opposed to the dreaded wall of text.

Plan insights

Get plan insights based on query plan information, as well as other information gathered from your database.

Referencing of schema data

Access relevant schema data for a table that a Sequential Scan node has scanned and review which indexes exist on the table.

Plan grouping

pganalyze automatically groups similar query plans together and highlights plans that differ significantly.

Screenshot of Query Plan visualization
Screenshot of pganalyze Index Advisor for Postgres

Index Advisor to Improve Postgres Query Performance

Learn more about Postgres Index Recommendations with pganalyze Index Adivsor →

Index Recommendations

We recommend the best index that covers a specific query and provide helpful, actionable context.

Improve Query Performance

Get index recommendations based on your database schema and statistics and your query workload.

pganalyze Index Matrix

See which indexes could be used by your query, as well as the likely index that would be picked out of those.

Copy CREATE INDEX command

The pganalyze Index Advisor conveniently lets you copy the CREATE INDEX command for the best index.

Best-in-class Postgres Query Analysis

Learn more about Postgres Query Analysis with pganalyze →

Per-query statistics

Access statistics on a per-query basis and catch slow queries before they become big problems.

Automatically collect query plans

See how a query plan is executed with automatically collected execution plans using auto_explain.

Optimize your queries

Understand why a query is slow and whether an index can be created to make the query faster.

Deep query insights

Extract query samples from your log files and see how they relate to your query statistics.

Screenshot of Query Details page
Screenshot of Autovacuum Monitoring

Database Visualization and Sophisticated Dashboards

Learn more about Postgres Monitoring with pganalyze →

Avoid CLI tools

Uncover root causes to issues in minutes and stop wasting time with command line tools.

One single platform

View your logs and query statistics in one single platform and monitor your key metrics in real-time.

Trend analysis

Analyze meaningful trends and get insights into your query performance history.

Tuning recommendations

Collect detailed insights and receive tuning recommendations for your per-table autovacuum configuration.

Clear Understanding of Logs with pganalyze Log Insights

Learn more about pganalyze Log Insights →

Structured data

Log Insights automatically extracts the logs into structured data, and filters any sensitive information.

auto_explain integration

Automatically extract the output for the auto_explain extension that comes bundled with Postgres.

Postgres vacuum monitoring

Automatically combine information about vacuum logs with statistics data, and see it in one unified interface.

Careful PII filtering

Thanks to over 100 log filters, pganalyze filters PII from the log messages before it gets stored.

Example of Log Insights
Screenshot of Query Performance Dashboard with date picker

Performance Optimization for your Postgres Databases

Learn more about Postgres Performance Optimization with pganalyze →

Comparison over time

Get easy access to historic data, and zoom into specific moments of your database server performance.

Tuning recommendations

Set up automated checks that analyze your Postgres configuration and suggest optimizations.

Per-Table Detection

pganalyze detects per-table configuration, for example for table-specific autovacuum settings.

Buffer cache hit ratio

Easily get insights into your buffer cache hit ratio for each query, over time.

Secure Postgres Monitoring

Learn more about secure Database Monitoring with pganalyze →

Running on-premise

pganalyze can be run on-premise inside a Docker container behind your firewall, on your own servers.

Comply with local policies

Retain your database statistics data in the correct region of the world to comply with local policies.

Sensitive data

pganalyze normalizes query information so that only structural data is stored and presented.

SSO integration

pganalyze integrates with your Active Directory, LDAP or Google Apps setup. Okta coming soon.

Architecture pganalyze