explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KAIK

Settings
# exclusive inclusive rows x rows loops node
1. 3.372 6,762.434 ↑ 1.4 42 1

Hash Left Join (cost=122,316.41..906,253.13 rows=58 width=7,313) (actual time=3,550.377..6,762.434 rows=42 loops=1)

  • Hash Cond: (sbd.action = pa.productactionid)
2. 0.169 3,491.681 ↑ 1.4 42 1

Hash Left Join (cost=122,315.21..128,158.99 rows=58 width=10,157) (actual time=3,482.139..3,491.681 rows=42 loops=1)

  • Hash Cond: (qi.status = qits.itemstatusid)
3. 0.316 3,491.488 ↑ 1.4 42 1

Nested Loop Left Join (cost=122,314.10..128,157.65 rows=58 width=10,157) (actual time=3,482.103..3,491.488 rows=42 loops=1)

4. 0.278 3,490.416 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,313.68..127,343.60 rows=29 width=9,939) (actual time=3,482.062..3,490.416 rows=42 loops=1)

5. 0.272 3,489.550 ↓ 1.4 42 1

Hash Left Join (cost=122,313.39..127,331.68 rows=29 width=8,907) (actual time=3,482.025..3,489.550 rows=42 loops=1)

  • Hash Cond: (q.status = qs.quotationstatusid)
6. 0.248 3,489.219 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,311.85..127,330.00 rows=29 width=8,689) (actual time=3,481.944..3,489.219 rows=42 loops=1)

7. 0.270 3,488.929 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,311.71..127,324.98 rows=29 width=8,689) (actual time=3,481.937..3,488.929 rows=42 loops=1)

8. 0.263 3,488.239 ↓ 1.4 42 1

Hash Join (cost=122,311.56..127,319.96 rows=29 width=8,689) (actual time=3,481.915..3,488.239 rows=42 loops=1)

  • Hash Cond: (sbd.status = ps.productstatusid)
9. 0.305 3,487.860 ↑ 23.3 48 1

Nested Loop Left Join (cost=122,310.07..127,314.21 rows=1,119 width=8,471) (actual time=3,481.781..3,487.860 rows=48 loops=1)

10. 0.315 3,486.787 ↑ 23.3 48 1

Nested Loop Left Join (cost=122,309.79..126,897.76 rows=1,119 width=8,451) (actual time=3,481.749..3,486.787 rows=48 loops=1)

11. 92.375 3,485.704 ↑ 23.3 48 1

Hash Right Join (cost=122,309.50..126,493.86 rows=1,119 width=8,431) (actual time=3,481.701..3,485.704 rows=48 loops=1)

  • Hash Cond: (q.productid = pd.productid)
12. 99.938 99.938 ↓ 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..99.938 rows=101,835 loops=1)

13. 0.074 3,293.391 ↑ 17.4 17 1

Hash (cost=122,305.81..122,305.81 rows=295 width=8,350) (actual time=3,293.390..3,293.391 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
14. 0.077 3,293.317 ↑ 17.4 17 1

Hash Left Join (cost=91,487.64..122,305.81 rows=295 width=8,350) (actual time=2,958.501..3,293.317 rows=17 loops=1)

  • Hash Cond: ((pd.seasonclient = sc.seasonclientid) AND (pd.client = sc.clientid))
15. 0.103 3,292.199 ↑ 17.4 17 1

Nested Loop Left Join (cost=91,466.86..122,282.81 rows=295 width=8,370) (actual time=2,957.440..3,292.199 rows=17 loops=1)

16. 45.882 3,291.858 ↑ 17.4 17 1

Nested Loop (cost=91,466.58..122,183.51 rows=295 width=8,262) (actual time=2,957.389..3,291.858 rows=17 loops=1)

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

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

  • Index Cond: (companyshort = 'SVH'::text)
  • Heap Fetches: 1
18. 65.895 3,245.946 ↑ 1.0 26,853 1

Hash Left Join (cost=91,466.43..121,835.00 rows=26,854 width=8,242) (actual time=2,869.910..3,245.946 rows=26,853 loops=1)

  • Hash Cond: (sbd.sustainability = sa.sustainabilityid)
19. 87.903 3,180.002 ↑ 1.0 26,853 1

Hash Left Join (cost=91,465.03..121,708.73 rows=26,854 width=8,044) (actual time=2,869.853..3,180.002 rows=26,853 loops=1)

  • Hash Cond: (md.shellweightunit = swu.weightunitid)
20. 184.975 3,092.046 ↑ 1.0 26,853 1

Hash Right Join (cost=91,463.53..121,576.99 rows=26,854 width=7,846) (actual time=2,869.779..3,092.046 rows=26,853 loops=1)

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

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

22. 93.275 2,869.433 ↑ 1.0 26,853 1

Hash (cost=67,787.86..67,787.86 rows=26,854 width=7,092) (actual time=2,869.433..2,869.433 rows=26,853 loops=1)

  • Buckets: 1024 Batches: 64 Memory Usage: 135kB
23. 103.757 2,776.158 ↑ 1.0 26,853 1

Hash Left Join (cost=31.37..67,787.86 rows=26,854 width=7,092) (actual time=1.420..2,776.158 rows=26,853 loops=1)

  • Hash Cond: (sbd.packaging = packaging.packagingid)
24. 56.165 2,672.331 ↑ 1.0 26,853 1

Hash Left Join (cost=29.58..67,638.38 rows=26,854 width=7,080) (actual time=1.342..2,672.331 rows=26,853 loops=1)

  • Hash Cond: (sbd.wittmkz = mkz.smmkzid)
25. 141.878 2,615.712 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=20.51..67,260.06 rows=26,854 width=6,346) (actual time=0.879..2,615.712 rows=26,853 loops=1)

