2016-10-31 15:54 GMT+13:00 Venkata B Nagothi <nag1...@gmail.com>: > > 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 > >
Thanks!!!!