On Mon, Oct 31, 2016 at 11:57 AM, Patrick B <patrickbake...@gmail.com> wrote:
> Hi guys, > > I'm using this query to measure the delay between a Master and a Streaming > Replication Slave server, using PostgreSQL 9.2. > > SELECT >> pg_last_xlog_receive_location() receive, >> pg_last_xlog_replay_location() replay, >> ( >> extract(epoch FROM now()) - >> extract(epoch FROM pg_last_xact_replay_timestamp()) >> )::int lag; > > > In your opinion, is that right? > > Yes, thats right. Regards, Venkata B N Database Consultant
