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.
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.
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.
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, Okta or Google Apps setup.
