explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c6P1 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 1.747 3.814 ↓ 482.9 6,278 1

Bitmap Heap Scan on uzgps_routing_trip_template (cost=4.42..46.72 rows=13 width=128) (actual time=2.108..3.814 rows=6,278 loops=1)

  • Recheck Cond: ((status = 'A'::bpchar) AND (time_start > '999999999999'::bigint))
  • Heap Blocks: exact=139
2. 2.067 2.067 ↓ 484.1 6,293 1

Bitmap Index Scan on uzgps_routing_trip_template_status_time_start_idx (cost=0.00..4.41 rows=13 width=0) (actual time=2.067..2.067 rows=6,293 loops=1)

  • Index Cond: ((status = 'A'::bpchar) AND (time_start > '999999999999'::bigint))