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?
