Documentation

Installation Guide

• Troubleshooting

Log Insights

• Initial setup

  • Amazon RDS & Amazon Aurora
  • Azure Database for PostgreSQL
  • Google Cloud SQL
  • Heroku Postgres
  • Self-managed Postgres Server
• Tuning Log Config Settings

• Classifications

  • Server
  • Connections
  • WAL & Checkpoints
  • Autovacuum
  • Locks
  • Statements
  • Standby Servers
  • Constraint Violations
  • Application / User Errors

EXPLAIN

• Set up automatic EXPLAIN plan collection

  • auto_explain
  • Log-based EXPLAIN

• Insights

  • Disk Sort
  • Expensive
  • Hash Batches
  • Inefficient Index
  • I/O Heavy
  • Large Offset
  • Lossy Bitmaps
  • Mis-Estimate
  • Slow Scan
  • Stale Stats

• Scan nodes

  • Sequential Scan
  • Index Scan
  • Index-Only Scan
  • Bitmap Heap Scan
  • Bitmap Index Scan
  • CTE Scan
  • Custom Scan
  • Foreign Scan
  • Function Scan
  • Subquery Scan
  • Table Sample Scan
  • Tid Scan
  • Values Scan
  • Work Table Scan

• Join nodes

  • Hash Join
  • Merge Join
  • Nested Loop

• Other nodes

  • Aggregate
  • Append
  • Bitmap And
  • Bitmap Or
  • Gather Merge
  • Gather
  • Group
  • Hash
  • Limit
  • Lock Rows
  • Materialize
  • Merge Append
  • Modify Table
  • Project Set
  • Recursive Union
  • Result
  • SetOp
  • Sort
  • Unique
  • Window Aggregate

Enterprise Edition

• Initial Setup
• Release Changelog
• Log Insights Setup
• Google Auth Setup
• Upgrading to new releases

pganalyze GraphQL API

• Creating an API key

• Queries

  • getIssues - Get check-up issues and alerts
  • getQueryStats - Export query statistics

• Mutations

  • addServer - Add a server to pganalyze Enterprise Edition