阿里云日志分析

分析uwsgi日志耗时

* |  select approx_percentile(try_cast(time as bigint),Array[0.5,0.85,0.95]), max(try_cast(time as bigint)) as max, count(time) as count from (select regexp_extract(content, '.* in (\d+) msecs .*', 1) as time from log)

使用估算函数统计中位数

https://help.aliyun.com/document_detail/63447.html?spm=a2c4g.11186623.6.872.10595443REUrUO#title-ld0-otz-1d2

分析调用次数

* | select count_if(search) as search, count_if(zhongshu) as zhongshu from (select regexp_like(content, '(.+)Search with keyword(.+).') as search,  regexp_like(content, '(.+)Query zhongshu .* used by Search for .*') as zhongshu from log)

正则函数

https://help.aliyun.com/document_detail/63453.html?spm=a2c4g.11186623.6.866.7f84632es9UXF5