Postgres Pro
Downloads
Home   >   mailing lists

[ADMIN] How to measure replication lag in logical replication setup. - Mailing list pgsql-admin

From rammohan ganapavarapu
Subject [ADMIN] How to measure replication lag in logical replication setup.
Date
Msg-id CALm_VjgnWfTimUMCB3+71R2FGr9fuzJWWoYEc56UcyHCP9-vQA@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] How to measure replication lag in logical replicationsetup.
List pgsql-admin
Tree view
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;
 time_lag
----------

(1 row)

this is my slot details

SELECT * FROM pg_replication_slots;
 slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin | restart_lsn
-----------+--------+-----------+--------+----------+--------+------+--------------+-------------
 slot_1    |        | physical  |        |          | t      | 1983 |              | 0/50805C8


In my case slot_type is physical,  does it look ok or for logical replication the slot_type should be logical?

Thanks,
Ram

pgsql-admin by date:

Previous
From: Yuri Martsinovsky
Date:
Subject: [ADMIN] Running Windows binaries from non-English folder
Next
From: Thomas Kellerer
Date:
Subject: Re: [ADMIN] Running Windows binaries from non-English folder