Search Postgresql Archives

Re: Correct query to check streaming replication lag

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.kumar@xxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux