                                                                                                                                                                                                                                                                                                                                                                                                                QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1676701.23..1676701.24 rows=1 width=128)
   ->  Nested Loop  (cost=2331.07..1676701.21 rows=1 width=16)
         Join Filter: (((customer_demographics.cd_marital_status = 'U'::bpchar) AND (customer_demographics.cd_education_status = '4 yr Degree'::bpchar) AND (store_sales.ss_sales_price >= 100.00) AND (store_sales.ss_sales_price <= 150.00) AND (household_demographics.hd_dep_count = 3)) OR ((customer_demographics.cd_marital_status = 'S'::bpchar) AND (customer_demographics.cd_education_status = 'Unknown'::bpchar) AND (store_sales.ss_sales_price >= 50.00) AND (store_sales.ss_sales_price <= 100.00) AND (household_demographics.hd_dep_count = 1)) OR ((customer_demographics.cd_marital_status = 'D'::bpchar) AND (customer_demographics.cd_education_status = '2 yr Degree'::bpchar) AND (store_sales.ss_sales_price >= 150.00) AND (store_sales.ss_sales_price <= 200.00) AND (household_demographics.hd_dep_count = 1)))
         ->  Nested Loop  (cost=2330.65..1676606.83 rows=95 width=30)
               ->  Nested Loop  (cost=2330.23..1675696.54 rows=1098 width=40)
                     ->  Hash Join  (cost=2329.95..1673748.43 rows=4247 width=40)
                           Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                           ->  Hash Join  (cost=2322.65..1673729.01 rows=4443 width=44)
                                 Hash Cond: (store_sales.ss_sold_date_sk = date_dim.d_date_sk)
                                 ->  Seq Scan on store_sales  (cost=0.00..1668947.68 rows=936589 width=48)
                                       Filter: ((((ss_sales_price >= 100.00) AND (ss_sales_price <= 150.00)) OR ((ss_sales_price >= 50.00) AND (ss_sales_price <= 100.00)) OR ((ss_sales_price >= 150.00) AND (ss_sales_price <= 200.00))) AND (((ss_net_profit >= '100'::numeric) AND (ss_net_profit <= '200'::numeric)) OR ((ss_net_profit >= '150'::numeric) AND (ss_net_profit <= '300'::numeric)) OR ((ss_net_profit >= '50'::numeric) AND (ss_net_profit <= '250'::numeric))))
                                 ->  Hash  (cost=2318.11..2318.11 rows=363 width=4)
                                       ->  Seq Scan on date_dim  (cost=0.00..2318.11 rows=363 width=4)
                                             Filter: (d_year = 2001)
                           ->  Hash  (cost=6.02..6.02 rows=102 width=4)
                                 ->  Seq Scan on store  (cost=0.00..6.02 rows=102 width=4)
                     ->  Index Scan using household_demographics_pkey on household_demographics  (cost=0.28..0.46 rows=1 width=8)
                           Index Cond: (hd_demo_sk = store_sales.ss_hdemo_sk)
                           Filter: ((hd_dep_count = 3) OR (hd_dep_count = 1) OR (hd_dep_count = 1))
               ->  Index Scan using customer_address_pkey on customer_address  (cost=0.42..0.82 rows=1 width=7)
                     Index Cond: (ca_address_sk = store_sales.ss_addr_sk)
                     Filter: (((ca_country)::text = 'United States'::text) AND ((ca_state = ANY ('{CO,MI,MN}'::bpchar[])) OR (ca_state = ANY ('{NC,NY,TX}'::bpchar[])) OR (ca_state = ANY ('{CA,NE,TN}'::bpchar[]))) AND (((ca_state = ANY ('{CO,MI,MN}'::bpchar[])) AND (store_sales.ss_net_profit >= '100'::numeric) AND (store_sales.ss_net_profit <= '200'::numeric)) OR ((ca_state = ANY ('{NC,NY,TX}'::bpchar[])) AND (store_sales.ss_net_profit >= '150'::numeric) AND (store_sales.ss_net_profit <= '300'::numeric)) OR ((ca_state = ANY ('{CA,NE,TN}'::bpchar[])) AND (store_sales.ss_net_profit >= '50'::numeric) AND (store_sales.ss_net_profit <= '250'::numeric))))
         ->  Index Scan using customer_demographics_pkey on customer_demographics  (cost=0.43..0.95 rows=1 width=27)
               Index Cond: (cd_demo_sk = store_sales.ss_cdemo_sk)
               Filter: (((cd_marital_status = 'U'::bpchar) AND (cd_education_status = '4 yr Degree'::bpchar)) OR ((cd_marital_status = 'S'::bpchar) AND (cd_education_status = 'Unknown'::bpchar)) OR ((cd_marital_status = 'D'::bpchar) AND (cd_education_status = '2 yr Degree'::bpchar)))
(25 rows)

