Influxdb-Telegraf主机性能信息Flux查询语句

1. cpu使用率

from(bucket: "cts")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "cpu")
  |> filter(fn: (r) => r["_field"] == "usage_nice" or r["_field"] == "usage_user")
  |> filter(fn: (r) => r["cpu"] == "cpu-total")
  |> filter(fn: (r) => r["host"] == "localhost.localdomain")
  |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
//   |> 
  |> pivot(columnKey: ["_field"], rowKey: ["_time"], valueColumn: "_value")
  |> map(fn:(r) => ({
    
    _time: r._time,
    _start: r._start,
    _stop: r._stop,
    _measurement: r._measurement,
    _value: (r.usage_nice + r.usage_user) * 100.0}))

2. 系统运行时间

from(bucket: "cts")
  |> range(star