explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ofQ : 234324

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.090 ↓ 0.0 0 1

Bitmap Heap Scan on uzgps_routing_route_station_event (cost=267.31..940.32 rows=71 width=68) (actual time=0.089..0.090 rows=0 loops=1)

  • Recheck Cond: (route_station_id > 42779)
  • Filter: (status = 'A'::bpchar)
2. 0.087 0.087 ↓ 0.0 0 1

Bitmap Index Scan on uzgps_routing_route_station_event_route_station_id_idx (cost=0.00..267.29 rows=14,267 width=0) (actual time=0.087..0.087 rows=0 loops=1)

  • Index Cond: (route_station_id > 42779)