explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yxEI : 123123

Settings
# exclusive inclusive rows x rows loops node
1. 21.823 34.427 ↓ 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=13.131..34.427 rows=82,964 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=2670
2. 12.604 12.604 ↓ 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=12.604..12.604 rows=82,964 loops=1)

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