Query the project write latency in service logs

Group the data by project and use the avg function to calculate the average latency. Then, use the having clause to find the projects with a latency of more than 1,000 microseconds. The results are displayed in a table.

SQL

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

SQLSample query result:

样例图片

Query the project write latency in service logs ​

SQLSample query result: ​

Query the project write latency in service logs

SQLSample query result: