explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YaDm0 : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #iedG; plan #N2Gf; plan #SD9y; plan #hA3P; plan #Qoro

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 0.121 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.55..16.61 rows=1 width=36) (actual time=0.107..0.121 rows=1 loops=1)

  • Output: mrl.mobject_id, mrl.route_id, '0.927902912082601'::double precision, 1, rr.wkt_length
  • Join Filter: (mrl.route_id = rr.id)
  • Buffers: shared hit=7
2. 0.098 0.098 ↑ 1.0 1 1

Index Scan using mobject_route_list_mobject_id_is_in_route_route_id_idx on bus_tablo.mobject_route_list mrl (cost=0.28..8.30 rows=1 width=16) (actual time=0.086..0.098 rows=1 loops=1)

  • Output: mrl.id, mrl.route_id, mrl.mobject_id, mrl.mr_status, mrl.reg_date, mrl.mod_date, mrl.exp_date, mrl.is_in_route, mrl.percent_point_to_route, mrl.coor_lat, mrl.coor_lng, mrl.route_length, mrl.speed
  • Index Cond: ((mrl.mobject_id = 686) AND (mrl.is_in_route = 1) AND (mrl.route_id = 68))
  • Filter: (mrl.mr_status = 'A'::bpchar)
  • Buffers: shared hit=4
3. 0.016 0.016 ↑ 1.0 1 1

Index Scan using uzgps_routing_route_id_idx on public.uzgps_routing_route rr (cost=0.28..8.29 rows=1 width=16) (actual time=0.015..0.016 rows=1 loops=1)

  • Output: rr.wkt_length, rr.id
  • Index Cond: (rr.id = 68)
  • Filter: (rr.status = 'A'::bpchar)
  • Buffers: shared hit=3