-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Geoffrey a écrit :
> 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.
> 

st_origin is the node that produced the sync event.
st_received is the node that received it.
st_last_event is the number of the last produced event (on st_origin).
st_last_event_ts is the timestamp when st_last_event was produced.
st_last_received is the number of the last sync st_received did receive (i.e.
the event it confirmed), event originated on st_origin.
st_last_received_ts is time of confirmation on receiver
st_last_received_event_ts is time of event received
st_lag_num_events is the difference between st_last_event and st_last_received.
st_lag_time is the difference between current time and st_last_event_ts.

Everything may be deduced from the vue definition :

SELECT e.ev_origin AS st_origin, c.con_received AS st_received, e.ev_seqno AS
st_last_event, e.ev_timestamp AS st_last_event_ts, c.con_seqno AS
st_last_received, c.con_timestamp AS st_last_received_ts, ce.ev_timestamp AS
st_last_received_event_ts, e.ev_seqno - c.con_seqno AS st_lag_num_events, now()
- - ce.ev_timestamp::timestamp with time zone AS st_lag_time
   FROM _rep.sl_event e, _rep.sl_confirm c, _rep.sl_event ce
  WHERE e.ev_origin = c.con_origin AND ce.ev_origin = e.ev_origin AND
ce.ev_seqno = c.con_seqno AND ((e.ev_origin, e.ev_seqno) IN ( SELECT
sl_event.ev_origin, max(sl_event.ev_seqno) AS max
           FROM _rep.sl_event
          WHERE sl_event.ev_origin = _rep.getlocalnodeid('_rep'::name)
          GROUP BY sl_event.ev_origin)) AND ((c.con_origin, c.con_received,
c.con_seqno) IN ( SELECT sl_confirm.con_origin, sl_confirm.con_received,
max(sl_confirm.con_seqno) AS max
           FROM _rep.sl_confirm
          WHERE sl_confirm.con_origin = _rep.getlocalnodeid('_rep'::name)
          GROUP BY sl_confirm.con_origin, sl_confirm.con_received));

Regards,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
Dalibo - http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJIveBA+REPKWGI0ERAjeEAJ0crNwk3fNpRIrqtq/zvoD9lBjZgQCgwTkK
afh/2nVdhO9uI9z5wjnfjaU=
=EOEw
-----END PGP SIGNATURE-----