查询语句示例

备注

SELECT max(usage_user)

FROM cpu

WHERE (hostname = 'host_216249') and time >= '2021-11-02T06:16:22Z' and time <

'2021-11-02T07:16:22Z'

GROUP BY time(1m) 

1-1-1表示：

select 后面1个算子

where 后面的hostname条件1个

查询时间范围1小时

SELECT max(usage_user)

FROM cpu

WHERE (hostname = 'host_216249') and time >= '2021-11-02T00:16:22Z' and time <

'2021-11-02T12:16:22Z'

GROUP BY time(1m)

1-1-12表示：

select 后面1个算子

where 后面的hostname条件1个

查询时间范围12小时

SELECT max(usage_user)

FROM cpu

WHERE (hostname = 'host_216249'...or hostname = 'host_186121') and time >= '2021-

11-02T06:16:22Z' and time < '2021-11-02T07:16:22Z'

GROUP BY time(1m) 

1-1-12表示：

select 后面1个算子

where 后面的hostname条件8个

查询时间范围1小时

SELECT max(usage_user)...,max(usage_iowait)

FROM cpu

WHERE (hostname = 'host_216249') and time >= '2021-11-02T06:16:22Z' and time <

'2021-11-02T07:16:22Z'

GROUP BY time(1m)

5-1-1表示：

select 后面5个算子

where 后面的hostname条件1个

查询时间范围1小时

SELECT max(usage_user)...,max(usage_iowait)

FROM cpu

WHERE (hostname = 'host_216249') and time >= '2021-11-02T00:16:22Z' and time <

'2021-11-02T12:16:22Z'

GROUP BY time(1m)

SELECT max(usage_user)...,max(usage_iowait)

FROM cpu

WHERE (hostname = 'host_216249'...or hostname = 'host_18624') and time >= '2021-

11-02T06:16:22Z' and time < '2021-11-02T07:16:22Z'

GROUP BY time(1m)

SELECT max(*)

FROM cpu

WHERE (hostname = 'host_216249') and time >= '2021-11-02T02:16:22Z' and time <

'2021-11-02T10:16:22Z'

GROUP BY time(1h) 

SELECT max(*)

FROM cpu

WHERE (hostname = 'host_216249'...or hostname = 'host_186121') and time >= '2021-

11-02T02:16:22Z' and time < '2021-11-02T10:16:22Z'

GROUP BY time(1h) 

SELECT mean(usage_user)

FROM cpu

WHERE time >= '2021-11-02T00:16:22Z' and time < '2021-11-02T12:16:22Z'

GROUP BY time(1h),hostname

double-groupby-1表示：

SELECT后面算子有1个，查询范围12小时，分组按时间和hostname两个维度进行分组

SELECT mean(usage_user)...,mean(usage_iowait)

FROM cpu

WHERE time >= '2021-11-02T00:16:22Z' and time < '2021-11-02T12:16:22Z'

GROUP BY time(1h),hostname 

double-groupby-5表示：

SELECT后面算子有5个，查询范围12小时，分组按时间和hostname两个维度进行分组

SELECT mean(*)
FROM cpu
WHERE time >= '2021-11-02T00:16:22Z' and time < '2021-11-02T12:16:22Z'
GROUP BY time(1h),hostname

SELECT *
FROM cpu
WHERE usage_user > 90.0 and time >= '2021-11-02T00:16:22Z' and time < '2021-11-

02T12:16:22Z'

SELECT *
FROM cpu
WHERE usage_user > 90.0 and (hostname = 'host_216249') and time >= '2021-11-

02T00:16:22Z' and time < '2021-11-02T12:16:22Z' 

SELECT *
FROM cpu
WHERE time >= '2021-11-02T00:16:22Z' and time <= '2021-11-02T12:16:22Z' and

SELECT LAST(*)
FROM cpu
GROUP BY hostname

SELECT max(usage_user)
FROM cpu
WHERE time < '2021-11-02T07:16:22Z'
GROUP BY time(1m)
LIMIT 5