可以基于 charging_status 与 charging_start/stop 事件,通过 SQL 计算异常指标并配合告警规则触发:
- 低速充电检测:按小时聚合 SOC 提升幅度,将低于阈值的记录纳入告警。
event: charging_status
| SELECT date_trunc('hour', __time__) as dt, vin, station_id,
(MAX(battery_soc) - MIN(battery_soc)) AS avg_soc_per_hour
FROM log GROUP BY dt, vin, station_id
HAVING avg_soc_per_hour < 0.2
- 频繁断充检测:在右上角时间范围选择相对 1 小时,统计开始/结束事件次数。
* | SELECT vin, station_id, COUNT(*) AS interrupt_count
FROM log
WHERE event IN ('charging_start', 'charging_stop')
GROUP BY vin, station_id
HAVING interrupt_count > 3
再将上述查询配置为 SLS 告警,即可在异常发生时实时触发通知。




