explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qt2A : 234

Settings
# exclusive inclusive rows x rows loops node
1. 3.062 3.988 ↓ 482.9 6,278 1

Bitmap Heap Scan on uzgps_routing_trip_template (cost=56.50..298.92 rows=13 width=128) (actual time=0.967..3.988 rows=6,278 loops=1)

  • Recheck Cond: (time_start > '999999999999'::bigint)
  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1806
  • Heap Blocks: exact=174
2. 0.926 0.926 ↓ 3.0 8,084 1

Bitmap Index Scan on uzgps_routing_trip_template_time_start_idx (cost=0.00..56.49 rows=2,695 width=0) (actual time=0.926..0.926 rows=8,084 loops=1)

  • Index Cond: (time_start > '999999999999'::bigint)