explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tvW5 : 234

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

Bitmap Heap Scan on uzgps_routing_route_station_event (cost=5.90..383.71 rows=1 width=68) (actual time=0.013..0.013 rows=0 loops=1)

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

Bitmap Index Scan on uzgps_routing_route_station_event_route_station_id_idx (cost=0.00..5.90 rows=214 width=0) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (route_station_id = 42779)