InfluxDB query SUM for diskio (writes + reads) = total

grafana
influxdb
#1

Do you have any suggestion regarding how to make an easy math for diskio writes + diskio reads = and to have a total iops?

image

#2

It seems that there will be a progress.

SELECT MEAN(usage_system) + MEAN(usage_user) AS avg
FROM cpu
WHERE time > now() - 10s
GROUP BY host;
It’s not supported by Grafana GUI editor yet (but you can write it in manual mode).

#3

What I’ve tried to achieve is that the:

  • Total IOPs per reads;
  • Total IOPs per writes;
  • Sum of Total IOPs (reads) + Total IOPs (writes) = Total IOPs per that VM.