explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gl27 : 234

Settings
# exclusive inclusive rows x rows loops node
1. 4.156 5.382 ↓ 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.263..5.382 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.226 1.226 ↓ 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.226..1.226 rows=8,084 loops=1)

  • Index Cond: (contract_id = 4)