index.mdx

title
Welcome to the pganalyze documentation!

import styles from './style.module.scss'

import OverviewInstallChoice from './_install_choice.mdx'

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:

If you're interested in integrating pganalyze with your database hosting provider but don't see it listed as officially supported, you can follow the manual installation guide for self-managed databases. You will need to run the pganalyze collector on a server with network connectivity to your database in order to monitor your database. Note that system-level statistics (memory usage, I/O, etc.) cannot be collected this way and will not be available in pganalyze. Log Insights (and the features that depend on it) is only available if your provider exports Postgres logs for your database server via syslog.

Explore how pganalyze works

pganalyze Index Advisor Automatically finds missing indexes and unused index insights Indexing Engine Extracts table scans and identifies missing indexes using "What If?" analysis

pganalyze VACUUM Advisor Workload-aware autovacuum tuning and insights for Postgres Alerts & Check-Up Detects common database problems and notifies via email, Slack and PagerDuty

Connections Monitors wait events, lock problems and other activity in near-realtime EXPLAIN Collects query plans for slow Postgres queries and finds insights

Schema Statistics Tracks workload patterns, schema and data model design, as well as changes over time Query Performance Identify slowdowns for specific queries over time

Log Insights Continuously monitors your Postgres error log for unexpected events

Manage your pganalyze installation

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

pganalyze collector Configure the agent that runs within your environment to collect data GraphQL API Retrieve data that is available in pganalyze programmatically