[prev in list] [next in list] [prev in thread] [next in thread] 

List:       slony1-general
Subject:    Re: [Slony1-general] Slon not catching up
From:       Christopher Browne <cbbrowne () ca ! afilias ! info>
Date:       2006-03-22 17:25:18
Message-ID: 4421887E.4070509 () ca ! afilias ! info
[Download RAW message or body]

Vivek Khera wrote:

>On Mar 22, 2006, at 11:11 AM, Scott Marlowe wrote:
>
>  
>
>>Would welcome any suggestions for a better query to check the  
>>health of
>>the set.
>>    
>>
>
>My simple test, which I use from a nagios monitoring plugin, is this:
>
>SELECT date_part('epoch',st_lag_time)::INTEGER FROM _$ 
>{cluster}.sl_status WHERE st_origin=$origin_node AND st_received= 
>$subscriber_node
>
>It gives me the number of seconds behind the subscriber is, which is  
>for me the most important measure.  The lag_time is based on last  
>event timestamp.  I suspect both queries give basically the same info  
>in the end.
>
>  
>
We're using a query much like this for MRTG graphing.

[prev in list] [next in list] [prev in thread] [next in thread]