接口响应时间分位数监控+告警

阿里云性能监控指标

腾讯云sql案例

接口响应时间分位数监控

原始日志条目

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 

设置触发条件

设置告警通知