


顺序 | 日志字段 | 说明 |
1 | time | 请求时间 |
2 | client_ip | 客户端 IP |
3 | host | 被访问的域名 |
4 | url | URL |
5 | size | 推流字节数大小 |
6 | country_id | country_id |
7 | prov | 省份 |
8 | isp | 运营商 |
9 | streamname | 流 ID |
10 | node_ip | 节点 IP |
11 | server_region | 服务器地区 |
12 | server_country | 服务器国家 |
顺序 | 日志字段 | 说明 |
1 | type | 播放类型,lvb 代表标准直播,leb 代表快直播 |
2 | time | 请求时间 |
3 | client_ip | 客户端 IP |
4 | host | 被访问的域名 |
5 | url | URL |
6 | size | 本次访问字节数大小 |
7 | country_id | country_id |
8 | prov | 省份 |
9 | isp | 运营商 |
10 | http_code | HTTP 状态码 |
11 | referer | Referer 信息 |
12 | process_time | 处理时长(单位:毫秒) |
13 | ua | User - Agent 信息 |
14 | range | Range 参数 |
15 | method | HTTP Method |
16 | streamname | 流 ID |
17 | hit | 缓存 HIT/MISS |
18 | node_ip | 节点 IP(因无法获取部分 CDN 集群节点 IP,此字段可能为空) |
19 | server_region | 服务器地区 |
20 | server_country | 服务器国家 |
21 | connect_fd | connect_fd(连接端口号) |
22 | lost_rate | 丢包率,仅 type=leb 时才有值 |
23 | rtt | rtt,仅 type=leb 时才有值 |
type:* | select approx_percentile(request_time, 0.99) as p99
$1.p99 > 100

type:* | select url_extract_path(url) as url_path , round(count_if(try_cast( "http_code" as bigint) >= 400)*100.0/count(*),2) as "Request Error Rate (%)" group by "url_path" order by "Request Error Rate (%)" desc limit 100
type:* | select url_extract_path(url) as url_path , round(avg( "process_time" ), 1) as "Avg. processing time (ms)" group by "url_path" order by "Avg. processing time (ms)" desc limit 100

type:* | select url_extract_path(url) as url_path , round(count_if(try_cast( "http_code" as bigint) >= 400)*100.0/count(*),2) as "Request Error Rate (%)" group by "url_path" having "Request Error Rate (%)" >=3 order by "Request Error Rate (%)" desc limit 100
type:* | select url_extract_path(url) as url_path , round(avg( "process_time" ), 1) as "Avg. processing time (ms)" group by "url_path" having "Avg. processing time (ms)" >=500 order by "Avg. processing time (ms)" desc limit 100

文档反馈