On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik <[email protected]> wrote: > Hi > > We're using 1.8.23.1 on CentOS 5 and are trying to get accurate stats for > queues. > > For a particular customer, when I run queue show <queue_name> I get the > following numbers: > > <queue_name> has 0 calls (max unlimited) in 'ringall' strategy (17s > holdtime, 94s talktime), W:0, C:175, A:44, SL:48.6% within 45s > > So from that data we look at > 17s holdtime > And assume that is the average hold time before calls get answered by a > queue members. > > However, if I calculate the average hold time from out queue log table using > the following SQL > > select sum(data1)/ count(*) as ave_hold_time from queue_log where time > > DATE(NOW()) and queuename='<queue_name>' and event='CONNECT'; > > I get the vastly different figure of 92.4. > > So, is the queue show figure wrong due to a bug or am I making an incorrect > assumption as to what it means? > > Thanks in advance > Welcome to business logic embedded into app_queue. The issue with the queue show command rendering stats, is what timeframe are the stats aggregated over? IIRC, the calculations are using a moving average[1].
-- Paul Belanger | PolyBeacon, Inc. Jabber: [email protected] | IRC: pabelanger (Freenode) Github: https://github.com/pabelanger | Twitter: https://twitter.com/pabelanger -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
