                                                                                                                                                                                                                                                                                                                                                                                                                QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1679826.85..1679826.86 rows=1 width=128)
   ->  Nested Loop  (cost=204.69..1679826.83 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=204.26..1679732.45 rows=95 width=30)
               ->  Nested Loop  (cost=203.84..1678822.15 rows=1098 width=40)
                     ->  Nested Loop  (cost=203.69..1678785.29 rows=1149 width=44)
                           ->  Hash Join  (cost=203.39..1671610.99 rows=242191 width=48)
                                 Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_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=179.00..179.00 rows=1951 width=8)
                                       ->  Seq Scan on household_demographics  (cost=0.00..179.00 rows=1951 width=8)
                                             Filter: ((hd_dep_count = 3) OR (hd_dep_count = 1) OR (hd_dep_count = 1))
                           ->  Result Cache  (cost=0.30..0.62 rows=1 width=4)
                                 Cache Key: store_sales.ss_sold_date_sk
                                 ->  Index Scan using date_dim_pkey on date_dim  (cost=0.29..0.61 rows=1 width=4)
                                       Index Cond: (d_date_sk = store_sales.ss_sold_date_sk)
                                       Filter: (d_year = 2001)
                     ->  Result Cache  (cost=0.15..0.17 rows=1 width=4)
                           Cache Key: store_sales.ss_store_sk
                           ->  Index Only Scan using store_pkey on store  (cost=0.14..0.16 rows=1 width=4)
                                 Index Cond: (s_store_sk = store_sales.ss_store_sk)
               ->  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)))
(28 rows)

