explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aEic

Settings
# exclusive inclusive rows x rows loops node
1. 13.570 120,874.008 ↑ 1.4 42 1

Hash Left Join (cost=181,570.86..2,498,122.54 rows=58 width=7,473) (actual time=17,371.708..120,874.008 rows=42 loops=1)

  • Hash Cond: (sbd.action = pa.productactionid)
2. 0.210 14,734.344 ↑ 1.4 42 1

Hash Left Join (cost=181,569.66..187,413.43 rows=58 width=10,189) (actual time=14,693.838..14,734.344 rows=42 loops=1)

  • Hash Cond: (qi.status = qits.itemstatusid)
3. 0.366 14,734.110 ↑ 1.4 42 1

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

4. 11.477 14,732.442 ↓ 1.4 42 1

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

5. 0.252 14,713.489 ↓ 1.4 42 1

Hash Left Join (cost=181,567.84..186,586.13 rows=29 width=8,939) (actual time=14,693.719..14,713.489 rows=42 loops=1)

  • Hash Cond: (q.status = qs.quotationstatusid)
6. 0.294 14,713.165 ↓ 1.4 42 1

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

7. 0.336 14,712.829 ↓ 1.4 42 1

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

8. 0.321 14,711.989 ↓ 1.4 42 1

Hash Join (cost=181,566.01..186,574.41 rows=29 width=8,721) (actual time=14,693.592..14,711.989 rows=42 loops=1)

  • Hash Cond: (sbd.status = ps.productstatusid)
9. 0.387 14,711.536 ↑ 23.3 48 1

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

10. 0.351 14,699.053 ↑ 23.3 48 1

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

11. 171.132 14,697.454 ↑ 23.3 48 1

Hash Right Join (cost=181,563.94..185,748.31 rows=1,119 width=8,463) (actual time=14,693.348..14,697.454 rows=48 loops=1)

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

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

13. 0.098 14,398.675 ↑ 17.4 17 1

Hash (cost=181,560.26..181,560.26 rows=295 width=8,382) (actual time=14,398.675..14,398.675 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
14. 0.108 14,398.577 ↑ 17.4 17 1

Hash Left Join (cost=150,637.08..181,560.26 rows=295 width=8,382) (actual time=14,070.278..14,398.577 rows=17 loops=1)

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

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

16. 51.725 14,396.980 ↑ 17.4 17 1

Nested Loop (cost=150,616.02..181,437.96 rows=295 width=8,294) (actual time=14,069.156..14,396.980 rows=17 loops=1)

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

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

  • Index Cond: (companyshort = 'SVH'::text)
  • Heap Fetches: 1
18. 66.040 14,345.221 ↑ 1.0 26,853 1

Hash Left Join (cost=150,615.88..181,089.45 rows=26,854 width=8,274) (actual time=13,921.427..14,345.221 rows=26,853 loops=1)

  • Hash Cond: (sbd.sustainability = sa.sustainabilityid)
19. 88.085 14,279.137 ↑ 1.0 26,853 1

Hash Left Join (cost=150,614.48..180,963.17 rows=26,854 width=8,076) (actual time=13,921.361..14,279.137 rows=26,853 loops=1)

  • Hash Cond: (md.shellweightunit = swu.weightunitid)
20. 233.167 14,190.999 ↑ 1.0 26,853 1

Hash Right Join (cost=150,612.98..180,831.44 rows=26,854 width=7,878) (actual time=13,921.285..14,190.999 rows=26,853 loops=1)

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

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

22. 197.245 13,920.883 ↑ 1.0 26,853 1

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

  • Buckets: 1024 Batches: 64 Memory Usage: 136kB
23. 96.833 13,723.638 ↑ 1.0 26,853 1

Hash Left Join (cost=58,975.11..126,832.31 rows=26,854 width=7,124) (actual time=10,084.885..13,723.638 rows=26,853 loops=1)

  • Hash Cond: (sbd.packaging = packaging.packagingid)
24. 95.270 13,626.715 ↑ 1.0 26,853 1

Hash Left Join (cost=58,973.32..126,682.83 rows=26,854 width=7,112) (actual time=10,084.782..13,626.715 rows=26,853 loops=1)

  • Hash Cond: (sbd.wittmkz = mkz.smmkzid)
25. 166.327 13,530.984 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,964.25..126,304.51 rows=26,854 width=6,378) (actual time=10,084.305..13,530.984 rows=26,853 loops=1)

