Skip to navigation
Watch our latest webinar on demand: Postgres 19 in practice: what shipped, what got cut, and how to test it
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
      • Log Insights Setup
      • Automated EXPLAIN Setup
        • Overview
        • auto_explain
          • Overview
          • Amazon RDS & Amazon Aurora
          • Azure Database for PostgreSQL
          • Google Cloud SQL
          • Supabase
            • Step 1: Check for auto_explain
            • Step 2: Enable auto_explain
            • Step 3: Review auto_explain settings
            • Step 4: Test and Verify
          • Crunchy Bridge
          • Heroku Postgres
          • Self-Managed Server
        • Log-based EXPLAIN
      • 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
❮ Automated EXPLAIN: Setup

Step 2: Enable auto_explain

On Supabase, shared_preload_libraries is not user-configurable, but it includes auto_explain by default. If auto_explain doesn’t show up in shared_preload_libraries for your project, contact Supabase support.

Once that’s confirmed, continue to the next step to configure auto_explain at the role level.

Proceed to Step 3: Review auto_explain settings


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.