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

Microsoft Azure

Flexible Server and Cosmos DB

Cloud SQL and AlloyDB

VM, Container, On-Premise

Heroku Postgres

Managed PostgreSQL

Explore how pganalyze works

pganalyze Index AdvisorAutomatically finds missing indexes and unused index insights Indexing EngineExtracts table scans and identifies missing indexes using "What If?" analysis

pganalyze VACUUM AdvisorWorkload-aware autovacuum tuning and insights for Postgres Alerts & Check-UpDetects common database problems and notifies via email, Slack and PagerDuty

ConnectionsMonitors wait events, lock problems and other activity in near-realtime EXPLAINCollects query plans for slow Postgres queries and finds insights

Schema StatisticsTracks workload patterns, schema and data model design, as well as changes over time Query PerformanceIdentify slowdowns for specific queries over time

Log InsightsContinuously monitors your Postgres error log for unexpected events

Manage your pganalyze installation

Account Management & SSOManage accounts with different roles, and enable Single Sign-On through SAML pganalyze Enterprise ServerInstall pganalyze as a fully self-hosted version behind your firewall

pganalyze collectorConfigure the agent that runs within your environment to collect data GraphQL APIRetrieve data that is available in pganalyze programmatically

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →