explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 12zA

Settings
# exclusive inclusive rows x rows loops node
1. 6.693 97,374.606 ↑ 1.4 42 1

Hash Left Join (cost=181,569.66..2,498,185.62 rows=58 width=7,473) (actual time=11,468.937..97,374.606 rows=42 loops=1)

  • Hash Cond: (qi.status = qits.itemstatusid)
2. 0.317 10,204.172 ↑ 1.4 42 1

Nested Loop Left Join (cost=181,568.55..187,412.09 rows=58 width=10,189) (actual time=10,185.536..10,204.172 rows=42 loops=1)

3. 0.286 10,202.595 ↓ 1.4 42 1

Nested Loop Left Join (cost=181,568.13..186,598.05 rows=29 width=9,971) (actual time=10,185.496..10,202.595 rows=42 loops=1)

4. 0.290 10,201.133 ↓ 1.4 42 1

Hash Left Join (cost=181,567.84..186,586.13 rows=29 width=8,939) (actual time=10,185.459..10,201.133 rows=42 loops=1)

  • Hash Cond: (q.status = qs.quotationstatusid)
5. 0.251 10,200.781 ↓ 1.4 42 1

Nested Loop Left Join (cost=181,566.30..186,584.45 rows=29 width=8,721) (actual time=10,185.373..10,200.781 rows=42 loops=1)

6. 0.292 10,200.488 ↓ 1.4 42 1

Nested Loop Left Join (cost=181,566.15..186,579.42 rows=29 width=8,721) (actual time=10,185.365..10,200.488 rows=42 loops=1)

7. 0.299 10,199.692 ↓ 1.4 42 1

Hash Join (cost=181,566.01..186,574.41 rows=29 width=8,721) (actual time=10,185.348..10,199.692 rows=42 loops=1)

  • Hash Cond: (sbd.status = ps.productstatusid)
8. 0.582 10,199.274 ↑ 23.3 48 1

Nested Loop Left Join (cost=181,564.52..186,568.66 rows=1,119 width=8,503) (actual time=10,185.202..10,199.274 rows=48 loops=1)

9. 7.389 10,197.684 ↑ 23.3 48 1

Nested Loop Left Join (cost=181,564.23..186,152.21 rows=1,119 width=8,483) (actual time=10,185.170..10,197.684 rows=48 loops=1)

10. 168.790 10,188.135 ↑ 23.3 48 1

Hash Right Join (cost=181,563.94..185,748.31 rows=1,119 width=8,463) (actual time=10,184.124..10,188.135 rows=48 loops=1)

  • Hash Cond: (q.productid = pd.productid)
11. 148.276 148.276 ↓ 1.0 101,835 1

Seq Scan on quotation q (cost=0.00..3,791.31 rows=101,831 width=101) (actual time=0.019..148.276 rows=101,835 loops=1)

12. 0.090 9,871.069 ↑ 17.4 17 1

Hash (cost=181,560.26..181,560.26 rows=295 width=8,382) (actual time=9,871.068..9,871.069 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
13. 0.108 9,870.979 ↑ 17.4 17 1

Hash Left Join (cost=150,637.08..181,560.26 rows=295 width=8,382) (actual time=9,551.732..9,870.979 rows=17 loops=1)

  • Hash Cond: ((pd.seasonclient = sc.seasonclientid) AND (pd.client = sc.clientid))
14. 0.132 9,869.829 ↑ 17.4 17 1

Nested Loop Left Join (cost=150,616.31..181,537.26 rows=295 width=8,402) (actual time=9,550.666..9,869.829 rows=17 loops=1)

15. 20.847 9,869.374 ↑ 17.4 17 1

Nested Loop (cost=150,616.02..181,437.96 rows=295 width=8,294) (actual time=9,550.605..9,869.374 rows=17 loops=1)

  • Join Filter: (pd.client = c.clientid)
  • Rows Removed by Join Filter: 26836
16. 0.033 0.033 ↑ 1.0 1 1

Index Only Scan using ixclient90 on dbclient c (cost=0.14..12.83 rows=1 width=20) (actual time=0.028..0.033 rows=1 loops=1)

  • Index Cond: (companyshort = 'SVH'::text)
  • Heap Fetches: 1
17. 78.519 9,848.494 ↑ 1.0 26,853 1

Hash Left Join (cost=150,615.88..181,089.45 rows=26,854 width=8,274) (actual time=9,405.991..9,848.494 rows=26,853 loops=1)

  • Hash Cond: (sbd.sustainability = sa.sustainabilityid)
18. 117.413 9,769.931 ↑ 1.0 26,853 1

Hash Left Join (cost=150,614.48..180,963.17 rows=26,854 width=8,076) (actual time=9,405.937..9,769.931 rows=26,853 loops=1)

  • Hash Cond: (md.shellweightunit = swu.weightunitid)
19. 201.873 9,652.466 ↑ 1.0 26,853 1

Hash Right Join (cost=150,612.98..180,831.44 rows=26,854 width=7,878) (actual time=9,405.863..9,652.466 rows=26,853 loops=1)

  • Hash Cond: (md.productid = pd.productid)
20. 45.069 45.069 ↓ 1.0 26,841 1

Seq Scan on materialdetails md (cost=0.00..636.39 rows=26,839 width=854) (actual time=0.020..45.069 rows=26,841 loops=1)

21. 164.789 9,405.524 ↑ 1.0 26,853 1

Hash (cost=126,832.31..126,832.31 rows=26,854 width=7,124) (actual time=9,405.523..9,405.524 rows=26,853 loops=1)

  • Buckets: 1024 Batches: 64 Memory Usage: 136kB
22. 106.581 9,240.735 ↑ 1.0 26,853 1

Hash Left Join (cost=58,975.11..126,832.31 rows=26,854 width=7,124) (actual time=5,752.281..9,240.735 rows=26,853 loops=1)

  • Hash Cond: (sbd.packaging = packaging.packagingid)
23. 85.431 9,134.082 ↑ 1.0 26,853 1

Hash Left Join (cost=58,973.32..126,682.83 rows=26,854 width=7,112) (actual time=5,752.195..9,134.082 rows=26,853 loops=1)

  • Hash Cond: (sbd.wittmkz = mkz.smmkzid)
24. 145.560 9,048.192 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,964.25..126,304.51 rows=26,854 width=6,378) (actual time=5,751.706..9,048.192 rows=26,853 loops=1)

25. 113.269 8,634.102 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.96..115,610.36 rows=26,854 width=5,830) (actual time=5,751.683..8,634.102 rows=26,853 loops=1)

26. 170.143 8,252.303 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.67..104,916.22 rows=26,854 width=5,282) (actual time=5,751.678..8,252.303 rows=26,853 loops=1)

27. 73.791 7,894.189 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.38..94,222.07 rows=26,854 width=4,734) (actual time=5,751.670..7,894.189 rows=26,853 loops=1)

28. 194.684 7,793.545 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.09..83,527.93 rows=26,854 width=4,206) (actual time=5,751.663..7,793.545 rows=26,853 loops=1)

29. 114.145 7,357.184 ↑ 1.0 26,853 1

Hash Left Join (cost=58,962.80..72,833.78 rows=26,854 width=3,658) (actual time=5,751.599..7,357.184 rows=26,853 loops=1)

  • Hash Cond: (pd.productid = sr.productid)
30. 100.689 1,492.458 ↑ 1.0 26,853 1

Hash Left Join (cost=19.06..13,789.33 rows=26,854 width=3,626) (actual time=0.984..1,492.458 rows=26,853 loops=1)

  • Hash Cond: (sbd.calculationsizeoption = calculationsizeoption.calculationsizeoptionid)
31. 58.437 1,391.726 ↑ 1.0 26,853 1

Hash Left Join (cost=17.70..13,665.79 rows=26,854 width=3,428) (actual time=0.925..1,391.726 rows=26,853 loops=1)

  • Hash Cond: (sbd.subbrandcategory = subbrandcategory.subbrandcategoryid)
32. 110.453 1,333.252 ↑ 1.0 26,853 1

Hash Left Join (cost=16.52..13,553.17 rows=26,854 width=3,416) (actual time=0.868..1,333.252 rows=26,853 loops=1)

  • Hash Cond: (sbd.styleorigin = styleorigin.styleoriginid)
33. 88.540 1,222.755 ↑ 1.0 26,853 1

Hash Left Join (cost=15.23..13,433.71 rows=26,854 width=3,404) (actual time=0.806..1,222.755 rows=26,853 loops=1)

  • Hash Cond: (sbd.assortment = assortment.assortmentid)
34. 51.257 1,134.194 ↑ 1.0 26,853 1

Hash Left Join (cost=14.18..13,329.28 rows=26,854 width=3,392) (actual time=0.770..1,134.194 rows=26,853 loops=1)

  • Hash Cond: (sbd.seasonname = seasonname.seasonnameid)
35. 76.677 1,082.878 ↑ 1.0 26,853 1

Hash Left Join (cost=12.73..13,200.27 rows=26,854 width=3,162) (actual time=0.697..1,082.878 rows=26,853 loops=1)

  • Hash Cond: (sbd.bodyshapetype = bodyshapetype.bodyshapetypeid)
36. 55.306 1,006.130 ↑ 1.0 26,853 1

Hash Left Join (cost=11.01..13,054.88 rows=26,854 width=3,150) (actual time=0.607..1,006.130 rows=26,853 loops=1)

  • Hash Cond: (sbd.subbrand = subbrand.subbrandid)
37. 103.787 950.802 ↑ 1.0 26,853 1

Hash Left Join (cost=9.99..12,951.82 rows=26,854 width=3,138) (actual time=0.569..950.802 rows=26,853 loops=1)

  • Hash Cond: ((sbd.package)::text = (packageoption.packageoptionid)::text)
38. 107.241 846.988 ↑ 1.0 26,853 1

Hash Left Join (cost=8.90..12,777.52 rows=26,854 width=3,138) (actual time=0.523..846.988 rows=26,853 loops=1)

  • Hash Cond: (sbd.fashionlevel = fashionlevel.fashionlevelid)
