explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l4Ki

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=801,831,301.31..896,942,927.50 rows=53,887,607 width=1,760) (actual rows= loops=)

  • Group Key: a.branch_bkey, a.dbranch_bkey, a.calendardate_bkey, a.comyoycalendardate_bkey, a.supplier_bkey, a.productrange_bkey, a.cover_material_code, a.cover_material_description, a.exclusivebrands_bkey, a.core64_bkey, a.der_hybrid_productstyletypecode, a.der_hybrid_productstyletype, (CASE WHEN (a.der_hybrid_productstyletypecode = 'UP'::text) THEN 'Y'::text ELSE 'N'::text END), (CASE WHEN (a.core64_bkey > '0'::numeric) THEN 'Y'::text ELSE 'N'::text END), a.product_flag
  • Functions: 954
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
2. 0.000 0.000 ↓ 0.0

Sort (cost=801,831,301.31..803,178,491.48 rows=538,876,069 width=1,720) (actual rows= loops=)

  • Sort Key: a.branch_bkey, a.dbranch_bkey, a.calendardate_bkey, a.comyoycalendardate_bkey, a.supplier_bkey, a.productrange_bkey, a.cover_material_code, a.cover_material_description, a.exclusivebrands_bkey, a.core64_bkey, a.der_hybrid_productstyletypecode, a.der_hybrid_productstyletype, (CASE WHEN (a.der_hybrid_productstyletypecode = 'UP'::text) THEN 'Y'::text ELSE 'N'::text END), (CASE WHEN (a.core64_bkey > '0'::numeric) THEN 'Y'::text ELSE 'N'::text END), a.product_flag
3. 0.000 0.000 ↓ 0.0

Subquery Scan on a (cost=20,275,848.91..253,320,957.77 rows=538,876,069 width=1,720) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Append (cost=20,275,848.91..245,237,816.74 rows=538,876,069 width=1,656) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Result (cost=20,275,848.91..232,682,134.63 rows=535,102,327 width=1,656) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Append (cost=20,275,848.91..216,629,064.82 rows=535,102,327 width=1,432) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Result (cost=20,275,848.91..203,842,963.45 rows=529,553,150 width=1,432) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Append (cost=20,275,848.91..187,956,368.95 rows=529,553,150 width=1,208) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Result (cost=20,275,848.91..175,583,597.87 rows=523,855,725 width=1,208) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Append (cost=20,275,848.91..159,867,926.12 rows=523,855,725 width=984) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=20,275,848.91..146,692,419.19 rows=515,566,503 width=954) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Gather (cost=20,275,848.91..131,225,424.10 rows=515,566,503 width=730) (actual rows= loops=)

  • Workers Planned: 8
  • Params Evaluated: $1
13.          

Initplan (for Gather)

14. 0.000 0.000 ↓ 0.0

Result (cost=12.36..12.37 rows=1 width=4) (actual rows= loops=)

15.          

Initplan (for Result)

16. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..12.36 rows=1 width=4) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 (cost=0.28..422.90 rows=35 width=4) (actual rows= loops=)

  • Index Cond: (cal_date IS NOT NULL)
  • Filter: (cal_rel_delivery_period = '-6'::integer)
18. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=20,274,836.54..79,667,761.43 rows=64,445,813 width=730) (actual rows= loops=)

  • Merge Cond: (("left"(((pr.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr.re_rep_prd_rng_desc)::text || '('::text)) - 1))) = (cpty.ty_range)::text)
  • Join Filter: ((c.cal_date >= cpty.ty_date_from) AND (c.cal_date <= cpty.ty_date_to))
19. 0.000 0.000 ↓ 0.0

Sort (cost=20,272,778.69..20,391,034.72 rows=47,302,415 width=187) (actual rows= loops=)

  • Sort Key: ("left"(((pr.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr.re_rep_prd_rng_desc)::text || '('::text)) - 1)))
20. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,437,249.07..11,685,980.64 rows=47,302,415 width=187) (actual rows= loops=)

  • Hash Cond: (((pr.pt_description)::bpchar = pac64.value) AND (oh.oh_company = pac64.company))
21. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=2,437,199.48..9,785,858.52 rows=47,302,415 width=141) (actual rows= loops=)

  • Hash Cond: ((od.od_company = (s.sm_company)::bpchar) AND (od.od_supp_cd = (s.sm_supp_cd)::bpchar))
22. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,433,236.06..9,232,290.89 rows=47,302,415 width=152) (actual rows= loops=)

  • Hash Cond: ((prn.productrangefamilyoriginaldesc)::text = (e.range)::text)
  • Join Filter: ((c.cal_date >= e.exclusivedatefrom) AND (c.cal_date <= e.exclusivedateto))
23. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=2,433,228.63..8,981,009.78 rows=47,302,415 width=156) (actual rows= loops=)

  • Hash Cond: (os.oh_bi_order_date = ca.datety)
24. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=2,431,695.84..8,621,614.43 rows=47,302,415 width=152) (actual rows= loops=)

  • Hash Cond: ((od.od_company = (pr.pm_company)::bpchar) AND (od.od_prod_cd = (pr.pm_prod_code)::bpchar))
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,331,394.45..8,048,289.18 rows=47,302,415 width=101) (actual rows= loops=)

  • Hash Cond: (os.oh_bi_order_date = c.cal_date)
26. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,331,231.18..7,663,001.21 rows=146,616,810 width=97) (actual rows= loops=)

  • Hash Cond: ((od.oh_ord_no = oh.oh_ord_no) AND (od.od_company = oh.oh_company))
27. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,503.16..5,275,994.91 rows=5,135,486 width=95) (actual rows= loops=)

  • Hash Cond: ((od.od_company = db.br_company) AND (od.od_branch_ref = db.br_branch))
28. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,251.58..5,244,453.73 rows=5,154,285 width=88) (actual rows= loops=)

  • Hash Cond: ((od.od_company = b.br_company) AND (od.od_branch_id = b.br_branch))
29. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on f_orderdetail_preload od (cost=0.00..5,212,812.62 rows=5,173,162 width=85) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch b (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch db (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=2,287,246.86..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.46..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

  • Hash Cond: (os.oh_bi_order_status = (ohs.os_order_status_id)::numeric)
36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,251,764.36 rows=2,365,411 width=38) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using f_ohsbo_preload_idx1 on f_orderheadersummarybyorder_preload os (cost=0.56..375,300.13 rows=2,365,411 width=19) (actual rows= loops=)

  • Index Cond: (oh_bi_order_status = ANY ('{100,420,500,800,999}'::numeric[]))
38. 0.000 0.000 ↓ 0.0

Index Scan using f_orderheader_preload_oh_ord_no_idx2 on f_orderheader_preload oh (cost=0.56..0.78 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (oh_ord_no = os.oh_ord_no)
39. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=15 width=4) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Seq Scan on dim_orderheaderstatus ohs (cost=0.00..1.15 rows=15 width=4) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash (cost=137.53..137.53 rows=2,059 width=4) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dim_calendar_v2 on dim_calendar_v2 c (cost=0.28..137.53 rows=2,059 width=4) (actual rows= loops=)

  • Index Cond: (cal_date >= $1)
43. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=99,414.55..99,414.55 rows=59,123 width=77) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=16,897.72..99,414.55 rows=59,123 width=77) (actual rows= loops=)

  • Hash Cond: (((pr.pm_ptyp)::text = (prn.producttypecode)::text) AND ((pr.pg_prd_rng_cd)::text = (prn.productrangecode)::text) AND ((pr.der_productsubfamily)::text = (prn.der_productsubfamily)::text))
45. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_product pr (cost=0.00..82,051.23 rows=59,123 width=67) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=16,644.80..16,644.80 rows=14,453 width=39) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Parallel Index Scan using pk_dim_productrange on dim_productrange prn (cost=0.29..16,644.80 rows=14,453 width=39) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,502.35..1,502.35 rows=2,435 width=8) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_campaigncalendar ca (cost=0.00..1,502.35 rows=2,435 width=8) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=241 width=21) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Seq Scan on dim_exclusivebrands e (cost=0.00..4.41 rows=241 width=21) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=3,954.77..3,954.77 rows=577 width=16) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_supplier s (cost=0.00..3,954.77 rows=577 width=16) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Hash (cost=49.39..49.39 rows=14 width=55) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Seq Scan on productattributes pac64 (cost=0.00..49.39 rows=14 width=55) (actual rows= loops=)

  • Filter: (usagetypeid = '5'::numeric)
56. 0.000 0.000 ↓ 0.0

Sort (cost=2,057.85..2,102.70 rows=17,939 width=21) (actual rows= loops=)

  • Sort Key: cpty.ty_range
57. 0.000 0.000 ↓ 0.0

Seq Scan on dim_core64v2 cpty (cost=0.00..790.39 rows=17,939 width=21) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=8,524,562.42..10,556,228.30 rows=8,289,222 width=954) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Gather (cost=8,524,562.42..10,307,551.64 rows=8,289,222 width=730) (actual rows= loops=)

  • Workers Planned: 8
  • Params Evaluated: $3
60.          

Initplan (for Gather)

61. 0.000 0.000 ↓ 0.0

Result (cost=12.36..12.37 rows=1 width=4) (actual rows= loops=)

62.          

Initplan (for Result)

63. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..12.36 rows=1 width=4) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 dim_calendar_v2_1 (cost=0.28..422.90 rows=35 width=4) (actual rows= loops=)

  • Index Cond: (cal_date IS NOT NULL)
  • Filter: (cal_rel_delivery_period = '-6'::integer)
65. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,523,550.05..9,477,617.08 rows=1,036,153 width=730) (actual rows= loops=)

  • Merge Cond: (("left"(((pr_1.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr_1.re_rep_prd_rng_desc)::text || '('::text)) - 1))) = (cpty_1.ly_range)::text)
  • Join Filter: ((c_1.cal_date >= cpty_1.ty_date_from) AND (c_1.cal_date <= cpty_1.ty_date_to))
66. 0.000 0.000 ↓ 0.0

Sort (cost=8,521,492.20..8,523,272.64 rows=712,178 width=191) (actual rows= loops=)

  • Sort Key: ("left"(((pr_1.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr_1.re_rep_prd_rng_desc)::text || '('::text)) - 1)))
67. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,406,000.01..8,452,261.81 rows=712,178 width=191) (actual rows= loops=)

  • Hash Cond: (((pr_1.pt_description)::bpchar = pac64_1.value) AND (oh_1.oh_company = pac64_1.company))
68. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,405,950.41..8,423,605.01 rows=712,178 width=145) (actual rows= loops=)

  • Merge Cond: ((od_1.od_company = (s_1.sm_company)::bpchar) AND (od_1.od_supp_cd = (s_1.sm_supp_cd)::bpchar))
69. 0.000 0.000 ↓ 0.0

Sort (cost=8,401,915.37..8,403,695.81 rows=712,178 width=156) (actual rows= loops=)

  • Sort Key: od_1.od_company, od_1.od_supp_cd
70. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,433,075.21..8,332,684.98 rows=712,178 width=156) (actual rows= loops=)

  • Hash Cond: ((prn_1.productrangefamilyoriginaldesc)::text = (e_1.range)::text)
  • Join Filter: ((c_1.cal_yoy_date >= e_1.exclusivedatefrom) AND (c_1.cal_yoy_date <= e_1.exclusivedateto))
71. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=2,433,067.79..8,328,894.41 rows=712,178 width=160) (actual rows= loops=)

  • Hash Cond: ((od_1.od_company = (pr_1.pm_company)::bpchar) AND (od_1.od_prod_cd = (pr_1.pm_prod_code)::bpchar))
72. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,332,766.40..8,221,471.24 rows=712,178 width=109) (actual rows= loops=)

  • Hash Cond: (os_1.oh_bi_order_date = c_1.cal_yoy_date)
73. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,331,231.18..7,663,001.21 rows=146,616,810 width=97) (actual rows= loops=)

  • Hash Cond: ((od_1.oh_ord_no = oh_1.oh_ord_no) AND (od_1.od_company = oh_1.oh_company))
74. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,503.16..5,275,994.91 rows=5,135,486 width=95) (actual rows= loops=)

  • Hash Cond: ((od_1.od_company = db_1.br_company) AND (od_1.od_branch_ref = db_1.br_branch))
75. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,251.58..5,244,453.73 rows=5,154,285 width=88) (actual rows= loops=)

  • Hash Cond: ((od_1.od_company = b_1.br_company) AND (od_1.od_branch_id = b_1.br_branch))
76. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on f_orderdetail_preload od_1 (cost=0.00..5,212,812.62 rows=5,173,162 width=85) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch b_1 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch db_1 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=2,287,246.86..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.46..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

  • Hash Cond: (os_1.oh_bi_order_status = (ohs_1.os_order_status_id)::numeric)
83. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,251,764.36 rows=2,365,411 width=38) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using f_ohsbo_preload_idx1 on f_orderheadersummarybyorder_preload os_1 (cost=0.56..375,300.13 rows=2,365,411 width=19) (actual rows= loops=)

  • Index Cond: (oh_bi_order_status = ANY ('{100,420,500,800,999}'::numeric[]))
85. 0.000 0.000 ↓ 0.0

Index Scan using f_orderheader_preload_oh_ord_no_idx2 on f_orderheader_preload oh_1 (cost=0.56..0.78 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (oh_ord_no = os_1.oh_ord_no)
86. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=15 width=4) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Seq Scan on dim_orderheaderstatus ohs_1 (cost=0.00..1.15 rows=15 width=4) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash (cost=1,534.83..1,534.83 rows=31 width=12) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=4.55..1,534.83 rows=31 width=12) (actual rows= loops=)

  • Hash Cond: (ca_1.datety = c_1.cal_date)
90. 0.000 0.000 ↓ 0.0

Seq Scan on dim_campaigncalendar ca_1 (cost=0.00..1,519.40 rows=4,140 width=8) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=4.17..4.17 rows=31 width=8) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 c_1 (cost=0.29..4.17 rows=31 width=8) (actual rows= loops=)

  • Index Cond: ((cal_date >= $3) AND (cal_date < LOCALTIMESTAMP))
93. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=99,414.55..99,414.55 rows=59,123 width=77) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=16,897.72..99,414.55 rows=59,123 width=77) (actual rows= loops=)

  • Hash Cond: (((pr_1.pm_ptyp)::text = (prn_1.producttypecode)::text) AND ((pr_1.pg_prd_rng_cd)::text = (prn_1.productrangecode)::text) AND ((pr_1.der_productsubfamily)::text = (prn_1.der_productsubfamily)::text))
95. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_product pr_1 (cost=0.00..82,051.23 rows=59,123 width=67) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=16,644.80..16,644.80 rows=14,453 width=39) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Parallel Index Scan using pk_dim_productrange on dim_productrange prn_1 (cost=0.29..16,644.80 rows=14,453 width=39) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=241 width=21) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on dim_exclusivebrands e_1 (cost=0.00..4.41 rows=241 width=21) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Sort (cost=4,035.05..4,038.51 rows=1,384 width=16) (actual rows= loops=)

  • Sort Key: s_1.sm_company USING <, s_1.sm_supp_cd USING <
101. 0.000 0.000 ↓ 0.0

Seq Scan on dim_supplier s_1 (cost=0.00..3,962.84 rows=1,384 width=16) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Hash (cost=49.39..49.39 rows=14 width=55) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on productattributes pac64_1 (cost=0.00..49.39 rows=14 width=55) (actual rows= loops=)

  • Filter: (usagetypeid = '5'::numeric)
104. 0.000 0.000 ↓ 0.0

Sort (cost=2,057.85..2,102.70 rows=17,939 width=29) (actual rows= loops=)

  • Sort Key: cpty_1.ly_range
105. 0.000 0.000 ↓ 0.0

Seq Scan on dim_core64v2 cpty_1 (cost=0.00..790.39 rows=17,939 width=29) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 3 (cost=8,407,002.99..9,725,005.33 rows=5,697,425 width=1,178) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Gather (cost=8,407,002.99..9,425,890.52 rows=5,697,425 width=702) (actual rows= loops=)

  • Workers Planned: 8
  • Params Evaluated: $5
108.          

Initplan (for Gather)

109. 0.000 0.000 ↓ 0.0

Result (cost=12.36..12.37 rows=1 width=4) (actual rows= loops=)

110.          

Initplan (for Result)

111. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..12.36 rows=1 width=4) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 dim_calendar_v2_2 (cost=0.28..422.90 rows=35 width=4) (actual rows= loops=)

  • Index Cond: (cal_date IS NOT NULL)
  • Filter: (cal_rel_delivery_period = '-6'::integer)
113. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=8,405,990.62..8,855,135.65 rows=712,178 width=702) (actual rows= loops=)

  • Hash Cond: ((od_2.od_company = (s_2.sm_company)::bpchar) AND (od_2.od_supp_cd = (s_2.sm_supp_cd)::bpchar))
114. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,402,027.20..8,407,578.67 rows=712,178 width=188) (actual rows= loops=)

  • Merge Cond: ((oh_2.oh_company = pac64_2.company) AND ((pr_2.pt_description)::bpchar = pac64_2.value))
115. 0.000 0.000 ↓ 0.0

Sort (cost=8,401,977.55..8,403,757.99 rows=712,178 width=142) (actual rows= loops=)

  • Sort Key: od_2.od_company, pr_2.pt_description USING <
116. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=2,433,137.39..8,332,747.16 rows=712,178 width=142) (actual rows= loops=)

  • Hash Cond: ((prn_2.productrangefamilyoriginaldesc)::text = (e_2.range)::text)
  • Join Filter: ((c2.cal_yoy_date >= e_2.exclusivedatefrom) AND (c2.cal_yoy_date <= e_2.exclusivedateto))
117. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=2,433,129.97..8,328,956.59 rows=712,178 width=150) (actual rows= loops=)

  • Hash Cond: ((od_2.od_company = (pr_2.pm_company)::bpchar) AND (od_2.od_prod_cd = (pr_2.pm_prod_code)::bpchar))
118. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,332,828.58..8,221,533.42 rows=712,178 width=109) (actual rows= loops=)

  • Hash Cond: (os_2.oh_bi_order_date = c2.cal_yoy_date)
119. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,331,231.18..7,663,001.21 rows=146,616,810 width=97) (actual rows= loops=)

  • Hash Cond: ((od_2.oh_ord_no = oh_2.oh_ord_no) AND (od_2.od_company = oh_2.oh_company))
120. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,503.16..5,275,994.91 rows=5,135,486 width=95) (actual rows= loops=)

  • Hash Cond: ((od_2.od_company = db_2.br_company) AND (od_2.od_branch_ref = db_2.br_branch))
121. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,251.58..5,244,453.73 rows=5,154,285 width=88) (actual rows= loops=)

  • Hash Cond: ((od_2.od_company = b_2.br_company) AND (od_2.od_branch_id = b_2.br_branch))
122. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on f_orderdetail_preload od_2 (cost=0.00..5,212,812.62 rows=5,173,162 width=85) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch b_2 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch db_2 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=2,287,246.86..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.46..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

  • Hash Cond: (os_2.oh_bi_order_status = (ohs_2.os_order_status_id)::numeric)
129. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,251,764.36 rows=2,365,411 width=38) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using f_ohsbo_preload_idx1 on f_orderheadersummarybyorder_preload os_2 (cost=0.56..375,300.13 rows=2,365,411 width=19) (actual rows= loops=)

  • Index Cond: (oh_bi_order_status = ANY ('{100,420,500,800,999}'::numeric[]))
131. 0.000 0.000 ↓ 0.0

Index Scan using f_orderheader_preload_oh_ord_no_idx2 on f_orderheader_preload oh_2 (cost=0.56..0.78 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (oh_ord_no = os_2.oh_ord_no)
132. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=15 width=4) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Seq Scan on dim_orderheaderstatus ohs_2 (cost=0.00..1.15 rows=15 width=4) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Hash (cost=1,597.01..1,597.01 rows=31 width=12) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.92..1,597.01 rows=31 width=12) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=4.63..1,534.91 rows=31 width=12) (actual rows= loops=)

  • Hash Cond: (ca_2.datety = c1.cal_date)
137. 0.000 0.000 ↓ 0.0

Seq Scan on dim_campaigncalendar ca_2 (cost=0.00..1,519.40 rows=4,140 width=8) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Hash (cost=4.25..4.25 rows=31 width=8) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 c1 (cost=0.29..4.25 rows=31 width=8) (actual rows= loops=)

  • Index Cond: ((cal_date <= LOCALTIMESTAMP) AND (cal_date >= $5) AND (cal_date < LOCALTIMESTAMP))
140. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 c2 (cost=0.28..2.00 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (cal_date = c1.cal_yoy_date)
141. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=99,414.55..99,414.55 rows=59,123 width=67) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Parallel Hash Left Join (cost=16,897.72..99,414.55 rows=59,123 width=67) (actual rows= loops=)

  • Hash Cond: (((pr_2.pm_ptyp)::text = (prn_2.producttypecode)::text) AND ((pr_2.pg_prd_rng_cd)::text = (prn_2.productrangecode)::text) AND ((pr_2.der_productsubfamily)::text = (prn_2.der_productsubfamily)::text))
143. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_product pr_2 (cost=0.00..82,051.23 rows=59,123 width=57) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=16,644.80..16,644.80 rows=14,453 width=39) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Parallel Index Scan using pk_dim_productrange on dim_productrange prn_2 (cost=0.29..16,644.80 rows=14,453 width=39) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=241 width=21) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Seq Scan on dim_exclusivebrands e_2 (cost=0.00..4.41 rows=241 width=21) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Sort (cost=49.65..49.69 rows=14 width=55) (actual rows= loops=)

  • Sort Key: pac64_2.company, pac64_2.value
149. 0.000 0.000 ↓ 0.0

Seq Scan on productattributes pac64_2 (cost=0.00..49.39 rows=14 width=55) (actual rows= loops=)

  • Filter: (usagetypeid = '5'::numeric)
150. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=3,954.77..3,954.77 rows=577 width=16) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_supplier s_2 (cost=0.00..3,954.77 rows=577 width=16) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 4 (cost=8,528,534.54..10,110,589.74 rows=5,549,177 width=1,402) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Gather (cost=8,528,534.54..9,722,147.35 rows=5,549,177 width=730) (actual rows= loops=)

  • Workers Planned: 8
  • Params Evaluated: $7
154.          

Initplan (for Gather)

155. 0.000 0.000 ↓ 0.0

Result (cost=12.36..12.37 rows=1 width=4) (actual rows= loops=)

156.          

Initplan (for Result)

157. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..12.36 rows=1 width=4) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 dim_calendar_v2_3 (cost=0.28..422.90 rows=35 width=4) (actual rows= loops=)

  • Index Cond: (cal_date IS NOT NULL)
  • Filter: (cal_rel_delivery_period = '-6'::integer)
159. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,527,522.17..9,166,217.28 rows=693,647 width=730) (actual rows= loops=)

  • Merge Cond: (("left"(((pr_3.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr_3.re_rep_prd_rng_desc)::text || '('::text)) - 1))) = (cpty_2.ly_range)::text)
  • Join Filter: ((c_2.cal_date >= cpty_2.ty_date_from) AND (c_2.cal_date <= cpty_2.ty_date_to))
160. 0.000 0.000 ↓ 0.0

