0

Details:

  • Grafana version: 2.5.0
  • Datasource: influxdb
  • OS: ubuntu server 14.04

I was trying to get the current speed rate in megabit/s from a server interface but I cannot figure out how to transform "if_octets" in Megabit/s using Grafana. Or better I don't know what query to use.

I used this query but I have no output

select derivative(mean(value), 1s) from "interface_rx" where "istance" ='em1' and "type" = 'if_octects' and time > now() - 4h group by time(1m)
ROMANIA_engineer
  • 54,432
  • 29
  • 203
  • 199
Diego Aguiari
  • 33
  • 1
  • 8

1 Answers1

1

The following query will give you the number of if_octets/s.

select derivative(sum(value), 1s) ... group by time(1s)

Essentially, for each second we want to sum together all of the values in the previous second, and take the rate of change of that value.

See this description of the derivative for more details on why we want to group by time(1s).

Community
  • 1
  • 1
Michael Desa
  • 4,607
  • 24
  • 19