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