JP Fletcher jpfletch at ca.afilias.info
Tue Nov 18 08:59:29 PST 2008
The last event originating on node 1 was 73226.  The last event 
originating on node 1 that was received by node 2 was 73226.  Describe 
the view sl_status, and you'll see the way the lagtime is calculated.

Geoffrey wrote:
> Can someone tell me what is meant by the following data from sl_status?
>
>  st_origin | st_received | st_last_event |      st_last_event_ts      
> | st_last_received |    st_last_received_ts    | 
> st_last_received_event_ts  | st_lag_num_events | st_lag_time
> -----------+-------------+---------------+----------------------------+------------------+---------------------------+----------------------------+-------------------+------------- 
>
>          1 |           2 |         73226 | 11/18/2008 09:52:03.588658 
> |            73226 | 11/18/2008 09:54:45.17624 | 11/18/2008 
> 09:52:03.588658 |                 0 | @ 2.25 secs
> (1 row)
>
> That is, 'st_origin' == 1.  Does 1 indicate a particular status?  Same 
> for 'st_received', what does the value 2 tell me?
>
> Is 2.25 secs st_lag_time good?
>
> Thanks for any info.
>


-- 
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
jpfletch at ca.afilias.info




More information about the Slony1-general mailing list