query-plan-1236

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
34.266 100.00% 
 Aggregate (cost=221.93..221.93 rows=1 width=4) (actual time=34.262..34.266 rows=1 loops=1)
34.237 99.92% 
   -> Hash Left Join (cost=9.07..220.86 rows=426 width=4) (actual time=34.237..34.237 rows=0 loops=1)
         Hash Cond: ("outer".tid = "inner".tid)
         Filter: ("inner".tid IS NULL)
0.512 1.49% 
         -> Index Scan using axp_temp_order_match_idx1 on axp_temp_order_match a (cost=0.0..209.65 rows=426 width=4) (actual time=0.277..0.512 rows=6 loops=1)
               Index Cond: (sid = 16072)
32.777 95.65% 
         -> Hash (cost=9.07..9.07 rows=1 width=4) (actual time=32.777..32.777 rows=0 loops=1)
31.563 92.11% 
               -> Nested Loop (cost=0.0..9.07 rows=1 width=4) (actual time=0.208..31.563 rows=284 loops=1)
20.684 60.36% 
                     -> Nested Loop (cost=0.0..6.05 rows=1 width=4) (actual time=0.178..20.684 rows=552 loops=1)
3.973 11.59% 
                           -> Index Scan using axp_dayschedule_day_idx on axp_dayschedule ds (cost=0.0..3.02 rows=1 width=8) (actual time=0.036..3.973 rows=610 loops=1)
                                 Index Cond: (("day" >= '2005-05-12'::date) AND ("day" <= '2005-05-12'::date))
                                 Filter: (used = B'1'::"bit")
7.930 23.14% 
                           -> Index Scan using axp_order_orid_key on axp_order o (cost=0.0..3.02 rows=1 width=4) (actual time=0.009..0.013 rows=1 loops=610)
                                 Index Cond: ("outer".orid = o.orid)
                                 Filter: (status >= 100)
4.416 12.89% 
                     -> Index Scan using axp_order_line_pk on axp_order_line ol (cost=0.0..3.01 rows=1 width=8) (actual time=0.006..0.008 rows=1 loops=552)
                           Index Cond: (ol.olid = "outer".olid)
Run-time
0.034581 seconds (34.581 ms)