meter one-minute problem,one-minute is 100 times less

[Serega Sheypak]

Hi, I have a problem, can't understand what's wrong

Here is influx db query

select mean(count) from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

430515860000 551

1430515870000 553

1430515880000 556

1430515890000 563

1430515900000 570

1430515910000 574

1430515920000 578

here is one-minute query

select mean("one-minute") from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

1430515860000 0.45540621578410007

1430515870000 0.4309092320324512

1430515880000 0.4114515620981317

1430515890000 0.40969353803751857

1430515900000 0.4696127128420458

1430515910000 0.4870723860099401

1430515920000 0.474983762626429

I suppose that value for one-minute should be in 100 greater...

What do I do wrong?

[Jens]

select mean(count) from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

430515860000 551

1430515870000 553

1430515880000 556

1430515890000 563

1430515900000 570

1430515910000 574

1430515920000 578

meter.count is the number of events occurred. If you call meter.mark() it is equivalent to add one event, and if you call meter.mark(n) you have added n events.

So your query gives you a mean value of your visitors within 10 second intervals.

 

here is one-minute query

select mean("one-minute") from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

1430515860000 0.45540621578410007

1430515870000 0.4309092320324512

1430515880000 0.4114515620981317

1430515890000 0.40969353803751857

1430515900000 0.4696127128420458

1430515910000 0.4870723860099401

1430515920000 0.474983762626429

I suppose that value for one-minute should be in 100 greater...

The number should probably be treated as milliseconds. So within a one minute interval you have roughly every 450ms a new visitor.

-- J.

[Stephen Connolly]

On 1 May 2015 at 22:48, Serega Sheypak <serega....@gmail.com> wrote:

Hi, I have a problem, can't understand what's wrong

Here is influx db query

select mean(count) from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

430515860000 551

1430515870000 553

1430515880000 556

1430515890000 563

1430515900000 570

1430515910000 574

1430515920000 578

count is the running count. It increases, so at

Fri, 01 May 2015 21:31:00 GMT the count was 551

Fri, 01 May 2015 21:31:10 GMT the count was 553, meaning you had 2 new visitors in those 10 seconds

...

Fri, 01 May 2015 21:32:00 GMT the count was 578, meaning you had 27 visitors in total for the one minute from 21:31:00 until 21:32:00

That is a per-minute rate of 0.45

here is one-minute query

select mean("one-minute") from "visitor.meter.meter" where time > now() - 15m group by time(10s) order asc

result:

1430515860000 0.45540621578410007

1430515870000 0.4309092320324512

1430515880000 0.4114515620981317

1430515890000 0.40969353803751857

1430515900000 0.4696127128420458

1430515910000 0.4870723860099401

1430515920000 0.474983762626429

Oh look the per minute rates are around 0.45

Seems correct to me

 

I suppose that value for one-minute should be in 100 greater...

What do I do wrong?

--
You received this message because you are subscribed to the Google Groups "metrics-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to metrics-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.