VoIP Mailing List Archives :: View topic - [asterisk-users] queue show <queue-name> vs queue log for calculating average hold time

Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community

[asterisk-users] queue show <queue-name> vs queue log for calculating average hold time

VoIP Mailing List Archives Forum Index -> Asterisk Users

View previous topic :: View next topic

Author

Message

ish at pack-net.co.uk
Guest

Posted: Wed Jan 28, 2015 12:24 pm Post subject: [asterisk-users] queue show <queue-name> vs queue log

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

--

Quote:

Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish@pack-net.co.uk (ish@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

paul.belanger at polyb...
Guest

Posted: Wed Jan 28, 2015 1:37 pm Post subject: [asterisk-users] queue show <queue-name> vs queue log

On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik <ish@pack-net.co.uk> wrote:

Quote:

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.belanger@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

paul.belanger at polyb...
Guest

Posted: Wed Jan 28, 2015 1:39 pm Post subject: [asterisk-users] queue show <queue-name> vs queue log

On Wed, Jan 28, 2015 at 1:37 PM, Paul Belanger
<paul.belanger@polybeacon.com> wrote:

Quote:

On Wed, Jan 28, 2015 at 12:23 PM, Ishfaq Malik <ish@pack-net.co.uk> wrote:

Quote:

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

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.belanger@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

Display posts from previous:

	VoIP Mailing List Archives Forum Index -> Asterisk Users	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum