explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a7i9 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=150.58..151.11 rows=1 width=36) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=150.58..151.11 rows=1 width=36) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=150.58..150.59 rows=1 width=48) (actual rows= loops=)

  • Sort Key: rrs.priority
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=4.95..150.57 rows=1 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on uzgps_routing_route_station rrs (cost=4.67..142.26 rows=1 width=12) (actual rows= loops=)

  • Recheck Cond: (route_id = '49'::bigint)
  • Filter: (status = 'A'::bpchar)
6. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (route_id = '49'::bigint)
7. 0.000 0.000 ↓ 0.0

Index Scan using uzgps_routing_station_id_idx1 on uzgps_routing_station rs (cost=0.28..8.30 rows=1 width=52) (actual rows= loops=)

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