On Fri, Jul 20, 2012 at 1:02 AM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:
> I was looking into this last month and some nice folks on the list pointed me to this formula
> for calculating lag. (to be run on the slave) similar to what Sergey said.
> 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;
If you have a connection problem this will not reflect the situation.
a database architect, software developer at PostgreSQL-Consulting.com
Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
In response to
pgsql-admin by date
|Next:||From: David Kerr||Date: 2012-07-20 04:10:50|
|Subject: Re: Measurin the lag between a master and a replica|
|Previous:||From: Madhu.Lanka||Date: 2012-07-20 02:33:36|
|Subject: ERROR: there is no parameter $1|