[Enhanced Monitoring] pglogical.show_subscription_table
- Dominant language
- Python
- Stars
- 22
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
**Is your feature request related to a problem? Please describe.**
It would be nice to extract all the table sync info from pglogical when running replication, to see if table copies have finished, replication level, etc. Seems `pglogical.show_subscription_table` is the command to run.
**Describe the solution you'd like**
An extra view with all tables in the subscription listed, along with their sync status and level.
**Describe alternatives you've considered**
N/A, we have no insight into this right now.
**Additional context**
DMS shows this on a per-table level too. We need this!
Contributor guide
Research direction
Start by locating the existing monitoring views and the PostgreSQL/pglogical integration, using pglogical.show_subscription_table as the entry point. Determine how subscription table names, sync status, and replication level are exposed, then add a view listing those values for every table in a subscription. Done means table-copy progress and replication details are queryable per table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgres, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100