接口响应时间分位数监控+告警
接口响应时间分位数监控
原始日志条目
CogTTS首次响应时间: 2025-08-21 16:53:20.808, 耗时 533 毫秒
查询语法
content:"CogTTS首次响应时间" | select
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.99) AS p99,
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.90) AS p90,
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.80) AS p80,
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.70) AS p70,
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.5) AS p50,
histogram(__TIMESTAMP__,INTERVAL 5 minute) as time
group by time limit 10000
效果如下
接口响应时间分位数告警
设置执行语句
content:"CogTTS首次响应时间" | select
APPROX_PERCENTILE(cast(regexp_extract(content, '耗时 (\d+) 毫秒', 1) as double), 0.99) AS p99
limit 10000