Queue Show 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
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=’
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].
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