explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GiW9

Settings
# exclusive inclusive rows x rows loops node
1. 3.726 12,892.889 ↑ 1.4 42 1

Hash Left Join (cost=122,306.31..906,243.03 rows=58 width=7,313) (actual time=6,184.756..12,892.889 rows=42 loops=1)

  • Hash Cond: (sbd.action = pa.productactionid)
2. 0.175 6,046.749 ↑ 1.4 42 1

Hash Left Join (cost=122,305.11..128,148.89 rows=58 width=10,157) (actual time=6,037.064..6,046.749 rows=42 loops=1)

  • Hash Cond: (qi.status = qits.itemstatusid)
3. 0.257 6,046.549 ↑ 1.4 42 1

Nested Loop Left Join (cost=122,304.00..128,147.55 rows=58 width=10,157) (actual time=6,037.029..6,046.549 rows=42 loops=1)

4. 0.311 6,045.494 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,303.58..127,333.50 rows=29 width=9,939) (actual time=6,036.993..6,045.494 rows=42 loops=1)

5. 0.252 6,044.595 ↓ 1.4 42 1

Hash Left Join (cost=122,303.29..127,321.58 rows=29 width=8,907) (actual time=6,036.955..6,044.595 rows=42 loops=1)

  • Hash Cond: (q.status = qs.quotationstatusid)
6. 0.243 6,044.286 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,301.75..127,319.91 rows=29 width=8,689) (actual time=6,036.879..6,044.286 rows=42 loops=1)

7. 0.268 6,044.001 ↓ 1.4 42 1

Nested Loop Left Join (cost=122,301.61..127,314.88 rows=29 width=8,689) (actual time=6,036.871..6,044.001 rows=42 loops=1)

8. 0.254 6,043.271 ↓ 1.4 42 1

Hash Join (cost=122,301.46..127,309.86 rows=29 width=8,689) (actual time=6,036.847..6,043.271 rows=42 loops=1)

  • Hash Cond: (sbd.status = ps.productstatusid)
9. 0.328 6,042.901 ↑ 23.3 48 1

Nested Loop Left Join (cost=122,299.97..127,304.12 rows=1,119 width=8,471) (actual time=6,036.714..6,042.901 rows=48 loops=1)

10. 0.302 6,041.805 ↑ 23.3 48 1

Nested Loop Left Join (cost=122,299.69..126,887.66 rows=1,119 width=8,451) (actual time=6,036.676..6,041.805 rows=48 loops=1)

11. 240.441 6,040.639 ↑ 23.3 48 1

Hash Right Join (cost=122,299.40..126,483.76 rows=1,119 width=8,431) (actual time=6,036.632..6,040.639 rows=48 loops=1)

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

13. 0.109 5,588.146 ↑ 17.4 17 1

