Logo PG Pilot PG Pilot
Features About Docs
What's New Log In Sign Up

Getting Started

  • Overview
  • Installation
  • Inviting Collaborators

Features

  • Query Monitoring
  • Index Health
  • Table Monitoring
  • Vacuum Management
  • Replication Monitoring
  • Connection Management
  • Configuration Management
  • Schema Monitoring
  • Dashboard

Issues Reference

Index Issues

  • Duplicate Index
  • Integer Primary Key
  • Invalid Index
  • Unindexed Foreign Key
  • Unused Index

Table Health

  • Autovacuum Disabled on Table
  • Freeze Age Risk
  • High Sequential Scan Ratio
  • Table Bloat
  • Tables Needing Vacuum
  • Unlogged Table

Sequence Issues

  • Sequence Near Exhaustion

Transaction ID

  • XID Wraparound Risk

Replication

  • High Replication Lag
  • Inactive Replication Slot
  • Old Replication Slot XMIN
  • WAL Status Issues

Connections

  • Connection Blocking
  • Connection Pool Exhaustion
  • Idle Connection
  • Idle Transaction
  • Long-Running Query
  • Old Transaction

Configuration

  • Autovacuum Disabled Globally
  • Debug Logging Enabled
  • Excessive Statement Logging
  • Few Superuser Reserved Connections
  • High Autovacuum Freeze Max Age
  • Index Scans Disabled
  • Index-Only Scans Disabled
  • Log Minimum Duration Zero
  • Low Checkpoint Completion Target
  • No Idle Transaction Timeout
  • No Lock Timeout
  • No Statement Timeout
  • Statistics Tracking Disabled
  • Synchronous Commit Disabled
  • WAL Level Minimal
  • Weak Password Encryption
  • fsync Disabled
  • full_page_writes Disabled

Extensions

  • Extension Update Available
Docs Issues Extensions

Extensions

1 issues in this category.

All Index Issues Table Health Sequence Issues Transaction ID Replication Connections Configuration Extensions

Extension Update Available

Notice

An installed PostgreSQL extension has a newer version available that should be applied for security and feature improvements.