From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of rammohan ganapavarapu Sent: Tuesday, November 07, 2017 9:52 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] How to measure replication lag in logical replication setup.
HI,
How to measure replication lag time in case of logical replication?
this query is returning empty
SELECT now() - pg_last_xact_replay_timestamp() AS time_lag;