26. 149.118 13,096.127 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.96..115,610.36 rows=26,854 width=5,830) (actual time=10,084.278..13,096.127 rows=26,853 loops=1)

27. 143.344 12,759.038 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.67..104,916.22 rows=26,854 width=5,282) (actual time=10,084.272..12,759.038 rows=26,853 loops=1)

28. 116.831 12,320.311 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.38..94,222.07 rows=26,854 width=4,734) (actual time=10,084.263..12,320.311 rows=26,853 loops=1)

29. 190.756 12,149.774 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=58,963.09..83,527.93 rows=26,854 width=4,206) (actual time=10,084.257..12,149.774 rows=26,853 loops=1)

30. 106.296 11,717.341 ↑ 1.0 26,853 1

Hash Left Join (cost=58,962.80..72,833.78 rows=26,854 width=3,658) (actual time=10,084.197..11,717.341 rows=26,853 loops=1)

  • Hash Cond: (pd.productid = sr.productid)
31. 90.987 1,527.835 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.calculationsizeoption = calculationsizeoption.calculationsizeoptionid)
32. 90.315 1,436.804 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.subbrandcategory = subbrandcategory.subbrandcategoryid)
33. 75.881 1,346.434 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.styleorigin = styleorigin.styleoriginid)
34. 79.729 1,270.513 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.assortment = assortment.assortmentid)
35. 95.668 1,190.763 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.seasonname = seasonname.seasonnameid)
36. 115.997 1,095.044 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.bodyshapetype = bodyshapetype.bodyshapetypeid)
37. 69.063 978.981 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.subbrand = subbrand.subbrandid)
38. 79.857 909.897 ↑ 1.0 26,853 1

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

  • Hash Cond: ((sbd.package)::text = (packageoption.packageoptionid)::text)
39. 74.131 830.013 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.fashionlevel = fashionlevel.fashionlevelid)
40. 100.619 755.856 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.tactemplate = template.templateid)
41. 100.256 655.151 ↑ 1.0 26,853 1

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

  • Hash Cond: (sbd.genre = genre.genreid)
42. 187.467 554.622 ↑ 1.0 26,853 1

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

43. 44.919 44.919 ↑ 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.012..44.919 rows=26,853 loops=1)

44. 322.236 322.236 ↑ 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.012 rows=1 loops=26,853)

  • Index Cond: (productid = sbd.productid)
45. 0.149 0.273 ↑ 1.0 159 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
46. 0.124 0.124 ↑ 1.0 159 1

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

47. 0.047 0.086 ↑ 1.0 41 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
48. 0.039 0.039 ↑ 1.0 41 1

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

49. 0.012 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
50. 0.014 0.014 ↑ 1.0 5 1

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

51. 0.012 0.027 ↑ 1.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
52. 0.015 0.015 ↑ 1.0 4 1

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

53. 0.008 0.021 ↑ 1.0 1 1

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

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

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

55. 0.029 0.066 ↑ 1.0 32 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
56. 0.037 0.037 ↑ 1.0 32 1

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

57. 0.027 0.051 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=270) (actual time=0.050..0.051 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
58. 0.024 0.024 ↑ 1.0 20 1

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

59. 0.009 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
60. 0.012 0.012 ↑ 1.0 2 1

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

61. 0.022 0.040 ↑ 1.0 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
62. 0.018 0.018 ↑ 1.0 13 1

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

63. 0.018 0.055 ↓ 1.6 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
64. 0.037 0.037 ↓ 1.6 13 1

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

65. 0.022 0.044 ↑ 1.0 16 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
66. 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)

67. 16.400 10,083.210 ↓ 5,834.0 5,834 1

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

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 345kB
68. 6.593 10,066.810 ↓ 5,834.0 5,834 1

Subquery Scan on sr (cost=58,943.67..58,943.72 rows=1 width=52) (actual time=9,981.510..10,066.810 rows=5,834 loops=1)

69. 44.672 10,060.217 ↓ 5,834.0 5,834 1

GroupAggregate (cost=58,943.67..58,943.71 rows=1 width=52) (actual time=9,981.509..10,060.217 rows=5,834 loops=1)

  • Group Key: p.productid
70. 26.166 10,015.545 ↓ 6,176.0 6,176 1

Unique (cost=58,943.67..58,943.69 rows=1 width=170) (actual time=9,981.486..10,015.545 rows=6,176 loops=1)

71. 24.040 9,989.379 ↓ 12,725.0 12,725 1

