explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4vt2

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 1,143.874 ↑ 1.0 30 1

Limit (cost=0.29..2,516,491.09 rows=30 width=747) (actual time=254.743..1,143.874 rows=30 loops=1)

2. 6.204 1,143.807 ↑ 143.3 30 1

Nested Loop (cost=0.29..360,613,131.38 rows=4,299 width=747) (actual time=254.739..1,143.807 rows=30 loops=1)

3. 26.361 92.193 ↑ 143.3 30 1

Nested Loop (cost=0.00..332,220.47 rows=4,299 width=619) (actual time=44.097..92.193 rows=30 loops=1)

  • Join Filter: (l.id = lel.load_id)
  • Rows Removed by Join Filter: 181824
4. 0.128 0.128 ↑ 119.6 43 1

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

5. 60.180 65.704 ↑ 1.0 4,229 43

Materialize (cost=0.00..375.43 rows=4,299 width=32) (actual time=0.950..1.528 rows=4,229 loops=43)

6. 5.524 5.524 ↑ 1.0 4,299 1

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

  • Filter: (shipper_business_id = '2121438735764555001'::bigint)
  • Rows Removed by Filter: 8096
7. 22.320 22.320 ↑ 1.0 1 30

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

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

SubPlan (for Nested Loop)

9. 1.920 208.110 ↑ 8.0 1 30

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

10. 36.090 36.090 ↑ 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=1.201..1.203 rows=1 loops=30)

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

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

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

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

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

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

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

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

  • Filter: (lel.carrier_business_id = id)
  • Rows Removed by Filter: 9610
15. 280.680 735.660 ↑ 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=16.323..24.522 rows=2 loops=30)

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

SubPlan (for Index Scan)

17. 2.820 189.300 ↑ 1.0 1 60

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

18. 182.640 182.640 ↑ 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=3.043..3.044 rows=1 loops=60)

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

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

  • Index Cond: (id = al.address_id)
20. 127.980 262.380 ↑ 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=3.070..4.373 rows=8 loops=60)

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

SubPlan (for Index Scan)

22. 134.400 134.400 ↑ 1.0 1 480

Index Scan using good_pkey on good g (cost=0.42..8.44 rows=1 width=32) (actual time=0.278..0.280 rows=1 loops=480)

  • Index Cond: (c.good_id = id)
23. 3.300 3.300 ↑ 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.055..0.055 rows=1 loops=60)

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

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

Planning time : 45.608 ms
Execution time : 1,156.180 ms