查询页面PV数sql

 

SELECT
    count(`view_name`) `count`,
    `view_name`
FROM
    `rum_view`
WHERE
    (start_time >= '2024-12-22 00:00:00'
        and start_time <= '2025-01-20 23:59:59' )
    and `web_group_id` = 13100005
    and `env` = "TEST"
    and `view_name` is not null
GROUP BY
    `view_name`
ORDER BY
    `count` desc

 不一定是查这个表，正确方法为：看F12里的view_name接口，比如，打开数据看板，然后看view_name接口，

 这里source为rum_view，那么就是查rum_View这个表，sql类似上面的
再比如JS错误里的页面PV，如下图，那么就应该查rum_error表，SQL类似上面的