explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5WfN

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 386.443 ↑ 1.0 30 1

Limit (cost=0.86..24,931.51 rows=30 width=747) (actual time=22.947..386.443 rows=30 loops=1)

2. 2.868 386.400 ↑ 3,817.5 30 1

Nested Loop (cost=0.86..95,173,581.09 rows=114,526 width=747) (actual time=22.946..386.400 rows=30 loops=1)

3. 0.323 30.372 ↑ 3,817.5 30 1

Nested Loop (cost=0.57..88,066.05 rows=114,526 width=651) (actual time=8.270..30.372 rows=30 loops=1)

  • Join Filter: (lel.load_id = l.id)
4. 0.442 22.819 ↑ 3,937.7 30 1

Nested Loop (cost=0.29..50,546.25 rows=118,132 width=72) (actual time=6.776..22.819 rows=30 loops=1)

5. 9.117 9.117 ↑ 620.0 221 1

Seq Scan on stop s (cost=0.00..6,392.10 rows=137,010 width=40) (actual time=2.055..9.117 rows=221 loops=1)

6. 13.260 13.260 ↓ 0.0 0 221

Index Scan using idx_load_execution_link_load_shipper_business_id on load_execution_link lel (cost=0.29..0.31 rows=1 width=32) (actual time=0.058..0.060 rows=0 loops=221)

  • Index Cond: ((load_id = s.parent_id) AND (shipper_business_id = '2121438735764555001'::bigint))
7. 7.230 7.230 ↑ 1.0 1 30

Index Scan using load_pkey on load l (cost=0.28..0.31 rows=1 width=595) (actual time=0.239..0.241 rows=1 loops=30)

  • Index Cond: (id = s.parent_id)
8. 12.180 12.180 ↑ 1.0 1 30

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

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

SubPlan (for Nested Loop)

10. 1.530 25.140 ↑ 8.0 1 30

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

11. 8.790 8.790 ↑ 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=0.291..0.293 rows=1 loops=30)

  • Index Cond: (id = lel.execution_id)
12. 12.660 14.820 ↑ 275.0 1 30

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

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

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

  • Index Cond: (id = e.posting_id)
14. 1.650 1.650 ↓ 0.0 0 30

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

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

Index Scan using idx_carrier_business_id on carrier_business cb (cost=0.29..8.30 rows=1 width=32) (actual time=0.026..0.027 rows=1 loops=30)

  • Index Cond: (lel.carrier_business_id = id)
16. 4.200 313.080 ↑ 1.0 1 30

Result (cost=114.07..114.08 rows=1 width=32) (actual time=10.434..10.436 rows=1 loops=30)

17.          

Initplan (for Result)

18. 1.380 58.620 ↑ 1.0 1 30

Nested Loop (cost=0.70..16.75 rows=1 width=32) (actual time=1.952..1.954 rows=1 loops=30)

19. 54.960 54.960 ↑ 1.0 1 30

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.831..1.832 rows=1 loops=30)

  • Index Cond: (s.id = parent_id)
20. 2.280 2.280 ↑ 1.0 1 30

Index Scan using address_pkey on address a (cost=0.28..8.30 rows=1 width=544) (actual time=0.075..0.076 rows=1 loops=30)

  • Index Cond: (id = al.address_id)
21. 97.239 247.170 ↑ 1.1 8 30

Index Scan using idx_consignment_stop_id on consignment c (cost=0.42..89.01 rows=9 width=32) (actual time=6.620..8.239 rows=8 loops=30)

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

SubPlan (for Index Scan)

23. 149.931 149.931 ↑ 1.0 1 243

Index Scan using good_pkey on good g (cost=0.42..8.44 rows=1 width=32) (actual time=0.604..0.617 rows=1 loops=243)

  • Index Cond: (c.good_id = id)
24. 3.090 3.090 ↑ 1.0 1 30

Index Scan using idx_facility_id_status on facility f (cost=0.29..8.31 rows=1 width=32) (actual time=0.102..0.103 rows=1 loops=30)

  • Index Cond: (s.facility_id = id)
25. 0.300 0.300 ↑ 1.0 1 30

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

Planning time : 8.011 ms
Execution time : 386.698 ms