Calculating Replication Lag - units - Mailing list pgsql-general

From David Kerr
Subject Calculating Replication Lag - units
Date
Msg-id 20120625201722.GB37347@mr-paradox.net
Whole thread Raw
Responses Re: Calculating Replication Lag - units  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Calculating Replication Lag - units  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
Howdy,

When calculating Replication lag, I know that we have to compare the pg_current_xlog_location
to pg_last_xlog_receive_location, etc. but what I'm trying to figure out is what are
the units that I'm left with after the calculation.

(i.e., does the xlog_location imply some time value?)

Here's the output of the (slightly modified script)
Master: 5003964876715
Receive: 5003964876715
Replay: 5003964765203

receive.value 0
apply.value 111512

111512 isn't inherently useful to me on its own.

Any tips?

Thanks

Dave

pgsql-general by date:

Previous
From: Eduardo Morras
Date:
Subject: UFS2 Snapshots and Postgres
Next
From: Marlon Pascoal
Date:
Subject: 08006 Connection Closed