Hash (cost=122,295.71..122,295.71 rows=295 width=8,350) (actual time=5,588.146..5,588.146 rows=17 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 15kB
14. 0.086 5,588.037 ↑ 17.4 17 1

Hash Left Join (cost=91,479.63..122,295.71 rows=295 width=8,350) (actual time=5,166.242..5,588.037 rows=17 loops=1)

  • Hash Cond: ((pd.seasonclient = sc.seasonclientid) AND (pd.client = sc.clientid))
15. 0.114 5,586.903 ↑ 17.4 17 1

Nested Loop Left Join (cost=91,458.85..122,272.71 rows=295 width=8,370) (actual time=5,165.172..5,586.903 rows=17 loops=1)

16. 87.091 5,586.483 ↑ 17.4 17 1

Nested Loop (cost=91,458.57..122,173.42 rows=295 width=8,262) (actual time=5,165.108..5,586.483 rows=17 loops=1)

  • Join Filter: (pd.client = c.clientid)
  • Rows Removed by Join Filter: 26,836
17. 0.049 0.049 ↑ 1.0 1 1

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

  • Index Cond: (companyshort = 'SVH'::text)
  • Heap Fetches: 1
18. 81.731 5,499.343 ↓ 1.0 26,853 1

Hash Left Join (cost=91,458.42..121,824.94 rows=26,851 width=8,242) (actual time=4,936.011..5,499.343 rows=26,853 loops=1)

  • Hash Cond: (sbd.sustainability = sa.sustainabilityid)
19. 131.427 5,417.563 ↓ 1.0 26,853 1

Hash Left Join (cost=91,457.02..121,698.68 rows=26,851 width=8,044) (actual time=4,935.953..5,417.563 rows=26,853 loops=1)

  • Hash Cond: (md.shellweightunit = swu.weightunitid)
20. 270.054 5,286.084 ↓ 1.0 26,853 1

Hash Right Join (cost=91,455.52..121,566.95 rows=26,851 width=7,846) (actual time=4,935.881..5,286.084 rows=26,853 loops=1)

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

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

22. 249.729 4,935.516 ↓ 1.0 26,853 1

Hash (cost=67,781.89..67,781.89 rows=26,851 width=7,092) (actual time=4,935.515..4,935.516 rows=26,853 loops=1)

  • Buckets: 1,024 Batches: 64 Memory Usage: 135kB
23. 201.752 4,685.787 ↓ 1.0 26,853 1

Hash Left Join (cost=31.37..67,781.89 rows=26,851 width=7,092) (actual time=1.472..4,685.787 rows=26,853 loops=1)

  • Hash Cond: (sbd.packaging = packaging.packagingid)
24. 132.756 4,483.966 ↓ 1.0 26,853 1

Hash Left Join (cost=29.58..67,632.42 rows=26,851 width=7,080) (actual time=1.392..4,483.966 rows=26,853 loops=1)

  • Hash Cond: (sbd.wittmkz = mkz.smmkzid)
25. 232.861 4,350.749 ↓ 1.0 26,853 1

Nested Loop Left Join (cost=20.51..67,254.14 rows=26,851 width=6,346) (actual time=0.924..4,350.749 rows=26,853 loops=1)

26. 123.768 3,849.358 ↓ 1.0 26,853 1

Nested Loop Left Join (cost=20.22..56,560.95 rows=26,851 width=5,798) (actual time=0.902..3,849.358 rows=26,853 loops=1)

27. 253.184 3,483.913 ↓ 1.0 26,853 1

Nested Loop Left Join (cost=19.93..45,867.76 rows=26,851 width=5,250) (actual time=0.898..3,483.913 rows=26,853 loops=1)

28. 176.288 2,881.640 ↓ 1.0 26,853 1

Nested Loop Left Join (cost=19.64..35,174.56 rows=26,851 width=4,702) (actual time=0.895..2,881.640 rows=26,853 loops=1)

29. 183.479 2,651.646 ↓ 1.0 26,853 1

Nested Loop Left Join (cost=19.35..24,481.37 rows=26,851 width=4,174) (actual time=0.890..2,651.646 rows=26,853 loops=1)

30. 115.089 2,065.372 ↓ 1.0 26,853 1

Hash Left Join (cost=19.06..13,788.18 rows=26,851 width=3,626) (actual time=0.855..2,065.372 rows=26,853 loops=1)

  • Hash Cond: (sbd.calculationsizeoption = calculationsizeoption.calculationsizeoptionid)
31. 87.789 1,950.245 ↓ 1.0 26,853 1

Hash Left Join (cost=17.70..13,664.65 rows=26,851 width=3,428) (actual time=0.811..1,950.245 rows=26,853 loops=1)

  • Hash Cond: (sbd.subbrandcategory = subbrandcategory.subbrandcategoryid)
32. 65.126 1,862.422 ↓ 1.0 26,853 1

Hash Left Join (cost=16.52..13,552.04 rows=26,851 width=3,416) (actual time=0.769..1,862.422 rows=26,853 loops=1)

  • Hash Cond: (sbd.styleorigin = styleorigin.styleoriginid)
33. 72.971 1,797.262 ↓ 1.0 26,853 1

Hash Left Join (cost=15.23..13,432.60 rows=26,851 width=3,404) (actual time=0.728..1,797.262 rows=26,853 loops=1)

  • Hash Cond: (sbd.assortment = assortment.assortmentid)
34. 103.088 1,724.274 ↓ 1.0 26,853 1

Hash Left Join (cost=14.18..13,328.18 rows=26,851 width=3,392) (actual time=0.705..1,724.274 rows=26,853 loops=1)

  • Hash Cond: (sbd.seasonname = seasonname.seasonnameid)
35. 124.019 1,621.139 ↓ 1.0 26,853 1

Hash Left Join (cost=12.73..13,199.18 rows=26,851 width=3,162) (actual time=0.652..1,621.139 rows=26,853 loops=1)

  • Hash Cond: (sbd.bodyshapetype = bodyshapetype.bodyshapetypeid)
36. 66.235 1,497.056 ↓ 1.0 26,853 1

Hash Left Join (cost=11.01..13,053.81 rows=26,851 width=3,150) (actual time=0.581..1,497.056 rows=26,853 loops=1)

  • Hash Cond: (sbd.subbrand = subbrand.subbrandid)
37. 226.000 1,430.806 ↓ 1.0 26,853 1

Hash Left Join (cost=9.99..12,950.76 rows=26,851 width=3,138) (actual time=0.557..1,430.806 rows=26,853 loops=1)

  • Hash Cond: ((sbd.package)::text = (packageoption.packageoptionid)::text)
38. 187.477 1,204.776 ↓ 1.0 26,853 1

Hash Left Join (cost=8.90..12,776.48 rows=26,851 width=3,138) (actual time=0.511..1,204.776 rows=26,853 loops=1)

  • Hash Cond: (sbd.fashionlevel = fashionlevel.fashionlevelid)
39. 123.459 1,017.262 ↓ 1.0 26,853 1

Hash Left Join (cost=7.79..12,667.97 rows=26,851 width=3,126) (actual time=0.452..1,017.262 rows=26,853 loops=1)

  • Hash Cond: (sbd.tactemplate = template.templateid)
40. 123.495 893.725 ↓ 1.0 26,853 1

Hash Left Join (cost=5.87..12,510.31 rows=26,851 width=2,928) (actual time=0.365..893.725 rows=26,853 loops=1)

  • Hash Cond: (sbd.genre = genre.genreid)
41. 287.312 769.926 ↓ 1.0 26,853 1

Nested Loop (cost=0.29..12,190.58 rows=26,851 width=2,710) (actual time=0.052..769.926 rows=26,853 loops=1)

42. 26.113 26.113 ↓ 1.0 26,853 1

Seq Scan on sourcerbriefingdetails sbd (cost=0.00..1,196.51 rows=26,851 width=1,710) (actual time=0.012..26.113 rows=26,853 loops=1)

43. 456.501 456.501 ↑ 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.016..0.017 rows=1 loops=26,853)

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 16kB
45. 0.164 0.164 ↑ 1.0 159 1

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

