Influxdb Querys: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Thomas (Diskussion | Beiträge) |
Thomas (Diskussion | Beiträge) |
||
| Zeile 1: | Zeile 1: | ||
=MEAN Value= | =MEAN Value= | ||
*SELECT MEAN("bytes") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic' | *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' | ||
=DERIVATIVE per Second= | =DERIVATIVE per Second= | ||
*SELECT DERIVATIVE("bytes,1s") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic' | *SELECT DERIVATIVE("bytes,1s") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic' | ||
Version vom 17. Mai 2017, 19:26 Uhr
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'
DERIVATIVE per Second
- SELECT DERIVATIVE("bytes,1s") FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'