26. 100.855 2,312.716 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=20.22..56,565.92 rows=26,854 width=5,798) (actual time=0.858..2,312.716 rows=26,853 loops=1)

27. 90.195 2,050.743 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=19.93..45,871.77 rows=26,854 width=5,250) (actual time=0.856..2,050.743 rows=26,853 loops=1)

28. 114.589 1,772.577 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=19.64..35,177.62 rows=26,854 width=4,702) (actual time=0.851..1,772.577 rows=26,853 loops=1)

29. 161.620 1,631.135 ↑ 1.0 26,853 1

Nested Loop Left Join (cost=19.35..24,483.48 rows=26,854 width=4,174) (actual time=0.846..1,631.135 rows=26,853 loops=1)

30. 52.018 1,254.691 ↑ 1.0 26,853 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

42. 40.108 40.108 ↑ 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..40.108 rows=26,853 loops=1)

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

  • Index Cond: (productid = sbd.productid)
44. 0.151 0.267 ↑ 1.0 159 1

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

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

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

46. 0.041 0.081 ↑ 1.0 41 1

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

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

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

48. 0.008 0.022 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=52) (actual time=0.021..0.022 rows=5 loops=1)

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

50. 0.023 0.037 ↑ 1.0 4 1

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

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

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

52. 0.002 0.016 ↑ 1.0 1 1

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

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

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

54. 0.033 0.064 ↑ 1.0 32 1

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

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

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

56. 0.021 0.047 ↑ 1.0 20 1

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

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

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

58. 0.004 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.017 0.017 ↑ 1.0 2 1

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

60. 0.014 0.035 ↑ 1.0 13 1

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

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

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

62. 0.013 0.035 ↓ 1.6 13 1

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

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

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

64. 0.015 0.040 ↑ 1.0 16 1

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

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

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

66. 214.824 214.824 ↑ 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.007..0.008 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.creativebuyer)
67. 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)
68. 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)
69. 161.118 161.118 ↑ 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.005..0.006 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.sourcingbuyer)
70. 161.118 161.118 ↑ 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.005..0.006 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.rebuying)
71. 0.246 0.454 ↑ 1.0 270 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
72. 0.208 0.208 ↑ 1.0 270 1

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

73. 0.039 0.070 ↑ 1.0 35 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
74. 0.031 0.031 ↑ 1.0 35 1

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

75. 0.024 0.053 ↑ 1.0 22 1

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

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

77. 0.019 0.049 ↑ 1.0 18 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.030 0.030 ↑ 1.0 18 1

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

79. 0.238 0.238 ↑ 1.0 1 17

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

  • Index Cond: (pd.department = departmentid)
  • Filter: (pd.client = clientid)
80. 0.577 1.041 ↑ 1.0 591 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
81. 0.464 0.464 ↑ 1.0 591 1

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

82. 0.768 0.768 ↑ 1.0 1 48

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

  • Index Cond: (q.clientsupplier = clientsupplierid)
83. 0.768 0.768 ↑ 1.0 1 48

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

  • Index Cond: (cs.supplierid = supplierid)
84. 0.010 0.116 ↓ 4.0 4 1

Hash (cost=1.48..1.48 rows=1 width=238) (actual time=0.115..0.116 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
85. 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.056..0.106 rows=4 loops=1)

  • Filter: ((code)::text ~~* 'Free for Quotation'::text)
  • Rows Removed by Filter: 34
86. 0.420 0.420 ↑ 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.008..0.010 rows=1 loops=42)

  • Index Cond: (officeid = cs.officeid)
  • Heap Fetches: 42
87. 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
88. 0.026 0.059 ↑ 1.0 24 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
89. 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.014..0.033 rows=24 loops=1)

90. 0.588 0.588 ↑ 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.012..0.014 rows=1 loops=42)

  • Index Cond: (productid = pd.productid)
91. 0.756 0.756 ↑ 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.015..0.018 rows=1 loops=42)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
93. 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.012..0.016 rows=5 loops=1)

94. 0.014 0.033 ↑ 1.0 9 1

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

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

96.          

SubPlan (for Hash Left Join)

97. 0.378 1.134 ↑ 2,183.0 1 42

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

  • Recheck Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
  • Heap Blocks: exact=42
98. 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))
99. 0.252 1,067.724 ↑ 200.0 1 42

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

100. 0.504 1,067.472 ↑ 257.0 1 42

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

  • Sort Key: dbsmfabric.code
  • Sort Method: quicksort Memory: 25kB
101. 0.471 1,066.968 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
103. 1.451 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
104. 1.270 1.270 ↑ 1.0 1,702 1

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

105. 0.252 1,121.442 ↑ 46.0 1 42

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

106. 0.588 1,121.190 ↑ 257.0 1 42

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

  • Sort Key: ft.en
  • Sort Method: quicksort Memory: 25kB
107. 0.498 1,120.602 ↑ 257.0 1 42

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

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

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

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
110. 0.045 0.045 ↑ 1.0 46 1

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

111. 0.252 1,076.292 ↑ 29.0 1 42

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

112. 0.630 1,076.040 ↑ 257.0 1 42

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

  • Sort Key: cam.en
  • Sort Method: quicksort Memory: 25kB
113. 0.395 1,075.410 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
115. 0.028 0.067 ↓ 1.0 30 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
116. 0.039 0.039 ↓ 1.0 30 1

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

117. 0.210 0.756 ↓ 0.0 0 42

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

  • Recheck Cond: (productid = pd.productid)
118. 0.546 0.546 ↓ 0.0 0 42

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

  • Index Cond: (productid = pd.productid)
Planning time : 65.676 ms
Execution time : 6,771.208 ms