explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZWQo

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

Gather Motion 304:1 (slice71; segments: 304) (cost=0.00..821,074,653,860.86 rows=133,508,621,380,670 width=2,692) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..24,968,471,385.11 rows=439,173,096,647 width=2,692) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 71:0) (cost=0.00..2,243.18 rows=382 width=1) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,243.18 rows=382 width=1) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,243.18 rows=382 width=40) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,243.16 rows=382 width=32) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.ms_id::text = toms_hub.secured_fact_resource_fg_status.ms_id::text
7. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice64; segments: 304) (cost=0.00..1,343.64 rows=382 width=28) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.ms_id
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,343.60 rows=382 width=28) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.work_order_dim_key = secured_dim_work_order.work_order_dim_key
9. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice61; segments: 304) (cost=0.00..900.80 rows=374 width=32) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_dim_key
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..900.76 rows=374 width=32) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.work_order_fact_key = toms_hub.secured_fact_work_order.work_order_fact_key
11. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice58; segments: 304) (cost=0.00..447.35 rows=1,145 width=23) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_fact_key
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..447.26 rows=1,145 width=23) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
13. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..435.29 rows=30,900 width=27) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-05-20'::date
14. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
16. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice57) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice56; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_resource_fg_status'::text
21. 0.000 0.000 ↓ 0.0

Hash (cost=452.91..452.91 rows=509 width=17) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..452.91 rows=509 width=17) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_work_order.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
23. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..444.32 rows=13,727 width=21) (actual rows= loops=)

  • Filter: NOT bill_rate IS NULL
24. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
26. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice60) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice59; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_work_order'::text
31. 0.000 0.000 ↓ 0.0

Hash (cost=442.63..442.63 rows=336 width=4) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..442.63 rows=336 width=4) (actual rows= loops=)

  • Hash Cond: secured_dim_work_order.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
33. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_work_order (cost=0.00..434.87 rows=9,050 width=8) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
36. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice63) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice62; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_dim_work_order'::text
41. 0.000 0.000 ↓ 0.0

Hash (cost=899.35..899.35 rows=197 width=9) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..899.35 rows=197 width=9) (actual rows= loops=)

  • Group By: toms_hub.secured_fact_resource_fg_status.ms_id
43. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice70; segments: 304) (cost=0.00..899.33 rows=197 width=9) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.ms_id
44. 0.000 0.000 ↓ 0.0

Result (cost=0.00..899.32 rows=197 width=9) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..899.32 rows=197 width=9) (actual rows= loops=)

  • Group By: toms_hub.secured_fact_resource_fg_status.ms_id
46. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..899.27 rows=374 width=9) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.work_order_fact_key = toms_hub.secured_fact_work_order.work_order_fact_key
47. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice67; segments: 304) (cost=0.00..446.51 rows=1,145 width=13) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_fact_key
48. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..446.46 rows=1,145 width=13) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
49. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..434.71 rows=30,900 width=17) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-05-20'::date
50. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
52. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice66) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice65; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

56. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_resource_fg_status'::text
57. 0.000 0.000 ↓ 0.0

Hash (cost=452.45..452.45 rows=509 width=4) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..452.45 rows=509 width=4) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_work_order.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
59. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..443.99 rows=13,727 width=8) (actual rows= loops=)

  • Filter: NOT bill_rate IS NULL
60. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
62. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice69) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice68; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_work_order'::text
67. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..23,786,215,165.75 rows=439,173,096,647 width=2,692) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 71:1) (cost=0.00..5,568.97 rows=214 width=1) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..5,568.97 rows=214 width=1) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,568.97 rows=214 width=132) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,568.94 rows=214 width=66) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_furlough_details.vendor_code_as_was::text = toms_hub.secured_dim_vendor_fms_details.vendor_code::text
72. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,131.75 rows=107 width=57) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_furlough_details.ms_id::text = share0_ref2.ms_id::text
  • Join Filter: to_date(btrim(secured_fact_resource_furlough_details.furlough_date::text), 'YYYYMMDD'::text) >= share0_ref2.business_eff_start_dt AND to_date(btrim(secured_fact_resource_furlough_details.furlough_date::text), 'YYYYMMDD'::text) <= share0_ref2.effective_end_date
73. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice52; segments: 304) (cost=0.00..1,762.04 rows=1 width=49) (actual rows= loops=)

  • Hash Key: secured_fact_resource_furlough_details.ms_id
74. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,762.04 rows=1 width=49) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is = secured_fact_resource_furlough_details.resource_key_as_is AND toms_hub.secured_fact_resource_furlough_summary.cost_center_as_was::text = secured_fact_resource_furlough_details.cost_center::text AND toms_hub.secured_fact_resource_furlough_summary.vendor_code_as_was::text = secured_fact_resource_furlough_details.vendor_code_as_was::text AND btrim(toms_hub.secured_fact_resource_furlough_summary.furlough_year::text) = "substring"(btrim(secured_fact_resource_furlough_details.furlough_date::text), 1, 4) AND toms_hub.dim_resource.resource_key = secured_fact_resource_furlough_details.resource_key_as_is
75. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..882.55 rows=3 width=30) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_key = toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is
76. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..443.85 rows=195 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
77. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource (cost=0.00..437.05 rows=4,256 width=18) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar AND resource_rec_type = 'E'::bpchar
78. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
80. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice41) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice40; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_resource'::text
85. 0.000 0.000 ↓ 0.0

Hash (cost=438.64..438.64 rows=43 width=16) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice44; segments: 304) (cost=0.00..438.64 rows=43 width=16) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is
87. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..438.64 rows=43 width=16) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_furlough_summary.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
88. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_furlough_summary (cost=0.00..432.46 rows=938 width=20) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar
89. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
91. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice43) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice42; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_resource_furlough_summary'::text
96. 0.000 0.000 ↓ 0.0

Hash (cost=879.49..879.49 rows=2 width=39) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice51; segments: 304) (cost=0.00..879.49 rows=2 width=39) (actual rows= loops=)

  • Hash Key: secured_fact_resource_furlough_details.resource_key_as_is
98. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..879.49 rows=2 width=39) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_furlough_details.furlough_status_lkp_key = dim_report_lookup.report_lkp_key
99. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..441.36 rows=302 width=36) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_furlough_details.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
100. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_furlough_details (cost=0.00..434.01 rows=6,587 width=40) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar
101. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
103. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice46) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice45; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_resource_furlough_details'::text
108. 0.000 0.000 ↓ 0.0

Hash (cost=438.07..438.07 rows=1 width=11) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice50; segments: 304) (cost=0.00..438.07 rows=1 width=11) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..438.07 rows=1 width=11) (actual rows= loops=)

  • Hash Cond: toms_hub.cfg_gpload_version_ctrl.curr_version_id = dim_report_lookup.gpload_version_id
111. 0.000 0.000 ↓ 0.0

Redistribute Motion 1:304 (slice48) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Hash Key: toms_hub.cfg_gpload_version_ctrl.curr_version_id
112. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
113. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice47; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_report_lookup'::text
116. 0.000 0.000 ↓ 0.0

Hash (cost=432.07..432.07 rows=1 width=15) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice49; segments: 304) (cost=0.00..432.07 rows=1 width=15) (actual rows= loops=)

  • Hash Key: dim_report_lookup.gpload_version_id
118. 0.000 0.000 ↓ 0.0

Table Scan on dim_report_lookup (cost=0.00..432.07 rows=1 width=15) (actual rows= loops=)

  • Filter: title::text = 'FURLOUGH_STATUS'::text AND is_deleted = 'N'::bpchar AND (code::text = ANY ('{SER,PUB,PLAN}'::text[]))
119. 0.000 0.000 ↓ 0.0

