                                                               QUERY PLAN                                                               
----------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=888838.60..888838.60 rows=1 width=8)
   ->  Sort  (cost=888838.60..888838.60 rows=1 width=8)
         Sort Key: (count(*))
         ->  Aggregate  (cost=888838.58..888838.59 rows=1 width=8)
               ->  Nested Loop  (cost=2722.01..888820.83 rows=7101 width=0)
                     ->  Hash Join  (cost=2721.71..884793.62 rows=74409 width=4)
                           Hash Cond: (store_sales.ss_store_sk = store.s_store_sk)
                           ->  Hash Join  (cost=2715.26..883239.32 rows=567130 width=8)
                                 Hash Cond: (store_sales.ss_sold_time_sk = time_dim.t_time_sk)
                                 ->  Seq Scan on store_sales  (cost=0.00..804917.92 rows=28800992 width=12)
                                 ->  Hash  (cost=2693.00..2693.00 rows=1781 width=4)
                                       ->  Seq Scan on time_dim  (cost=0.00..2693.00 rows=1781 width=4)
                                             Filter: ((t_minute >= 30) AND (t_hour = 8))
                           ->  Hash  (cost=6.28..6.28 rows=14 width=4)
                                 ->  Seq Scan on store  (cost=0.00..6.28 rows=14 width=4)
                                       Filter: ((s_store_name)::text = 'ese'::text)
                     ->  Result Cache  (cost=0.29..0.31 rows=1 width=4)
                           Cache Key: store_sales.ss_hdemo_sk
                           ->  Index Scan using household_demographics_pkey on household_demographics  (cost=0.28..0.30 rows=1 width=4)
                                 Index Cond: (hd_demo_sk = store_sales.ss_hdemo_sk)
                                 Filter: (hd_dep_count = 5)
(21 rows)

