如何从InfluxDB查找CPU空闲率超过90%的主机?
以 TICK 监控方式为例,查询最近三天的,CPU 空闲率超过 90% 的主机列表, ``` SELECT usage_idle FROM (SELECT min("usage_idle") as usage_idle FROM "cpu" WHERE ("cpu" = 'cpu-total') AND ("time" > now() - 3d) GROUP BY "host") WHERE usage_idle > 93 GROUP BY "host" ```...阅读全文