Re: [asterisk-users] queue show queue-name vs queue log for calculating average hold time
On Wed, Jan 28, 2015 at 1:37 PM, Paul Belanger paul.belan...@polybeacon.com wrote: On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik i...@pack-net.co.uk 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]. Opps, sent instead of pasting. Either way, your likely better off rendering the data using the raw sql info vs depending on CLI output. That's what we've done. [1] http://en.wikipedia.org/wiki/Moving_average -- Paul Belanger | PolyBeacon, Inc. Jabber: paul.belan...@polybeacon.com | 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
Re: [asterisk-users] queue show queue-name vs queue log for calculating average hold time
On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik i...@pack-net.co.uk 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: paul.belan...@polybeacon.com | 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
[asterisk-users] queue show queue-name vs queue log for calculating average hold time
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 Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: i...@pack-net.co.uk w: http://www.pack-net.co.uk Registered Address: PACKNET LIMITED, Duplex 2, Ducie House 37 Ducie Street Manchester, M1 2JW COMPANY REG NO. 04920552 -- _ -- 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