explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t5TE

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 19.724 ↑ 1.0 30 1

Limit (cost=1.56..24,454.80 rows=30 width=747) (actual time=0.433..19.724 rows=30 loops=1)

2. 3.530 19.696 ↑ 3,817.5 30 1

Nested Loop (cost=1.56..93,351,050.47 rows=114,526 width=747) (actual time=0.431..19.696 rows=30 loops=1)

3. 0.089 2.216 ↑ 3,817.5 30 1

Nested Loop (cost=1.27..182,414.36 rows=114,526 width=1,187) (actual time=0.090..2.216 rows=30 loops=1)

4. 0.072 1.917 ↑ 3,817.5 30 1

Nested Loop (cost=0.99..146,645.56 rows=114,526 width=659) (actual time=0.082..1.917 rows=30 loops=1)

5. 0.113 1.515 ↑ 3,817.5 30 1

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

  • Join Filter: (lel.load_id = l.id)
6. 0.127 1.162 ↑ 3,937.7 30 1

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

7. 0.151 0.151 ↑ 620.0 221 1

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

8. 0.884 0.884 ↓ 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.004..0.004 rows=0 loops=221)

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

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

  • Index Cond: (id = s.parent_id)
10. 0.330 0.330 ↑ 1.0 1 30

Index Scan using idx_address_link_parent_id on address_link al (cost=0.42..0.50 rows=1 width=16) (actual time=0.010..0.011 rows=1 loops=30)

  • Index Cond: (parent_id = s.id)
11. 0.210 0.210 ↑ 1.0 1 30

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

  • Index Cond: (id = al.address_id)
12. 0.360 0.360 ↑ 1.0 1 30

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

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

SubPlan (for Nested Loop)

14. 0.720 1.350 ↑ 8.0 1 30

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

15. 0.270 0.270 ↑ 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.008..0.009 rows=1 loops=30)

  • Index Cond: (id = lel.execution_id)
16. 0.120 0.360 ↑ 275.0 1 30

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

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

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

  • Index Cond: (id = e.posting_id)
18. 1.080 1.080 ↓ 0.0 0 30

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

  • Filter: (lel.shipper_business_id = id)
  • Rows Removed by Filter: 202
19. 0.570 0.570 ↑ 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.018..0.019 rows=1 loops=30)

  • Index Cond: (lel.carrier_business_id = id)
20. 4.050 10.170 ↑ 1.0 1 30

Result (cost=97.33..97.34 rows=1 width=32) (actual time=0.338..0.339 rows=1 loops=30)

21.          

Initplan (for Result)

22. 0.150 0.150 ↑ 1.0 1 30

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

23. 2.664 5.580 ↑ 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=0.043..0.186 rows=8 loops=30)

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

SubPlan (for Index Scan)

25. 2.916 2.916 ↑ 1.0 1 243

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

  • Index Cond: (c.good_id = id)
26. 0.390 0.390 ↑ 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.013..0.013 rows=1 loops=30)

  • Index Cond: (s.facility_id = id)
27. 0.420 0.420 ↑ 1.0 1 30

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

Planning time : 6.788 ms
Execution time : 20.064 ms