39. 52.214 739.721 ↑ 1.0 26,853 1

Hash Left Join (cost=7.79..12,668.99 rows=26,854 width=3,126) (actual time=0.479..739.721 rows=26,853 loops=1)

  • Hash Cond: (sbd.tactemplate = template.templateid)
40. 59.529 687.420 ↑ 1.0 26,853 1

Hash Left Join (cost=5.87..12,511.32 rows=26,854 width=2,928) (actual time=0.375..687.420 rows=26,853 loops=1)

  • Hash Cond: (sbd.genre = genre.genreid)
41. 174.746 627.594 ↑ 1.0 26,853 1

Nested Loop (cost=0.29..12,191.55 rows=26,854 width=2,710) (actual time=0.056..627.594 rows=26,853 loops=1)

42. 76.906 76.906 ↑ 1.0 26,853 1

Seq Scan on sourcerbriefingdetails sbd (cost=0.00..1,196.54 rows=26,854 width=1,710) (actual time=0.013..76.906 rows=26,853 loops=1)

43. 375.942 375.942 ↑ 1.0 1 26,853

Index Scan using pk_product on product pd (cost=0.29..0.40 rows=1 width=1,040) (actual time=0.012..0.014 rows=1 loops=26,853)

  • Index Cond: (productid = sbd.productid)
44. 0.179 0.297 ↑ 1.0 159 1

