explain.depesz.com

PostgreSQL's explain analyze made readable

Result: okf8 : 234

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

  • Recheck Cond: (contract_id = 4)
  • Filter: (status = 'A'::bpchar)
  • Rows Removed by Filter: 1806
  • Heap Blocks: exact=174
2. 0.679 0.679 ↓ 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=0.679..0.679 rows=8,084 loops=1)

  • Index Cond: (contract_id = 4)