                                                                                                                                                                                                                                                                                                                                                                                                                QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1676701.23..1676701.24 rows=1 width=128) (actual time=26418.762..26418.768 rows=1 loops=1)
   Buffers: shared hit=1197338
   ->  Nested Loop  (cost=2331.07..1676701.21 rows=1 width=16) (actual time=818.251..26418.399 rows=73 loops=1)
         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)))
         Rows Removed by Join Filter: 432
         Buffers: shared hit=1197338
         ->  Nested Loop  (cost=2330.65..1676606.83 rows=95 width=30) (actual time=26.893..26362.058 rows=5552 loops=1)
               Buffers: shared hit=1175134
               ->  Nested Loop  (cost=2330.23..1675696.54 rows=1098 width=40) (actual time=20.108..26091.082 rows=34756 loops=1)
                     Buffers: shared hit=1036334
                     ->  Hash Join  (cost=2329.95..1673748.43 rows=4247 width=40) (actual time=18.951..25441.316 rows=173215 loops=1)
                           Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                           Buffers: shared hit=518318
                           ->  Hash Join  (cost=2322.65..1673729.01 rows=4443 width=44) (actual time=18.844..25355.008 rows=174348 loops=1)
                                 Hash Cond: (store_sales.ss_sold_date_sk = date_dim.d_date_sk)
                                 Buffers: shared hit=518313
                                 ->  Seq Scan on store_sales  (cost=0.00..1668947.68 rows=936589 width=48) (actual time=0.033..25075.074 rows=889891 loops=1)
                                       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))))
                                       Rows Removed by Filter: 27911100
                                       Buffers: shared hit=516908
                                 ->  Hash  (cost=2318.11..2318.11 rows=363 width=4) (actual time=18.744..18.745 rows=365 loops=1)
                                       Buckets: 1024  Batches: 1  Memory Usage: 21kB
                                       Buffers: shared hit=1405
                                       ->  Seq Scan on date_dim  (cost=0.00..2318.11 rows=363 width=4) (actual time=9.847..18.642 rows=365 loops=1)
                                             Filter: (d_year = 2001)
                                             Rows Removed by Filter: 72684
                                             Buffers: shared hit=1405
                           ->  Hash  (cost=6.02..6.02 rows=102 width=4) (actual time=0.093..0.094 rows=102 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 12kB
                                 Buffers: shared hit=5
                                 ->  Seq Scan on store  (cost=0.00..6.02 rows=102 width=4) (actual time=0.011..0.059 rows=102 loops=1)
                                       Buffers: shared hit=5
                     ->  Index Scan using household_demographics_pkey on household_demographics  (cost=0.28..0.46 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=173215)
                           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))
                           Rows Removed by Filter: 1
                           Buffers: shared hit=518016
               ->  Index Scan using customer_address_pkey on customer_address  (cost=0.42..0.82 rows=1 width=7) (actual time=0.007..0.007 rows=0 loops=34756)
                     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))))
                     Rows Removed by Filter: 1
                     Buffers: shared hit=138800
         ->  Index Scan using customer_demographics_pkey on customer_demographics  (cost=0.43..0.95 rows=1 width=27) (actual time=0.009..0.009 rows=0 loops=5552)
               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)))
               Rows Removed by Filter: 1
               Buffers: shared hit=22204
 Planning:
   Buffers: shared hit=651
 Planning Time: 5.213 ms
 Execution Time: 26418.989 ms
(51 rows)

