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 Transaction ID

Transaction ID

1 issues in this category.

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

XID Wraparound Risk

Critical

The database is approaching transaction ID wraparound, which would force PostgreSQL to shut down to prevent data corruption.