explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oTfyW

Settings
# exclusive inclusive rows x rows loops node
1. 10.572 7,614.906 ↑ 1.4 42 1

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

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

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

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

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

4. 0.294 3,672.881 ↓ 1.4 42 1

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

5. 0.249 3,671.999 ↓ 1.4 42 1

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

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

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

7. 0.275 3,671.444 ↓ 1.4 42 1

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

8. 0.244 3,670.749 ↓ 1.4 42 1

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

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

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

10. 0.323 3,669.285 ↑ 23.3 48 1

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

11. 103.169 3,668.194 ↑ 23.3 48 1

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

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

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

13. 0.083 3,475.991 ↑ 17.4 17 1

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

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

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

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

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

16. 35.044 3,474.383 ↑ 17.4 17 1

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

  • Join Filter: (pd.client = c.clientid)
  • Rows Removed by Join Filter: 26836
17. 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.029..0.033 rows=1 loops=1)

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

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

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

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

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

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

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

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

22. 105.066 2,999.468 ↑ 1.0 26,853 1

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

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

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

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

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

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

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

26. 86.619 2,247.210 ↑ 1.0 26,853 1

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

27. 111.648 1,972.620 ↑ 1.0 26,853 1

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

28. 75.185 1,673.001 ↑ 1.0 26,853 1

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

29. 131.721 1,570.963 ↑ 1.0 26,853 1

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

30. 88.061 1,251.271 ↑ 1.0 26,853 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

43. 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.011..0.012 rows=1 loops=26,853)

  • Index Cond: (productid = sbd.productid)
44. 0.140 0.268 ↑ 1.0 159 1

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

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

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

46. 0.042 0.080 ↑ 1.0 41 1

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

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

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

48. 0.026 0.041 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=52) (actual time=0.040..0.041 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.012..0.015 rows=5 loops=1)

50. 0.008 0.024 ↑ 1.0 4 1

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

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

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

52. 0.003 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.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)

54. 0.028 0.062 ↑ 1.0 32 1

Hash (cost=1.32..1.32 rows=32 width=52) (actual time=0.062..0.062 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.011..0.034 rows=32 loops=1)

56. 0.024 0.052 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=270) (actual time=0.051..0.052 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.015..0.028 rows=20 loops=1)

58. 0.005 0.017 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=52) (actual time=0.016..0.017 rows=2 loops=1)

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

60. 0.015 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.020 0.020 ↑ 1.0 13 1

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

62. 0.012 0.033 ↓ 1.6 13 1

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

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

Seq Scan on subbrandcategory (cost=0.00..1.08 rows=8 width=52) (actual time=0.011..0.021 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.039..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.012..0.025 rows=16 loops=1)

66. 187.971 187.971 ↑ 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.007 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. 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)
70. 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)
71. 0.251 0.450 ↑ 1.0 270 1

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

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

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

73. 0.033 0.072 ↑ 1.0 35 1

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

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

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

75. 0.025 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.028 0.028 ↑ 1.0 22 1

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

77. 0.021 0.065 ↑ 1.0 18 1

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

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

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

79. 0.289 0.289 ↑ 1.0 1 17

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

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

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

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

Seq Scan on dbseasonclient sc (cost=0.00..11.91 rows=591 width=40) (actual time=0.017..0.461 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.025 0.122 ↓ 4.0 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
85. 0.097 0.097 ↓ 4.0 4 1

Seq Scan on productstatus ps (cost=0.00..1.48 rows=1 width=238) (actual time=0.055..0.097 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.027 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.032 0.032 ↑ 1.0 24 1

Seq Scan on quotationstatus qs (cost=0.00..1.24 rows=24 width=238) (actual time=0.014..0.032 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.023 ↑ 1.0 5 1

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

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

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

94. 0.012 0.029 ↑ 1.0 9 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
95. 0.017 0.017 ↑ 1.0 9 1

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

96.          

SubPlan (for Hash Left Join)

97. 0.378 1.050 ↑ 2,183.0 1 42

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

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

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

  • Index Cond: ((rid = (sbd.brand)::numeric) AND (languageid = '3064863'::numeric))
99. 0.252 1,306.494 ↑ 200.0 1 42

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

100. 0.588 1,306.242 ↑ 257.0 1 42

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

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

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51265
103. 8.470 9.737 ↑ 1.0 1,702 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 96kB
104. 1.267 1.267 ↑ 1.0 1,702 1

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

105. 0.252 1,312.374 ↑ 46.0 1 42

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

106. 0.588 1,312.122 ↑ 257.0 1 42

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

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

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

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

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

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

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

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

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

111. 0.294 1,309.476 ↑ 29.0 1 42

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

112. 0.588 1,309.182 ↑ 257.0 1 42

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

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

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

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

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

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

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

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

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

117. 0.210 0.798 ↓ 0.0 0 42

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

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

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

  • Index Cond: (productid = pd.productid)
Planning time : 35.295 ms
Execution time : 7,616.672 ms