Hash (cost=576.78..576.78 rows=2,880,533 width=21) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 71:0) (cost=0.00..576.78 rows=2,880,533 width=21) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash (cost=437.03..437.03 rows=211 width=14) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice55; segments: 304) (cost=0.00..437.03 rows=211 width=14) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.03 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_dim_vendor_fms_details.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
124. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_vendor_fms_details (cost=0.00..431.02 rows=21 width=18) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar AND current_flag = 'Y'::bpchar
125. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
127. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice54) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice53; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_dim_vendor_fms_details'::text
132. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..22,603,955,620.61 rows=439,173,096,647 width=2,692) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 71:3) (cost=0.00..2,570,449,565.99 rows=6,877,829,435,184 width=1) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,570,449,565.99 rows=6,877,829,435,184 width=1) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,563,571,736.55 rows=6,877,829,435,184 width=115) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,563,571,736.55 rows=6,875,241,519,980 width=115) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice27; segments: 304) (cost=0.00..1,772,918,961.76 rows=6,875,241,519,980 width=107) (actual rows= loops=)

  • Hash Key: share1_ref2.ms_id
138. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,772,918,961.76 rows=6,875,241,519,980 width=107) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 27:1) (cost=0.00..1,772,918,961.76 rows=6,875,241,519,980 width=107) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,700,220.90 rows=2,587,915,204 width=117) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,397,434.82 rows=947,358 width=97) (actual rows= loops=)

142. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice39; segments: 304) (cost=0.00..1,959,397,342.92 rows=947,358 width=65) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.ms_id
143. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,397,342.92 rows=947,358 width=65) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,959,397,342.92 rows=947,358 width=65) (actual rows= loops=)

  • Group By: toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is, (btrim(toms_hub.secured_fact_resource_furlough_summary.furlough_year::text)), toms_hub.dim_resource.ms_id, ((toms_hub.secured_fact_resource_furlough_summary.furlough_year::text || '1231'::text)::integer), (to_date(toms_hub.secured_fact_resource_furlough_summary.furlough_year::text || '1231'::text, 'YYYYMMDD'::text)), (CASE WHEN share0_ref3.employee_status_code = 'T'::bpchar AND toms_hub.dim_resource.empl_status_code = 'T'::bpchar THEN 0::bigint ELSE COALESCE(toms_hub.secured_dim_vendor_fms_details.num_days_cap, 0) - COALESCE((count((count()))), 0::bigint) END), (CASE WHEN share0_ref3.employee_status_code = 'T'::bpchar AND toms_hub.dim_resource.empl_status_code = 'T'::bpchar THEN 0::numeric ELSE (COALESCE(toms_hub.secured_dim_vendor_fms_details.num_days_cap, 0) - COALESCE((count((count()))), 0::bigint))::numeric * share0_ref3.bill_rate_daily_usd END)
145. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,396,464.32 rows=947,358 width=61) (actual rows= loops=)

  • Filter: (CASE WHEN share0_ref3.employee_status_code = 'T'::bpchar AND toms_hub.dim_resource.empl_status_code = 'T'::bpchar THEN 0::bigint ELSE COALESCE(toms_hub.secured_dim_vendor_fms_details.num_days_cap, 0) - COALESCE((count((count()))), 0::bigint) END) > 0
146. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,396,386.40 rows=2,368,394 width=61) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,959,396,241.93 rows=2,368,394 width=61) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_furlough_summary.vendor_code_as_was::text = toms_hub.secured_dim_vendor_fms_details.vendor_code::text
148. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,959,394,925.66 rows=1,817,804 width=52) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.ms_id::text = share0_ref3.ms_id::text
  • Join Filter: to_date(toms_hub.secured_fact_resource_furlough_summary.furlough_year::text || '1231'::text, 'YYYYMMDD'::text) >= share0_ref3.business_eff_start_dt AND to_date(toms_hub.secured_fact_resource_furlough_summary.furlough_year::text || '1231'::text, 'YYYYMMDD'::text) <= share0_ref3.effective_end_date
149. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice35; segments: 304) (cost=0.00..1,959,390,160.07 rows=1,104 width=31) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.ms_id
150. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,959,390,159.97 rows=1,104 width=31) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_furlough_summary.furlough_year::integer = (share1_ref3.furlough_year::integer) AND toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is = share1_ref3.resource_key_as_is
151. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice33; segments: 304) (cost=0.00..882.51 rows=3 width=23) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_furlough_summary.furlough_year::integer, toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is
152. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..882.51 rows=3 width=23) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_key = toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is
153. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..443.81 rows=195 width=11) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
154. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource (cost=0.00..437.02 rows=4,256 width=15) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar AND resource_rec_type = 'E'::bpchar
155. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
157. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice29) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice28; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_resource'::text
162. 0.000 0.000 ↓ 0.0

Hash (cost=438.64..438.64 rows=43 width=16) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice32; segments: 304) (cost=0.00..438.64 rows=43 width=16) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_furlough_summary.resource_key_as_is
164. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..438.64 rows=43 width=16) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_furlough_summary.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
165. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_furlough_summary (cost=0.00..432.46 rows=938 width=20) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar
166. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
168. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice31) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice30; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_fact_resource_furlough_summary'::text
173. 0.000 0.000 ↓ 0.0

Hash (cost=1,959,389,267.58..1,959,389,267.58 rows=17,317 width=16) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,959,389,267.58 rows=17,317 width=16) (actual rows= loops=)

  • Group By: (share1_ref3.furlough_year::integer), share1_ref3.resource_key_as_is
175. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice34; segments: 304) (cost=0.00..1,959,389,263.21 rows=17,317 width=16) (actual rows= loops=)

  • Hash Key: (share1_ref3.furlough_year::integer), share1_ref3.resource_key_as_is
176. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,959,389,262.34 rows=17,317 width=16) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,959,389,262.34 rows=17,317 width=16) (actual rows= loops=)

  • Group By: share1_ref3.furlough_year::integer, share1_ref3.resource_key_as_is
178. 0.000 0.000 ↓ 0.0

Result (cost=0.00..253,834,347.92 rows=6,875,241,519,980 width=8) (actual rows= loops=)

179. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 34:1) (cost=0.00..198,832,415.76 rows=6,875,241,519,980 width=12) (actual rows= loops=)

180. 0.000 0.000 ↓ 0.0

Hash (cost=667.03..667.03 rows=2,880,533 width=34) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 39:0) (cost=0.00..667.03 rows=2,880,533 width=34) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Hash (cost=437.03..437.03 rows=211 width=14) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice38; segments: 304) (cost=0.00..437.03 rows=211 width=14) (actual rows= loops=)

184. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.03 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_dim_vendor_fms_details.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
185. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_vendor_fms_details (cost=0.00..431.02 rows=21 width=18) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar AND current_flag = 'Y'::bpchar
186. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
188. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice37) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

190. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice36; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_dim_vendor_fms_details'::text
193. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..18,851,252,078.45 rows=439,173,096,647 width=2,692) (actual rows= loops=)

  • Hash Cond: share3_ref3.vendor_code_as_was::text = toms_hub.secured_dim_vendor_fms_details.vendor_code::text AND toms_hub.dim_resource.resource_category_code::text = dim_resource_category.resource_category_code::text AND share3_ref3.vendor_code_as_was::text = secured_dim_vendor.vendor_code::text
194. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..14,601,390,756.90 rows=56,427,476,004 width=2,493) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_key = toms_hub.dim_resource.resource_key AND share3_ref3.cost_center::text = toms_hub.dim_integrated_cc.cc_id::text
195. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6,651,638,663.64 rows=5,199,566,203,819 width=127) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice6; segments: 304) (cost=0.00..5,991,293,755.76 rows=441,798,456,620 width=89) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.resource_key, share3_ref3.cost_center
197. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..5,868,221,959.70 rows=441,798,456,620 width=89) (actual rows= loops=)

  • Hash Cond: share3_ref3.furlough_year = share3_ref2.furlough_year AND share3_ref3.vendor_code_as_was::text = share3_ref2.vendor_code_as_was::text
198. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,002,515,036.92 rows=441,798,456,620 width=81) (actual rows= loops=)

  • Hash Cond: share3_ref3.resource_key_as_is = toms_hub.dim_resource.resource_key
199. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 6:3) (cost=0.00..1,342,621,515.04 rows=6,877,829,435,184 width=81) (actual rows= loops=)