Hash (cost=3.59..3.59 rows=159 width=238) (actual time=0.297..0.297 rows=159 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
45. 0.118 0.118 ↑ 1.0 159 1

Seq Scan on genre (cost=0.00..3.59 rows=159 width=238) (actual time=0.015..0.118 rows=159 loops=1)

46. 0.046 0.087 ↑ 1.0 41 1

Hash (cost=1.41..1.41 rows=41 width=238) (actual time=0.087..0.087 rows=41 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
47. 0.041 0.041 ↑ 1.0 41 1

Seq Scan on template (cost=0.00..1.41 rows=41 width=238) (actual time=0.013..0.041 rows=41 loops=1)

48. 0.011 0.026 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=52) (actual time=0.025..0.026 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
49. 0.015 0.015 ↑ 1.0 5 1

Seq Scan on fashionlevel (cost=0.00..1.05 rows=5 width=52) (actual time=0.010..0.015 rows=5 loops=1)

50. 0.015 0.027 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=238) (actual time=0.026..0.027 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
51. 0.012 0.012 ↑ 1.0 4 1

Seq Scan on packageoption (cost=0.00..1.04 rows=4 width=238) (actual time=0.010..0.012 rows=4 loops=1)

52. 0.009 0.022 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=52) (actual time=0.022..0.022 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
53. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on subbrand (cost=0.00..1.01 rows=1 width=52) (actual time=0.011..0.013 rows=1 loops=1)

54. 0.037 0.071 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=52) (actual time=0.071..0.071 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
55. 0.034 0.034 ↑ 1.0 32 1

Seq Scan on bodyshapetype (cost=0.00..1.32 rows=32 width=52) (actual time=0.012..0.034 rows=32 loops=1)

56. 0.031 0.059 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=270) (actual time=0.058..0.059 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
57. 0.028 0.028 ↑ 1.0 20 1

Seq Scan on seasonname (cost=0.00..1.20 rows=20 width=270) (actual time=0.014..0.028 rows=20 loops=1)

58. 0.007 0.021 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=52) (actual time=0.020..0.021 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
59. 0.014 0.014 ↑ 1.0 2 1

Seq Scan on assortment (cost=0.00..1.02 rows=2 width=52) (actual time=0.011..0.014 rows=2 loops=1)

60. 0.022 0.044 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=52) (actual time=0.044..0.044 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
61. 0.022 0.022 ↑ 1.0 13 1

Seq Scan on styleorigin (cost=0.00..1.13 rows=13 width=52) (actual time=0.012..0.022 rows=13 loops=1)

62. 0.017 0.037 ↓ 1.6 13 1

Hash (cost=1.08..1.08 rows=8 width=52) (actual time=0.037..0.037 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
63. 0.020 0.020 ↓ 1.6 13 1

Seq Scan on subbrandcategory (cost=0.00..1.08 rows=8 width=52) (actual time=0.011..0.020 rows=13 loops=1)

64. 0.021 0.043 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=238) (actual time=0.042..0.043 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
65. 0.022 0.022 ↑ 1.0 16 1

Seq Scan on calculationsizeoption (cost=0.00..1.16 rows=16 width=238) (actual time=0.010..0.022 rows=16 loops=1)

66. 5.261 5,750.581 ↓ 5,834.0 5,834 1

Hash (cost=58,943.72..58,943.72 rows=1 width=52) (actual time=5,750.581..5,750.581 rows=5,834 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 345kB
67. 6.763 5,745.320 ↓ 5,834.0 5,834 1

Subquery Scan on sr (cost=58,943.67..58,943.72 rows=1 width=52) (actual time=5,704.662..5,745.320 rows=5,834 loops=1)

68. 11.460 5,738.557 ↓ 5,834.0 5,834 1

GroupAggregate (cost=58,943.67..58,943.71 rows=1 width=52) (actual time=5,704.660..5,738.557 rows=5,834 loops=1)

  • Group Key: p.productid
69. 14.444 5,727.097 ↓ 6,176.0 6,176 1

Unique (cost=58,943.67..58,943.69 rows=1 width=170) (actual time=5,704.634..5,727.097 rows=6,176 loops=1)

70. 23.895 5,712.653 ↓ 12,725.0 12,725 1

Sort (cost=58,943.67..58,943.68 rows=1 width=170) (actual time=5,704.631..5,712.653 rows=12,725 loops=1)

  • Sort Key: p.productid, isz.sizerangecode, (CASE WHEN (((isz0.dim2)::text || (isz0.dim1)::text) = ((isz1.dim2)::text || (isz1.dim1)::text)) THEN ((isz0.dim2)::text || (isz0.dim1)::text) ELSE (((((isz0.dim2)::text || (isz0.dim1)::text) || '-'::text) || (isz1.dim2)::text) || (isz1.dim1)::text) END)
  • Sort Method: quicksort Memory: 1350kB
71. 598.992 5,688.758 ↓ 12,725.0 12,725 1

Merge Join (cost=55,981.20..58,943.66 rows=1 width=170) (actual time=4,519.352..5,688.758 rows=12,725 loops=1)

  • Merge Cond: ((p.productid = i.productid) AND ((isz.sizerangecode)::text = (isz0.sizerangecode)::text))
  • Join Filter: ((isz0.sortkeyinrange = (min(isz.sortkeyinrange))) AND (isz1.sortkeyinrange = (max(isz.sortkeyinrange))))
  • Rows Removed by Join Filter: 552761
72. 86.989 1,281.741 ↑ 12.6 6,212 1

GroupAggregate (cost=22,624.15..24,385.83 rows=78,297 width=146) (actual time=1,135.983..1,281.741 rows=6,212 loops=1)

  • Group Key: p.productid, isz.sizerangecode
73. 300.069 1,194.752 ↓ 1.0 78,300 1

Sort (cost=22,624.15..22,819.89 rows=78,297 width=142) (actual time=1,135.942..1,194.752 rows=78,300 loops=1)

  • Sort Key: p.productid, isz.sizerangecode
  • Sort Method: external merge Disk: 1992kB
74. 275.188 894.683 ↓ 1.0 78,300 1

Hash Join (cost=4,335.35..10,638.91 rows=78,297 width=142) (actual time=468.725..894.683 rows=78,300 loops=1)

  • Hash Cond: (isz.itemid = i_1.itemid)
75. 151.196 151.196 ↓ 1.0 78,300 1

Seq Scan on itemsize isz (cost=0.00..1,613.97 rows=78,297 width=142) (actual time=0.014..151.196 rows=78,300 loops=1)

76. 116.694 468.299 ↑ 1.0 51,266 1

Hash (cost=3,292.90..3,292.90 rows=51,316 width=40) (actual time=468.299..468.299 rows=51,266 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1761kB
77. 184.459 351.605 ↑ 1.0 51,266 1

Hash Join (cost=1,133.15..3,292.90 rows=51,316 width=40) (actual time=97.458..351.605 rows=51,266 loops=1)

  • Hash Cond: (i_1.productid = p.productid)
78. 69.916 69.916 ↑ 1.0 51,266 1

Seq Scan on item i_1 (cost=0.00..1,454.16 rows=51,316 width=40) (actual time=0.014..69.916 rows=51,266 loops=1)

79. 49.302 97.230 ↓ 1.0 26,853 1

Hash (cost=797.51..797.51 rows=26,851 width=20) (actual time=97.229..97.230 rows=26,853 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1332kB
80. 47.928 47.928 ↓ 1.0 26,853 1

Seq Scan on product p (cost=0.00..797.51 rows=26,851 width=20) (actual time=0.011..47.928 rows=26,853 loops=1)

81. 2,546.994 3,808.025 ↓ 947.2 565,486 1

Sort (cost=33,357.06..33,358.55 rows=597 width=736) (actual time=3,383.303..3,808.025 rows=565,486 loops=1)

  • Sort Key: i.productid, isz0.sizerangecode
  • Sort Method: external sort Disk: 26712kB
82. 787.597 1,261.031 ↓ 947.2 565,486 1

Hash Join (cost=18,844.62..33,329.53 rows=597 width=736) (actual time=405.409..1,261.031 rows=565,486 loops=1)

  • Hash Cond: ((isz0.itemid = i.itemid) AND ((isz0.sizerangecode)::text = (isz1.sizerangecode)::text))
83. 68.423 68.423 ↓ 1.0 78,300 1

Seq Scan on itemsize isz0 (cost=0.00..1,613.97 rows=78,297 width=378) (actual time=0.019..68.423 rows=78,300 loops=1)

84. 90.964 405.011 ↓ 1.0 78,300 1

Hash (cost=13,388.16..13,388.16 rows=78,297 width=418) (actual time=405.010..405.011 rows=78,300 loops=1)

  • Buckets: 16384 Batches: 16 Memory Usage: 499kB
85. 161.101 314.047 ↓ 1.0 78,300 1

Hash Join (cost=2,496.61..13,388.16 rows=78,297 width=418) (actual time=88.943..314.047 rows=78,300 loops=1)

  • Hash Cond: (isz1.itemid = i.itemid)
86. 64.127 64.127 ↓ 1.0 78,300 1

Seq Scan on itemsize isz1 (cost=0.00..1,613.97 rows=78,297 width=378) (actual time=0.007..64.127 rows=78,300 loops=1)

87. 48.491 88.819 ↑ 1.0 51,266 1

Hash (cost=1,454.16..1,454.16 rows=51,316 width=40) (actual time=88.819..88.819 rows=51,266 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1761kB
88. 40.328 40.328 ↑ 1.0 51,266 1

Seq Scan on item i (cost=0.00..1,454.16 rows=51,316 width=40) (actual time=0.014..40.328 rows=51,266 loops=1)

89. 241.677 241.677 ↑ 1.0 1 26,853

Index Scan using pk_ldpsrmppng on dbldapusermapping creativebuyer (cost=0.29..0.39 rows=1 width=568) (actual time=0.008..0.009 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.creativebuyer)
90. 26.853 26.853 ↓ 0.0 0 26,853

Index Scan using pk_ldpsrmppng on dbldapusermapping designer (cost=0.29..0.39 rows=1 width=568) (actual time=0.001..0.001 rows=0 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.designer)
91. 187.971 187.971 ↑ 1.0 1 26,853

Index Scan using pk_ldpsrmppng on dbldapusermapping development (cost=0.29..0.39 rows=1 width=568) (actual time=0.006..0.007 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.qa)
92. 268.530 268.530 ↑ 1.0 1 26,853

Index Scan using pk_ldpsrmppng on dbldapusermapping sourcingbuyer (cost=0.29..0.39 rows=1 width=568) (actual time=0.007..0.010 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.sourcingbuyer)
93. 268.530 268.530 ↑ 1.0 1 26,853

Index Scan using pk_ldpsrmppng on dbldapusermapping rebuying (cost=0.29..0.39 rows=1 width=568) (actual time=0.008..0.010 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.rebuying)
94. 0.239 0.459 ↑ 1.0 270 1

Hash (cost=5.70..5.70 rows=270 width=754) (actual time=0.458..0.459 rows=270 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
95. 0.220 0.220 ↑ 1.0 270 1

Seq Scan on dbsmmkz mkz (cost=0.00..5.70 rows=270 width=754) (actual time=0.018..0.220 rows=270 loops=1)

96. 0.036 0.072 ↑ 1.0 35 1

Hash (cost=1.35..1.35 rows=35 width=52) (actual time=0.072..0.072 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
97. 0.036 0.036 ↑ 1.0 35 1

Seq Scan on packaging (cost=0.00..1.35 rows=35 width=52) (actual time=0.013..0.036 rows=35 loops=1)

98. 0.018 0.052 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=238) (actual time=0.052..0.052 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
99. 0.034 0.034 ↑ 1.0 22 1

Seq Scan on weightunit swu (cost=0.00..1.22 rows=22 width=238) (actual time=0.015..0.034 rows=22 loops=1)

100. 0.018 0.044 ↑ 1.0 18 1

Hash (cost=1.18..1.18 rows=18 width=238) (actual time=0.044..0.044 rows=18 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
101. 0.026 0.026 ↑ 1.0 18 1

Seq Scan on sustainability sa (cost=0.00..1.18 rows=18 width=238) (actual time=0.012..0.026 rows=18 loops=1)

102. 0.323 0.323 ↑ 1.0 1 17

Index Scan using pk_department on dbdepartment d (cost=0.29..0.33 rows=1 width=148) (actual time=0.018..0.019 rows=1 loops=17)

  • Index Cond: (pd.department = departmentid)
  • Filter: (pd.client = clientid)
103. 0.587 1.042 ↑ 1.0 591 1

Hash (cost=11.91..11.91 rows=591 width=40) (actual time=1.042..1.042 rows=591 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
104. 0.455 0.455 ↑ 1.0 591 1

Seq Scan on dbseasonclient sc (cost=0.00..11.91 rows=591 width=40) (actual time=0.018..0.455 rows=591 loops=1)

105. 2.160 2.160 ↑ 1.0 1 48

Index Scan using pk_clients on dbclientsupplier cs (cost=0.29..0.35 rows=1 width=60) (actual time=0.043..0.045 rows=1 loops=48)

  • Index Cond: (q.clientsupplier = clientsupplierid)
106. 1.008 1.008 ↑ 1.0 1 48

Index Scan using pk_supplier on dbsupplier s (cost=0.29..0.36 rows=1 width=40) (actual time=0.019..0.021 rows=1 loops=48)

  • Index Cond: (cs.supplierid = supplierid)
107. 0.013 0.119 ↓ 4.0 4 1

Hash (cost=1.48..1.48 rows=1 width=238) (actual time=0.118..0.119 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
108. 0.106 0.106 ↓ 4.0 4 1

Seq Scan on productstatus ps (cost=0.00..1.48 rows=1 width=238) (actual time=0.057..0.106 rows=4 loops=1)

  • Filter: ((code)::text ~~* 'Free for Quotation'::text)
  • Rows Removed by Filter: 34
109. 0.504 0.504 ↑ 1.0 1 42

Index Only Scan using pk_office on dboffice o1 (cost=0.14..0.16 rows=1 width=20) (actual time=0.009..0.012 rows=1 loops=42)

  • Index Cond: (officeid = cs.officeid)
  • Heap Fetches: 42
110. 0.042 0.042 ↓ 0.0 0 42

Index Only Scan using pk_office on dboffice o2 (cost=0.14..0.16 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=42)

  • Index Cond: (officeid = sbd.office)
  • Heap Fetches: 0
111. 0.029 0.062 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.061..0.062 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
112. 0.033 0.033 ↑ 1.0 24 1

Seq Scan on quotationstatus qs (cost=0.00..1.24 rows=24 width=238) (actual time=0.015..0.033 rows=24 loops=1)

113. 1.176 1.176 ↑ 1.0 1 42

Index Scan using iteminfo_pkey on iteminfo ii (cost=0.29..0.40 rows=1 width=1,052) (actual time=0.026..0.028 rows=1 loops=42)

  • Index Cond: (productid = pd.productid)
114. 1.260 1.260 ↑ 1,000.0 1 42

Index Scan using ix_quotationitem_quotionid on quotationitem qi (cost=0.42..18.07 rows=1,000 width=258) (actual time=0.027..0.030 rows=1 loops=42)

  • Index Cond: (q.quotationid = quotationid)
115. 0.021 0.049 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=20) (actual time=0.049..0.049 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
116. 0.028 0.028 ↑ 1.0 5 1

Seq Scan on itemstatus qits (cost=0.00..1.05 rows=5 width=20) (actual time=0.024..0.028 rows=5 loops=1)

117.          

SubPlan (for Hash Left Join)

118. 0.420 1.890 ↑ 2,183.0 1 42

Bitmap Heap Scan on dbi18ndescription (cost=78.95..8,541.46 rows=2,183 width=516) (actual time=0.044..0.045 rows=1 loops=42)

  • Recheck Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
  • Heap Blocks: exact=42
119. 1.470 1.470 ↑ 2,183.0 1 42

Bitmap Index Scan on pk_18ndscrptn (cost=0.00..78.40 rows=2,183 width=0) (actual time=0.035..0.035 rows=1 loops=42)

  • Index Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
120. 0.588 0.588 ↑ 1.0 1 42

Seq Scan on productaction pa (cost=0.00..1.11 rows=1 width=218) (actual time=0.012..0.014 rows=1 loops=42)

  • Filter: (productactionid = sbd.action)
  • Rows Removed by Filter: 8
121. 0.294 1,495.788 ↑ 200.0 1 42

Unique (cost=1,647.57..1,648.85 rows=200 width=58) (actual time=35.611..35.614 rows=1 loops=42)

122. 0.756 1,495.494 ↑ 257.0 1 42

Sort (cost=1,647.57..1,648.21 rows=257 width=58) (actual time=35.606..35.607 rows=1 loops=42)

  • Sort Key: dbsmfabric.code
  • Sort Method: quicksort Memory: 25kB
123. 0.555 1,494.738 ↑ 257.0 1 42

Hash Left Join (cost=51.30..1,637.28 rows=257 width=58) (actual time=33.575..35.589 rows=1 loops=42)

  • Hash Cond: (it.coloroption = dbsmfabric.smfabricid)
124. 1,491.462 1,491.462 ↑ 257.0 1 42

Seq Scan on item it (cost=0.00..1,582.45 rows=257 width=20) (actual time=33.499..35.511 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
125. 1.447 2.721 ↑ 1.0 1,702 1

Hash (cost=30.02..30.02 rows=1,702 width=78) (actual time=2.720..2.721 rows=1,702 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 96kB
126. 1.274 1.274 ↑ 1.0 1,702 1

Seq Scan on dbsmfabric (cost=0.00..30.02 rows=1,702 width=78) (actual time=0.017..1.274 rows=1,702 loops=1)

127. 0.294 1,482.348 ↑ 46.0 1 42

Unique (cost=1,596.33..1,597.61 rows=46 width=32) (actual time=35.292..35.294 rows=1 loops=42)

128. 0.756 1,482.054 ↑ 257.0 1 42

Sort (cost=1,596.33..1,596.97 rows=257 width=32) (actual time=35.286..35.287 rows=1 loops=42)

  • Sort Key: ft.en
  • Sort Method: quicksort Memory: 25kB
129. 0.563 1,481.298 ↑ 257.0 1 42

Hash Left Join (cost=2.04..1,586.04 rows=257 width=32) (actual time=33.454..35.269 rows=1 loops=42)

  • Hash Cond: (it_1.fashiontheme = ft.fashionthemeid)
130. 1,480.626 1,480.626 ↑ 257.0 1 42

Seq Scan on item it_1 (cost=0.00..1,582.45 rows=257 width=20) (actual time=33.440..35.253 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
131. 0.049 0.109 ↑ 1.0 46 1

Hash (cost=1.46..1.46 rows=46 width=52) (actual time=0.108..0.109 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
132. 0.060 0.060 ↑ 1.0 46 1

Seq Scan on fashiontheme ft (cost=0.00..1.46 rows=46 width=52) (actual time=0.028..0.060 rows=46 loops=1)

133. 0.294 1,519.350 ↑ 29.0 1 42

Unique (cost=1,595.72..1,597.01 rows=29 width=32) (actual time=36.173..36.175 rows=1 loops=42)

134. 7.770 1,519.056 ↑ 257.0 1 42

Sort (cost=1,595.72..1,596.37 rows=257 width=32) (actual time=36.167..36.168 rows=1 loops=42)

  • Sort Key: cam.en
  • Sort Method: quicksort Memory: 25kB
135. 0.513 1,511.286 ↑ 257.0 1 42

Hash Left Join (cost=1.65..1,585.44 rows=257 width=32) (actual time=33.797..35.983 rows=1 loops=42)

  • Hash Cond: (it_2.campaign = cam.campaignid)
136. 1,510.698 1,510.698 ↑ 257.0 1 42

Seq Scan on item it_2 (cost=0.00..1,582.45 rows=257 width=20) (actual time=33.785..35.969 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
137. 0.032 0.075 ↓ 1.0 30 1

Hash (cost=1.29..1.29 rows=29 width=52) (actual time=0.075..0.075 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
138. 0.043 0.043 ↓ 1.0 30 1

Seq Scan on campaign cam (cost=0.00..1.29 rows=29 width=52) (actual time=0.020..0.043 rows=30 loops=1)

139. 1.260 77,931.126 ↑ 1.0 1 42

Aggregate (cost=21,633.46..21,633.47 rows=1 width=32) (actual time=1,855.502..1,855.503 rows=1 loops=42)

140. 0.454 77,929.866 ↑ 157.5 2 42

Hash Left Join (cost=19,480.61..21,625.58 rows=315 width=300) (actual time=1,820.279..1,855.473 rows=2 loops=42)

  • Hash Cond: (mc.weightunitid = wu.weightunitid)
141. 93.957 77,929.362 ↑ 157.5 2 42

Hash Left Join (cost=19,479.11..21,622.55 rows=315 width=102) (actual time=1,820.271..1,855.461 rows=2 loops=42)

  • Hash Cond: (mc.component = c_1.componentid)
142. 3,378.396 77,835.282 ↑ 157.5 2 42

Hash Right Join (cost=19,476.76..21,618.08 rows=315 width=90) (actual time=1,818.034..1,853.221 rows=2 loops=42)

  • Hash Cond: (mce.materialcomponentid = mc.materialcomponentid)
143. 28,007.154 66,729.306 ↓ 312.8 62,569 42

GroupAggregate (cost=16,276.81..18,415.37 rows=200 width=52) (actual time=777.507..1,588.793 rows=62,569 loops=42)

  • Group Key: mce.materialcomponentid
144. 20,359.374 38,722.152 ↓ 1.0 106,811 42

Sort (cost=16,276.81..16,543.81 rows=106,803 width=64) (actual time=777.118..921.956 rows=106,811 loops=42)

  • Sort Key: mce.materialcomponentid
  • Sort Method: external merge Disk: 3440kB
145. 12,932.993 18,362.778 ↓ 1.0 106,811 42

Hash Join (cost=15.73..3,338.30 rows=106,803 width=64) (actual time=0.039..437.209 rows=106,811 loops=42)

  • Hash Cond: (mce.materialid = mat.materialid)
146. 5,429.004 5,429.004 ↓ 1.0 106,811 42

Seq Scan on materialcomponentelement mce (cost=0.00..1,854.03 rows=106,803 width=52) (actual time=0.014..129.262 rows=106,811 loops=42)

147. 0.432 0.781 ↑ 1.0 477 1

Hash (cost=9.77..9.77 rows=477 width=52) (actual time=0.781..0.781 rows=477 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
148. 0.349 0.349 ↑ 1.0 477 1

Seq Scan on material mat (cost=0.00..9.77 rows=477 width=52) (actual time=0.016..0.349 rows=477 loops=1)

149. 0.672 7,727.580 ↑ 157.5 2 42

Hash (cost=3,196.02..3,196.02 rows=315 width=78) (actual time=183.990..183.990 rows=2 loops=42)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
150. 3,219.090 7,726.908 ↑ 157.5 2 42

Hash Right Join (cost=1,585.66..3,196.02 rows=315 width=78) (actual time=133.383..183.974 rows=2 loops=42)

  • Hash Cond: (mc.objectid = it_3.itemid)
151. 2,945.586 2,945.586 ↓ 1.0 62,928 42

Seq Scan on materialcomponent mc (cost=0.00..1,371.24 rows=62,924 width=98) (actual time=0.014..70.133 rows=62,928 loops=42)

152. 0.462 1,562.232 ↑ 257.0 1 42

Hash (cost=1,582.45..1,582.45 rows=257 width=20) (actual time=37.196..37.196 rows=1 loops=42)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
153. 1,561.770 1,561.770 ↑ 257.0 1 42

Seq Scan on item it_3 (cost=0.00..1,582.45 rows=257 width=20) (actual time=34.907..37.185 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
154. 0.057 0.123 ↑ 1.0 60 1

Hash (cost=1.60..1.60 rows=60 width=52) (actual time=0.122..0.123 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
155. 0.066 0.066 ↑ 1.0 60 1

Seq Scan on component c_1 (cost=0.00..1.60 rows=60 width=52) (actual time=0.025..0.066 rows=60 loops=1)

156. 0.023 0.050 ↑ 1.0 22 1

Hash (cost=1.22..1.22 rows=22 width=238) (actual time=0.050..0.050 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
157. 0.027 0.027 ↑ 1.0 22 1

Seq Scan on weightunit wu (cost=0.00..1.22 rows=22 width=238) (actual time=0.013..0.027 rows=22 loops=1)

158. 0.294 1,652.952 ↑ 105.0 1 42

Unique (cost=1,599.41..1,600.70 rows=105 width=218) (actual time=39.354..39.356 rows=1 loops=42)

159. 0.630 1,652.658 ↑ 257.0 1 42

Sort (cost=1,599.41..1,600.06 rows=257 width=218) (actual time=39.348..39.349 rows=1 loops=42)

  • Sort Key: fc.code
  • Sort Method: quicksort Memory: 25kB
160. 0.643 1,652.028 ↑ 257.0 1 42

Hash Left Join (cost=4.36..1,589.13 rows=257 width=218) (actual time=34.615..39.334 rows=1 loops=42)

  • Hash Cond: (it_4.fabriccode = fc.fabriccodeid)
161. 1,651.188 1,651.188 ↑ 257.0 1 42

Seq Scan on item it_4 (cost=0.00..1,582.45 rows=257 width=20) (actual time=34.598..39.314 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
162. 0.100 0.197 ↑ 1.0 105 1

Hash (cost=3.05..3.05 rows=105 width=238) (actual time=0.196..0.197 rows=105 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
163. 0.097 0.097 ↑ 1.0 105 1

Seq Scan on fabriccode fc (cost=0.00..3.05 rows=105 width=238) (actual time=0.020..0.097 rows=105 loops=1)

164. 0.252 1,544.718 ↑ 145.0 1 42

Unique (cost=1,592.74..1,594.02 rows=145 width=20) (actual time=36.777..36.779 rows=1 loops=42)

165. 7.980 1,544.466 ↑ 257.0 1 42

Sort (cost=1,592.74..1,593.38 rows=257 width=20) (actual time=36.772..36.773 rows=1 loops=42)

  • Sort Key: item.vk
  • Sort Method: quicksort Memory: 25kB
166. 1,536.486 1,536.486 ↑ 257.0 1 42

Seq Scan on item (cost=0.00..1,582.45 rows=257 width=20) (actual time=34.526..36.583 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
167. 0.252 1,533.756 ↑ 6.0 1 42

Unique (cost=1,594.92..1,596.20 rows=6 width=218) (actual time=36.516..36.518 rows=1 loops=42)

168. 0.798 1,533.504 ↑ 257.0 1 42

Sort (cost=1,594.92..1,595.56 rows=257 width=218) (actual time=36.511..36.512 rows=1 loops=42)

  • Sort Key: dro.code
  • Sort Method: quicksort Memory: 25kB
169. 0.595 1,532.706 ↑ 257.0 1 42

Hash Left Join (cost=1.14..1,584.63 rows=257 width=218) (actual time=34.785..36.493 rows=1 loops=42)

  • Hash Cond: (it_5.dropoption = dro.dropoptionid)
170. 1,532.076 1,532.076 ↑ 257.0 1 42

Seq Scan on item it_5 (cost=0.00..1,582.45 rows=257 width=20) (actual time=34.772..36.478 rows=1 loops=42)

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
171. 0.012 0.035 ↓ 1.2 7 1

Hash (cost=1.06..1.06 rows=6 width=238) (actual time=0.034..0.035 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
172. 0.023 0.023 ↓ 1.2 7 1

Seq Scan on dropoption dro (cost=0.00..1.06 rows=6 width=238) (actual time=0.018..0.023 rows=7 loops=1)

173. 0.210 1.176 ↓ 0.0 0 42

Bitmap Heap Scan on productstatususer psu (cost=4.42..30.40 rows=18 width=20) (actual time=0.028..0.028 rows=0 loops=42)

  • Recheck Cond: (productid = pd.productid)
174. 0.966 0.966 ↓ 0.0 0 42

Bitmap Index Scan on pk_productstatususer (cost=0.00..4.42 rows=18 width=0) (actual time=0.023..0.023 rows=0 loops=42)

  • Index Cond: (productid = pd.productid)
Planning time : 88.669 ms
Execution time : 97,402.465 ms