Influxdb Querys: Unterschied zwischen den Versionen

Aus Xinux Wiki
Zur Navigation springen Zur Suche springen
Thomas (Diskussion | Beiträge)
 
(Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt)
Zeile 3: Zeile 3:
=Calculate=
=Calculate=
*SELECT MEAN("bytes") / 10000000000 FROM "telegraf"."autogen"."iptables" WHERE time > now() - 15m AND "host"='worf.xinux.lan' AND "ruleid"='input-traffic'
*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'

Links