200. 0.000 0.000 ↓ 0.0

Hash (cost=444.09..444.09 rows=59,191 width=4) (actual rows= loops=)

201. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice3; segments: 304) (cost=0.00..444.09 rows=59,191 width=4) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..443.74 rows=195 width=4) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
203. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource (cost=0.00..436.97 rows=4,256 width=8) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar AND resource_rec_type = 'E'::bpchar
204. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
206. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice2) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

208. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice1; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

210. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_resource'::text
211. 0.000 0.000 ↓ 0.0

Hash (cost=2,552,724,023.43..2,552,724,023.43 rows=89,438 width=21) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice5; segments: 304) (cost=0.00..2,552,724,023.43 rows=89,438 width=21) (actual rows= loops=)

213. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,552,724,020.58 rows=295 width=21) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,552,724,020.58 rows=295 width=21) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,552,724,020.58 rows=295 width=37) (actual rows= loops=)

216. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,552,724,020.57 rows=295 width=45) (actual rows= loops=)

  • Group By: share3_ref2.vendor_code_as_was, share3_ref2.furlough_year
217. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice4; segments: 304) (cost=0.00..2,552,724,020.49 rows=295 width=45) (actual rows= loops=)

  • Hash Key: share3_ref2.vendor_code_as_was, share3_ref2.furlough_year
218. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,552,724,020.45 rows=295 width=45) (actual rows= loops=)

219. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,552,724,020.45 rows=295 width=45) (actual rows= loops=)

  • Group By: share3_ref2.vendor_code_as_was, share3_ref2.furlough_year
220. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 4:3) (cost=0.00..745,901,033.25 rows=6,877,829,435,184 width=45) (actual rows= loops=)

221. 0.000 0.000 ↓ 0.0

Hash (cost=1,370,449,783.22..1,370,449,783.22 rows=139,644,486 width=2,375) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice16; segments: 304) (cost=0.00..1,370,449,783.22 rows=139,644,486 width=2,375) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.resource_key, toms_hub.dim_integrated_cc.cc_id
223. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,369,411,701.03 rows=139,644,486 width=2,375) (actual rows= loops=)

  • Join Filter: true
224. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice15; segments: 304) (cost=0.00..1,129.02 rows=77,877 width=1,858) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..910.05 rows=257 width=1,858) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.location_code::text = dim_location.location_code::text
226. 0.000 0.000 ↓ 0.0

Result (cost=0.00..470.58 rows=263 width=1,722) (actual rows= loops=)

227. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice11; segments: 304) (cost=0.00..470.12 rows=263 width=1,673) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.location_code
228. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..468.75 rows=263 width=1,673) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
229. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource (cost=0.00..436.50 rows=5,729 width=1,677) (actual rows= loops=)

230. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
232. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice10) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

233. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

235. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice9; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_resource'::text
237. 0.000 0.000 ↓ 0.0

Hash (cost=437.43..437.43 rows=18 width=141) (actual rows= loops=)

238. 0.000 0.000 ↓ 0.0

Result (cost=0.00..437.43 rows=18 width=141) (actual rows= loops=)

239. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice14; segments: 304) (cost=0.00..437.43 rows=18 width=128) (actual rows= loops=)

  • Hash Key: dim_location.location_code
240. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.42 rows=18 width=128) (actual rows= loops=)

  • Hash Cond: dim_location.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
241. 0.000 0.000 ↓ 0.0

Table Scan on dim_location (cost=0.00..431.27 rows=539 width=132) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar
242. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

243. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
244. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice13) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

246. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice12; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_location'::text
249. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..880.34 rows=1,794 width=517) (actual rows= loops=)

250. 0.000 0.000 ↓ 0.0

Result (cost=0.00..879.42 rows=1,794 width=517) (actual rows= loops=)

251. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..878.49 rows=1,794 width=812) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_integrated_cc.gpload_version_id = (max((max(toms_hub.dim_integrated_cc.gpload_version_id))))
252. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..437.93 rows=1,794 width=816) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar AND is_deleted = 'N'::bpchar AND NOT CASE WHEN entitlement_org_id::text = '1'::text THEN hr_division_short ELSE hr_division END IS NULL AND NOT hr_super_division IS NULL
253. 0.000 0.000 ↓ 0.0

Hash (cost=434.26..434.26 rows=1 width=4) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice8) (cost=0.00..434.26 rows=304 width=4) (actual rows= loops=)

255. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..434.26 rows=1 width=4) (actual rows= loops=)

256. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice7; segments: 304) (cost=0.00..434.26 rows=1 width=4) (actual rows= loops=)

257. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..434.26 rows=1 width=4) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..434.22 rows=4,904 width=4) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Hash (cost=1,784,344.36..1,784,344.36 rows=7,766 width=218) (actual rows= loops=)

260. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice26; segments: 304) (cost=0.00..1,784,344.36 rows=7,766 width=218) (actual rows= loops=)

261. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,784,340.65 rows=26 width=218) (actual rows= loops=)

  • Join Filter: true
262. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice25; segments: 304) (cost=0.00..437.01 rows=37 width=117) (actual rows= loops=)

263. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.01 rows=1 width=117) (actual rows= loops=)

  • Hash Cond: dim_resource_category.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
264. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource_category (cost=0.00..431.00 rows=4 width=121) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar
265. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

266. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
267. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice24) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

268. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

269. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

270. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice23; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

271. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_resource_category'::text
272. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..874.47 rows=1 width=101) (actual rows= loops=)

273. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..874.47 rows=1 width=101) (actual rows= loops=)

  • Hash Cond: secured_dim_vendor.vendor_code::text = toms_hub.secured_dim_vendor_fms_details.vendor_code::text
274. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice19; segments: 304) (cost=0.00..437.43 rows=23 width=61) (actual rows= loops=)

  • Hash Key: secured_dim_vendor.vendor_code
275. 0.000 0.000 ↓ 0.0

Result (cost=0.00..437.43 rows=23 width=61) (actual rows= loops=)

276. 0.000 0.000 ↓ 0.0

Result (cost=0.00..437.43 rows=23 width=61) (actual rows= loops=)

277. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.43 rows=23 width=75) (actual rows= loops=)

  • Hash Cond: secured_dim_vendor.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
278. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_vendor (cost=0.00..431.26 rows=685 width=79) (actual rows= loops=)

  • Filter: is_deleted = 'N'::bpchar
279. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

280. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
281. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice18) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

283. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

284. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice17; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

285. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_dim_vendor'::text
286. 0.000 0.000 ↓ 0.0

Hash (cost=437.03..437.03 rows=1 width=40) (actual rows= loops=)

287. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice22; segments: 304) (cost=0.00..437.03 rows=1 width=40) (actual rows= loops=)

  • Hash Key: toms_hub.secured_dim_vendor_fms_details.vendor_code
288. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.03 rows=1 width=40) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_dim_vendor_fms_details.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
289. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_vendor_fms_details (cost=0.00..431.02 rows=21 width=44) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar AND is_deleted = 'N'::bpchar
290. 0.000 0.000 ↓ 0.0

Hash (cost=6.01..6.01 rows=1 width=4) (actual rows= loops=)

291. 0.000 0.000 ↓ 0.0

Assert (cost=0.00..6.01 rows=1 width=4) (actual rows= loops=)

  • Assert Cond: (row_number()) = 1
292. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice21) (cost=0.00..6.01 rows=304 width=12) (actual rows= loops=)

293. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

294. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6.00 rows=1 width=12) (actual rows= loops=)

295. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice20; segments: 304) (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

296. 0.000 0.000 ↓ 0.0

Index Scan using cfg_gpload_version_ctrl_pkey on cfg_gpload_version_ctrl (cost=0.00..6.00 rows=1 width=4) (actual rows= loops=)

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'secured_dim_vendor_fms_details'::textSettings: gp_cte_sharing=on; gp_enable_relsize_collection=on; optimizer_join_arity_for_associativity_commutativity=7Optimizer status: PQO version 3.80.0