Skip to content

获取写入延迟较高的project

据Project进行分组使用avg函数计算平均延迟,再使用having 找出延迟超过5.7秒的数据,order by倒序之后进行展示 使用表格展示比较直观

SQL
method :PostLogstoreLogs |
select
  avg(latency) as avg_latency,
  projectName
group by
  projectName
HAVING
  avg_latency > 5700000
order by
  avg_latency desc

SQL查询结果样例:

样例图片