explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2X7d : 234

Settings
# exclusive inclusive rows x rows loops node
1. 1.724 3.057 ↓ 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.376..3.057 rows=6,278 loops=1)

  • Recheck Cond: (status = 'A'::bpchar)
  • Heap Blocks: exact=139
2. 1.333 1.333 ↓ 156.9 6,278 1

Bitmap Index Scan on uzgps_routing_trip_template_status_idx (cost=0.00..4.58 rows=40 width=0) (actual time=1.333..1.333 rows=6,278 loops=1)

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