查看历史SQL执行情况

select t1.THREAD_ID,t1.SQL_TEXT,t1.CURRENT_SCHEMA,\
  t1.NESTING_EVENT_TYPE,t1.ROWS_EXAMINED, 
  DATE_SUB(NOW(), INTERVAL (SELECT VARIABLE_VALUE FROM performance_schema.global_status \
  WHERE VARIABLE_NAME='UPTIME') - t1.TIMER_START*10e-13 second) AS 'start_time',
  ROUND(t1.timer_wait*10E-10, 3) AS 'wait in (ms)' \
from performance_schema.events_statements_history t1 \
join performance_schema.threads t2  on t1.THREAD_ID=t2.THREAD_ID \
where t2.PROCESSLIST_ID in(2154,2163) order by TIMER_START;