Star0
4
代码
代码
Issues6
Pull Requests5
流水线
讨论
Wiki
分析
Star0
4
Yyanghaoadd openGauss 3.1.0 feature code
b919f404创建于 2022年9月3日历史提交
set enable_functional_dependency=0;
DELETE FROM pg_statistic_ext;
DELETE FROM gs_model_warehouse;
CREATE TABLE db4ai_bayesnet (attr1 VARCHAR(256), attr2 VARCHAR(256), attr3 INT, attr4 INT, attr5 double precision, attr6 double precision);
COPY db4ai_bayesnet FROM '@abs_srcdir@/data/bayesnet_test_data_small.csv' DELIMITER ',';
SET enable_ai_stats=1;
SET multi_stats_type='BAYESNET';
set default_statistics_target=-10;
ANALYZE db4ai_bayesnet((attr1,attr2));
ANALYZE db4ai_bayesnet((attr1,attr3));
ANALYZE db4ai_bayesnet((attr1,attr4));
ANALYZE db4ai_bayesnet((attr1,attr5));
ANALYZE db4ai_bayesnet((attr1,attr6));
ANALYZE db4ai_bayesnet((attr2,attr3));
ANALYZE db4ai_bayesnet((attr2,attr4));
ANALYZE db4ai_bayesnet((attr2,attr5));
ANALYZE db4ai_bayesnet((attr2,attr6));
ANALYZE db4ai_bayesnet((attr3,attr4));
ANALYZE db4ai_bayesnet((attr3,attr5));
ANALYZE db4ai_bayesnet((attr3,attr6));
ANALYZE db4ai_bayesnet((attr4,attr5));
ANALYZE db4ai_bayesnet((attr4,attr6));
ANALYZE db4ai_bayesnet((attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3));
ANALYZE db4ai_bayesnet((attr1,attr2,attr4));
ANALYZE db4ai_bayesnet((attr1,attr2,attr5));
ANALYZE db4ai_bayesnet((attr1,attr2,attr6));
ANALYZE db4ai_bayesnet((attr1,attr3,attr4));
ANALYZE db4ai_bayesnet((attr1,attr3,attr5));
ANALYZE db4ai_bayesnet((attr1,attr3,attr6));
ANALYZE db4ai_bayesnet((attr1,attr4,attr5));
ANALYZE db4ai_bayesnet((attr1,attr4,attr6));
ANALYZE db4ai_bayesnet((attr1,attr5,attr6));
ANALYZE db4ai_bayesnet((attr2,attr3,attr4));
ANALYZE db4ai_bayesnet((attr2,attr3,attr5));
ANALYZE db4ai_bayesnet((attr2,attr3,attr6));
ANALYZE db4ai_bayesnet((attr2,attr4,attr5));
ANALYZE db4ai_bayesnet((attr2,attr4,attr6));
ANALYZE db4ai_bayesnet((attr2,attr5,attr6));
ANALYZE db4ai_bayesnet((attr3,attr4,attr5));
ANALYZE db4ai_bayesnet((attr3,attr4,attr6));
ANALYZE db4ai_bayesnet((attr3,attr5,attr6));
ANALYZE db4ai_bayesnet((attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr4));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr5));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr4,attr5));
ANALYZE db4ai_bayesnet((attr1,attr2,attr4,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr3,attr4,attr5));
ANALYZE db4ai_bayesnet((attr1,attr3,attr4,attr6));
ANALYZE db4ai_bayesnet((attr1,attr3,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr2,attr3,attr4,attr5));
ANALYZE db4ai_bayesnet((attr2,attr3,attr4,attr6));
ANALYZE db4ai_bayesnet((attr2,attr3,attr5,attr6));
ANALYZE db4ai_bayesnet((attr2,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr3,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr4,attr5));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr4,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr3,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr2,attr3,attr4,attr5,attr6));
ANALYZE db4ai_bayesnet((attr1,attr2,attr3,attr4,attr5,attr6));
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
SELECT COUNT(1) from pg_statistic_ext;
SELECT COUNT(1) from gs_model_warehouse;
DELETE FROM pg_statistic_ext;
DELETE FROM gs_model_warehouse;
ALTER TABLE db4ai_bayesnet add statistics((attr1, attr2));
ALTER TABLE db4ai_bayesnet add statistics((attr2, attr3));
ALTER TABLE db4ai_bayesnet add statistics((attr1, attr2, attr3));
ANALYZE db4ai_bayesnet;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
SELECT COUNT(1) from pg_statistic_ext;
SELECT COUNT(1) from gs_model_warehouse;
DROP TABLE db4ai_bayesnet;
DELETE FROM pg_statistic_ext;
DELETE FROM gs_model_warehouse;
SET enable_ai_stats=0;