pganalyze

The product is a SaaS platform for PostgreSQL performance monitoring and tuning that detects slow queries, missing indexes, and vacuum and bloat issues through continuous profiling and automated advisors. It is for developers, data teams, and operations and IT staff in businesses that run Postgres at scale, including teams using managed services such as AWS, Azure, GCP, Supabase and Neon. It is delivered as a cloud service via a collector installed alongside the database, with an enterprise server deployment option and integrations for major cloud platforms.

Key features

• Query Advisor for query plan problems
• Index Advisor for missing indexes
• VACUUM Advisor for bloat and freezing
• Workbooks for query optimization
• Per-query statistics and history
• Automatic EXPLAIN plan collection
• Tuning recommendations for slow queries
• Per-table autovacuum recommendations
• Configuration tuning for workload
• Log insights and monitoring dashboards
• Buffer cache hit ratio tracking
• I/O vs CPU time analysis