                                                                                                                 QUERY PLAN                                                                                                                 
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=7111857.33..7111857.56 rows=1 width=64) (actual time=90803.760..90803.825 rows=1 loops=1)
   Buffers: shared hit=4289190
   ->  Nested Loop  (cost=6222909.09..6222909.29 rows=1 width=56) (actual time=79564.554..79564.615 rows=1 loops=1)
         Buffers: shared hit=3752841
         ->  Nested Loop  (cost=5333871.06..5333871.23 rows=1 width=48) (actual time=68336.005..68336.058 rows=1 loops=1)
               Buffers: shared hit=3216972
               ->  Nested Loop  (cost=4444764.70..4444764.84 rows=1 width=40) (actual time=57032.861..57032.906 rows=1 loops=1)
                     Buffers: shared hit=2681313
                     ->  Nested Loop  (cost=3555732.52..3555732.63 rows=1 width=32) (actual time=45448.573..45448.610 rows=1 loops=1)
                           Buffers: shared hit=2142771
                           ->  Nested Loop  (cost=2666632.03..2666632.11 rows=1 width=24) (actual time=33860.619..33860.648 rows=1 loops=1)
                                 Buffers: shared hit=1604127
                                 ->  Nested Loop  (cost=1777826.26..1777826.31 rows=1 width=16) (actual time=22526.512..22526.532 rows=1 loops=1)
                                       Buffers: shared hit=1067745
                                       ->  Aggregate  (cost=888956.08..888956.09 rows=1 width=8) (actual time=11117.406..11117.417 rows=1 loops=1)
                                             Buffers: shared hit=531369
                                             ->  Nested Loop  (cost=2722.01..888910.36 rows=18285 width=0) (actual time=23.035..11113.571 rows=20619 loops=1)
                                                   Buffers: shared hit=531369
                                                   ->  Hash Join  (cost=2721.71..884793.62 rows=74409 width=4) (actual time=23.003..11028.570 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.825..10907.183 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.005..3857.726 rows=28800991 loops=1)
                                                                     Buffers: shared hit=516908
                                                               ->  Hash  (cost=2693.00..2693.00 rows=1781 width=4) (actual time=21.680..21.682 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.740..21.188 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.092..0.094 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.013..0.083 rows=14 loops=1)
                                                                     Filter: ((s_store_name)::text = 'ese'::text)
                                                                     Rows Removed by Filter: 88
                                                                     Buffers: shared hit=5
                                                   ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=74521)
                                                         Cache Key: store_sales.ss_hdemo_sk
                                                         Hits: 70167  Misses: 4354  Evictions: 0  Overflows: 0  Memory Usage: 333kB
                                                         Buffers: shared hit=13059
                                                         ->  Index Scan using household_demographics_pkey on household_demographics  (cost=0.28..0.32 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=4354)
                                                               Index Cond: (hd_demo_sk = store_sales.ss_hdemo_sk)
                                                               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: 1
                                                               Buffers: shared hit=13059
                                       ->  Aggregate  (cost=888870.18..888870.19 rows=1 width=8) (actual time=11409.100..11409.107 rows=1 loops=1)
                                             Buffers: shared hit=536376
                                             ->  Nested Loop  (cost=2721.46..888825.60 rows=17833 width=0) (actual time=20.509..11401.469 rows=41838 loops=1)
                                                   Buffers: shared hit=536376
                                                   ->  Hash Join  (cost=2721.16..884754.83 rows=72570 width=4) (actual time=20.246..11256.551 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.424..11014.509 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..3823.551 rows=28800991 loops=1)
                                                                     Buffers: shared hit=516908
                                                               ->  Hash  (cost=2693.00..2693.00 rows=1737 width=4) (actual time=19.341..19.343 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.014..18.847 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.068..0.068 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.015..0.059 rows=14 loops=1)
                                                                     Filter: ((s_store_name)::text = 'ese'::text)
                                                                     Rows Removed by Filter: 88
                                                                     Buffers: shared hit=5
                                                   ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=147345)
                                                         Cache Key: store_sales_1.ss_hdemo_sk
                                                         Hits: 141322  Misses: 6023  Evictions: 0  Overflows: 0  Memory Usage: 461kB
                                                         Buffers: shared hit=18066
                                                         ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_1  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=6023)
                                                               Index Cond: (hd_demo_sk = store_sales_1.ss_hdemo_sk)
                                                               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: 1
                                                               Buffers: shared hit=18066
                                 ->  Aggregate  (cost=888805.78..888805.79 rows=1 width=8) (actual time=11334.102..11334.110 rows=1 loops=1)
                                       Buffers: shared hit=536382
                                       ->  Nested Loop  (cost=2721.04..888762.04 rows=17494 width=0) (actual time=20.497..11326.728 rows=40936 loops=1)
                                             Buffers: shared hit=536382
                                             ->  Hash Join  (cost=2720.75..884725.73 rows=71191 width=4) (actual time=20.475..11182.899 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.763..10942.537 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.004..3847.361 rows=28800991 loops=1)
                                                               Buffers: shared hit=516908
                                                         ->  Hash  (cost=2693.00..2693.00 rows=1704 width=4) (actual time=19.688..19.689 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.578..19.183 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.070..0.071 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.017..0.061 rows=14 loops=1)
                                                               Filter: ((s_store_name)::text = 'ese'::text)
                                                               Rows Removed by Filter: 88
                                                               Buffers: shared hit=5
                                             ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=146451)
                                                   Cache Key: store_sales_2.ss_hdemo_sk
                                                   Hits: 140426  Misses: 6025  Evictions: 0  Overflows: 0  Memory Usage: 461kB
                                                   Buffers: shared hit=18072
                                                   ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_2  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=6025)
                                                         Index Cond: (hd_demo_sk = store_sales_2.ss_hdemo_sk)
                                                         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: 1
                                                         Buffers: shared hit=18072
                           ->  Aggregate  (cost=889100.49..889100.50 rows=1 width=8) (actual time=11587.948..11587.955 rows=1 loops=1)
                                 Buffers: shared hit=538644
                                 ->  Nested Loop  (cost=2722.93..889052.88 rows=19044 width=0) (actual time=19.543..11576.704 rows=62229 loops=1)
                                       Buffers: shared hit=538644
                                       ->  Hash Join  (cost=2722.64..884858.86 rows=77500 width=4) (actual time=19.507..11374.144 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.299..11015.255 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..3821.011 rows=28800991 loops=1)
                                                         Buffers: shared hit=516908
                                                   ->  Hash  (cost=2693.00..2693.00 rows=1855 width=4) (actual time=19.239..19.240 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.616..18.735 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.064..0.065 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.015..0.056 rows=14 loops=1)
                                                         Filter: ((s_store_name)::text = 'ese'::text)
                                                         Rows Removed by Filter: 88
                                                         Buffers: shared hit=5
                                       ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=220382)
                                             Cache Key: store_sales_3.ss_hdemo_sk
                                             Hits: 213603  Misses: 6779  Evictions: 0  Overflows: 0  Memory Usage: 519kB
                                             Buffers: shared hit=20334
                                             ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_3  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=6779)
                                                   Index Cond: (hd_demo_sk = store_sales_3.ss_hdemo_sk)
                                                   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: 1
                                                   Buffers: shared hit=20334
                     ->  Aggregate  (cost=889032.18..889032.19 rows=1 width=8) (actual time=11584.282..11584.289 rows=1 loops=1)
                           Buffers: shared hit=538542
                           ->  Nested Loop  (cost=2722.49..888985.46 rows=18685 width=0) (actual time=21.628..11573.408 rows=61896 loops=1)
                                 Buffers: shared hit=538542
                                 ->  Hash Join  (cost=2722.20..884828.00 rows=76038 width=4) (actual time=19.976..11365.086 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.475..11002.499 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.008..3824.668 rows=28800991 loops=1)
                                                   Buffers: shared hit=516908
                                             ->  Hash  (cost=2693.00..2693.00 rows=1820 width=4) (actual time=19.434..19.435 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=8.218..18.930 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.069..0.070 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.017..0.060 rows=14 loops=1)
                                                   Filter: ((s_store_name)::text = 'ese'::text)
                                                   Rows Removed by Filter: 88
                                                   Buffers: shared hit=5
                                 ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=223913)
                                       Cache Key: store_sales_4.ss_hdemo_sk
                                       Hits: 217168  Misses: 6745  Evictions: 0  Overflows: 0  Memory Usage: 516kB
                                       Buffers: shared hit=20232
                                       ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_4  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=6745)
                                             Index Cond: (hd_demo_sk = store_sales_4.ss_hdemo_sk)
                                             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: 1
                                             Buffers: shared hit=20232
               ->  Aggregate  (cost=889106.36..889106.37 rows=1 width=8) (actual time=11303.137..11303.144 rows=1 loops=1)
                     Buffers: shared hit=535659
                     ->  Nested Loop  (cost=2722.97..889058.67 rows=19075 width=0) (actual time=24.027..11296.534 rows=35996 loops=1)
                           Buffers: shared hit=535659
                           ->  Hash Join  (cost=2722.68..884861.50 rows=77626 width=4) (actual time=21.370..11166.048 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.867..10956.822 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.008..3824.786 rows=28800991 loops=1)
                                             Buffers: shared hit=516908
                                       ->  Hash  (cost=2693.00..2693.00 rows=1858 width=4) (actual time=19.648..19.649 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.677..19.128 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.069..0.070 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.017..0.061 rows=14 loops=1)
                                             Filter: ((s_store_name)::text = 'ese'::text)
                                             Rows Removed by Filter: 88
                                             Buffers: shared hit=5
                           ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=129381)
                                 Cache Key: store_sales_5.ss_hdemo_sk
                                 Hits: 123597  Misses: 5784  Evictions: 0  Overflows: 0  Memory Usage: 442kB
                                 Buffers: shared hit=17349
                                 ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_5  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=5784)
                                       Index Cond: (hd_demo_sk = store_sales_5.ss_hdemo_sk)
                                       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: 1
                                       Buffers: shared hit=17349
         ->  Aggregate  (cost=889038.03..889038.04 rows=1 width=8) (actual time=11228.543..11228.550 rows=1 loops=1)
               Buffers: shared hit=535869
               ->  Nested Loop  (cost=2722.53..888991.24 rows=18716 width=0) (actual time=20.628..11222.191 rows=35717 loops=1)
                     Buffers: shared hit=535869
                     ->  Hash Join  (cost=2722.24..884830.64 rows=76163 width=4) (actual time=19.941..11091.254 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.803..10881.142 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..3828.351 rows=28800991 loops=1)
                                       Buffers: shared hit=516908
                                 ->  Hash  (cost=2693.00..2693.00 rows=1823 width=4) (actual time=19.632..19.633 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=8.988..19.133 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.083..0.084 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.026..0.071 rows=14 loops=1)
                                       Filter: ((s_store_name)::text = 'ese'::text)
                                       Rows Removed by Filter: 88
                                       Buffers: shared hit=5
                     ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=128864)
                           Cache Key: store_sales_6.ss_hdemo_sk
                           Hits: 123010  Misses: 5854  Evictions: 0  Overflows: 0  Memory Usage: 447kB
                           Buffers: shared hit=17559
                           ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_6  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=5854)
                                 Index Cond: (hd_demo_sk = store_sales_6.ss_hdemo_sk)
                                 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: 1
                                 Buffers: shared hit=17559
   ->  Aggregate  (cost=888948.25..888948.26 rows=1 width=8) (actual time=11239.199..11239.202 rows=1 loops=1)
         Buffers: shared hit=536349
         ->  Nested Loop  (cost=2721.96..888902.64 rows=18244 width=0) (actual time=20.912..11231.639 rows=40930 loops=1)
               Buffers: shared hit=536349
               ->  Hash Join  (cost=2721.66..884790.09 rows=74241 width=4) (actual time=20.843..11088.048 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.665..10847.409 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.005..3823.483 rows=28800991 loops=1)
                                 Buffers: shared hit=516908
                           ->  Hash  (cost=2693.00..2693.00 rows=1777 width=4) (actual time=19.444..19.444 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.422..18.950 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.070..0.071 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.017..0.061 rows=14 loops=1)
                                 Filter: ((s_store_name)::text = 'ese'::text)
                                 Rows Removed by Filter: 88
                                 Buffers: shared hit=5
               ->  Result Cache  (cost=0.29..0.33 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=146497)
                     Cache Key: store_sales_7.ss_hdemo_sk
                     Hits: 140483  Misses: 6014  Evictions: 0  Overflows: 0  Memory Usage: 460kB
                     Buffers: shared hit=18039
                     ->  Index Scan using household_demographics_pkey on household_demographics household_demographics_7  (cost=0.28..0.32 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=6014)
                           Index Cond: (hd_demo_sk = store_sales_7.ss_hdemo_sk)
                           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: 1
                           Buffers: shared hit=18039
 Planning:
   Buffers: shared hit=643
 Planning Time: 9.324 ms
 Execution Time: 90807.609 ms
(298 rows)

