explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pvt6 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 1.235 1.944 ↓ 156.9 6,278 1

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

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

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