崩溃列表数据库查询(可供参考)

首先去https://weikezhijia.feishu.cn/sheets/BIvxsKZhHhzpC6tDyoLcPE50n4d?sheet=9ikXjx

看库中导出指标,然后可以查到是rum_error表,然后去ors_rum_test服务器,ors_rum_test数据库,rum_error表去查询,结合点击全部按钮后查看F12

 然后查看preView里的字段,结合着去查rum_error表,比如:

select
    stack_code,COUNT(stack_code) AS '数量'  
from
    rum_error 
where
--     view_type = 'h5'
--     and duration >= 0
--     and duration <= 100000000
    error_type='crash'
    and (start_time >= '2024-12-19 00:00:00'
        and start_time < '2024-12-25 23:59:59' )
        
    and access_no = 12100185
--     and stack_code='java.lang.IllegalStateException'

group by
    stack_code

然后可以自己摸索

posted @ 2024-12-25 20:09  四念处  阅读(2)  评论(0编辑  收藏  举报