QUERY PLAN                                                                       
--------------------------------------------------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=132352.98..132572.98 rows=200 width=52) (actual time=24354.972..24355.019 rows=47 loops=1)
   ->  Hash Join  (cost=2379.09..108954.69 rows=550548 width=52) (actual time=76.188..8177.510 rows=2593557 loops=1)
         Hash Cond: (_.i_id = __3.id)
         ->  Hash Join  (cost=16.20..92904.25 rows=935090 width=56) (actual time=0.140..5304.968 rows=2596942 loops=1)
               Hash Cond: (_.a_id = __1.id)
               ->  Append  (cost=0.00..73796.62 rows=2597473 width=56) (actual time=0.043..3272.024 rows=2596942 loops=1)
                     ->  Seq Scan on t_c _  (cost=0.00..21.55 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..73775.07 rows=2597469 width=56) (actual time=0.040..2245.209 rows=2596942 loops=1)
                           Filter: ((date_day >= '2008-01-01'::date) AND (date_day <= '2008-01-27'::date))
               ->  Hash  (cost=15.30..15.30 rows=72 width=4) (actual time=0.091..0.091 rows=72 loops=1)
                     ->  Seq Scan on t_a __1  (cost=0.00..15.30 rows=72 width=4) (actual time=0.003..0.061 rows=72 loops=1)
                           Filter: (status IS TRUE)
         ->  Hash  (cost=1882.44..1882.44 rows=38436 width=4) (actual time=76.027..76.027 rows=59934 loops=1)
               ->  Hash Join  (cost=55.45..1882.44 rows=38436 width=4) (actual time=0.835..54.576 rows=59934 loops=1)
                     Hash Cond: (__3.b_id = __2.id)
                     ->  Seq Scan on t_i __3  (cost=0.00..1197.82 rows=65282 width=8) (actual time=0.004..16.096 rows=65282 loops=1)
                     ->  Hash  (cost=48.90..48.90 rows=524 width=4) (actual time=0.513..0.513 rows=524 loops=1)
                           ->  Seq Scan on t_b __2  (cost=0.00..48.90 rows=524 width=4) (actual time=0.003..0.307 rows=524 loops=1)
                                 Filter: (status IS TRUE)
 Total runtime: 24355.179 ms