QUERY PLAN                                                                       
--------------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=134877.04..134899.04 rows=200 width=52) (actual time=21517.837..21517.890 rows=47 loops=1)
   ->  Hash Join  (cost=2450.09..111489.75 rows=550289 width=52) (actual time=76.083..7691.579 rows=2593557 loops=1)
         Hash Cond: (_.i_id = __3.id)
         ->  Hash Join  (cost=19.20..95377.74 rows=934651 width=56) (actual time=0.119..4933.928 rows=2596942 loops=1)
               Hash Cond: (_.a_id = __1.id)
               ->  Append  (cost=0.00..76276.09 rows=2596252 width=56) (actual time=0.014..2988.950 rows=2596942 loops=1)
                     ->  Seq Scan on t_c _  (cost=0.00..21.10 rows=4 width=56) (actual time=0.001..0.001 rows=0 loops=1)
                           Filter: ((date_day >= '2008-01-01'::date) AND (date_day <= '2008-01-27'::date))
                     ->  Seq Scan on t_c_2008_01 _  (cost=0.00..76254.99 rows=2596248 width=56) (actual time=0.011..1979.606 rows=2596942 loops=1)
                           Filter: ((date_day >= '2008-01-01'::date) AND (date_day <= '2008-01-27'::date))
               ->  Hash  (cost=18.30..18.30 rows=72 width=4) (actual time=0.094..0.094 rows=72 loops=1)
                     ->  Seq Scan on t_a __1  (cost=0.00..18.30 rows=72 width=4) (actual time=0.004..0.067 rows=72 loops=1)
                           Filter: (status IS TRUE)
         ->  Hash  (cost=1950.44..1950.44 rows=38436 width=4) (actual time=75.931..75.931 rows=59934 loops=1)
               ->  Hash Join  (cost=57.45..1950.44 rows=38436 width=4) (actual time=0.829..54.760 rows=59934 loops=1)
                     Hash Cond: (__3.b_id = __2.id)
                     ->  Seq Scan on t_i __3  (cost=0.00..1263.82 rows=65282 width=8) (actual time=0.005..16.852 rows=65282 loops=1)
                     ->  Hash  (cost=50.90..50.90 rows=524 width=4) (actual time=0.499..0.499 rows=524 loops=1)
                           ->  Seq Scan on t_b __2  (cost=0.00..50.90 rows=524 width=4) (actual time=0.004..0.312 rows=524 loops=1)
                                 Filter: (status IS TRUE)
 Total runtime: 21518.097 ms