Sort (cost=58,943.67..58,943.68 rows=1 width=170) (actual time=9,981.483..9,989.379 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
72. 1,247.340 9,965.339 ↓ 12,725.0 12,725 1

Merge Join (cost=55,981.20..58,943.66 rows=1 width=170) (actual time=7,640.778..9,965.339 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
73. 200.072 1,525.583 ↑ 12.6 6,212 1

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

  • Group Key: p.productid, isz.sizerangecode
74. 462.951 1,325.511 ↓ 1.0 78,300 1

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

  • Sort Key: p.productid, isz.sizerangecode
  • Sort Method: external merge Disk: 1992kB
75. 304.668 862.560 ↓ 1.0 78,300 1

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

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

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

77. 95.806 457.240 ↑ 1.0 51,266 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 1761kB
78. 207.524 361.434 ↑ 1.0 51,266 1

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

  • Hash Cond: (i_1.productid = p.productid)
79. 61.451 61.451 ↑ 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.012..61.451 rows=51,266 loops=1)

80. 48.622 92.459 ↓ 1.0 26,853 1

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

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

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

82. 4,692.334 7,192.416 ↓ 947.2 565,486 1

Sort (cost=33,357.06..33,358.55 rows=597 width=736) (actual time=6,421.503..7,192.416 rows=565,486 loops=1)

  • Sort Key: i.productid, isz0.sizerangecode
  • Sort Method: external sort Disk: 26712kB
83. 1,578.421 2,500.082 ↓ 947.2 565,486 1

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

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

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

85. 215.910 814.177 ↓ 1.0 78,300 1

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

  • Buckets: 16384 Batches: 16 Memory Usage: 499kB
86. 317.650 598.267 ↓ 1.0 78,300 1

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

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

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

88. 118.839 180.014 ↑ 1.0 51,266 1

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

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

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

90. 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)
91. 53.706 53.706 ↓ 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.002..0.002 rows=0 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.designer)
92. 295.383 295.383 ↑ 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.011..0.011 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.qa)
93. 187.971 187.971 ↑ 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.006..0.007 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.sourcingbuyer)
94. 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.009..0.010 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.rebuying)
95. 0.237 0.461 ↑ 1.0 270 1

Hash (cost=5.70..5.70 rows=270 width=754) (actual time=0.460..0.461 rows=270 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
96. 0.224 0.224 ↑ 1.0 270 1

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

97. 0.038 0.090 ↑ 1.0 35 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
98. 0.052 0.052 ↑ 1.0 35 1

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

99. 0.024 0.053 ↑ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
100. 0.029 0.029 ↑ 1.0 22 1

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

101. 0.020 0.044 ↑ 1.0 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
102. 0.024 0.024 ↑ 1.0 18 1

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

103. 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.017..0.019 rows=1 loops=17)

  • Index Cond: (pd.department = departmentid)
  • Filter: (pd.client = clientid)
104. 0.578 1.034 ↑ 1.0 591 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
105. 0.456 0.456 ↑ 1.0 591 1

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

106. 1.248 1.248 ↑ 1.0 1 48

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

  • Index Cond: (q.clientsupplier = clientsupplierid)
107. 12.096 12.096 ↑ 1.0 1 48

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

  • Index Cond: (cs.supplierid = supplierid)
108. 0.032 0.132 ↓ 4.0 4 1

Hash (cost=1.48..1.48 rows=1 width=238) (actual time=0.131..0.132 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
109. 0.100 0.100 ↓ 4.0 4 1

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

  • Filter: ((code)::text ~~* 'Free for Quotation'::text)
  • Rows Removed by Filter: 34
110. 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.010..0.012 rows=1 loops=42)

  • Index Cond: (officeid = cs.officeid)
  • Heap Fetches: 42
111. 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
112. 0.028 0.072 ↑ 1.0 24 1

Hash (cost=1.24..1.24 rows=24 width=238) (actual time=0.071..0.072 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
113. 0.044 0.044 ↑ 1.0 24 1

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

114. 7.476 7.476 ↑ 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.176..0.178 rows=1 loops=42)

  • Index Cond: (productid = pd.productid)
115. 1.302 1.302 ↑ 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.028..0.031 rows=1 loops=42)

  • Index Cond: (q.quotationid = quotationid)
116. 0.008 0.024 ↑ 1.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
117. 0.016 0.016 ↑ 1.0 5 1

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

