QUERY PLAN                                                                                                    
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=255.64..255.65 rows=3 width=256) (actual time=67.477..67.618 rows=128 loops=1)
   Sort Key: hmap, tstamp, l1total
   ->  Append  (cost=84.99..255.62 rows=3 width=256) (actual time=25.620..66.920 rows=128 loops=1)
         ->  Subquery Scan "*SELECT* 1"  (cost=84.99..85.18 rows=1 width=112) (actual time=25.617..29.713 rows=120 loops=1)
               ->  HashAggregate  (cost=84.99..85.17 rows=1 width=112) (actual time=25.612..29.414 rows=120 loops=1)
                     ->  Nested Loop Left Join  (cost=0.00..84.92 rows=1 width=112) (actual time=0.109..21.797 rows=513 loops=1)
                           ->  Nested Loop Left Join  (cost=0.00..41.99 rows=1 width=106) (actual time=0.083..13.335 rows=513 loops=1)
                                 ->  Index Scan using businessrequestsummary_lastflushtime_dx on businessrequestsummary brsa  (cost=0.00..8.33 rows=1 width=87) (actual time=0.059..5.120 rows=513 loops=1)
                                       Index Cond: ((lastflushtime >= '2007-11-27 13:15:03'::timestamp without time zone) AND (lastflushtime <= '2007-11-27 13:45:03'::timestamp without time zone))
                                       Filter: (((category)::text = 'Webservice'::text) AND ((request)::text = 'lowFareSearch'::text) AND ((perspective)::text = 'LowFareSearchReq'::text))
                                 ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsb  (cost=0.00..29.54 rows=330 width=45) (actual time=0.009..0.010 rows=1 loops=513)
                                       Index Cond: (brsa.businessrequestsummaryid = brsb.primaryrequestid)
                           ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsc  (cost=0.00..38.80 rows=330 width=32) (actual time=0.007..0.009 rows=1 loops=513)
                                 Index Cond: (brsb.businessrequestsummaryid = brsc.primaryrequestid)
         ->  Subquery Scan "*SELECT* 2"  (cost=84.98..85.17 rows=1 width=104) (actual time=23.430..23.533 rows=4 loops=1)
               ->  HashAggregate  (cost=84.98..85.16 rows=1 width=104) (actual time=23.426..23.520 rows=4 loops=1)
                     ->  Nested Loop Left Join  (cost=0.00..84.92 rows=1 width=104) (actual time=0.082..19.923 rows=513 loops=1)
                           ->  Nested Loop Left Join  (cost=0.00..41.99 rows=1 width=98) (actual time=0.068..12.580 rows=513 loops=1)
                                 ->  Index Scan using businessrequestsummary_lastflushtime_dx on businessrequestsummary brsa  (cost=0.00..8.33 rows=1 width=79) (actual time=0.050..4.726 rows=513 loops=1)
                                       Index Cond: ((lastflushtime >= '2007-11-27 13:15:03'::timestamp without time zone) AND (lastflushtime <= '2007-11-27 13:45:03'::timestamp without time zone))
                                       Filter: (((category)::text = 'Webservice'::text) AND ((request)::text = 'lowFareSearch'::text) AND ((perspective)::text = 'LowFareSearchReq'::text))
                                 ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsb  (cost=0.00..29.54 rows=330 width=45) (actual time=0.008..0.010 rows=1 loops=513)
                                       Index Cond: (brsa.businessrequestsummaryid = brsb.primaryrequestid)
                           ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsc  (cost=0.00..38.80 rows=330 width=32) (actual time=0.007..0.009 rows=1 loops=513)
                                 Index Cond: (brsb.businessrequestsummaryid = brsc.primaryrequestid)
         ->  Subquery Scan "*SELECT* 3"  (cost=85.20..85.27 rows=1 width=256) (actual time=12.854..13.390 rows=4 loops=1)
               ->  HashAggregate  (cost=85.20..85.26 rows=1 width=256) (actual time=12.848..13.373 rows=4 loops=1)
                     ->  HashAggregate  (cost=84.99..85.17 rows=1 width=112) (actual time=10.357..11.649 rows=47 loops=1)
                           ->  Nested Loop Left Join  (cost=0.00..84.92 rows=1 width=112) (actual time=0.102..8.791 rows=199 loops=1)
                                 ->  Nested Loop Left Join  (cost=0.00..41.99 rows=1 width=106) (actual time=0.072..5.385 rows=199 loops=1)
                                       ->  Index Scan using businessrequestsummary_lastflushtime_dx on businessrequestsummary brsa  (cost=0.00..8.33 rows=1 width=87) (actual time=0.052..2.085 rows=199 loops=1)
                                             Index Cond: ((lastflushtime >= '2007-11-27 09:14:00'::timestamp without time zone) AND (lastflushtime <= '2007-11-27 09:25:40'::timestamp without time zone))
                                             Filter: (((category)::text = 'Webservice'::text) AND ((request)::text = 'lowFareSearch'::text) AND ((perspective)::text = 'LowFareSearchReq'::text))
                                       ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsb  (cost=0.00..29.54 rows=330 width=45) (actual time=0.009..0.011 rows=1 loops=199)
                                             Index Cond: (brsa.businessrequestsummaryid = brsb.primaryrequestid)
                                 ->  Index Scan using businessrequestsummary_primreq_dx on businessrequestsummary brsc  (cost=0.00..38.80 rows=330 width=32) (actual time=0.008..0.010 rows=1 loops=199)
                                       Index Cond: (brsb.businessrequestsummaryid = brsc.primaryrequestid)
 Total runtime: 68.931 ms
(38 rows)