explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C1Kf : 234

Settings
# exclusive inclusive rows x rows loops node
1. 1.388 1.695 ↓ 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.378..1.695 rows=2,267 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=351
2. 0.307 0.307 ↓ 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.307..0.307 rows=2,267 loops=1)

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