Sorry, just wanted to make a little correction:
I get the status report in the target as replicating when I query this:
SELECT * FROM pglogical.show_subscription_status();
But I do not know how to check the stats for this.
Appreciate any help.
On Wed, Jul 31, 2024 at 8:49 AM Siraj G <tosiraj.g@xxxxxxxxx> wrote:
Hello Admins!I am trying to find the replication lag in the target that is being replicated using pglogical. I do not see any data in pg_stat_subscription. We are replicating data from GCP cloud SQL to a compute instance within the same VCN.I get the status report in the target as replication, but not sure why pg_stat_subscription does not show anything.Should I do it programmatically by creating a heartbeat table on the source, add it to the replication and monitor the data in this to get the report?Thanks in advance!RegardsSiraj
