explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JdLW : 234

Settings
# exclusive inclusive rows x rows loops node
1. 2.274 2.581 ↓ 159.3 2,230 1

Bitmap Heap Scan on uzgps_routing_trip_route (cost=4.39..49.19 rows=14 width=786) (actual time=0.341..2.581 rows=2,230 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=93
2. 0.307 0.307 ↓ 159.3 2,230 1

Bitmap Index Scan on uzgps_routing_trip_route_status_idx (cost=0.00..4.39 rows=14 width=0) (actual time=0.307..0.307 rows=2,230 loops=1)

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