explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mj4w

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 92,092.361 ↑ 25.1 23 1

Append (cost=6,165.14..6,600.87 rows=577 width=32) (actual time=92,089.912..92,092.361 rows=23 loops=1)

2. 92,092.155 92,092.155 ↓ 23.0 23 1

Unique (cost=6,165.14..6,165.15 rows=1 width=32) (actual time=92,089.910..92,092.155 rows=23 loops=1)

3. 92,090.889 92,090.889 ↓ 3,948.0 3,948 1

Sort (cost=6,165.14..6,165.15 rows=1 width=32) (actual time=92,089.909..92,090.889 rows=3,948 loops=1)

4. 92,086.018 92,086.018 ↓ 3,948.0 3,948 1

Nested Loop (cost=1.07..6,165.13 rows=1 width=32) (actual time=28,630.795..92,086.018 rows=3,948 loops=1)

5. 92,026.055 92,026.055 ↓ 987.0 987 1

Nested Loop (cost=1.07..6,161.30 rows=1 width=25) (actual time=28,630.739..92,026.055 rows=987 loops=1)

6. 92,020.711 92,020.711 ↓ 987.0 987 1

Nested Loop (cost=1.07..6,160.21 rows=1 width=32) (actual time=28,630.735..92,020.711 rows=987 loops=1)

7. 92,012.787 92,012.787 ↓ 987.0 987 1

Nested Loop (cost=1.07..6,159.01 rows=1 width=24) (actual time=28,630.728..92,012.787 rows=987 loops=1)

8. 92,000.651 92,000.651 ↓ 987.0 987 1

Nested Loop (cost=1.07..6,157.56 rows=1 width=12) (actual time=28,630.718..92,000.651 rows=987 loops=1)

9. 91,272.212 91,272.212 ↓ 987.0 987 1

Nested Loop (cost=1.07..6,108.37 rows=1 width=4) (actual time=28,630.480..91,272.212 rows=987 loops=1)

10. 356.460 356.460 ↓ 193,906.0 193,906 1

Hash Left Join (cost=1.07..6,078.74 rows=1 width=4) (actual time=0.054..356.460 rows=193,906 loops=1)

11. 173.784 173.784 ↓ 1.1 193,906 1

Seq Scan on orders o (cost=0.00..5,420.18 rows=175,305 width=8) (actual time=0.024..173.784 rows=193,906 loops=1)

12. 0.012 0.012 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=5) (actual time=0.012..0.012 rows=3 loops=1)

13. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on subcontracted_skips ss (cost=0.00..1.03 rows=3 width=5) (actual time=0.003..0.004 rows=3 loops=1)

14. 43,047.132 43,047.132 ↑ 1.0 987 193,906

Seq Scan on containers_on_site cos (cost=0.00..17.06 rows=1,006 width=8) (actual time=0.005..0.222 rows=987 loops=193,906)

15. 322.749 322.749 ↑ 1.0 1,653 987

Seq Scan on containers (cost=0.00..28.53 rows=1,653 width=16) (actual time=0.003..0.327 rows=1,653 loops=987)

16. 4.935 4.935 ↑ 1.0 18 987

Seq Scan on container_sizes (cost=0.00..1.18 rows=18 width=12) (actual time=0.001..0.005 rows=18 loops=987)

17. 2.961 2.961 ↑ 1.0 8 987

Seq Scan on container_types (cost=0.00..1.08 rows=8 width=16) (actual time=0.001..0.003 rows=8 loops=987)

18. 1.974 1.974 ↑ 1.0 4 987

Seq Scan on container_classes (cost=0.00..1.04 rows=4 width=9) (actual time=0.001..0.002 rows=4 loops=987)

19. 30.597 30.597 ↑ 1.0 70 987

Seq Scan on vehicle_type_accepts vta (cost=0.00..2.94 rows=70 width=4) (actual time=0.003..0.031 rows=70 loops=987)

20. 0.194 0.194 ↓ 0.0 0 1

HashAggregate (cost=415.55..429.95 rows=576 width=32) (actual time=0.194..0.194 rows=0 loops=1)

21. 0.189 0.189 ↓ 0.0 0 1

Hash Join (cost=107.20..397.66 rows=7,158 width=32) (actual time=0.189..0.189 rows=0 loops=1)

22. 0.004 0.004 ↓ 0.0 0 1

Hash Join (cost=100.87..184.75 rows=1,841 width=29) (actual time=0.004..0.004 rows=0 loops=1)

23. 0.003 0.003 ↓ 0.0 0 1

Hash Left Join (cost=20.35..78.91 rows=1,841 width=4) (actual time=0.003..0.003 rows=0 loops=1)

24. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bins_on_site bs (cost=0.00..28.50 rows=1,850 width=8) (actual time=0.002..0.002 rows=0 loops=1)

25. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.60..14.60 rows=460 width=36) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on bin_contract_containers (cost=0.00..14.60 rows=460 width=36) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=59.86..59.86 rows=1,653 width=33) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=2.40..59.86 rows=1,653 width=33) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on containers containers_1 (cost=0.00..28.53 rows=1,653 width=16) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Hash (cost=2.28..2.28 rows=8 width=25) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=1.09..2.28 rows=8 width=25) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_types container_types_1 (cost=0.00..1.08 rows=8 width=16) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.04..1.04 rows=4 width=9) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on container_classes container_classes_1 (cost=0.00..1.04 rows=4 width=9) (never executed)

35. 0.172 0.172 ↑ 1.0 68 1

Hash (cost=5.29..5.29 rows=70 width=16) (actual time=0.172..0.172 rows=68 loops=1)

36. 0.136 0.136 ↑ 1.0 68 1

Hash Join (cost=1.41..5.29 rows=70 width=16) (actual time=0.054..0.136 rows=68 loops=1)

37. 0.046 0.046 ↑ 1.0 70 1

Seq Scan on vehicle_type_accepts vta_1 (cost=0.00..2.94 rows=70 width=4) (actual time=0.009..0.046 rows=70 loops=1)

38. 0.027 0.027 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=12) (actual time=0.027..0.027 rows=18 loops=1)

39. 0.011 0.011 ↑ 1.0 18 1

Seq Scan on container_sizes container_sizes_1 (cost=0.00..1.18 rows=18 width=12) (actual time=0.004..0.011 rows=18 loops=1)