oceanbase 性能监控04-性能分析sql

1 . 查询是否存在sql 等待

select sql_id, elapsed_time, queue_time, get_plan_time, execute_time, application_wait_time, concurrency_wait_time, user_io_wait_time, schedule_time, event, wait_class, wait_time_micro, total_wait_time_micro 
from v$sql_audit 
 where trace_id = 'YB420B84FE35-0005648A67211DC9'\G

 
2.找到所有SQL中平均执行时间排在TOP N的SQL

select/*+ parallel(15)*/ avg_exe_usec, svr_ip, svr_port, sql_id, plan_id 
 from oceanbase.gv$plan_cache_plan_stat 
 where tenant_id = 1001 
 order by avg_exe_usec desc
 limit 3\G;

 
3.如何查看集群SQL请求流量是否均衡？

select/*+ parallel(15)*/t2.zone, t1.svr_ip,  count(*) as QPS, avg(t1.elapsed_time), avg(t1.queue_time)  
 from oceanbase.gv$sql_audit t1, __all_server t2  
 where t1.svr_ip = t2.svr_ip and IS_EXECUTOR_RPC = 0    
       and request_time > (time_to_usec(no