explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bBPv : 123213

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.013 ↓ 0.0 0 1

HashAggregate (cost=16.69..16.95 rows=26 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Group Key: uzgps_routing_route_station.route_id
2. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=0.57..16.62 rows=26 width=8) (actual time=0.012..0.012 rows=0 loops=1)

3. 0.011 0.011 ↓ 0.0 0 1

Index Scan using uzgps_routing_station_contract_id_status_idx on uzgps_routing_station (cost=0.28..8.30 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((contract_id = 9) AND (status = 'A'::bpchar))
  • Filter: (upper((name)::text) ~~ '%11%'::text)
4. 0.000 0.000 ↓ 0.0 0

Index Scan using uzgps_routing_route_station_station_id_status_idx on uzgps_routing_route_station (cost=0.29..8.30 rows=1 width=16) (never executed)

  • Index Cond: ((station_id = uzgps_routing_station.id) AND (status = 'A'::bpchar))