正在执行的语句,查看query_id
select * from system.processes;
通过query_id来 kill 掉正在查询的语句
KILL QUERY WHERE query_id='041525f4-ef57-4121-9512-37f51231fd7d'
历史执行语句记录查询
select query_id,query_start_time ,user,client_hostname,query from `system`.query_log
where query_start_time >= '2023-08-16 00:00:00'
and user = '用户账号'
order by query_start_time desc