explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DMEW : 234234

Settings
# exclusive inclusive rows x rows loops node
1. 2.116 3.432 ↓ 156.9 6,278 1

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

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=139
2. 1.316 1.316 ↓ 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=1.316..1.316 rows=6,293 loops=1)

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