标题MySql数据库业务耗时统计
例:
1,查询业务某一时间段内从开始到完成的平均耗时
select AVG(TIMESTAMPDIFF(SECOND,create_time,update_time)) as avg _time_second from 表名 where 字段1= ‘success’ and create_time >= ‘2022-12-01 00:00:00’ and create_time <= ‘2022-12-08 23:59:59’
2, 查询业务完成的耗时
select 字段1, 字段2, TIMEDIFF(update_time,create_time) as time_diff from 表名 where 字段1= ‘XXX’ and create_time >= ‘2022-12-01 00:00:00’ and create_time <= ‘2022-12-08 23:59:59’ order by time_diff desc.