46. 0.039 0.078 ↑ 1.0 41 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
47. 0.039 0.039 ↑ 1.0 41 1

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

48. 0.008 0.037 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=52) (actual time=0.036..0.037 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
49. 0.029 0.029 ↑ 1.0 5 1

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

50. 0.014 0.030 ↑ 1.0 4 1

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

  • Buckets: 1,024 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.015 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
53. 0.012 0.012 ↑ 1.0 1 1

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

54. 0.030 0.064 ↑ 1.0 32 1

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

  • Buckets: 1,024 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.023 0.047 ↑ 1.0 20 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
57. 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)

58. 0.006 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: 1,024 Batches: 1 Memory Usage: 9kB
59. 0.011 0.011 ↑ 1.0 2 1

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

60. 0.014 0.034 ↑ 1.0 13 1

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

  • Buckets: 1,024 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.013 0.034 ↓ 1.6 13 1

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

  • Buckets: 1,024 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.018 0.038 ↑ 1.0 16 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
65. 0.020 0.020 ↑ 1.0 16 1

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

66. 402.795 402.795 ↑ 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.012..0.015 rows=1 loops=26,853)

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

  • Index Cond: (ldapusermappingid = sbd.qa)
69. 241.677 241.677 ↑ 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.008..0.009 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.009..0.010 rows=1 loops=26,853)

  • Index Cond: (ldapusermappingid = sbd.rebuying)