Sort (cost=8,525,464.31..8,526,656.22 rows=476,764 width=187) (actual rows= loops=)

  • Sort Key: ("left"(((pr_3.re_rep_prd_rng_desc)::text || '('::text), (strpos('('::text, ((pr_3.re_rep_prd_rng_desc)::text || '('::text)) - 1)))
161. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,449,528.80..8,480,498.52 rows=476,764 width=187) (actual rows= loops=)

  • Hash Cond: (((pr_3.pt_description)::bpchar = pac64_3.value) AND (oh_3.oh_company = pac64_3.company))
162. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,449,479.20..8,461,297.97 rows=476,764 width=141) (actual rows= loops=)

  • Merge Cond: ((od_3.od_company = (s_3.sm_company)::bpchar) AND (od_3.od_supp_cd = (s_3.sm_supp_cd)::bpchar))
163. 0.000 0.000 ↓ 0.0

Sort (cost=8,445,444.15..8,446,636.06 rows=476,764 width=152) (actual rows= loops=)

  • Sort Key: od_3.od_company, od_3.od_supp_cd
164. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,386,026.70..8,400,478.36 rows=476,764 width=152) (actual rows= loops=)

  • Hash Cond: ((prn_3.productrangefamilyoriginaldesc)::text = (e_3.range)::text)
  • Join Filter: ((ca_3.dately >= e_3.exclusivedatefrom) AND (ca_3.dately <= e_3.exclusivedateto))
165. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,386,019.28..8,397,938.33 rows=476,764 width=156) (actual rows= loops=)

  • Merge Cond: ((od_3.od_company = (pr_3.pm_company)::bpchar) AND (od_3.od_prod_cd = (pr_3.pm_prod_code)::bpchar))
166. 0.000 0.000 ↓ 0.0

Sort (cost=8,262,047.53..8,263,239.44 rows=476,764 width=105) (actual rows= loops=)

  • Sort Key: od_3.od_company, od_3.od_prod_cd
167. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,332,744.63..8,217,081.73 rows=476,764 width=105) (actual rows= loops=)

  • Hash Cond: (os_3.oh_bi_order_date = ca_3.dately)
168. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,331,231.18..7,663,001.21 rows=146,616,810 width=97) (actual rows= loops=)

  • Hash Cond: ((od_3.oh_ord_no = oh_3.oh_ord_no) AND (od_3.od_company = oh_3.oh_company))
169. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,503.16..5,275,994.91 rows=5,135,486 width=95) (actual rows= loops=)

  • Hash Cond: ((od_3.od_company = db_3.br_company) AND (od_3.od_branch_ref = db_3.br_branch))
170. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,251.58..5,244,453.73 rows=5,154,285 width=88) (actual rows= loops=)

  • Hash Cond: ((od_3.od_company = b_3.br_company) AND (od_3.od_branch_id = b_3.br_branch))
171. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on f_orderdetail_preload od_3 (cost=0.00..5,212,812.62 rows=5,173,162 width=85) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch b_3 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch db_3 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=2,287,246.86..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.46..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

  • Hash Cond: (os_3.oh_bi_order_status = (ohs_3.os_order_status_id)::numeric)
178. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,251,764.36 rows=2,365,411 width=38) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using f_ohsbo_preload_idx1 on f_orderheadersummarybyorder_preload os_3 (cost=0.56..375,300.13 rows=2,365,411 width=19) (actual rows= loops=)

  • Index Cond: (oh_bi_order_status = ANY ('{100,420,500,800,999}'::numeric[]))
180. 0.000 0.000 ↓ 0.0

Index Scan using f_orderheader_preload_oh_ord_no_idx2 on f_orderheader_preload oh_3 (cost=0.56..0.78 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (oh_ord_no = os_3.oh_ord_no)
181. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=15 width=4) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Seq Scan on dim_orderheaderstatus ohs_3 (cost=0.00..1.15 rows=15 width=4) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,513.30..1,513.30 rows=12 width=8) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.55..1,513.30 rows=12 width=8) (actual rows= loops=)

  • Hash Cond: (ca_3.datety = c_2.cal_date)
185. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_campaigncalendar ca_3 (cost=0.00..1,502.35 rows=2,435 width=8) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Hash (cost=4.17..4.17 rows=31 width=4) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dim_calendar_v2 on dim_calendar_v2 c_2 (cost=0.29..4.17 rows=31 width=4) (actual rows= loops=)

  • Index Cond: ((cal_date >= $7) AND (cal_date < LOCALTIMESTAMP))
188. 0.000 0.000 ↓ 0.0

Sort (cost=123,971.75..124,562.98 rows=236,491 width=77) (actual rows= loops=)

  • Sort Key: pr_3.pm_company USING <, pr_3.pm_prod_code USING <
189. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,175.94..102,863.25 rows=236,491 width=77) (actual rows= loops=)

  • Hash Cond: (((pr_3.pm_ptyp)::text = (prn_3.producttypecode)::text) AND ((pr_3.pg_prd_rng_cd)::text = (prn_3.productrangecode)::text) AND ((pr_3.der_productsubfamily)::text = (prn_3.der_productsubfamily)::text))
190. 0.000 0.000 ↓ 0.0

Seq Scan on dim_product pr_3 (cost=0.00..83,824.91 rows=236,491 width=67) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Hash (cost=16,745.97..16,745.97 rows=24,570 width=39) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_productrange on dim_productrange prn_3 (cost=0.29..16,745.97 rows=24,570 width=39) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=241 width=21) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Seq Scan on dim_exclusivebrands e_3 (cost=0.00..4.41 rows=241 width=21) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Sort (cost=4,035.05..4,038.51 rows=1,384 width=16) (actual rows= loops=)

  • Sort Key: s_3.sm_company USING <, s_3.sm_supp_cd USING <
196. 0.000 0.000 ↓ 0.0

Seq Scan on dim_supplier s_3 (cost=0.00..3,962.84 rows=1,384 width=16) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Hash (cost=49.39..49.39 rows=14 width=55) (actual rows= loops=)

198. 0.000 0.000 ↓ 0.0

Seq Scan on productattributes pac64_3 (cost=0.00..49.39 rows=14 width=55) (actual rows= loops=)

  • Filter: (usagetypeid = '5'::numeric)
199. 0.000 0.000 ↓ 0.0

Sort (cost=2,057.85..2,102.70 rows=17,939 width=29) (actual rows= loops=)

  • Sort Key: cpty_2.ly_range
200. 0.000 0.000 ↓ 0.0

Seq Scan on dim_core64v2 cpty_2 (cost=0.00..790.39 rows=17,939 width=29) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 5 (cost=8,815,876.85..9,861,301.76 rows=3,773,742 width=1,626) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Gather (cost=8,815,876.85..9,512,230.63 rows=3,773,742 width=702) (actual rows= loops=)

  • Workers Planned: 8
  • Params Evaluated: $9
203.          

Initplan (for Gather)

204. 0.000 0.000 ↓ 0.0

Result (cost=12.36..12.37 rows=1 width=4) (actual rows= loops=)

205.          

Initplan (for Result)

206. 0.000 0.000 ↓ 0.0

Limit (cost=0.28..12.36 rows=1 width=4) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_calendar_v2 on dim_calendar_v2 dim_calendar_v2_4 (cost=0.28..422.90 rows=35 width=4) (actual rows= loops=)

  • Index Cond: (cal_date IS NOT NULL)
  • Filter: (cal_rel_delivery_period = '-6'::integer)
208. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,814,864.48..9,133,844.06 rows=471,718 width=702) (actual rows= loops=)

  • Hash Cond: (((pr_4.pt_description)::bpchar = pac64_4.value) AND (oh_4.oh_company = pac64_4.company))
209. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,814,814.88..8,826,508.57 rows=471,718 width=131) (actual rows= loops=)

  • Merge Cond: ((od_4.od_company = (s_4.sm_company)::bpchar) AND (od_4.od_supp_cd = (s_4.sm_supp_cd)::bpchar))
210. 0.000 0.000 ↓ 0.0

Sort (cost=8,810,779.84..8,811,959.13 rows=471,718 width=142) (actual rows= loops=)

  • Sort Key: od_4.od_company, od_4.od_supp_cd
211. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,752,027.46..8,766,326.16 rows=471,718 width=142) (actual rows= loops=)

  • Hash Cond: ((prn_4.productrangefamilyoriginaldesc)::text = (e_4.range)::text)
  • Join Filter: ((ca_4.datelly >= e_4.exclusivedatefrom) AND (ca_4.datelly <= e_4.exclusivedateto))
212. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=8,752,020.04..8,763,812.94 rows=471,718 width=150) (actual rows= loops=)

  • Merge Cond: ((od_4.od_company = (pr_4.pm_company)::bpchar) AND (od_4.od_prod_cd = (pr_4.pm_prod_code)::bpchar))
213. 0.000 0.000 ↓ 0.0

Sort (cost=8,628,048.28..8,629,227.58 rows=471,718 width=109) (actual rows= loops=)

  • Sort Key: od_4.od_company, od_4.od_prod_cd
214. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,332,744.63..8,583,594.61 rows=471,718 width=109) (actual rows= loops=)

  • Hash Cond: (os_4.oh_bi_order_date = ca_4.datelly)
215. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=2,331,231.18..7,663,001.21 rows=146,616,810 width=97) (actual rows= loops=)

  • Hash Cond: ((od_4.oh_ord_no = oh_4.oh_ord_no) AND (od_4.od_company = oh_4.oh_company))
216. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,503.16..5,275,994.91 rows=5,135,486 width=95) (actual rows= loops=)

  • Hash Cond: ((od_4.od_company = db_4.br_company) AND (od_4.od_branch_ref = db_4.br_branch))
217. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,251.58..5,244,453.73 rows=5,154,285 width=88) (actual rows= loops=)

  • Hash Cond: ((od_4.od_company = b_4.br_company) AND (od_4.od_branch_id = b_4.br_branch))
218. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on f_orderdetail_preload od_4 (cost=0.00..5,212,812.62 rows=5,173,162 width=85) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

220. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch b_4 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Hash (cost=4,247.47..4,247.47 rows=274 width=13) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_branch on dim_branch db_4 (cost=0.27..4,247.47 rows=274 width=13) (actual rows= loops=)

223. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=2,287,246.86..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.46..2,287,246.86 rows=2,365,411 width=42) (actual rows= loops=)

  • Hash Cond: (os_4.oh_bi_order_status = (ohs_4.os_order_status_id)::numeric)
225. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..2,251,764.36 rows=2,365,411 width=38) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Parallel Index Only Scan using f_ohsbo_preload_idx1 on f_orderheadersummarybyorder_preload os_4 (cost=0.56..375,300.13 rows=2,365,411 width=19) (actual rows= loops=)

  • Index Cond: (oh_bi_order_status = ANY ('{100,420,500,800,999}'::numeric[]))
227. 0.000 0.000 ↓ 0.0

Index Scan using f_orderheader_preload_oh_ord_no_idx2 on f_orderheader_preload oh_4 (cost=0.56..0.78 rows=1 width=30) (actual rows= loops=)

  • Index Cond: (oh_ord_no = os_4.oh_ord_no)
228. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=15 width=4) (actual rows= loops=)

229. 0.000 0.000 ↓ 0.0

Seq Scan on dim_orderheaderstatus ohs_4 (cost=0.00..1.15 rows=15 width=4) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=1,513.30..1,513.30 rows=12 width=12) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Hash Join (cost=4.55..1,513.30 rows=12 width=12) (actual rows= loops=)

  • Hash Cond: (ca_4.datety = c_3.cal_date)
232. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on dim_campaigncalendar ca_4 (cost=0.00..1,502.35 rows=2,435 width=12) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

Hash (cost=4.17..4.17 rows=31 width=4) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dim_calendar_v2 on dim_calendar_v2 c_3 (cost=0.29..4.17 rows=31 width=4) (actual rows= loops=)

  • Index Cond: ((cal_date >= $9) AND (cal_date < LOCALTIMESTAMP))
235. 0.000 0.000 ↓ 0.0

Sort (cost=123,971.75..124,562.98 rows=236,491 width=67) (actual rows= loops=)

  • Sort Key: pr_4.pm_company USING <, pr_4.pm_prod_code USING <
236. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,175.94..102,863.25 rows=236,491 width=67) (actual rows= loops=)

  • Hash Cond: (((pr_4.pm_ptyp)::text = (prn_4.producttypecode)::text) AND ((pr_4.pg_prd_rng_cd)::text = (prn_4.productrangecode)::text) AND ((pr_4.der_productsubfamily)::text = (prn_4.der_productsubfamily)::text))
237. 0.000 0.000 ↓ 0.0

Seq Scan on dim_product pr_4 (cost=0.00..83,824.91 rows=236,491 width=57) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Hash (cost=16,745.97..16,745.97 rows=24,570 width=39) (actual rows= loops=)

239. 0.000 0.000 ↓ 0.0

Index Scan using pk_dim_productrange on dim_productrange prn_4 (cost=0.29..16,745.97 rows=24,570 width=39) (actual rows= loops=)

240. 0.000 0.000 ↓ 0.0

Hash (cost=4.41..4.41 rows=241 width=21) (actual rows= loops=)

241. 0.000 0.000 ↓ 0.0

Seq Scan on dim_exclusivebrands e_4 (cost=0.00..4.41 rows=241 width=21) (actual rows= loops=)

242. 0.000 0.000 ↓ 0.0

Sort (cost=4,035.05..4,038.51 rows=1,384 width=16) (actual rows= loops=)

  • Sort Key: s_4.sm_company USING <, s_4.sm_supp_cd USING <
243. 0.000 0.000 ↓ 0.0

Seq Scan on dim_supplier s_4 (cost=0.00..3,962.84 rows=1,384 width=16) (actual rows= loops=)

244. 0.000 0.000 ↓ 0.0

Hash (cost=49.39..49.39 rows=14 width=55) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Seq Scan on productattributes pac64_4 (cost=0.00..49.39 rows=14 width=55) (actual rows= loops=)

  • Filter: (usagetypeid = '5'::numeric)