explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9caa : 234

Settings
# exclusive inclusive rows x rows loops node
1. 0.087 0.234 ↑ 1.0 5 1

Bitmap Heap Scan on uzgps_routing_trip_route_station_event (cost=4.47..23.84 rows=5 width=92) (actual time=0.188..0.234 rows=5 loops=1)

  • Recheck Cond: ((trip_route_station_id = 10000) AND (status = 'A'::bpchar))
  • Heap Blocks: exact=2
2. 0.147 0.147 ↑ 1.0 5 1

Bitmap Index Scan on uzgps_routing_trip_route_stati_trip_route_station_id_status_idx (cost=0.00..4.47 rows=5 width=0) (actual time=0.147..0.147 rows=5 loops=1)

  • Index Cond: ((trip_route_station_id = 10000) AND (status = 'A'::bpchar))