Welcome to the pganalyze documentation!
Learn more about how pganalyze works, and how to connect it with your Postgres database. pganalyze enables you to deliver consistent PostgreSQL performance and availability, at any scale.
Installation guides
In order to use pganalyze you need to install the pganalyze collector in your environment, either on the database server directly, or a container / VM that can connect to it when using managed database services. The collector sends query data and other statistics on a continuous basis — to the pganalyze cloud service, or to your pganalyze Enterprise Server installation.
To continue, select in which environment you are running your Postgres database:
Amazon Web Services
RDS and Aurora
Microsoft Azure
Flexible Server and Cosmos DB
Google Cloud
Cloud SQL and AlloyDB
Self-Managed
VM, Container, On-Premise
Heroku
Heroku Postgres
Crunchy Data
Crunchy Bridge
Aiven
Managed PostgreSQL
Explore how pganalyze works
pganalyze Index AdvisorAutomatically finds missing indexes and unused index insightsIndexing EngineExtracts table scans and identifies missing indexes using "What If?" analysis
pganalyze VACUUM AdvisorWorkload-aware autovacuum tuning and insights for PostgresAlerts & Check-UpDetects common database problems and notifies via email, Slack and PagerDuty
ConnectionsMonitors wait events, lock problems and other activity in near-realtimeEXPLAINCollects query plans for slow Postgres queries and finds insights
Schema StatisticsTracks workload patterns, schema and data model design, as well as changes over timeQuery PerformanceIdentify slowdowns for specific queries over time
Manage your pganalyze installation
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →