explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xEb0 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 4.118 5.869 ↓ 6,278.0 6,278 1

Bitmap Heap Scan on uzgps_routing_trip_template (cost=4.58..105.68 rows=1 width=128) (actual time=1.807..5.869 rows=6,278 loops=1)

  • Recheck Cond: (contract_id = 4)
  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1806
  • Heap Blocks: exact=174
2. 1.751 1.751 ↓ 202.1 8,084 1

Bitmap Index Scan on uzgps_routing_trip_template_contract_id_idx (cost=0.00..4.58 rows=40 width=0) (actual time=1.751..1.751 rows=8,084 loops=1)

  • Index Cond: (contract_id = 4)