explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tnc : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.455 ↑ 1.0 1 1

Limit (cost=150.58..150.59 rows=1 width=854) (actual time=0.453..0.455 rows=1 loops=1)

2. 0.043 0.453 ↑ 1.0 1 1

Sort (cost=150.58..150.59 rows=1 width=854) (actual time=0.453..0.453 rows=1 loops=1)

  • Sort Key: rrs.priority
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.034 0.410 ↓ 27.0 27 1

Nested Loop Left Join (cost=4.95..150.57 rows=1 width=854) (actual time=0.087..0.410 rows=27 loops=1)

4. 0.039 0.079 ↓ 27.0 27 1

Bitmap Heap Scan on uzgps_routing_route_station rrs (cost=4.67..142.26 rows=1 width=172) (actual time=0.050..0.079 rows=27 loops=1)

  • Recheck Cond: (route_id = 49)
  • Filter: (status = 'A'::bpchar)
  • Heap Blocks: exact=4
5. 0.040 0.040 ↑ 1.9 27 1

Bitmap Index Scan on uzgps_routing_route_station_route_id_priority_idx (cost=0.00..4.67 rows=51 width=0) (actual time=0.040..0.040 rows=27 loops=1)

  • Index Cond: (route_id = 49)
6. 0.297 0.297 ↑ 1.0 1 27

Index Scan using uzgps_routing_station_pkey on uzgps_routing_station rs (cost=0.28..8.30 rows=1 width=682) (actual time=0.011..0.011 rows=1 loops=27)

  • Index Cond: (rrs.station_id = id)
  • Filter: (status = 'A'::bpchar)