explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1RCu

Settings
# exclusive inclusive rows x rows loops node
1. 0.077 785.983 ↑ 1.0 30 1

Limit (cost=0.29..2,505,996.05 rows=30 width=747) (actual time=23.050..785.983 rows=30 loops=1)

2. 58.919 785.906 ↑ 143.3 30 1

Nested Loop (cost=0.29..359,109,192.83 rows=4,299 width=747) (actual time=23.049..785.906 rows=30 loops=1)

3. 35.355 90.687 ↑ 143.3 30 1

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

  • Join Filter: (l.id = lel.load_id)
  • Rows Removed by Join Filter: 151170
4. 0.462 0.462 ↑ 143.3 30 1

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

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

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

6. 5.284 5.284 ↑ 1.0 5,143 1

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

7. 2.340 2.340 ↑ 1.0 1 30

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

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

SubPlan (for Nested Loop)

9. 4.980 7.170 ↑ 8.0 1 30

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

10. 1.200 1.200 ↑ 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.038..0.040 rows=1 loops=30)

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

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

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

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

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

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

  • Filter: (lel.shipper_business_id = id)
  • Rows Removed by Filter: 202
14. 1.890 1.890 ↑ 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.060..0.063 rows=1 loops=30)

  • Index Cond: (lel.carrier_business_id = id)
15. 576.900 617.580 ↑ 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=3.701..20.586 rows=2 loops=30)

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

SubPlan (for Index Scan)

17. 2.040 10.380 ↑ 1.0 1 60

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

18. 5.400 5.400 ↑ 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=0.089..0.090 rows=1 loops=60)

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

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

  • Index Cond: (id = al.address_id)
20. 16.372 27.780 ↑ 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=0.135..0.463 rows=8 loops=60)

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

SubPlan (for Index Scan)

22. 11.408 11.408 ↑ 1.0 1 496

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

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

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

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

Planning time : 20.898 ms
Execution time : 792.156 ms