Influxdb Querys: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Thomas (Diskussion | Beiträge) |
|||
(4 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
=MEAN Value= | =MEAN Value= | ||
− | *SELECT | + | *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= | =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' | ||
+ | =Links= | ||
+ | *https://docs.influxdata.com/influxdb/v1.7/query_language/schema_exploration/# |
Aktuelle Version vom 20. September 2020, 15:09 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'
- 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'