Guest User

InfluxDB dashbord queries

a guest
May 26th, 2022
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. Query for Velocidad de download - Media:
  2. from(bucket: "<bucket>")
  3. |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  4. |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
  5. |> filter(fn: (r) => r["_field"] == "download_bandwidth")
  6. |> filter(fn: (r) => r["host"] == "raspberrypi")
  7. |> map(
  8. fn: (r) => ({
  9. _time: r._time,
  10. _measurement: r._measurement,
  11. _field: r._field,
  12. _host: r._host,
  13. _value: float(v: r._value) / 125000.0
  14. }),
  15. )
  16. |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  17. |> yield(name: "mean")
  18.  
  19. Query para Velocidad de download maxima (cambia la ultima funciona para min si quieres la minima):
  20. from(bucket: "<bucket>")
  21. |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  22. |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
  23. |> filter(fn: (r) => r["_field"] == "download_bandwidth")
  24. |> filter(fn: (r) => r["host"] == "raspberrypi")
  25. |> map(
  26. fn: (r) => ({
  27. _time: r._time,
  28. _measurement: r._measurement,
  29. _field: r._field,
  30. _host: r._host,
  31. _value: float(v: r._value) / 125000.0
  32. }),
  33. )
  34. |> max(column: "_value")
  35.  
  36.  
  37. Query historical velocidad de bajada (cambia "download_bandwidth" para "upload_bandwidth" para velocidad de subida):
  38. from(bucket: "<bucket>")
  39. |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  40. |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
  41. |> filter(fn: (r) => r["_field"] == "download_bandwidth")
  42. |> filter(fn: (r) => r["host"] == "raspberrypi")
  43. |> map(
  44. fn: (r) => ({
  45. _time: r._time,
  46. _measurement: r._measurement,
  47. _field: r._field,
  48. _host: r._host,
  49. _value: float(v: r._value) / 125000.0
  50. }),
  51. )
Advertisement
Add Comment
Please, Sign In to add comment