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=42648.38..259191.44 rows=78221 width=750) (actual time=.. rows= loops=)

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

Hash Join (cost=42582.46..61171.68 rows=78221 width=741) (actual time=.. rows= loops=)

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

Hash Join (cost=42543.02..60056.70 rows=78221 width=789) (actual time=.. rows= loops=)

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

Hash Join (cost=42442.64..58783.01 rows=78221 width=251) (actual time=.. rows= loops=)

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

Hash Join (cost=42364.30..57629.13 rows=78221 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..12333.08 rows=429908 width=101) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=42031.21..42031.21 rows=26647 width=105) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=36399.73..42031.21 rows=26647 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..4083.54 rows=146454 width=48) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=36139.61..36139.61 rows=20810 width=73) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=22479.10..36139.61 rows=20810 width=73) (actual time=.. rows= loops=)

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

Hash Join (cost=22400.76..35775.13 rows=20810 width=78) (actual time=.. rows= loops=)

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

Hash Join (cost=22396.15..35477.42 rows=22666 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..12282.74 rows=114374 width=48) (actual time=.. rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=22085.89..22085.89 rows=24821 width=100) (actual time=.. rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash Join (cost=15803.96..22085.89 rows=24821 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..5407.48 rows=125248 width=32) (actual time=.. rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=15493.70..15493.70 rows=24821 width=68) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0

Hash Join (cost=9676.77..15493.70 rows=24821 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..4942.48 rows=125248 width=23) (actual time=.. rows= loops=)

21. 0.000 0.000 ↓ 0.0

Hash (cost=9366.51..9366.51 rows=24821 width=45) (actual time=.. rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash Join (cost=6352.15..9366.51 rows=24821 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..2296.47 rows=125247 width=36) (actual time=.. rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=6236.56..6236.56 rows=9247 width=73) (actual time=.. rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash Join (cost=4855.15..6236.56 rows=9247 width=73) (actual time=.. rows= loops=)

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

Hash Join (cost=4783.20..6025.91 rows=9247 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=34549 width=32) (actual time=.. rows= loops=)

28. 0.000 0.000 ↓ 0.0

Hash (cost=4627.09..4627.09 rows=12489 width=40) (actual time=.. rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash Join (cost=431.00..4627.09 rows=12489 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..3604.60 rows=46660 width=24) (actual time=.. rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=274.89..274.89 rows=12489 width=16) (actual time=.. rows= loops=)

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

Hash (cost=50.31..50.31 rows=1731 width=33) (actual time=.. rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on commercialentity (cost=0.00..50.31 rows=1731 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=1989 width=570) (actual time=.. rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3.82..75.52 rows=1989 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=1989 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=1989 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=1774 width=25) (actual time=.. rows= loops=)

61. 0.000 0.000 ↓ 0.0

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