Queue Show Vs Queue Log For Calculating Average Hold Time

Home » Asterisk Users » Queue Show Vs Queue Log For Calculating Average Hold Time
Asterisk Users 2 Comments

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 I get the following numbers:

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=’‘ 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

2 thoughts on - Queue Show Vs Queue Log For Calculating Average Hold Time

  • 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].