explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHBg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 58,451.614 ↓ 0.0 0 1

Nested Loop (cost=1.28..9,176.69 rows=1 width=198) (actual time=58,451.614..58,451.614 rows=0 loops=1)

2. 0.007 58,451.614 ↓ 0.0 0 1

Nested Loop (cost=0.85..9,175.20 rows=1 width=166) (actual time=58,451.614..58,451.614 rows=0 loops=1)

3. 307.364 58,451.559 ↓ 8.0 8 1

Nested Loop (cost=0.43..9,172.61 rows=1 width=166) (actual time=253.240..58,451.559 rows=8 loops=1)

  • Join Filter: (carrier_contract_lanes.delivery_location_id = delivery.id)
  • Rows Removed by Join Filter: 3,605,028
4. 6.318 6.318 ↓ 1,213.0 1,213 1

Index Scan using index_locations_on_lower_city on locations delivery (cost=0.43..207.58 rows=1 width=4) (actual time=0.023..6.318 rows=1,213 loops=1)

  • Index Cond: (lower((city)::text) = 'reno'::text)
  • Filter: ((state_code)::text = 'NV'::text)
  • Rows Removed by Filter: 50
5. 58,137.877 58,137.877 ↓ 1.5 2,972 1,213

Seq Scan on carrier_contract_lanes (cost=0.00..8,940.53 rows=1,960 width=166) (actual time=0.013..47.929 rows=2,972 loops=1,213)

  • Filter: ((deprecated_at IS NULL) AND ((equipment_id = 3) OR (equipment_id IS NULL)) AND (action_type = 'auto_offer'::text) AND ((creation_source = ANY ('{my_lanes,acceptance_confirmation,manage_lanes,migration}'::text[])) OR ((acti
  • Rows Removed by Filter: 162,422
6. 0.048 0.048 ↓ 0.0 0 8

Index Scan using locations_pkey on locations pickup (cost=0.43..2.58 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=8)

  • Index Cond: (id = carrier_contract_lanes.pickup_location_id)
  • Filter: (((state_code)::text = 'IN'::text) AND (lower((city)::text) = 'plainfield'::text))
  • Rows Removed by Filter: 1
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using carrier_applications_pkey on carrier_applications (cost=0.43..1.48 rows=1 width=4) (never executed)

  • Index Cond: (id = carrier_contract_lanes.carrier_application_id)
  • Heap Fetches: 0
Planning time : 1.519 ms
Execution time : 58,451.730 ms