Re: Logical replication data lag

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(dot)g(at)gmail(dot)com> 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!
> Regards
> Siraj
>