KES使用索引建议插件

1、添加插件：
在kingbase.conf配置文件中修改并添加相关插件及配置
shared_preload_libraries = ‘sys_stat_statements, sys_qualstats,kdb_rbo’;
sys_qualstats.enabled = true
sys_stat_statements.track='top'
sys_qualstats.sample_rate=1

2、重启数据库
sys_ctl -D /home/kingbase/KingbaseES/V8/data restart

3、创建插件
ksql db1 system 
create extension sys_qualstats;
create extension sys_hypo;

4、测试插件是否生效：
ksql db1 system
create table test (id int , info text , crt_time timestamp); 
insert into test select generate_series(1,1000000), md5(random()::text), clock_timestamp();

select * from test where id = 100;
select * from index_recommendation_by_qual;
select * from index_recommendation_by_index;