On Fri, Jul 20, 2012 at 1:02 AM, David Kerr <[email protected]> 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. -- Sergey Konoplev a database architect, software developer at PostgreSQL-Consulting.com http://www.postgresql-consulting.com Jabber: [email protected] Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
