topic Graph of peak traffic measured by hour in Dashboards & Visualizations

Graph of peak traffic measured by hour

karthy — Fri, 06 May 2011 08:11:48 GMT

I have an apache-like access log and would like to graph the traffic by hour. However, the graph I want is a graph of the number of requests pr. hour divided by 60*60 so that it is easy to identify the busy hour expressed in requests pr. seconds.

I assume I have to use bins or span, but I have been unsuccessful so far. Any hints?

Re: Graph of peak traffic measured by hour

David — Fri, 06 May 2011 13:49:10 GMT

If you're looking for the average per hour, I'd go this route:

YourSearch | timechart span=1h count as TotalRequests 
           | eval RequestsPerSecond = TotalRequests/3600

If you wanted to look at the actual busiest second, you could go for:

YourSearch | bucket _time span=1s 
           | stats count as RequestsPerSec by _time 
           | timechart span=1h avg(RequestsPerSec) Max(RequestsPerSec)

Re: Graph of peak traffic measured by hour

karthy — Tue, 10 May 2011 13:46:38 GMT

Thanks - works just right!

Re: Graph of peak traffic measured by hour

David — Tue, 10 May 2011 14:19:57 GMT

Excellent! I'm glad to hear it.