Re: Check Replication lag - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Check Replication lag
Date
Msg-id 20211011125204.GA18100@depesz.com
Whole thread Raw
In response to Check Replication lag  (Pawan Sharma <pawanpg0963@gmail.com>)
Responses Re: Check Replication lag
List pgsql-general
On Mon, Oct 11, 2021 at 05:58:03PM +0530, Pawan Sharma wrote:
> Is there a way to monitor the replication lag, where replica nodes are
> configured through aws s3.

You can check it on replica, by issuing:
select now() - pg_last_xact_replay_timestamp();

and it will show you, more or less, what is your current lag.

Best regards,

depesz




pgsql-general by date:

Previous
From: Pawan Sharma
Date:
Subject: Check Replication lag
Next
From: Pawan Sharma
Date:
Subject: Re: Check Replication lag