Autodesk / Autodesk/pgbelt

[Enhanced Monitoring] pglogical.show_subscription_table

Open
#176 3 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.