explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o5Te : 23423

Settings
# exclusive inclusive rows x rows loops node
1. 146.879 174.265 ↓ 172.7 71,669 1

Bitmap Heap Scan on uzgps_routing_trip_route_station (cost=11.51..1,645.69 rows=415 width=360) (actual time=31.505..174.265 rows=71,669 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=10822
2. 27.386 27.386 ↓ 172.7 71,669 1

Bitmap Index Scan on uzgps_routing_trip_route_station_status_idx (cost=0.00..11.41 rows=415 width=0) (actual time=27.386..27.386 rows=71,669 loops=1)

  • Index Cond: (status = 'A'::bpchar)