Influxdb Querys

MEAN Value

• SELECT MEAN("bytes") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'

Calculate

• SELECT MEAN("bytes") / 10000000000 FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'

• SELECT mean("value") * 100 / mean("max") FROM "disk" WHERE "metric" = '/' AND "hostname" = 'doom.xinux.lan' AND time > now() - 15m ;

DERIVATIVE per Second

• SELECT DERIVATIVE("bytes,1s") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'

Links

• https://docs.influxdata.com/influxdb/v1.7/query_language/schema_exploration/#