怎么查找一次执行时间最长的SQL

发布网友发布时间：2022-04-09 07:23

共2个回答

懂视网时间：2022-04-09 11:44

ml.`name` as lessonName,ml.category,ml.deleted,ml.teacherName, ml.id,ml.liveId,ml.selected,mlc.channelId,p.viewNums,count(*) as totalNum from mlk_live_channel AS ml LEFT JOIN mlk_lesson_channel AS mlc ON mlc.lessonId = ml.id LEFT JOIN mlk_live_channel AS mcl ON mcl.id = mlc.channelId LEFT JOIN (SELECT mpr.liveId,mpr.memberId,COUNT(mpr.liveId) as viewNums FROM mlk_payment_record AS mpr WHERE mpr.payType = 3 AND mpr.notify = 1 GROUP BY mpr.liveId) AS p ON p.liveId = mcl.liveId WHERE ml.deleted = 0 AND ml.category = 1 GROUP BY ml.id ORDER BY ml.create_time

历史最长的SQL语句

标签：

热心网友时间：2022-04-09 08:52

执行时间最长的20条SQL语句（按时间降序排列），可保存为脚本方便调用：
SELECT rows_read / (num_executions + 1) as avg_rows_read,
rows_written / (num_executions + 1) as avg_rows_written,
stmt_sorts / (num_executions + 1) as avg_sorts,
total_exec_time / (num_executions + 1) as avg_exec_time,
substr(stmt_text,1,1000) as SQL_Stmt
FROM SYSIBMADM.SNAPDYN_SQL ORDER BY avg_exec_time desc fetch first 20 rows only;
祝你学习愉快！