                                                  QUERY PLAN                                                  
--------------------------------------------------------------------------------------------------------------
 Limit  (cost=893685.25..893685.26 rows=1 width=8)
   ->  Sort  (cost=893685.25..893685.26 rows=1 width=8)
         Sort Key: (count(*))
         ->  Aggregate  (cost=893685.23..893685.24 rows=1 width=8)
               ->  Nested Loop  (cost=2867.40..893667.48 rows=7101 width=0)
                     ->  Hash Join  (cost=2867.26..884880.87 rows=54121 width=4)
                           Hash Cond: (store_sales.ss_hdemo_sk = household_demographics.hd_demo_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=143.00..143.00 rows=720 width=4)
                                 ->  Seq Scan on household_demographics  (cost=0.00..143.00 rows=720 width=4)
                                       Filter: (hd_dep_count = 5)
                     ->  Index Scan using store_pkey on store  (cost=0.14..0.16 rows=1 width=4)
                           Index Cond: (s_store_sk = store_sales.ss_store_sk)
                           Filter: ((s_store_name)::text = 'ese'::text)
(19 rows)

