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';
QUERY PLAN
---------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=9 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=5 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=4 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=4 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=2 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
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;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.90 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
QUERY PLAN
---------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=9 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=5 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=4 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=4 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=2 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
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;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.90 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1';
QUERY PLAN
---------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=9 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=5 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=4 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=3 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=1 width=1056)
Filter: ((attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=4 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
--------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=2 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=1 width=1056)
Filter: ((attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=3 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.12 rows=1 width=1056)
Filter: ((attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr4=1 AND attr6=0.3;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1 AND attr4=1 AND attr5=0.3 AND attr6=0.3;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.51 rows=1 width=1056)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
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;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..5.90 rows=1 width=1056)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1) AND (attr4 = 1) AND (attr5 = .3::double precision) AND (attr6 = .3::double precision))
(2 rows)
SELECT COUNT(1) from pg_statistic_ext;
count
-------
57
(1 row)
SELECT COUNT(1) from gs_model_warehouse;
count
-------
57
(1 row)
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';
QUERY PLAN
---------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=9 width=30)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr2='x1' AND attr3=1;
QUERY PLAN
---------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.34 rows=4 width=30)
Filter: (((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
EXPLAIN SELECT * FROM db4ai_bayesnet WHERE attr1='x1' AND attr2='x1' AND attr3=1;
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on db4ai_bayesnet (cost=0.00..4.73 rows=4 width=30)
Filter: (((attr1)::text = 'x1'::text) AND ((attr2)::text = 'x1'::text) AND (attr3 = 1))
(2 rows)
SELECT COUNT(1) from pg_statistic_ext;
count
-------
3
(1 row)
SELECT COUNT(1) from gs_model_warehouse;
count
-------
3
(1 row)
DROP TABLE db4ai_bayesnet;
DELETE FROM pg_statistic_ext;
DELETE FROM gs_model_warehouse;
SET enable_ai_stats=0;