118. 0.013 0.032 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=238) (actual time=0.032..0.032 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
119. 0.019 0.019 ↑ 1.0 9 1

Seq Scan on productaction pa (cost=0.00..1.09 rows=9 width=238) (actual time=0.012..0.019 rows=9 loops=1)

120.          

SubPlan (for Hash Left Join)

121. 11.424 12.180 ↑ 2,183.0 1 42

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

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

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

  • Index Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
123. 0.294 1,770.132 ↑ 200.0 1 42

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

124. 0.672 1,769.838 ↑ 257.0 1 42

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

  • Sort Key: dbsmfabric.code
  • Sort Method: quicksort Memory: 25kB
125. 0.515 1,769.166 ↑ 257.0 1 42

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

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

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

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

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

  • Buckets: 2048 Batches: 1 Memory Usage: 96kB
128. 1.272 1.272 ↑ 1.0 1,702 1

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

129. 0.294 1,871.520 ↑ 46.0 1 42

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

130. 0.630 1,871.226 ↑ 257.0 1 42

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

  • Sort Key: ft.en
  • Sort Method: quicksort Memory: 25kB
131. 0.574 1,870.596 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
133. 0.045 0.098 ↑ 1.0 46 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
134. 0.053 0.053 ↑ 1.0 46 1

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

135. 0.294 1,875.552 ↑ 29.0 1 42

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

136. 0.672 1,875.258 ↑ 257.0 1 42

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

  • Sort Key: cam.en
  • Sort Method: quicksort Memory: 25kB
137. 0.475 1,874.586 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
139. 0.030 0.071 ↓ 1.0 30 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
140. 0.041 0.041 ↓ 1.0 30 1

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

141. 1.260 95,155.368 ↑ 1.0 1 42

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

142. 7.467 95,154.108 ↑ 157.5 2 42

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

  • Hash Cond: (mc.weightunitid = wu.weightunitid)
143. 122.081 95,146.590 ↑ 157.5 2 42

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

  • Hash Cond: (mc.component = c_1.componentid)
144. 4,256.952 95,024.370 ↑ 157.5 2 42

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

  • Hash Cond: (mce.materialcomponentid = mc.materialcomponentid)
145. 35,247.870 81,584.244 ↓ 312.8 62,569 42

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

  • Group Key: mce.materialcomponentid
146. 24,712.296 46,336.374 ↓ 1.0 106,811 42

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

  • Sort Key: mce.materialcomponentid
  • Sort Method: external merge Disk: 3440kB
147. 15,619.344 21,624.078 ↓ 1.0 106,811 42

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

  • Hash Cond: (mce.materialid = mat.materialid)
148. 6,003.942 6,003.942 ↓ 1.0 106,811 42

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

149. 0.421 0.792 ↑ 1.0 477 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
150. 0.371 0.371 ↑ 1.0 477 1

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

151. 0.672 9,183.174 ↑ 157.5 2 42

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
152. 3,930.066 9,182.502 ↑ 157.5 2 42

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

  • Hash Cond: (mc.objectid = it_3.itemid)
153. 3,401.454 3,401.454 ↓ 1.0 62,928 42

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

154. 0.420 1,850.982 ↑ 257.0 1 42

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
155. 1,850.562 1,850.562 ↑ 257.0 1 42

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
156. 0.060 0.139 ↑ 1.0 60 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
157. 0.079 0.079 ↑ 1.0 60 1

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

158. 0.022 0.051 ↑ 1.0 22 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
159. 0.029 0.029 ↑ 1.0 22 1

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

160. 0.294 1,892.352 ↑ 105.0 1 42

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

161. 0.630 1,892.058 ↑ 257.0 1 42

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

  • Sort Key: fc.code
  • Sort Method: quicksort Memory: 25kB
162. 22.613 1,891.428 ↑ 257.0 1 42

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
165. 0.093 0.093 ↑ 1.0 105 1

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

166. 0.336 1,721.034 ↑ 145.0 1 42

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

167. 0.840 1,720.698 ↑ 257.0 1 42

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

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

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

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

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

170. 7.686 1,826.790 ↑ 257.0 1 42

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

  • Sort Key: dro.code
  • Sort Method: quicksort Memory: 25kB
171. 7.651 1,819.104 ↑ 257.0 1 42

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
174. 0.025 0.025 ↓ 1.2 7 1

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

175. 0.252 0.882 ↓ 0.0 0 42

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

  • Recheck Cond: (productid = pd.productid)
176. 0.630 0.630 ↓ 0.0 0 42

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

  • Index Cond: (productid = pd.productid)
Planning time : 136.795 ms
Execution time : 120,895.496 ms