Tue Nov 18 09:13:22 PST 2008
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] sl_status what does it mean?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
-----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-----
- Previous message: [Slony1-general] sl_status what does it mean?
- Next message: [Slony1-general] sl_status what does it mean?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list