Automatic Insights into Postgres Query PlansLearn 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.
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.
pganalyze automatically groups similar query plans together and highlights plans that differ significantly.
Index Advisor to Improve Postgres Query PerformanceLearn more about Postgres Index Recommendations with pganalyze Index Adivsor →
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 AnalysisLearn more about Postgres Query Analysis with pganalyze →
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 DashboardsLearn 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.
Analyze meaningful trends and get insights into your query performance history.
Collect detailed insights and receive tuning recommendations for your per-table autovacuum configuration.
Clear Understanding of Logs with pganalyze Log InsightsLearn more about pganalyze Log Insights →
Log Insights automatically extracts the logs into structured data, and filters any sensitive information.
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 DatabasesLearn 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.
Set up automated checks that analyze your Postgres configuration and suggest optimizations.
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 MonitoringLearn more about secure Database Monitoring with pganalyze →
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.
pganalyze normalizes query information so that only structural data is stored and presented.
pganalyze integrates with your Active Directory, LDAP, Okta or Google Apps setup.