                                                                                                            QUERY PLAN                                                                                                            
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=7082436.31..7082436.54 rows=1 width=64) (actual time=89993.517..89993.575 rows=1 loops=1)
   Buffers: shared hit=4146904
   ->  Nested Loop  (cost=6197149.44..6197149.64 rows=1 width=56) (actual time=78803.888..78803.941 rows=1 loops=1)
         Buffers: shared hit=3628541
         ->  Nested Loop  (cost=5311815.79..5311815.96 rows=1 width=48) (actual time=67779.712..67779.757 rows=1 loops=1)
               Buffers: shared hit=3110178
               ->  Nested Loop  (cost=4426446.54..4426446.68 rows=1 width=40) (actual time=56616.282..56616.320 rows=1 loops=1)
                     Buffers: shared hit=2591815
                     ->  Nested Loop  (cost=3541115.95..3541116.06 rows=1 width=32) (actual time=44957.810..44957.840 rows=1 loops=1)
                           Buffers: shared hit=2073452
                           ->  Nested Loop  (cost=2655749.76..2655749.84 rows=1 width=24) (actual time=33421.032..33421.055 rows=1 loops=1)
                                 Buffers: shared hit=1555089
                                 ->  Nested Loop  (cost=1770537.14..1770537.19 rows=1 width=16) (actual time=22239.492..22239.508 rows=1 loops=1)
                                       Buffers: shared hit=1036726
                                       ->  Aggregate  (cost=885290.94..885290.95 rows=1 width=8) (actual time=10999.341..10999.348 rows=1 loops=1)
                                             Buffers: shared hit=518363
                                             ->  Hash Join  (cost=2977.89..885245.23 rows=18285 width=0) (actual time=25.631..10995.809 rows=20619 loops=1)
                                                   Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk)
                                                   Buffers: shared hit=518363
                                                   ->  Hash Join  (cost=2721.71..884793.62 rows=74409 width=4) (actual time=22.829..10972.389 rows=74521 loops=1)
                                                         Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                                                         Buffers: shared hit=518310
                                                         ->  Hash Join  (cost=2715.26..883239.32 rows=567130 width=8) (actual time=21.679..10850.987 rows=551977 loops=1)
                                                               Hash Cond: (store_sales.ss_sold_time_sk = time_dim.t_time_sk)
                                                               Buffers: shared hit=518305
                                                               ->  Seq Scan on store_sales  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.007..3805.880 rows=28800991 loops=1)
                                                                     Buffers: shared hit=516908
                                                               ->  Hash  (cost=2693.00..2693.00 rows=1781 width=4) (actual time=21.536..21.538 rows=1800 loops=1)
                                                                     Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                                                     Buffers: shared hit=1397
                                                                     ->  Seq Scan on time_dim  (cost=0.00..2693.00 rows=1781 width=4) (actual time=7.847..21.042 rows=1800 loops=1)
                                                                           Filter: ((t_minute >= 30) AND (t_hour = 8))
                                                                           Rows Removed by Filter: 84600
                                                                           Buffers: shared hit=1397
                                                         ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.066..0.067 rows=14 loops=1)
                                                               Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                               Buffers: shared hit=5
                                                               ->  Seq Scan on store  (cost=0.00..6.28 rows=14 width=4) (actual time=0.007..0.059 rows=14 loops=1)
                                                                     Filter: ((s_store_name)::text = 'ese'::text)
                                                                     Rows Removed by Filter: 88
                                                                     Buffers: shared hit=5
                                                   ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.788..2.789 rows=2040 loops=1)
                                                         Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                                         Buffers: shared hit=53
                                                         ->  Seq Scan on household_demographics  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.054..2.219 rows=2040 loops=1)
                                                               Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                                               Rows Removed by Filter: 5160
                                                               Buffers: shared hit=53
                                       ->  Aggregate  (cost=885246.20..885246.21 rows=1 width=8) (actual time=11240.143..11240.149 rows=1 loops=1)
                                             Buffers: shared hit=518363
                                             ->  Hash Join  (cost=2977.34..885201.61 rows=17833 width=0) (actual time=23.416..11233.101 rows=41838 loops=1)
                                                   Hash Cond: (store_sales_1.ss_hdemo_sk = household_demographics_1.hd_demo_sk)
                                                   Buffers: shared hit=518363
                                                   ->  Hash Join  (cost=2721.16..884754.83 rows=72570 width=4) (actual time=20.611..11190.518 rows=147345 loops=1)
                                                         Hash Cond: (store_sales_1.ss_store_sk = store_1.s_store_sk)
                                                         Buffers: shared hit=518310
                                                         ->  Hash Join  (cost=2714.71..883238.77 rows=553118 width=8) (actual time=19.790..10949.179 rows=1105793 loops=1)
                                                               Hash Cond: (store_sales_1.ss_sold_time_sk = time_dim_1.t_time_sk)
                                                               Buffers: shared hit=518305
                                                               ->  Seq Scan on store_sales store_sales_1  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.004..3757.935 rows=28800991 loops=1)
                                                                     Buffers: shared hit=516908
                                                               ->  Hash  (cost=2693.00..2693.00 rows=1737 width=4) (actual time=19.710..19.711 rows=1800 loops=1)
                                                                     Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                                                     Buffers: shared hit=1397
                                                                     ->  Seq Scan on time_dim time_dim_1  (cost=0.00..2693.00 rows=1737 width=4) (actual time=7.181..19.211 rows=1800 loops=1)
                                                                           Filter: ((t_minute < 30) AND (t_hour = 9))
                                                                           Rows Removed by Filter: 84600
                                                                           Buffers: shared hit=1397
                                                         ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.064..0.065 rows=14 loops=1)
                                                               Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                               Buffers: shared hit=5
                                                               ->  Seq Scan on store store_1  (cost=0.00..6.28 rows=14 width=4) (actual time=0.013..0.058 rows=14 loops=1)
                                                                     Filter: ((s_store_name)::text = 'ese'::text)
                                                                     Rows Removed by Filter: 88
                                                                     Buffers: shared hit=5
                                                   ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.555..2.556 rows=2040 loops=1)
                                                         Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                                         Buffers: shared hit=53
                                                         ->  Seq Scan on household_demographics household_demographics_1  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.046..1.982 rows=2040 loops=1)
                                                               Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                                               Rows Removed by Filter: 5160
                                                               Buffers: shared hit=53
                                 ->  Aggregate  (cost=885212.62..885212.63 rows=1 width=8) (actual time=11181.532..11181.538 rows=1 loops=1)
                                       Buffers: shared hit=518363
                                       ->  Hash Join  (cost=2976.93..885168.89 rows=17494 width=0) (actual time=22.697..11174.759 rows=40936 loops=1)
                                             Hash Cond: (store_sales_2.ss_hdemo_sk = household_demographics_2.hd_demo_sk)
                                             Buffers: shared hit=518363
                                             ->  Hash Join  (cost=2720.75..884725.73 rows=71191 width=4) (actual time=20.096..11132.364 rows=146451 loops=1)
                                                   Hash Cond: (store_sales_2.ss_store_sk = store_2.s_store_sk)
                                                   Buffers: shared hit=518310
                                                   ->  Hash Join  (cost=2714.30..883238.36 rows=542610 width=8) (actual time=19.413..10890.564 rows=1100580 loops=1)
                                                         Hash Cond: (store_sales_2.ss_sold_time_sk = time_dim_2.t_time_sk)
                                                         Buffers: shared hit=518305
                                                         ->  Seq Scan on store_sales store_sales_2  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.006..3760.700 rows=28800991 loops=1)
                                                               Buffers: shared hit=516908
                                                         ->  Hash  (cost=2693.00..2693.00 rows=1704 width=4) (actual time=19.340..19.341 rows=1800 loops=1)
                                                               Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                                               Buffers: shared hit=1397
                                                               ->  Seq Scan on time_dim time_dim_2  (cost=0.00..2693.00 rows=1704 width=4) (actual time=7.488..18.829 rows=1800 loops=1)
                                                                     Filter: ((t_minute >= 30) AND (t_hour = 9))
                                                                     Rows Removed by Filter: 84600
                                                                     Buffers: shared hit=1397
                                                   ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.076..0.076 rows=14 loops=1)
                                                         Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                         Buffers: shared hit=5
                                                         ->  Seq Scan on store store_2  (cost=0.00..6.28 rows=14 width=4) (actual time=0.014..0.057 rows=14 loops=1)
                                                               Filter: ((s_store_name)::text = 'ese'::text)
                                                               Rows Removed by Filter: 88
                                                               Buffers: shared hit=5
                                             ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.556..2.557 rows=2040 loops=1)
                                                   Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                                   Buffers: shared hit=53
                                                   ->  Seq Scan on household_demographics household_demographics_2  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.044..1.981 rows=2040 loops=1)
                                                         Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                                         Rows Removed by Filter: 5160
                                                         Buffers: shared hit=53
                           ->  Aggregate  (cost=885366.19..885366.20 rows=1 width=8) (actual time=11536.769..11536.776 rows=1 loops=1)
                                 Buffers: shared hit=518363
                                 ->  Hash Join  (cost=2978.81..885318.58 rows=19044 width=0) (actual time=22.024..11525.880 rows=62229 loops=1)
                                       Hash Cond: (store_sales_3.ss_hdemo_sk = household_demographics_3.hd_demo_sk)
                                       Buffers: shared hit=518363
                                       ->  Hash Join  (cost=2722.64..884858.86 rows=77500 width=4) (actual time=19.428..11461.352 rows=220382 loops=1)
                                             Hash Cond: (store_sales_3.ss_store_sk = store_3.s_store_sk)
                                             Buffers: shared hit=518310
                                             ->  Hash Join  (cost=2716.19..883240.25 rows=590694 width=8) (actual time=19.253..11096.138 rows=1645352 loops=1)
                                                   Hash Cond: (store_sales_3.ss_sold_time_sk = time_dim_3.t_time_sk)
                                                   Buffers: shared hit=518305
                                                   ->  Seq Scan on store_sales store_sales_3  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.004..3797.987 rows=28800991 loops=1)
                                                         Buffers: shared hit=516908
                                                   ->  Hash  (cost=2693.00..2693.00 rows=1855 width=4) (actual time=19.197..19.198 rows=1800 loops=1)
                                                         Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                                         Buffers: shared hit=1397
                                                         ->  Seq Scan on time_dim time_dim_3  (cost=0.00..2693.00 rows=1855 width=4) (actual time=7.518..18.700 rows=1800 loops=1)
                                                               Filter: ((t_minute < 30) AND (t_hour = 10))
                                                               Rows Removed by Filter: 84600
                                                               Buffers: shared hit=1397
                                             ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.061..0.062 rows=14 loops=1)
                                                   Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                   Buffers: shared hit=5
                                                   ->  Seq Scan on store store_3  (cost=0.00..6.28 rows=14 width=4) (actual time=0.012..0.055 rows=14 loops=1)
                                                         Filter: ((s_store_name)::text = 'ese'::text)
                                                         Rows Removed by Filter: 88
                                                         Buffers: shared hit=5
                                       ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.553..2.554 rows=2040 loops=1)
                                             Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                             Buffers: shared hit=53
                                             ->  Seq Scan on household_demographics household_demographics_3  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.043..1.972 rows=2040 loops=1)
                                                   Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                                   Rows Removed by Filter: 5160
                                                   Buffers: shared hit=53
                     ->  Aggregate  (cost=885330.59..885330.60 rows=1 width=8) (actual time=11658.465..11658.472 rows=1 loops=1)
                           Buffers: shared hit=518363
                           ->  Hash Join  (cost=2978.38..885283.88 rows=18685 width=0) (actual time=23.613..11647.895 rows=61896 loops=1)
                                 Hash Cond: (store_sales_4.ss_hdemo_sk = household_demographics_4.hd_demo_sk)
                                 Buffers: shared hit=518363
                                 ->  Hash Join  (cost=2722.20..884828.00 rows=76038 width=4) (actual time=19.514..11585.486 rows=223913 loops=1)
                                       Hash Cond: (store_sales_4.ss_store_sk = store_4.s_store_sk)
                                       Buffers: shared hit=518310
                                       ->  Hash Join  (cost=2715.75..883239.81 rows=579548 width=8) (actual time=19.064..11227.223 rows=1657729 loops=1)
                                             Hash Cond: (store_sales_4.ss_sold_time_sk = time_dim_4.t_time_sk)
                                             Buffers: shared hit=518305
                                             ->  Seq Scan on store_sales store_sales_4  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.004..3796.672 rows=28800991 loops=1)
                                                   Buffers: shared hit=516908
                                             ->  Hash  (cost=2693.00..2693.00 rows=1820 width=4) (actual time=19.020..19.021 rows=1800 loops=1)
                                                   Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                                   Buffers: shared hit=1397
                                                   ->  Seq Scan on time_dim time_dim_4  (cost=0.00..2693.00 rows=1820 width=4) (actual time=7.915..18.532 rows=1800 loops=1)
                                                         Filter: ((t_minute >= 30) AND (t_hour = 10))
                                                         Rows Removed by Filter: 84600
                                                         Buffers: shared hit=1397
                                       ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.059..0.060 rows=14 loops=1)
                                             Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                             Buffers: shared hit=5
                                             ->  Seq Scan on store store_4  (cost=0.00..6.28 rows=14 width=4) (actual time=0.011..0.053 rows=14 loops=1)
                                                   Filter: ((s_store_name)::text = 'ese'::text)
                                                   Rows Removed by Filter: 88
                                                   Buffers: shared hit=5
                                 ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.545..2.546 rows=2040 loops=1)
                                       Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                       Buffers: shared hit=53
                                       ->  Seq Scan on household_demographics household_demographics_4  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.041..1.959 rows=2040 loops=1)
                                             Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                             Rows Removed by Filter: 5160
                                             Buffers: shared hit=53
               ->  Aggregate  (cost=885369.25..885369.26 rows=1 width=8) (actual time=11163.422..11163.429 rows=1 loops=1)
                     Buffers: shared hit=518363
                     ->  Hash Join  (cost=2978.85..885321.56 rows=19075 width=0) (actual time=26.390..11157.390 rows=35996 loops=1)
                           Hash Cond: (store_sales_5.ss_hdemo_sk = household_demographics_5.hd_demo_sk)
                           Buffers: shared hit=518363
                           ->  Hash Join  (cost=2722.68..884861.50 rows=77626 width=4) (actual time=21.179..11120.296 rows=129381 loops=1)
                                 Hash Cond: (store_sales_5.ss_store_sk = store_5.s_store_sk)
                                 Buffers: shared hit=518310
                                 ->  Hash Join  (cost=2716.22..883240.29 rows=591649 width=8) (actual time=19.714..10912.198 rows=958094 loops=1)
                                       Hash Cond: (store_sales_5.ss_sold_time_sk = time_dim_5.t_time_sk)
                                       Buffers: shared hit=518305
                                       ->  Seq Scan on store_sales store_sales_5  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.007..3795.519 rows=28800991 loops=1)
                                             Buffers: shared hit=516908
                                       ->  Hash  (cost=2693.00..2693.00 rows=1858 width=4) (actual time=19.483..19.483 rows=1800 loops=1)
                                             Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                             Buffers: shared hit=1397
                                             ->  Seq Scan on time_dim time_dim_5  (cost=0.00..2693.00 rows=1858 width=4) (actual time=8.536..18.983 rows=1800 loops=1)
                                                   Filter: ((t_minute < 30) AND (t_hour = 11))
                                                   Rows Removed by Filter: 84600
                                                   Buffers: shared hit=1397
                                 ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.061..0.062 rows=14 loops=1)
                                       Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                       Buffers: shared hit=5
                                       ->  Seq Scan on store store_5  (cost=0.00..6.28 rows=14 width=4) (actual time=0.011..0.054 rows=14 loops=1)
                                             Filter: ((s_store_name)::text = 'ese'::text)
                                             Rows Removed by Filter: 88
                                             Buffers: shared hit=5
                           ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.554..2.554 rows=2040 loops=1)
                                 Buckets: 2048  Batches: 1  Memory Usage: 88kB
                                 Buffers: shared hit=53
                                 ->  Seq Scan on household_demographics household_demographics_5  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.042..1.976 rows=2040 loops=1)
                                       Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                       Rows Removed by Filter: 5160
                                       Buffers: shared hit=53
         ->  Aggregate  (cost=885333.65..885333.66 rows=1 width=8) (actual time=11024.168..11024.175 rows=1 loops=1)
               Buffers: shared hit=518363
               ->  Hash Join  (cost=2978.41..885286.86 rows=18716 width=0) (actual time=22.901..11018.159 rows=35717 loops=1)
                     Hash Cond: (store_sales_6.ss_hdemo_sk = household_demographics_6.hd_demo_sk)
                     Buffers: shared hit=518363
                     ->  Hash Join  (cost=2722.24..884830.64 rows=76163 width=4) (actual time=19.658..10980.741 rows=128864 loops=1)
                           Hash Cond: (store_sales_6.ss_store_sk = store_6.s_store_sk)
                           Buffers: shared hit=518310
                           ->  Hash Join  (cost=2715.79..883239.85 rows=580504 width=8) (actual time=19.583..10773.506 rows=956288 loops=1)
                                 Hash Cond: (store_sales_6.ss_sold_time_sk = time_dim_6.t_time_sk)
                                 Buffers: shared hit=518305
                                 ->  Seq Scan on store_sales store_sales_6  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.004..3785.043 rows=28800991 loops=1)
                                       Buffers: shared hit=516908
                                 ->  Hash  (cost=2693.00..2693.00 rows=1823 width=4) (actual time=19.401..19.401 rows=1800 loops=1)
                                       Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                       Buffers: shared hit=1397
                                       ->  Seq Scan on time_dim time_dim_6  (cost=0.00..2693.00 rows=1823 width=4) (actual time=9.003..18.898 rows=1800 loops=1)
                                             Filter: ((t_minute >= 30) AND (t_hour = 11))
                                             Rows Removed by Filter: 84600
                                             Buffers: shared hit=1397
                           ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.060..0.060 rows=14 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                 Buffers: shared hit=5
                                 ->  Seq Scan on store store_6  (cost=0.00..6.28 rows=14 width=4) (actual time=0.011..0.054 rows=14 loops=1)
                                       Filter: ((s_store_name)::text = 'ese'::text)
                                       Rows Removed by Filter: 88
                                       Buffers: shared hit=5
                     ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.555..2.556 rows=2040 loops=1)
                           Buckets: 2048  Batches: 1  Memory Usage: 88kB
                           Buffers: shared hit=53
                           ->  Seq Scan on household_demographics household_demographics_6  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.045..1.968 rows=2040 loops=1)
                                 Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                                 Rows Removed by Filter: 5160
                                 Buffers: shared hit=53
   ->  Aggregate  (cost=885286.87..885286.88 rows=1 width=8) (actual time=11189.622..11189.625 rows=1 loops=1)
         Buffers: shared hit=518363
         ->  Hash Join  (cost=2977.84..885241.26 rows=18244 width=0) (actual time=23.630..11182.691 rows=40930 loops=1)
               Hash Cond: (store_sales_7.ss_hdemo_sk = household_demographics_7.hd_demo_sk)
               Buffers: shared hit=518363
               ->  Hash Join  (cost=2721.66..884790.09 rows=74241 width=4) (actual time=20.991..11140.563 rows=146497 loops=1)
                     Hash Cond: (store_sales_7.ss_store_sk = store_7.s_store_sk)
                     Buffers: shared hit=518310
                     ->  Hash Join  (cost=2715.21..883239.27 rows=565856 width=8) (actual time=19.853..10903.044 rows=1100338 loops=1)
                           Hash Cond: (store_sales_7.ss_sold_time_sk = time_dim_7.t_time_sk)
                           Buffers: shared hit=518305
                           ->  Seq Scan on store_sales store_sales_7  (cost=0.00..804917.92 rows=28800992 width=12) (actual time=0.007..3876.240 rows=28800991 loops=1)
                                 Buffers: shared hit=516908
                           ->  Hash  (cost=2693.00..2693.00 rows=1777 width=4) (actual time=19.628..19.628 rows=1800 loops=1)
                                 Buckets: 2048  Batches: 1  Memory Usage: 80kB
                                 Buffers: shared hit=1397
                                 ->  Seq Scan on time_dim time_dim_7  (cost=0.00..2693.00 rows=1777 width=4) (actual time=9.546..19.116 rows=1800 loops=1)
                                       Filter: ((t_minute < 30) AND (t_hour = 12))
                                       Rows Removed by Filter: 84600
                                       Buffers: shared hit=1397
                     ->  Hash  (cost=6.28..6.28 rows=14 width=4) (actual time=0.061..0.061 rows=14 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 9kB
                           Buffers: shared hit=5
                           ->  Seq Scan on store store_7  (cost=0.00..6.28 rows=14 width=4) (actual time=0.011..0.054 rows=14 loops=1)
                                 Filter: ((s_store_name)::text = 'ese'::text)
                                 Rows Removed by Filter: 88
                                 Buffers: shared hit=5
               ->  Hash  (cost=233.00..233.00 rows=1854 width=4) (actual time=2.565..2.565 rows=2040 loops=1)
                     Buckets: 2048  Batches: 1  Memory Usage: 88kB
                     Buffers: shared hit=53
                     ->  Seq Scan on household_demographics household_demographics_7  (cost=0.00..233.00 rows=1854 width=4) (actual time=0.042..1.985 rows=2040 loops=1)
                           Filter: (((hd_dep_count = 2) AND (hd_vehicle_count <= 4)) OR ((hd_dep_count = 1) AND (hd_vehicle_count <= 3)) OR ((hd_dep_count = 4) AND (hd_vehicle_count <= 6)))
                           Rows Removed by Filter: 5160
                           Buffers: shared hit=53
 Planning:
   Buffers: shared hit=643
 Planning Time: 8.930 ms
 Execution Time: 89994.445 ms
(290 rows)

