explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ueJG

Settings
# exclusive inclusive rows x rows loops node
1. 0.083 1,709.695 ↑ 1.0 30 1

Limit (cost=0.29..2,516,491.10 rows=30 width=747) (actual time=76.869..1,709.695 rows=30 loops=1)

2. 10.345 1,709.612 ↑ 143.3 30 1

Nested Loop (cost=0.29..360,613,133.49 rows=4,299 width=747) (actual time=76.866..1,709.612 rows=30 loops=1)

3. 35.289 136.207 ↑ 143.3 30 1

Nested Loop (cost=0.00..332,222.58 rows=4,299 width=619) (actual time=15.014..136.207 rows=30 loops=1)

  • Join Filter: (l.id = lel.load_id)
  • Rows Removed by Join Filter: 151,170
4. 0.448 0.448 ↑ 143.3 30 1

Seq Scan on load_execution_link lel (cost=0.00..353.94 rows=4,299 width=32) (actual time=0.069..0.448 rows=30 loops=1)

  • Filter: (shipper_business_id = '2121438735764555001'::bigint)
  • Rows Removed by Filter: 126
5. 89.828 100.470 ↑ 1.0 5,040 30

Materialize (cost=0.00..235.15 rows=5,143 width=595) (actual time=0.003..3.349 rows=5,040 loops=30)

6. 10.642 10.642 ↑ 1.0 5,143 1

Seq Scan on load l (cost=0.00..209.43 rows=5,143 width=595) (actual time=0.031..10.642 rows=5,143 loops=1)

7. 245.130 245.130 ↑ 1.0 1 30

Index Scan using vehicle_pkey on vehicle v (cost=0.29..1.83 rows=1 width=528) (actual time=8.166..8.171 rows=1 loops=30)

  • Index Cond: (id = l.vehicle_id)
8.          

SubPlan (for Nested Loop)

9. 2.820 185.550 ↑ 8.0 1 30

Nested Loop Left Join (cost=6.71..699.49 rows=8 width=32) (actual time=6.174..6.185 rows=1 loops=30)

10. 82.710 82.710 ↑ 1.0 1 30

Index Scan using idx_execution_bid_order_id on execution e (cost=0.29..8.30 rows=1 width=32) (actual time=2.753..2.757 rows=1 loops=30)

  • Index Cond: (id = lel.execution_id)
11. 62.040 100.020 ↑ 275.0 1 30

Bitmap Heap Scan on posting p (cost=6.42..688.42 rows=275 width=21) (actual time=3.330..3.334 rows=1 loops=30)

  • Recheck Cond: (id = e.posting_id)
  • Heap Blocks: exact=30
12. 37.980 37.980 ↑ 275.0 1 30

Bitmap Index Scan on idx_posting_id (cost=0.00..6.35 rows=275 width=0) (actual time=1.266..1.266 rows=1 loops=30)

  • Index Cond: (id = e.posting_id)
13. 3.810 3.810 ↓ 0.0 0 30

Seq Scan on shipper_business sb (cost=0.00..6.53 rows=1 width=32) (actual time=0.127..0.127 rows=0 loops=30)

  • Filter: (lel.shipper_business_id = id)
  • Rows Removed by Filter: 202
14. 185.640 185.640 ↑ 1.0 1 30

Seq Scan on carrier_business cb (cost=0.00..358.14 rows=1 width=32) (actual time=1.043..6.188 rows=1 loops=30)

  • Filter: (lel.carrier_business_id = id)
  • Rows Removed by Filter: 9,610
15. 484.740 941.700 ↑ 342.5 2 30

Index Scan using idx_stop_parent on stop s (cost=0.42..82,739.74 rows=685 width=32) (actual time=18.926..31.390 rows=2 loops=30)

  • Index Cond: (l.id = parent_id)
16.          

SubPlan (for Index Scan)

17. 2.880 88.980 ↑ 1.0 1 60

Nested Loop (cost=0.70..16.75 rows=1 width=32) (actual time=1.479..1.483 rows=1 loops=60)

18. 76.920 76.920 ↑ 1.0 1 60

Index Scan using idx_address_link_parent_id_parent_type on address_link al (cost=0.42..8.44 rows=1 width=8) (actual time=1.281..1.282 rows=1 loops=60)

  • Index Cond: (s.id = parent_id)
19. 9.180 9.180 ↑ 1.0 1 60

Index Scan using address_pkey on address a (cost=0.28..8.30 rows=1 width=544) (actual time=0.150..0.153 rows=1 loops=60)

  • Index Cond: (id = al.address_id)
20. 146.392 366.120 ↑ 1.1 8 60

Index Scan using idx_consignment_stop_id on consignment c (cost=0.42..89.01 rows=9 width=32) (actual time=2.507..6.102 rows=8 loops=60)

  • Index Cond: (s.id = stop_id)
21.          

SubPlan (for Index Scan)

22. 219.728 219.728 ↑ 1.0 1 496

Index Scan using good_pkey on good g (cost=0.42..8.44 rows=1 width=32) (actual time=0.434..0.443 rows=1 loops=496)

  • Index Cond: (c.good_id = id)
23. 1.860 1.860 ↑ 1.0 1 60

Index Scan using idx_facility_id_status on facility f (cost=0.29..8.31 rows=1 width=32) (actual time=0.030..0.031 rows=1 loops=60)

  • Index Cond: (s.facility_id = id)
24. 1.230 1.230 ↑ 1.0 1 30

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.041..0.041 rows=1 loops=30)

Planning time : 16.859 ms
Execution time : 1,712.796 ms