rendered paste body 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)