Yes byte lag as well as it makes more sense. Regards, Granthana
Regards, Granthana On Tue, Jan 21, 2014 at 11:03 AM, Sameer Kumar <sameer.ku...@ashnik.com>wrote: > >> >> We are already using the following query: >> >> SELECT CASE WHEN pg_last_xlog_receive_location( >> ) = pg_last_xlog_replay_location() THEN 0 ELSE EXTRACT (EPOCH FROM now() >> - pg_last_xact_replay_timestamp()) END AS log_delay; >> >> This is (delay) not the correct thing to monitor. > > We cannot use pg_xlog_location_diff as we use postgresql 9.1. >> >> You can still use the other two methods I mentioned. > > > Regards > Sameer > Ashnik Pte Ltd, Singapore >