explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rWSY : 2234

Settings
# exclusive inclusive rows x rows loops node
1. 2.837 17.112 ↓ 156.9 6,278 1

Bitmap Heap Scan on uzgps_routing_trip_template (cost=4.59..105.59 rows=40 width=128) (actual time=14.331..17.112 rows=6,278 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=139
2. 14.275 14.275 ↓ 157.3 6,293 1

Bitmap Index Scan on uzgps_routing_trip_template_status_time_start_idx (cost=0.00..4.58 rows=40 width=0) (actual time=14.274..14.275 rows=6,293 loops=1)

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