explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vZRk : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.068 49.516 ↑ 1.0 5 1

Bitmap Heap Scan on uzgps_routing_trip_route_station_event (cost=19.31..1,759.39 rows=5 width=92) (actual time=49.487..49.516 rows=5 loops=1)

  • Recheck Cond: (trip_route_station_id = 10001)
  • Filter: (status = 'A'::bpchar)
  • Heap Blocks: exact=2
2. 49.448 49.448 ↑ 183.6 5 1

Bitmap Index Scan on uzgps_routing_trip_route_station_even_trip_route_station_id_idx (cost=0.00..19.30 rows=918 width=0) (actual time=49.448..49.448 rows=5 loops=1)

  • Index Cond: (trip_route_station_id = 10001)