Use Limit operator with Group BY clause and where clause

errishma · March 31, 2017, 3:32pm

I am running the below query to figure out 10 underutilized servers.

select mean(“load15”) FROM “autogen”.“system” WHERE time > now() - 15m GROUP BY host limit 10

I dont see the expected results that shows only 10 servers that are underutilized servers.

Please guide.

Topic		Replies	Views
Using a subquery to do a count limited by a where clause influxql	2	2569	May 5, 2017
Group by on multiple columns Store	3	8210	June 20, 2017
Subqueries and group by clause	2	784	October 2, 2019
Last with Group BY with Offset and Limit? Store	0	662	June 14, 2018
Improving the performance of InfluxDB Kapacitor influxdb , telegraf , time-series	6	1707	March 17, 2019