ESR6中Kwr性能报告分析使用

1、修改kingbase.conf参数，重启数据库生效 track_activities = on track_wait_timing = on track_io_timing = on track_functions = 'all' sys_stat_statements.track = 'top' sys_kwr.enable = on 2、手动创建快照 select * from perf.create_snapshot(); KingbaseES启动服务后，sys_kwr collector后台进程后会每个小时采集一次负载信息 3、语句查看 select snap_id, datid, wait_event_type, wait_event,sum(calls) as calls, sum(times) as times from perf.kwr_snap_waitaccums group by snap_id, datid, wait_event_type, wait_event order by snap_id,times desc, calls desc; 4、生成kwr报告，默认保留在data/sys_log下 select * from perf.kwr_report(1,2,'html');