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 SameerAshnik Pte Ltd, Singapore
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;
We cannot use pg_xlog_location_diff as we use postgresql 9.1.
pg_xlog_location_diff as we use postgresql 9.1.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных