                                                                                                                                                                                                                                                                                                                                                                                                                QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                 
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1679826.85..1679826.86 rows=1 width=128) (actual time=25607.680..25607.685 rows=1 loops=1)
   Buffers: shared hit=683536
   ->  Nested Loop  (cost=204.69..1679826.83 rows=1 width=16) (actual time=802.386..25607.365 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=683536
         ->  Nested Loop  (cost=204.26..1679732.45 rows=95 width=30) (actual time=10.488..25549.494 rows=5552 loops=1)
               Buffers: shared hit=661332
               ->  Nested Loop  (cost=203.84..1678822.15 rows=1098 width=40) (actual time=3.527..25266.611 rows=34756 loops=1)
                     Buffers: shared hit=522532
                     ->  Nested Loop  (cost=203.69..1678785.29 rows=1149 width=44) (actual time=3.503..25233.530 rows=34881 loops=1)
                           Buffers: shared hit=522430
                           ->  Hash Join  (cost=203.39..1671610.99 rows=242191 width=48) (actual time=2.505..25064.891 rows=175981 loops=1)
                                 Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk)
                                 Buffers: shared hit=516961
                                 ->  Seq Scan on store_sales  (cost=0.00..1668947.68 rows=936589 width=48) (actual time=0.041..24791.586 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=179.00..179.00 rows=1951 width=8) (actual time=2.212..2.213 rows=1440 loops=1)
                                       Buckets: 2048  Batches: 1  Memory Usage: 73kB
                                       Buffers: shared hit=53
                                       ->  Seq Scan on household_demographics  (cost=0.00..179.00 rows=1951 width=8) (actual time=0.039..1.787 rows=1440 loops=1)
                                             Filter: ((hd_dep_count = 3) OR (hd_dep_count = 1) OR (hd_dep_count = 1))
                                             Rows Removed by Filter: 5760
                                             Buffers: shared hit=53
                           ->  Result Cache  (cost=0.30..0.62 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=175981)
                                 Cache Key: store_sales.ss_sold_date_sk
                                 Hits: 174157  Misses: 1824  Evictions: 0  Overflows: 0  Memory Usage: 134kB
                                 Buffers: shared hit=5469
                                 ->  Index Scan using date_dim_pkey on date_dim  (cost=0.29..0.61 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=1824)
                                       Index Cond: (d_date_sk = store_sales.ss_sold_date_sk)
                                       Filter: (d_year = 2001)
                                       Rows Removed by Filter: 1
                                       Buffers: shared hit=5469
                     ->  Result Cache  (cost=0.15..0.17 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=34881)
                           Cache Key: store_sales.ss_store_sk
                           Hits: 34829  Misses: 52  Evictions: 0  Overflows: 0  Memory Usage: 6kB
                           Buffers: shared hit=102
                           ->  Index Only Scan using store_pkey on store  (cost=0.14..0.16 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=52)
                                 Index Cond: (s_store_sk = store_sales.ss_store_sk)
                                 Heap Fetches: 51
                                 Buffers: shared hit=102
               ->  Index Scan using customer_address_pkey on customer_address  (cost=0.42..0.82 rows=1 width=7) (actual time=0.008..0.008 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.010..0.010 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.742 ms
 Execution Time: 25608.091 ms
(57 rows)

