subscription_errors
Report apply and tablesync error counts per subscription to identify stuck subscriptions by checking apply_error_count in pg_stat_subscription_stats.
Instructions
Report apply and tablesync error counts per subscription.
Deterministic. Reads pg_stat_subscription_stats (PG15+) for apply_error_count and sync_error_count. A non-zero apply_error_count is the first sign of a wedged subscription. Run this on the SUBSCRIBER.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |