explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Q3W

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=42,648.38..259,191.44 rows=78,221 width=750) (actual time=.. rows= loops=)

  • Hash Cond: (wors.productionbatch_id = pb.id)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,582.46..61,171.68 rows=78,221 width=741) (actual time=.. rows= loops=)

  • Hash Cond: (public.product.id = public.product.id)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,543.02..60,056.70 rows=78,221 width=789) (actual time=.. rows= loops=)

  • Hash Cond: (wod.quantitygroupmeasure_id = groupmeasure.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,442.64..58,783.01 rows=78,221 width=251) (actual time=.. rows= loops=)

  • Hash Cond: (wod.inventoryproduct_id = public.product.id)
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,364.30..57,629.13 rows=78,221 width=174) (actual time=.. rows= loops=)

  • Hash Cond: (wod.workorderroutingstep_id = wors.id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on workorderdetail wod (cost=0.00..12,333.08 rows=429,908 width=101) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=42,031.21..42,031.21 rows=26,647 width=105) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=36,399.73..42,031.21 rows=26,647 width=105) (actual time=.. rows= loops=)

  • Hash Cond: (wors.workorder_id = parentwo.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on workorderroutingstep wors (cost=0.00..4,083.54 rows=146,454 width=48) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=36,139.61..36,139.61 rows=20,810 width=73) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,479.10..36,139.61 rows=20,810 width=73) (actual time=.. rows= loops=)

  • Hash Cond: (parentwo.fabricationproduct_id = public.product.id)
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,400.76..35,775.13 rows=20,810 width=78) (actual time=.. rows= loops=)

  • Hash Cond: (exploditem.productquicklibrary_id = productqcode.id)
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=22,396.15..35,477.42 rows=22,666 width=84) (actual time=.. rows= loops=)

  • Hash Cond: (parentwo.explodableitem_id = std.id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on workorder parentwo (cost=0.00..12,282.74 rows=114,374 width=48) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=22,085.89..22,085.89 rows=24,821 width=100) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=15,803.96..22,085.89 rows=24,821 width=100) (actual time=.. rows= loops=)

  • Hash Cond: (exploditem.id = std.id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on explodableitem exploditem (cost=0.00..5,407.48 rows=125,248 width=32) (actual time=.. rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=15,493.70..15,493.70 rows=24,821 width=68) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=9,676.77..15,493.70 rows=24,821 width=68) (actual time=.. rows= loops=)

  • Hash Cond: (td.id = std.id)
20. 0.000 0.000 ↓ 0.0

Seq Scan on transactiondetail td (cost=0.00..4,942.48 rows=125,248 width=23) (actual time=.. rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=9,366.51..9,366.51 rows=24,821 width=45) (actual time=.. rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,352.15..9,366.51 rows=24,821 width=45) (actual time=.. rows= loops=)

  • Hash Cond: (std.saletransaction_id = document.id)
23. 0.000 0.000 ↓ 0.0

Seq Scan on saletransactiondetail std (cost=0.00..2,296.47 rows=125,247 width=36) (actual time=.. rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=6,236.56..6,236.56 rows=9,247 width=73) (actual time=.. rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,855.15..6,236.56 rows=9,247 width=73) (actual time=.. rows= loops=)

  • Hash Cond: (st.customer_id = commercialentity.id)
26. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,783.20..6,025.91 rows=9,247 width=72) (actual time=.. rows= loops=)

  • Hash Cond: (st.id = document.id)
27. 0.000 0.000 ↓ 0.0

Seq Scan on saletransaction st (cost=0.00..977.49 rows=34,549 width=32) (actual time=.. rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=4,627.09..4,627.09 rows=12,489 width=40) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash Join (cost=431.00..4,627.09 rows=12,489 width=40) (actual time=.. rows= loops=)

  • Hash Cond: (document.id = orders.id)
30. 0.000 0.000 ↓ 0.0

Seq Scan on document (cost=0.00..3,604.60 rows=46,660 width=24) (actual time=.. rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=274.89..274.89 rows=12,489 width=16) (actual time=.. rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on orders (cost=0.00..274.89 rows=12,489 width=16) (actual time=.. rows= loops=)

33. 0.000 0.000 ↓ 0.0

Hash (cost=50.31..50.31 rows=1,731 width=33) (actual time=.. rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on commercialentity (cost=0.00..50.31 rows=1,731 width=33) (actual time=.. rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash (cost=3.16..3.16 rows=116 width=26) (actual time=.. rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on productquicklibrary productqcode (cost=0.00..3.16 rows=116 width=26) (actual time=.. rows= loops=)

37. 0.000 0.000 ↓ 0.0

Hash (cost=71.43..71.43 rows=553 width=43) (actual time=.. rows= loops=)

38. 0.000 0.000 ↓ 0.0

Hash Join (cost=30.60..71.43 rows=553 width=43) (actual time=.. rows= loops=)

  • Hash Cond: (public.product.id = public.productdescription.product_id)
39. 0.000 0.000 ↓ 0.0

Seq Scan on product (cost=0.00..32.53 rows=553 width=27) (actual time=.. rows= loops=)

40. 0.000 0.000 ↓ 0.0

Hash (cost=23.69..23.69 rows=553 width=16) (actual time=.. rows= loops=)

41. 0.000 0.000 ↓ 0.0

Seq Scan on productdescription (cost=0.00..23.69 rows=553 width=16) (actual time=.. rows= loops=)

  • Filter: ((languagecode)::text = 'en'::text)
42. 0.000 0.000 ↓ 0.0

Hash (cost=71.43..71.43 rows=553 width=77) (actual time=.. rows= loops=)

43. 0.000 0.000 ↓ 0.0

Hash Join (cost=30.60..71.43 rows=553 width=77) (actual time=.. rows= loops=)

  • Hash Cond: (public.product.id = public.productdescription.product_id)
44. 0.000 0.000 ↓ 0.0

Seq Scan on product (cost=0.00..32.53 rows=553 width=27) (actual time=.. rows= loops=)

45. 0.000 0.000 ↓ 0.0

Hash (cost=23.69..23.69 rows=553 width=50) (actual time=.. rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on productdescription (cost=0.00..23.69 rows=553 width=50) (actual time=.. rows= loops=)

  • Filter: ((languagecode)::text = 'en'::text)
47. 0.000 0.000 ↓ 0.0

Hash (cost=75.52..75.52 rows=1,989 width=570) (actual time=.. rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3.82..75.52 rows=1,989 width=570) (actual time=.. rows= loops=)

  • Hash Cond: (groupmeasure.measureunitmultiplier_id = measureunitmultiplier.id)
49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2.53..51.91 rows=1,989 width=548) (actual time=.. rows= loops=)

  • Hash Cond: (groupmeasure.regroupingunit_id = regroupingunit.id)
50. 0.000 0.000 ↓ 0.0

Seq Scan on groupmeasure (cost=0.00..36.89 rows=1,989 width=48) (actual time=.. rows= loops=)

51. 0.000 0.000 ↓ 0.0

Hash (cost=2.36..2.36 rows=13 width=532) (actual time=.. rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.18..2.36 rows=13 width=532) (actual time=.. rows= loops=)

  • Hash Cond: (regroupingunit.id = regroupingunitdescription.regroupingunit_id)
53. 0.000 0.000 ↓ 0.0

Seq Scan on regroupingunit (cost=0.00..1.13 rows=13 width=16) (actual time=.. rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=1.16..1.16 rows=1 width=532) (actual time=.. rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on regroupingunitdescription (cost=0.00..1.16 rows=1 width=532) (actual time=.. rows= loops=)

  • Filter: ((languagecode)::text = 'en'::text)
56. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=13 width=54) (actual time=.. rows= loops=)

57. 0.000 0.000 ↓ 0.0

Seq Scan on measureunitmultiplier (cost=0.00..1.13 rows=13 width=54) (actual time=.. rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=32.53..32.53 rows=553 width=16) (actual time=.. rows= loops=)

59. 0.000 0.000 ↓ 0.0

Seq Scan on product (cost=0.00..32.53 rows=553 width=16) (actual time=.. rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash (cost=43.74..43.74 rows=1,774 width=25) (actual time=.. rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on productionbatch pb (cost=0.00..43.74 rows=1,774 width=25) (actual time=.. rows= loops=)