Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Enhanced Monitoring] pglogical.show_subscription_table #176

Open
vjeeva opened this issue Mar 2, 2023 · 3 comments
Open

[Enhanced Monitoring] pglogical.show_subscription_table #176

vjeeva opened this issue Mar 2, 2023 · 3 comments

Comments

@vjeeva
Copy link
Contributor

vjeeva commented Mar 2, 2023

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!

@vjeeva
Copy link
Contributor Author

vjeeva commented Mar 29, 2023

database=> SELECT pglogical.show_subscription_table('pg1_pg2', 'some_table');
            show_subscription_table
-----------------------------------------------
 (public,some_table,replicating)

@vjeeva
Copy link
Contributor Author

vjeeva commented Oct 5, 2023

During the initializing COPY phase, we see unknown above. We should also track table sizes in the destination against the source, and also have a column for that table replication status (unknown == initial copy it seems).

@vjeeva
Copy link
Contributor Author

vjeeva commented Oct 11, 2023

Note that this command must be run on the destination database.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant