query-plan-1240

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
14.185 100.00% 
 Aggregate (cost=31.91..31.92 rows=1 width=4) (actual time=14.185..14.185 rows=1 loops=1)
13.400 94.47% 
   -> Nested Loop Left Join (cost=0.0..17.11 rows=2959 width=4) (actual time=8.608..13.400 rows=2953 loops=1)
0.011 0.08% 
         -> Index Scan using id_idx on tab1 (cost=0.0..8.27 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)
               Index Cond: (id = 10)
11.924 84.06% 
         -> Index Scan using out_id_idx on tab_outer (cost=0.0..8.83 rows=1 width=8) (actual time=8.590..11.924 rows=2953 loops=1)
               Index Cond: ((tab_outer.out_id = 10) AND (tab1.id = tab_outer.out_id))
Run-time
0.014361 seconds (14.361 ms)