explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SlWS : re

Settings
# exclusive inclusive rows x rows loops node
1. 27.111 44.866 ↓ 199.9 82,964 1

Bitmap Heap Scan on uzgps_routing_trip_station (cost=11.51..1,174.27 rows=415 width=666) (actual time=18.385..44.866 rows=82,964 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=2670
2. 17.755 17.755 ↓ 199.9 82,964 1

Bitmap Index Scan on uzgps_routing_trip_station_status_idx (cost=0.00..11.41 rows=415 width=0) (actual time=17.755..17.755 rows=82,964 loops=1)

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