Skip to navigation
Watch our latest webinar on demand: Optimizing Postgres with Claude Code and the pganalyze MCP Server.
pganalyze
  • Docs
  • Our Key Features
    Query AdvisorDetect and fix Postgres query plan problemsIndex AdvisorFaster queries, less guessworkVACUUM AdvisorOptimize bloat, freezing and VACUUM performanceWorkbooksDedicated environment for query optimization
    All features
  • Fix Slow QueriesEnterprise Scale
  • Pricing
  • Blog
  • WebinarseBooksToolsCustomer StoriesBlogNewsletter
  • About usCareers
  • Contact
LoginFree Trial
pganalyze
Docs
Query AdvisorDetect and fix Postgres query plan problemsIndex AdvisorFaster queries, less guessworkVACUUM AdvisorOptimize bloat, freezing and VACUUM performanceWorkbooksDedicated environment for query optimization
See all features
Fix Slow QueriesEnterprise Scale
PricingBlog
WebinarseBooksToolsCustomer StoriesBlogNewsletter
About usCareers
Contact
Free TrialLog in
    • Overview
    • Installation Guide
      • Overview
      • Initial Setup
        • Amazon RDS and Amazon Aurora
        • Azure Database for PostgreSQL
        • Google Cloud SQL and AlloyDB
        • Crunchy Bridge
        • Heroku Postgres
        • Aiven
        • Self-managed (and other hosted Postgres)
          • Choose Setup Method
          • Guided Setup
          • Manual Setup
            • Step 1: Create Monitoring User
            • Step 2: Enable pg_stat_statements
              • Choose deployment
              • Ubuntu & Debian
              • RHEL, CentOS & Fedora
              • Docker
            • Step 3: Install the collector
            • Step 4: Configure the collector
      • Log Insights Setup
      • Automated EXPLAIN Setup
      • Troubleshooting
    • pganalyze Collector
    • Query Performance
    • Query Advisor
    • EXPLAIN Plans
    • Workbooks
    • Index Advisor
    • Indexing Engine
    • VACUUM Advisor
    • Schema Statistics
    • Log Insights
    • Connections
    • Alerts & Check-Up
    • Account Management
    • MCP Server (Preview)
    • OpenTelemetry Integration
    • pganalyze Enterprise Server
    • pganalyze GraphQL API
    • Open-Source Components
❮ Installation Guide

Step 2: Enable pg_stat_statements

In this step we setup pg_stat_statements, which is used by pganalyze to collect Postgres query statistics.

To continue, we need to know where your collector is running:

Logo of Ubuntu & DebianUbuntu & Debian
Logo of RHEL, CentOS & FedoraRHEL, CentOS & Fedora
Logo of Amazon Linux 2Amazon Linux 2
Logo of DockerDocker

If your Postgres runs somewhere else, let us know & we’re happy to help.


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

Logo
  • Contact
  • Plans & Pricing
  • Resources
  • Enterprise
  • Documentation
  • Customer Stories
  • Careers
  • Index Advisor
  • Security
  • Status
  • Postgres Query Formatter
  • Compare pganalyze
  • Terms of Service
  • Privacy Policy
  • Newsletter
  • SOC 2 Type 2
  • Do Not Sell My Personal Information

Get in touch

Use the contact us form or email sales:
 sales@pganalyze.com

SOC 2 certification

pganalyze is SOC 2 Type 2 certified

pganalyze is SOC 2 Type 2 certified
© 2026 Duboce Labs, Inc.