Skip to content

服务日志中查询project的写入延迟情况

根据Project进行分组通过avg函数计算平均延迟,再使用having 找出延迟超过1000微秒的project 使用表格展示比较直观

SQL
method: PostLogstoreLogs |
select
  avg(latency) as avg_latency,
  Project
group by
  Project
HAVING
  avg_latency > 1000

SQL查询结果样例:

样例图片