71. 0.254 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: 1,024 Batches: 1 Memory Usage: 25kB
72. 0.207 0.207 ↑ 1.0 270 1

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

73. 0.033 0.069 ↑ 1.0 35 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
74. 0.036 0.036 ↑ 1.0 35 1

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

75. 0.021 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: 1,024 Batches: 1 Memory Usage: 10kB
76. 0.031 0.031 ↑ 1.0 22 1

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

77. 0.023 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: 1,024 Batches: 1 Memory Usage: 9kB
78. 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.017..0.026 rows=18 loops=1)

79. 0.306 0.306 ↑ 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.018 rows=1 loops=17)

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 37kB
81. 0.470 0.470 ↑ 1.0 591 1

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

82. 0.864 0.864 ↑ 1.0 1 48

Index Scan using pk_clients on dbclientsupplier cs (cost=0.29..0.35 rows=1 width=60) (actual time=0.016..0.018 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.006 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: 1,024 Batches: 1 Memory Usage: 9kB
85. 0.110 0.110 ↓ 4.0 4 1

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

  • Filter: ((code)::text ~~* 'Free for Quotation'::text)
  • Rows Removed by Filter: 34
86. 0.462 0.462 ↑ 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.011 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.029 0.057 ↑ 1.0 24 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
89. 0.028 0.028 ↑ 1.0 24 1

Seq Scan on quotationstatus qs (cost=0.00..1.24 rows=24 width=238) (actual time=0.012..0.028 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.798 0.798 ↑ 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.019 rows=1 loops=42)

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

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
93. 0.017 0.017 ↑ 1.0 5 1

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

94. 0.011 0.026 ↑ 1.0 9 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
95. 0.015 0.015 ↑ 1.0 9 1

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

96.          

SubPlan (for Hash Left Join)

97. 0.378 1.092 ↑ 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.026 rows=1 loops=42)

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

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

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

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

100. 11.676 2,332.554 ↑ 257.0 1 42

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

  • Sort Key: dbsmfabric.code
  • Sort Method: quicksort Memory: 25kB
101. 0.519 2,320.878 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51,265
103. 1.480 2.715 ↑ 1.0 1,702 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 96kB
104. 1.235 1.235 ↑ 1.0 1,702 1

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

105. 0.252 2,310.924 ↑ 46.0 1 42

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

106. 0.588 2,310.672 ↑ 257.0 1 42

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

  • Sort Key: ft.en
  • Sort Method: quicksort Memory: 25kB
107. 0.591 2,310.084 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51,265
109. 0.049 0.123 ↑ 1.0 46 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
110. 0.074 0.074 ↑ 1.0 46 1

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

111. 0.336 2,196.684 ↑ 29.0 1 42

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

112. 0.588 2,196.348 ↑ 257.0 1 42

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

  • Sort Key: cam.en
  • Sort Method: quicksort Memory: 25kB
113. 0.516 2,195.760 ↑ 257.0 1 42

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

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

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

  • Filter: (productid = pd.productid)
  • Rows Removed by Filter: 51,265
115. 0.035 0.072 ↓ 1.0 30 1

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

  • Buckets: 1,024 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.017..0.037 rows=30 loops=1)

117. 0.252 0.840 ↓ 0.0 0 42

Bitmap Heap Scan on productstatususer psu (cost=4.42..30.40 rows=18 width=20) (actual time=0.020..0.020 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 : 113.326 ms
Execution time : 12,895.296 ms