Grafana语句收集

总任务数
app_id:42012 and title_name:'抢舱执行日志' and title_message: Task and title_message: 4525 | select count(*) "任务数" where json_extract_scalar(title_message, '$.bizParam.query_price.Id')= '4525'

成功率统计
app_id:42012 and title_name:'抢舱执行日志' and title_message: Task and title_message: 4525 | select sum(if(json_extract_scalar(title_message, '$.result')='success' or json_extract_scalar(title_message, '$.result')='noData',1,0))100/count() as "成功率" where json_extract_scalar(title_message, '$.bizParam.query_price.carrierId')= '4525'

posted @ 2023-01-18 11:07  xudong5273  阅读(110)  评论(0)    收藏  举报