replication_status
Check PostgreSQL replication health including physical and logical standbys, replication slots, WAL status, and archiving to diagnose replica lag and potential issues.
Instructions
Comprehensive replication health - physical, logical, CDC, slots, WAL, archiving.
LEVEL: Server (PostgreSQL instance level)
USE FOR: replication status, replica lag, standby, streaming replication, replication slots, CDC, logical replication, publications, subscriptions, WAL archiving, backup progress, "is replication healthy?", "how far behind is the replica?". DO NOT USE FOR: database-level health (use database_health), query performance (use query_performance), PostgreSQL settings (use configuration_review).
INCLUDE OPTIONS:
'all': Everything (default)
'physical': Standbys, streaming replication, replay lag
'logical': CDC status, wal_level, publications, subscriptions, logical slots
'slots': All replication slots (physical and logical), inactive slot warnings
'wal': WAL info, WAL settings
'archiving': Archive mode, archiver status, failed archives, active basebackups
Examples: replication_status() - Full replication report replication_status(include='physical') - Physical replication only replication_status(include='logical') - Logical replication/CDC only replication_status(include='slots') - Replication slots only replication_status(include='wal') - WAL status only replication_status(include='archiving') - WAL archiving status
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include | No | What to include: 'all', 'physical', 'logical', 'slots', 'wal', 'archiving' | all |
| url | No | Database URL for auto-connection | |
| format | No | Output format: 'json' or 'markdown' | json |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |