Re: Correct query to check streaming replication lag

[Sameer Kumar <sameer.kumar@xxxxxxxxxx>]

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