explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7goO : 23234

Settings
# exclusive inclusive rows x rows loops node
1. 1.466 1.855 ↓ 174.4 2,267 1

Bitmap Heap Scan on uzgps_routing_trip (cost=4.38..53.04 rows=13 width=1,160) (actual time=0.464..1.855 rows=2,267 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=351
2. 0.389 0.389 ↓ 174.4 2,267 1

Bitmap Index Scan on uzgps_routing_trip_status_idx (cost=0.00..4.38 rows=13 width=0) (actual time=0.389..0.389 rows=2,267 loops=1)

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