explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iao6 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 1.537 2.100 ↓ 174.4 2,267 1

Bitmap Heap Scan on uzgps_routing_trip (cost=72.09..120.75 rows=13 width=1,160) (actual time=0.651..2.100 rows=2,267 loops=1)

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

Bitmap Index Scan on uzgps_routing_trip_trip_template_id_status_idx (cost=0.00..72.09 rows=13 width=0) (actual time=0.563..0.563 rows=2,267 loops=1)

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