explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j7kd

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

NOTICE: One or more columns in the following table(s) do not have statistics: v1_open_position_as_of_today(Hint For non-partitioned tables, run analyze <table_name>(<column_list>). For partitioned tables, run analyze rootpartition <table_name>(<column_list>). See log for columns missing statistics.; File COptTasks.cpp; Line 1147; Routine PrintMissingStatsWarning; )Gather Motion 304:1 (slice194; segments: 304) (cost=0.00..45,033,964,196,978,794,496.00 rows=1,321,198,793,836,000,968,704 width=3,514) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..34,750,094,732,868,243,456.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 194:0) (cost=0.00..4,375,150,730.04 rows=2,769,661 width=1) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4,375,150,730.04 rows=2,769,661 width=1) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..4,375,150,727.27 rows=2,769,661 width=382) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice190; segments: 304) (cost=0.00..4,375,150,727.27 rows=2,769,097 width=382) (actual rows= loops=)

  • Hash Key: secured_fact_resource_monthly_snapshot.resource_snapshot_key
7. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,375,150,727.27 rows=2,769,097 width=382) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,375,149,669.48 rows=2,769,097 width=366) (actual rows= loops=)

  • Filter: CASE WHEN secured_fact_resource_monthly_snapshot.transaction_type = ANY ('{S,S-B,S-PL,R,C,F,M-P,Y,Y-P}'::bpchar[]) THEN true WHEN (secured_fact_resource_monthly_snapshot.transaction_type = ANY ('{M,T,N,I,O}'::bpchar[])) AND (COALESCE((max((max(toms_hub.cfg_lookup_param.lookup_code_int)))), 0)) = 0 THEN secured_fact_resource_monthly_snapshot.transaction_date <= '2020-04-24'::date WHEN (secured_fact_resource_monthly_snapshot.transaction_type = ANY ('{M,T,N,I,O}'::bpchar[])) AND (COALESCE((max((max(toms_hub.cfg_lookup_param.lookup_code_int)))), 0)) = 1 THEN true ELSE false END
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..4,375,149,660.33 rows=69,494 width=374) (actual rows= loops=)

  • Join Filter: true
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..4,271,645.70 rows=34,747 width=370) (actual rows= loops=)

  • Join Filter: true
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,260.36 rows=17,374 width=366) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_monthly_snapshot.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
12. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..2,183.01 rows=1,563,612 width=370) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Partition Selector for secured_fact_resource_monthly_snapshot (dynamic scan id: 1) (cost=10.00..100.00 rows=1 width=4) (actual rows= loops=)

  • Partitions selected: 1 (out of 2)
14. 0.000 0.000 ↓ 0.0

Dynamic Table Scan on secured_fact_resource_monthly_snapshot (dynamic scan id: 1) (cost=0.00..2,183.01 rows=1,563,612 width=370) (actual rows= loops=)

  • Filter: snapshot_type = 'I'::bpchar
15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

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

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

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

18. 0.000 0.000 ↓ 0.0

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

19. 0.000 0.000 ↓ 0.0

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

20. 0.000 0.000 ↓ 0.0

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

21. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'secured_fact_resource_monthly_snapshot'::text AND table_schema::text = 'toms_hub'::text
22. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

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

25. 0.000 0.000 ↓ 0.0

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

26. 0.000 0.000 ↓ 0.0

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

27. 0.000 0.000 ↓ 0.0

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

28. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: title::text = 'RSRC_SNAPSHOT_INCLUDE_FUTURE_DATA'::text
29. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

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

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

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

34. 0.000 0.000 ↓ 0.0

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

35. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: title::text = 'RSRC_SNAPSHOT_INCLUDE_FUTURE_DATA'::text
36. 0.000 0.000 ↓ 0.0

Result (cost=0.00..939.75 rows=564 width=384) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice192; segments: 304) (cost=0.00..939.75 rows=564 width=384) (actual rows= loops=)

  • Hash Key: secured_fact_resource_monthly_snapshot_opco.snapshot_ts, secured_fact_resource_monthly_snapshot_opco.resource_snapshot_key
38. 0.000 0.000 ↓ 0.0

Result (cost=0.00..939.75 rows=564 width=392) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..939.53 rows=564 width=380) (actual rows= loops=)

  • Hash Cond: secured_fact_resource_monthly_snapshot_opco.snapshot_ts = dim_snapshot.snapshot_ts
40. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_monthly_snapshot_opco (cost=0.00..484.93 rows=56,390 width=380) (actual rows= loops=)

  • Filter: snapshot_type = 'E'::bpchar
41. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=8) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice191; segments: 304) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Table Scan on dim_snapshot (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

  • Filter: is_latest::text = 'Yes'::text AND snapshot_status::text = 'PUBLISHED'::text AND data_domain::text = 'Resource Snapshot'::text
44. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice193; segments: 304) (cost=0.00..431.00 rows=1 width=680) (actual rows= loops=)

  • Hash Key: v1_open_position_as_of_today.resource_snapshot_key
45. 0.000 0.000 ↓ 0.0

Table Scan on v1_open_position_as_of_today (cost=0.00..431.00 rows=1 width=680) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..34,734,822,713,488,027,648.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 194:2) (cost=0.00..2,225.46 rows=68 width=1) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,225.46 rows=68 width=1) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,225.46 rows=68 width=8) (actual rows= loops=)

  • Group By: fact_resource_curr_plan_provider.pt_request_id
50. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice183; segments: 304) (cost=0.00..2,225.46 rows=68 width=8) (actual rows= loops=)

  • Hash Key: fact_resource_curr_plan_provider.pt_request_id
51. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,225.45 rows=68 width=8) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,225.45 rows=68 width=8) (actual rows= loops=)

  • Group By: fact_resource_curr_plan_provider.pt_request_id
53. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,225.45 rows=68 width=8) (actual rows= loops=)

  • Hash Cond: fact_resource_curr_plan_provider.fiscal_year::integer = (generate_series(2020, 2021))
54. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,225.43 rows=68 width=10) (actual rows= loops=)

  • Hash Cond: fact_resource_curr_plan_provider.period_key = dim_project_period.period_key
55. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice179; segments: 304) (cost=0.00..1,363.15 rows=283 width=10) (actual rows= loops=)

  • Hash Key: fact_resource_curr_plan_provider.period_key
56. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,363.14 rows=283 width=10) (actual rows= loops=)

  • Hash Cond: fact_resource_curr_plan_provider.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
57. 0.000 0.000 ↓ 0.0

Table Scan on fact_resource_curr_plan_provider (cost=0.00..900.07 rows=175,765 width=14) (actual rows= loops=)

  • Filter: assignment_type_code::text = 'APPROVED'::text AND fte <> 0::numeric AND budget_status::text = 'In Budget'::text
58. 0.000 0.000 ↓ 0.0

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

59. 0.000 0.000 ↓ 0.0

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

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

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

61. 0.000 0.000 ↓ 0.0

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

62. 0.000 0.000 ↓ 0.0

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

63. 0.000 0.000 ↓ 0.0

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

64. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'fact_resource_curr_plan_provider'::text AND table_schema::text = 'toms_hub'::text
65. 0.000 0.000 ↓ 0.0

Hash (cost=862.04..862.04 rows=8 width=8) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.04 rows=8 width=8) (actual rows= loops=)

  • Hash Cond: dim_project_period.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
67. 0.000 0.000 ↓ 0.0

Table Scan on dim_project_period (cost=0.00..431.01 rows=129 width=12) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

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

69. 0.000 0.000 ↓ 0.0

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

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

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

71. 0.000 0.000 ↓ 0.0

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

72. 0.000 0.000 ↓ 0.0

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

73. 0.000 0.000 ↓ 0.0

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

74. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_project_period'::text AND table_schema::text = 'toms_hub'::text
75. 0.000 0.000 ↓ 0.0

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

76. 0.000 0.000 ↓ 0.0

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

77. 0.000 0.000 ↓ 0.0

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

78. 0.000 0.000 ↓ 0.0

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

79. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..34,719,550,698,482,958,336.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 194:3) (cost=0.00..1,219.17 rows=99 width=1) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,219.17 rows=99 width=1) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,219.17 rows=99 width=124) (actual rows= loops=)

  • Group By: (btrim(toms_hub.dim_rdm_requisition.gen_reqid::text))
83. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice176; segments: 304) (cost=0.00..1,219.15 rows=99 width=124) (actual rows= loops=)

  • Hash Key: (btrim(toms_hub.dim_rdm_requisition.gen_reqid::text))
84. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,219.11 rows=99 width=124) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,219.11 rows=99 width=124) (actual rows= loops=)

  • Group By: btrim(toms_hub.dim_rdm_requisition.gen_reqid::text)
86. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,218.98 rows=740 width=169) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,218.85 rows=740 width=166) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_rdm_requisition.gpload_version_id = (max((max(toms_hub.dim_rdm_requisition.gpload_version_id))))
88. 0.000 0.000 ↓ 0.0

Table Scan on dim_rdm_requisition (cost=0.00..542.69 rows=740 width=166) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

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

90. 0.000 0.000 ↓ 0.0

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

91. 0.000 0.000 ↓ 0.0

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

92. 0.000 0.000 ↓ 0.0

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

93. 0.000 0.000 ↓ 0.0

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

94. 0.000 0.000 ↓ 0.0

Table Scan on dim_rdm_requisition (cost=0.00..542.69 rows=740 width=4) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..34,704,278,683,477,893,120.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 194:4) (cost=0.00..1,361.72 rows=1,912 width=1) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1,361.72 rows=1,912 width=1) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,361.72 rows=1,912 width=36) (actual rows= loops=)

  • Group By: (btrim(toms_hub.dim_rdm_candidate_application.gen_reqid::text)), (btrim(toms_hub.dim_rdm_candidate_application.gen_cand_id::text))
99. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice173; segments: 304) (cost=0.00..1,361.21 rows=1,912 width=36) (actual rows= loops=)

  • Hash Key: (btrim(toms_hub.dim_rdm_candidate_application.gen_reqid::text)), (btrim(toms_hub.dim_rdm_candidate_application.gen_cand_id::text))
100. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,360.99 rows=1,912 width=36) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,360.99 rows=1,912 width=36) (actual rows= loops=)

  • Group By: btrim(toms_hub.dim_rdm_candidate_application.gen_reqid::text), btrim(toms_hub.dim_rdm_candidate_application.gen_cand_id::text)
102. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,360.48 rows=1,912 width=49) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,360.38 rows=1,912 width=46) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_rdm_candidate_application.gpload_version_id = (max((max(toms_hub.dim_rdm_candidate_application.gpload_version_id))))
104. 0.000 0.000 ↓ 0.0

Table Scan on dim_rdm_candidate_application (cost=0.00..657.16 rows=1,912 width=46) (actual rows= loops=)

  • Filter: is_completed::text = 'Y'::text
105. 0.000 0.000 ↓ 0.0

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

106. 0.000 0.000 ↓ 0.0

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

107. 0.000 0.000 ↓ 0.0

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

108. 0.000 0.000 ↓ 0.0

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

109. 0.000 0.000 ↓ 0.0

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

110. 0.000 0.000 ↓ 0.0

Table Scan on dim_rdm_candidate_application (cost=0.00..579.10 rows=2,726 width=4) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Redistribute Motion 1:304 (slice170) (cost=0.00..34,689,006,668,472,827,904.00 rows=1,321,198,793,836,000,968,704 width=3,514) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Result (cost=0.00..23,859,315,388,081,258,496.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Result (cost=0.00..23,859,315,388,081,258,496.00 rows=4,346,048,663,934,213,632 width=3,514) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Window (cost=0.00..19,216,622,826,541,551,616.00 rows=4,346,048,663,934,213,632 width=3,301) (actual rows= loops=)

  • Order By: "outer".?column?
115. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice169; segments: 304) (cost=0.00..14,855,345,608,088,911,872.00 rows=1,321,198,793,836,000,968,704 width=3,301) (actual rows= loops=)

  • Merge Key: "outer".?column?
116. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,194,829,643,083,523,072.00 rows=4,346,048,663,934,213,632 width=3,301) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..5,194,829,643,083,523,072.00 rows=4,346,048,663,934,213,632 width=3,301) (actual rows= loops=)

  • Sort Key: "outer".?column?
118. 0.000 0.000 ↓ 0.0

Result (cost=0.00..158,491,199,169,472,832.00 rows=4,346,048,663,934,213,632 width=3,301) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..144,144,892,529,825,984.00 rows=4,346,048,663,934,213,632 width=4,342) (actual rows= loops=)

  • Hash Cond: share0_ref3.request_id = toms_hub.pt_requisition.resource_id
  • Join Filter: share0_ref3.transaction_type = 'R-C'::bpchar
120. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..65,610,445,897,446,240.00 rows=4,346,048,663,934,213,632 width=4,290) (actual rows= loops=)

  • Hash Cond: share0_ref3.snapshot_type = share0_ref2.snapshot_type AND share0_ref3.transaction_type = share0_ref2.transaction_type AND share0_ref3.ms_id::text = share0_ref2.ms_id::text AND share0_ref3.transaction_date = share0_ref2.transaction_date
121. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..343,755,817,402,016.12 rows=3,309,363,741,356,499 width=4,202) (actual rows= loops=)

  • Hash Cond: share0_ref3.ms_id::text = fact_fg_contingent_tenure_calc.ms_id::text
122. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice140; segments: 304) (cost=0.00..288,452,763,396,948.00 rows=2,431,221,681,260,210 width=4,194) (actual rows= loops=)

  • Hash Key: share0_ref3.ms_id
123. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..256,537,581,518,275.38 rows=2,431,221,681,260,210 width=4,194) (actual rows= loops=)

  • Hash Cond: share0_ref3.request_id = share2_ref2.pt_request_id
124. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..215,886,833,033,689.78 rows=1,820,886,889,033,367 width=4,190) (actual rows= loops=)

  • Hash Cond: share0_ref3.request_id = toms_hub.pt_requisition.resource_id
125. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..184,442,465,400,718.66 rows=1,820,886,889,033,367 width=3,990) (actual rows= loops=)

  • Hash Cond: share0_ref3.request_id = pt_resource_candidate.resource_id
126. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..154,277,154,273,553.31 rows=1,820,886,889,033,367 width=3,986) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.job_level_code::text = toms_hub.dim_report_lookup.code::text
127. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..124,157,296,124,471.00 rows=1,820,886,889,033,367 width=3,968) (actual rows= loops=)

  • Hash Cond: share0_ref3.job_level_code::text = toms_hub.dim_report_lookup.code::text
128. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..94,172,114,411,475.39 rows=1,820,886,889,033,367 width=3,950) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.headcount_level_code::text = toms_hub.dim_report_lookup.code::text
129. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..64,320,500,214,451.04 rows=1,820,886,889,033,367 width=3,933) (actual rows= loops=)

  • Hash Cond: share0_ref3.headcount_level_code::text = toms_hub.dim_report_lookup.code::text
130. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..34,597,189,349,401.75 rows=1,820,886,889,033,367 width=3,915) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.hr_cc_code::text = toms_hub.dim_integrated_cc.cc_id::text
131. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..9,185,717,827,459.23 rows=180,297,818,225,050 width=3,911) (actual rows= loops=)

  • Hash Cond: share0_ref3.transaction_type = toms_hub.dim_report_lookup.code::bpchar
132. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,259,138,245,278.88 rows=180,297,818,225,050 width=3,891) (actual rows= loops=)

  • Hash Cond: share0_ref3.vendor_code::text = secured_dim_vendor.vendor_code::text
133. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..3,519,119,159,320.66 rows=117,449,799,822,145 width=3,694) (actual rows= loops=)

  • Hash Cond: share0_ref3.calendar_key = dim_calendar.calendar_key
134. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,858,584,779,039.95 rows=58,856,379,548,864 width=3,677) (actual rows= loops=)

  • Hash Cond: COALESCE(share0_ref3.transfer_level, '-'::character varying)::text = toms_hub.dim_report_lookup.code::text
135. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..959,823,554,772.05 rows=58,856,379,548,864 width=3,657) (actual rows= loops=)

  • Hash Cond: share0_ref3.resource_key = dim_resource_managers_btmup_hist.resource_key AND share0_ref3.calendar_key = to_char(to_date(dim_resource_managers_btmup_hist.calendar_key::text, 'MM/DD/YYYY'::text)::timestamp with time zone, 'YYYYMMDD'::text)::integer
136. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..150,712,519,154.93 rows=5,125,311,558,369 width=3,365) (actual rows= loops=)

  • Hash Cond: share0_ref3.role_group_code::text = toms_hub.dim_report_lookup.code::text
137. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..79,029,921,077.86 rows=5,114,096,890,799 width=3,349) (actual rows= loops=)

  • Hash Cond: share0_ref3.resource_key = dim_resource_managers_hist.resource_key AND share0_ref3.calendar_key = to_char(to_date(dim_resource_managers_hist.calendar_key::text, 'MM/DD/YYYY'::text)::timestamp with time zone, 'YYYYMMDD'::text)::integer
138. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..15,481,219,871.26 rows=367,057,213,911 width=3,010) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_3_ms_id::text = toms_hub.dim_resource.ms_id::text
139. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..11,027,740,215.73 rows=293,416,179,780 width=2,997) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_2_ms_id::text = toms_hub.dim_resource.ms_id::text
140. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..7,482,949,734.48 rows=234,549,192,792 width=2,984) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_1_ms_id::text = toms_hub.dim_resource.ms_id::text
141. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..4,661,288,569.30 rows=187,595,781,144 width=2,971) (actual rows= loops=)

  • Hash Cond: share0_ref3.role_code::text = toms_hub.dim_report_lookup.code::text
142. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,341,072,595.81 rows=187,183,192,774 width=2,956) (actual rows= loops=)

  • Hash Cond: ((toms_hub.dim_resource.business_area_code::text || '-'::text) || toms_hub.dim_resource.resource_type_code::text) = toms_hub.dim_report_lookup.code::text
143. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..383,275,309.27 rows=10,310,686,846 width=2,948) (actual rows= loops=)

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

Hash Left Join (cost=0.00..263,697,959.22 rows=6,744,689,459 width=2,926) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.pt_repl_ms_id::text = toms_hub.dim_resource.ms_id::text
145. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..183,830,539.86 rows=5,602,971,661 width=2,878) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.request_id = dim_resource_requisition.request_id
146. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..120,104,012.08 rows=3,837,022,105 width=2,833) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.pt_justification_type_code::text = toms_hub.dim_report_lookup.code::text
147. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..74,807,658.17 rows=3,837,022,105 width=2,817) (actual rows= loops=)

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

Hash Left Join (cost=0.00..32,251,954.03 rows=2,506,642,954 width=2,809) (actual rows= loops=)

  • Hash Cond: ((toms_hub.dim_resource.business_area_code::text || '-'::text) || toms_hub.dim_resource.resource_type_code::text) = toms_hub.dim_report_lookup.code::text
149. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..7,335,497.24 rows=138,074,419 width=2,801) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.pt_position_type_code::text = toms_hub.dim_report_lookup.code::text
150. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,723,000.32 rows=138,074,419 width=2,783) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.pt_request_status_code::text = toms_hub.dim_report_lookup.code::text
151. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..4,120,547.49 rows=138,074,419 width=2,767) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_3_resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
152. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,615,700.07 rows=89,997,688 width=2,758) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_2_resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
153. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,637,701.32 rows=58,653,960 width=2,749) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_1_resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
154. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,001,970.96 rows=38,279,943 width=2,740) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_3_location_code::text = toms_hub.dim_location.location_code::text
155. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..588,021.40 rows=24,997,909 width=2,735) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_2_location_code::text = toms_hub.dim_location.location_code::text
156. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..317,888.01 rows=16,324,342 width=2,730) (actual rows= loops=)

  • Hash Cond: share0_ref3.co_mgr_1_location_code::text = toms_hub.dim_location.location_code::text
157. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..141,483.73 rows=10,670,132 width=2,725) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.hr_cc_code::text = toms_hub.dim_integrated_cc.cc_id::text
158. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice29; segments: 304) (cost=0.00..37,448.93 rows=1,056,519 width=1,832) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.hr_cc_code
159. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..31,390.68 rows=1,056,519 width=1,832) (actual rows= loops=)

  • Hash Cond: share0_ref3.mgr_resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
160. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..22,834.53 rows=716,300 width=1,823) (actual rows= loops=)

  • Hash Cond: share0_ref3.mgr_location_code::text = toms_hub.dim_location.location_code::text
161. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..16,804.56 rows=467,730 width=1,804) (actual rows= loops=)

  • Hash Cond: share0_ref3.mgr_ms_id::text = toms_hub.dim_resource.ms_id::text
162. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..12,489.19 rows=373,862 width=1,786) (actual rows= loops=)

  • Hash Cond: share0_ref3.location_code::text = toms_hub.dim_location.location_code::text
163. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..8,997.41 rows=244,121 width=1,578) (actual rows= loops=)

  • Hash Cond: share0_ref3.cost_center::text = toms_hub.dim_integrated_cc.cc_id::text
164. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice13; segments: 304) (cost=0.00..6,728.74 rows=24,172 width=676) (actual rows= loops=)

  • Hash Key: share0_ref3.cost_center
165. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,677.60 rows=24,172 width=676) (actual rows= loops=)

  • Hash Cond: share0_ref3.prev_resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
166. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,749.00 rows=16,052 width=676) (actual rows= loops=)

  • Hash Cond: share0_ref3.resource_cat_code::text = toms_hub.dim_resource_category.resource_category_code::text
167. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..4,842.23 rows=13,049 width=560) (actual rows= loops=)

  • Hash Cond: share0_ref3.resource_key = toms_hub.dim_resource.resource_key
168. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice4; segments: 304) (cost=0.00..3,944.03 rows=12,318 width=310) (actual rows= loops=)

  • Hash Key: share0_ref3.resource_key
169. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,932.07 rows=12,318 width=310) (actual rows= loops=)

  • Hash Cond: substr("varchar"(share0_ref3.calendar_key::character varying, 14, true)::text, 1, 4) = toms_hub.dim_report_lookup.code::text
170. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,591.33 rows=1,248,795 width=310) (actual rows= loops=)

  • Filter: share0_ref3.transaction_type <> 'P'::bpchar
171. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 4:0) (cost=0.00..2,500.21 rows=2,769,661 width=310) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Hash (cost=874.57..874.57 rows=1 width=7) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice3) (cost=0.00..874.57 rows=304 width=7) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..874.57 rows=1 width=7) (actual rows= loops=)

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

Gather Motion 304:1 (slice1; segments: 304) (cost=0.00..443.57 rows=2 width=11) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Table Scan on dim_report_lookup (cost=0.00..443.57 rows=1 width=11) (actual rows= loops=)

  • Filter: title::text = 'RESOURCE_CUBE_TIMELINE'::text AND description::text = 'ON'::text
177. 0.000 0.000 ↓ 0.0

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

178. 0.000 0.000 ↓ 0.0

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

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

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

180. 0.000 0.000 ↓ 0.0

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

181. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
182. 0.000 0.000 ↓ 0.0

Hash (cost=867.18..867.18 rows=169 width=254) (actual rows= loops=)

183. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..867.18 rows=169 width=254) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.72 rows=2,839 width=258) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

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

186. 0.000 0.000 ↓ 0.0

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

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

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

188. 0.000 0.000 ↓ 0.0

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

189. 0.000 0.000 ↓ 0.0

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

190. 0.000 0.000 ↓ 0.0

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

191. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
192. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=125) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice9; segments: 304) (cost=0.00..862.01 rows=20 width=125) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=125) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=129) (actual rows= loops=)

196. 0.000 0.000 ↓ 0.0

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

197. 0.000 0.000 ↓ 0.0

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

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

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

199. 0.000 0.000 ↓ 0.0

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

200. 0.000 0.000 ↓ 0.0

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

201. 0.000 0.000 ↓ 0.0

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

202. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
203. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=9) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice12; segments: 304) (cost=0.00..862.01 rows=20 width=9) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=9) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=13) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

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

208. 0.000 0.000 ↓ 0.0

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

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

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

210. 0.000 0.000 ↓ 0.0

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

211. 0.000 0.000 ↓ 0.0

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

212. 0.000 0.000 ↓ 0.0

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

213. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
214. 0.000 0.000 ↓ 0.0

Hash (cost=876.17..876.17 rows=1,454 width=907) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice16; segments: 304) (cost=0.00..876.17 rows=1,454 width=907) (actual rows= loops=)

  • Hash Key: toms_hub.dim_integrated_cc.cc_id
216. 0.000 0.000 ↓ 0.0

Hash EXISTS Join (cost=0.00..872.05 rows=1,454 width=907) (actual rows= loops=)

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

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=911) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

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

219. 0.000 0.000 ↓ 0.0

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

220. 0.000 0.000 ↓ 0.0

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

221. 0.000 0.000 ↓ 0.0

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

222. 0.000 0.000 ↓ 0.0

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

223. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=4) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Hash (cost=863.12..863.12 rows=2,963 width=213) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice19; segments: 304) (cost=0.00..863.12 rows=2,963 width=213) (actual rows= loops=)

226. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.17 rows=10 width=213) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.04 rows=165 width=217) (actual rows= loops=)

228. 0.000 0.000 ↓ 0.0

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

229. 0.000 0.000 ↓ 0.0

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

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

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

231. 0.000 0.000 ↓ 0.0

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

232. 0.000 0.000 ↓ 0.0

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

233. 0.000 0.000 ↓ 0.0

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

234. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
235. 0.000 0.000 ↓ 0.0

Hash (cost=866.68..866.68 rows=38,308 width=23) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice22; segments: 304) (cost=0.00..866.68 rows=38,308 width=23) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..865.35 rows=127 width=23) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.93 rows=2,122 width=27) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
239. 0.000 0.000 ↓ 0.0

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

240. 0.000 0.000 ↓ 0.0

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

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

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

242. 0.000 0.000 ↓ 0.0

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

243. 0.000 0.000 ↓ 0.0

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

244. 0.000 0.000 ↓ 0.0

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

245. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
246. 0.000 0.000 ↓ 0.0

Hash (cost=862.21..862.21 rows=2,963 width=29) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice25; segments: 304) (cost=0.00..862.21 rows=2,963 width=29) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.08 rows=10 width=29) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.04 rows=165 width=33) (actual rows= loops=)

250. 0.000 0.000 ↓ 0.0

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

251. 0.000 0.000 ↓ 0.0

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

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

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

253. 0.000 0.000 ↓ 0.0

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

254. 0.000 0.000 ↓ 0.0

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

255. 0.000 0.000 ↓ 0.0

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

256. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
257. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=22) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice28; segments: 304) (cost=0.00..862.01 rows=20 width=22) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=22) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=26) (actual rows= loops=)

261. 0.000 0.000 ↓ 0.0

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

262. 0.000 0.000 ↓ 0.0

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

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

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

264. 0.000 0.000 ↓ 0.0

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

265. 0.000 0.000 ↓ 0.0

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

266. 0.000 0.000 ↓ 0.0

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

267. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
268. 0.000 0.000 ↓ 0.0

Hash (cost=876.12..876.12 rows=1,454 width=903) (actual rows= loops=)

269. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice32; segments: 304) (cost=0.00..876.12 rows=1,454 width=903) (actual rows= loops=)

  • Hash Key: toms_hub.dim_integrated_cc.cc_id
270. 0.000 0.000 ↓ 0.0

Hash EXISTS Join (cost=0.00..872.01 rows=1,454 width=903) (actual rows= loops=)

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

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=907) (actual rows= loops=)

272. 0.000 0.000 ↓ 0.0

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

273. 0.000 0.000 ↓ 0.0

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

274. 0.000 0.000 ↓ 0.0

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

275. 0.000 0.000 ↓ 0.0

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

276. 0.000 0.000 ↓ 0.0

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

277. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=4) (actual rows= loops=)

278. 0.000 0.000 ↓ 0.0

Hash (cost=862.14..862.14 rows=2,963 width=14) (actual rows= loops=)

279. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice35; segments: 304) (cost=0.00..862.14 rows=2,963 width=14) (actual rows= loops=)

280. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.08 rows=10 width=14) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.04 rows=165 width=18) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

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

283. 0.000 0.000 ↓ 0.0

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

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

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

285. 0.000 0.000 ↓ 0.0

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

286. 0.000 0.000 ↓ 0.0

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

287. 0.000 0.000 ↓ 0.0

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

288. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
289. 0.000 0.000 ↓ 0.0

Hash (cost=862.14..862.14 rows=2,963 width=14) (actual rows= loops=)

290. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice38; segments: 304) (cost=0.00..862.14 rows=2,963 width=14) (actual rows= loops=)

291. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.08 rows=10 width=14) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.04 rows=165 width=18) (actual rows= loops=)

293. 0.000 0.000 ↓ 0.0

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

294. 0.000 0.000 ↓ 0.0

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

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

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

296. 0.000 0.000 ↓ 0.0

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

297. 0.000 0.000 ↓ 0.0

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

298. 0.000 0.000 ↓ 0.0

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

299. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
300. 0.000 0.000 ↓ 0.0

Hash (cost=862.14..862.14 rows=2,963 width=14) (actual rows= loops=)

301. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice41; segments: 304) (cost=0.00..862.14 rows=2,963 width=14) (actual rows= loops=)

302. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.08 rows=10 width=14) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.04 rows=165 width=18) (actual rows= loops=)

304. 0.000 0.000 ↓ 0.0

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

305. 0.000 0.000 ↓ 0.0

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

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

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

307. 0.000 0.000 ↓ 0.0

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

308. 0.000 0.000 ↓ 0.0

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

309. 0.000 0.000 ↓ 0.0

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

310. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
311. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=22) (actual rows= loops=)

312. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice44; segments: 304) (cost=0.00..862.01 rows=20 width=22) (actual rows= loops=)

313. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=22) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=26) (actual rows= loops=)

315. 0.000 0.000 ↓ 0.0

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

316. 0.000 0.000 ↓ 0.0

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

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

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

318. 0.000 0.000 ↓ 0.0

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

319. 0.000 0.000 ↓ 0.0

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

320. 0.000 0.000 ↓ 0.0

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

321. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
322. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=22) (actual rows= loops=)

323. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice47; segments: 304) (cost=0.00..862.01 rows=20 width=22) (actual rows= loops=)

324. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=22) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=26) (actual rows= loops=)

326. 0.000 0.000 ↓ 0.0

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

327. 0.000 0.000 ↓ 0.0

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

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

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

329. 0.000 0.000 ↓ 0.0

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

330. 0.000 0.000 ↓ 0.0

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

331. 0.000 0.000 ↓ 0.0

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

332. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
333. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=20 width=22) (actual rows= loops=)

334. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice50; segments: 304) (cost=0.00..862.01 rows=20 width=22) (actual rows= loops=)

335. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=1 width=22) (actual rows= loops=)

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=2 width=26) (actual rows= loops=)

337. 0.000 0.000 ↓ 0.0

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

338. 0.000 0.000 ↓ 0.0

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

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

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

340. 0.000 0.000 ↓ 0.0

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

341. 0.000 0.000 ↓ 0.0

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

342. 0.000 0.000 ↓ 0.0

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

343. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_category'::text AND table_schema::text = 'toms_hub'::text
344. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

345. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice53; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

346. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'REQUEST_STATUS'::text
348. 0.000 0.000 ↓ 0.0

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

349. 0.000 0.000 ↓ 0.0

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

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

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

351. 0.000 0.000 ↓ 0.0

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

352. 0.000 0.000 ↓ 0.0

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

353. 0.000 0.000 ↓ 0.0

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

354. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
355. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

356. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice56; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

357. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'POSITION_TYPE'::text
359. 0.000 0.000 ↓ 0.0

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

360. 0.000 0.000 ↓ 0.0

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

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

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

362. 0.000 0.000 ↓ 0.0

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

363. 0.000 0.000 ↓ 0.0

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

364. 0.000 0.000 ↓ 0.0

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

365. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
366. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

367. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice59; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

368. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'RESOURCE_TYPE'::text
370. 0.000 0.000 ↓ 0.0

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

371. 0.000 0.000 ↓ 0.0

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

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

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

373. 0.000 0.000 ↓ 0.0

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

374. 0.000 0.000 ↓ 0.0

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

375. 0.000 0.000 ↓ 0.0

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

376. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
377. 0.000 0.000 ↓ 0.0

Hash (cost=862.17..862.17 rows=2,963 width=18) (actual rows= loops=)

378. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice62; segments: 304) (cost=0.00..862.17 rows=2,963 width=18) (actual rows= loops=)

379. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.09 rows=10 width=18) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.05 rows=165 width=22) (actual rows= loops=)

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

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

382. 0.000 0.000 ↓ 0.0

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

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

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

384. 0.000 0.000 ↓ 0.0

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

385. 0.000 0.000 ↓ 0.0

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

386. 0.000 0.000 ↓ 0.0

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

387. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
388. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

389. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice65; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

390. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'JUSTIFICATION_TYPE'::text
392. 0.000 0.000 ↓ 0.0

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

393. 0.000 0.000 ↓ 0.0

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

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

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

395. 0.000 0.000 ↓ 0.0

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

396. 0.000 0.000 ↓ 0.0

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

397. 0.000 0.000 ↓ 0.0

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

398. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
399. 0.000 0.000 ↓ 0.0

Hash (cost=866.48..866.48 rows=41,736 width=49) (actual rows= loops=)

400. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice68; segments: 304) (cost=0.00..866.48 rows=41,736 width=49) (actual rows= loops=)

401. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.38 rows=138 width=49) (actual rows= loops=)

  • Hash Cond: dim_resource_requisition.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
402. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource_requisition (cost=0.00..431.88 rows=2,312 width=53) (actual rows= loops=)

  • Filter: is_primary_requisition = 'Y'::bpchar AND is_deleted = 'N'::bpchar
403. 0.000 0.000 ↓ 0.0

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

404. 0.000 0.000 ↓ 0.0

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

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

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

406. 0.000 0.000 ↓ 0.0

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

407. 0.000 0.000 ↓ 0.0

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

408. 0.000 0.000 ↓ 0.0

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

409. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_requisition'::text AND table_schema::text = 'toms_hub'::text
410. 0.000 0.000 ↓ 0.0

Hash (cost=868.59..868.59 rows=38,308 width=53) (actual rows= loops=)

411. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice71; segments: 304) (cost=0.00..868.59 rows=38,308 width=53) (actual rows= loops=)

412. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..865.52 rows=127 width=53) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..434.05 rows=2,122 width=57) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
414. 0.000 0.000 ↓ 0.0

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

415. 0.000 0.000 ↓ 0.0

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

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

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

417. 0.000 0.000 ↓ 0.0

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

418. 0.000 0.000 ↓ 0.0

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

419. 0.000 0.000 ↓ 0.0

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

420. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
421. 0.000 0.000 ↓ 0.0

Hash (cost=862.24..862.24 rows=2,963 width=32) (actual rows= loops=)

422. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice74; segments: 304) (cost=0.00..862.24 rows=2,963 width=32) (actual rows= loops=)

423. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.09 rows=10 width=32) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.05 rows=165 width=36) (actual rows= loops=)

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

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

426. 0.000 0.000 ↓ 0.0

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

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

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

428. 0.000 0.000 ↓ 0.0

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

429. 0.000 0.000 ↓ 0.0

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

430. 0.000 0.000 ↓ 0.0

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

431. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_location'::text AND table_schema::text = 'toms_hub'::text
432. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

433. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice77; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

434. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'RESOURCE_TYPE'::text
436. 0.000 0.000 ↓ 0.0

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

437. 0.000 0.000 ↓ 0.0

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

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

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

439. 0.000 0.000 ↓ 0.0

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

440. 0.000 0.000 ↓ 0.0

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

441. 0.000 0.000 ↓ 0.0

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

442. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
443. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

444. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice80; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

445. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'ROLE'::text
447. 0.000 0.000 ↓ 0.0

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

448. 0.000 0.000 ↓ 0.0

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

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

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

450. 0.000 0.000 ↓ 0.0

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

451. 0.000 0.000 ↓ 0.0

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

452. 0.000 0.000 ↓ 0.0

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

453. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
454. 0.000 0.000 ↓ 0.0

Hash (cost=866.36..866.36 rows=38,308 width=18) (actual rows= loops=)

455. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice83; segments: 304) (cost=0.00..866.36 rows=38,308 width=18) (actual rows= loops=)

456. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..865.32 rows=127 width=18) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.91 rows=2,122 width=22) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
458. 0.000 0.000 ↓ 0.0

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

459. 0.000 0.000 ↓ 0.0

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

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

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

461. 0.000 0.000 ↓ 0.0

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

462. 0.000 0.000 ↓ 0.0

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

463. 0.000 0.000 ↓ 0.0

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

464. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
465. 0.000 0.000 ↓ 0.0

Hash (cost=866.36..866.36 rows=38,308 width=18) (actual rows= loops=)

466. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice86; segments: 304) (cost=0.00..866.36 rows=38,308 width=18) (actual rows= loops=)

467. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..865.32 rows=127 width=18) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.91 rows=2,122 width=22) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
469. 0.000 0.000 ↓ 0.0

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

470. 0.000 0.000 ↓ 0.0

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

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

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

472. 0.000 0.000 ↓ 0.0

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

473. 0.000 0.000 ↓ 0.0

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

474. 0.000 0.000 ↓ 0.0

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

475. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
476. 0.000 0.000 ↓ 0.0

Hash (cost=866.36..866.36 rows=38,308 width=18) (actual rows= loops=)

477. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice89; segments: 304) (cost=0.00..866.36 rows=38,308 width=18) (actual rows= loops=)

478. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..865.32 rows=127 width=18) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.91 rows=2,122 width=22) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
480. 0.000 0.000 ↓ 0.0

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

481. 0.000 0.000 ↓ 0.0

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

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

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

483. 0.000 0.000 ↓ 0.0

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

484. 0.000 0.000 ↓ 0.0

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

485. 0.000 0.000 ↓ 0.0

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

486. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource'::text AND table_schema::text = 'toms_hub'::text
487. 0.000 0.000 ↓ 0.0

Hash (cost=6,892.59..6,892.59 rows=4,187,830 width=354) (actual rows= loops=)

488. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice92; segments: 304) (cost=0.00..6,892.59 rows=4,187,830 width=354) (actual rows= loops=)

489. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..4,649.10 rows=13,776 width=354) (actual rows= loops=)

  • Hash Cond: dim_resource_managers_hist.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
490. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource_managers_hist (cost=0.00..1,112.05 rows=2,920,460 width=358) (actual rows= loops=)

491. 0.000 0.000 ↓ 0.0

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

492. 0.000 0.000 ↓ 0.0

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

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

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

494. 0.000 0.000 ↓ 0.0

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

495. 0.000 0.000 ↓ 0.0

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

496. 0.000 0.000 ↓ 0.0

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

497. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_managers_hist'::text AND table_schema::text = 'toms_hub'::text
498. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

499. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice95; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

500. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'ROLE_GROUP'::text
502. 0.000 0.000 ↓ 0.0

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

503. 0.000 0.000 ↓ 0.0

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

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

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

505. 0.000 0.000 ↓ 0.0

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

506. 0.000 0.000 ↓ 0.0

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

507. 0.000 0.000 ↓ 0.0

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

508. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
509. 0.000 0.000 ↓ 0.0

Hash (cost=4,146.76..4,146.76 rows=4,307,622 width=307) (actual rows= loops=)

510. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice98; segments: 304) (cost=0.00..4,146.76 rows=4,307,622 width=307) (actual rows= loops=)

511. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,145.48 rows=14,170 width=307) (actual rows= loops=)

  • Hash Cond: dim_resource_managers_btmup_hist.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
512. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource_managers_btmup_hist (cost=0.00..711.86 rows=1,048,566 width=311) (actual rows= loops=)

513. 0.000 0.000 ↓ 0.0

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

514. 0.000 0.000 ↓ 0.0

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

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

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

516. 0.000 0.000 ↓ 0.0

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

517. 0.000 0.000 ↓ 0.0

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

518. 0.000 0.000 ↓ 0.0

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

519. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_resource_managers_btmup_hist'::text AND table_schema::text = 'toms_hub'::text
520. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

521. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice101; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

522. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'RESOURCE_TRANSFER_LEVEL_TYPE'::text
524. 0.000 0.000 ↓ 0.0

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

525. 0.000 0.000 ↓ 0.0

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

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

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

527. 0.000 0.000 ↓ 0.0

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

528. 0.000 0.000 ↓ 0.0

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

529. 0.000 0.000 ↓ 0.0

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

530. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
531. 0.000 0.000 ↓ 0.0

Hash (cost=864.42..864.42 rows=36,543 width=21) (actual rows= loops=)

532. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice104; segments: 304) (cost=0.00..864.42 rows=36,543 width=21) (actual rows= loops=)

533. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.26 rows=121 width=21) (actual rows= loops=)

  • Hash Cond: dim_calendar.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
534. 0.000 0.000 ↓ 0.0

Table Scan on dim_calendar (cost=0.00..431.62 rows=2,645 width=25) (actual rows= loops=)

535. 0.000 0.000 ↓ 0.0

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

536. 0.000 0.000 ↓ 0.0

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

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

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

538. 0.000 0.000 ↓ 0.0

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

539. 0.000 0.000 ↓ 0.0

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

540. 0.000 0.000 ↓ 0.0

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

541. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_calendar'::text AND table_schema::text = 'toms_hub'::text
542. 0.000 0.000 ↓ 0.0

Hash (cost=863.32..863.32 rows=3,690 width=202) (actual rows= loops=)

543. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice107; segments: 304) (cost=0.00..863.32 rows=3,690 width=202) (actual rows= loops=)

544. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.19 rows=13 width=202) (actual rows= loops=)

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

Table Scan on secured_dim_vendor (cost=0.00..431.04 rows=205 width=206) (actual rows= loops=)

546. 0.000 0.000 ↓ 0.0

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

547. 0.000 0.000 ↓ 0.0

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

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

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

549. 0.000 0.000 ↓ 0.0

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

550. 0.000 0.000 ↓ 0.0

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

551. 0.000 0.000 ↓ 0.0

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

552. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'secured_dim_vendor'::text AND table_schema::text = 'toms_hub'::text
553. 0.000 0.000 ↓ 0.0

Hash (cost=874.59..874.59 rows=32 width=27) (actual rows= loops=)

554. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice110; segments: 304) (cost=0.00..874.59 rows=32 width=27) (actual rows= loops=)

555. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..874.59 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..443.57 rows=47 width=31) (actual rows= loops=)

  • Filter: title::text = 'RESOURCE_SNAPSHOT_TXN_TYPE'::text AND (code::text < 'P'::bpchar::text OR code::text > 'P'::bpchar::text)
557. 0.000 0.000 ↓ 0.0

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

558. 0.000 0.000 ↓ 0.0

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

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

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

560. 0.000 0.000 ↓ 0.0

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

561. 0.000 0.000 ↓ 0.0

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

562. 0.000 0.000 ↓ 0.0

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

563. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
564. 0.000 0.000 ↓ 0.0

Hash (cost=870.28..870.28 rows=441,736 width=9) (actual rows= loops=)

565. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice113; segments: 304) (cost=0.00..870.28 rows=441,736 width=9) (actual rows= loops=)

566. 0.000 0.000 ↓ 0.0

Hash EXISTS Join (cost=0.00..864.26 rows=1,454 width=9) (actual rows= loops=)

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

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=13) (actual rows= loops=)

568. 0.000 0.000 ↓ 0.0

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

569. 0.000 0.000 ↓ 0.0

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

570. 0.000 0.000 ↓ 0.0

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

571. 0.000 0.000 ↓ 0.0

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

572. 0.000 0.000 ↓ 0.0

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

573. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.95 rows=1,454 width=4) (actual rows= loops=)

574. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

575. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice116; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

576. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'HEADCOUNT_LEVEL'::text
578. 0.000 0.000 ↓ 0.0

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

579. 0.000 0.000 ↓ 0.0

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

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

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

581. 0.000 0.000 ↓ 0.0

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

582. 0.000 0.000 ↓ 0.0

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

583. 0.000 0.000 ↓ 0.0

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

584. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
585. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

586. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice119; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

587. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'HEADCOUNT_LEVEL'::text
589. 0.000 0.000 ↓ 0.0

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

590. 0.000 0.000 ↓ 0.0

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

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

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

592. 0.000 0.000 ↓ 0.0

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

593. 0.000 0.000 ↓ 0.0

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

594. 0.000 0.000 ↓ 0.0

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

595. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
596. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

597. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice122; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

598. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'JOB_LEVEL'::text
600. 0.000 0.000 ↓ 0.0

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

601. 0.000 0.000 ↓ 0.0

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

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

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

603. 0.000 0.000 ↓ 0.0

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

604. 0.000 0.000 ↓ 0.0

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

605. 0.000 0.000 ↓ 0.0

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

606. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
607. 0.000 0.000 ↓ 0.0

Hash (cost=871.97..871.97 rows=45 width=27) (actual rows= loops=)

608. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice125; segments: 304) (cost=0.00..871.97 rows=45 width=27) (actual rows= loops=)

609. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..871.97 rows=1 width=27) (actual rows= loops=)

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

Table Scan on dim_report_lookup (cost=0.00..440.95 rows=66 width=31) (actual rows= loops=)

  • Filter: title::text = 'JOB_LEVEL'::text
611. 0.000 0.000 ↓ 0.0

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

612. 0.000 0.000 ↓ 0.0

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

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

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

614. 0.000 0.000 ↓ 0.0

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

615. 0.000 0.000 ↓ 0.0

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

616. 0.000 0.000 ↓ 0.0

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

617. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_report_lookup'::text AND table_schema::text = 'toms_hub'::text
618. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=8) (actual rows= loops=)

619. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice126; segments: 304) (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

620. 0.000 0.000 ↓ 0.0

Table Scan on pt_resource_candidate (cost=0.00..431.00 rows=1 width=8) (actual rows= loops=)

621. 0.000 0.000 ↓ 0.0

Hash (cost=3,451.72..3,451.72 rows=4 width=204) (actual rows= loops=)

622. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice138; segments: 304) (cost=0.00..3,451.72 rows=4 width=204) (actual rows= loops=)

623. 0.000 0.000 ↓ 0.0

Result (cost=0.00..3,451.34 rows=1 width=204) (actual rows= loops=)

624. 0.000 0.000 ↓ 0.0

Result (cost=0.00..3,451.34 rows=1 width=204) (actual rows= loops=)

625. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..3,451.34 rows=1 width=327) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_requisition.req_nbr::text = share3_ref3.req_number
626. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,724.66 rows=1 width=294) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_requisition.req_nbr::text = toms_hub.dim_fg_requisition.requisition_id::text
627. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..862.01 rows=1 width=148) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_requisition.req_nbr::text = share3_ref4.req_number
628. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice127; segments: 304) (cost=0.00..431.00 rows=1 width=36) (actual rows= loops=)

  • Hash Key: toms_hub.pt_requisition.req_nbr
629. 0.000 0.000 ↓ 0.0

Table Scan on pt_requisition (cost=0.00..431.00 rows=1 width=36) (actual rows= loops=)

  • Filter: primary_req = 1
630. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=4 width=112) (actual rows= loops=)

631. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice128; segments: 304) (cost=0.00..431.00 rows=4 width=112) (actual rows= loops=)

  • Hash Key: share3_ref4.req_number
632. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.00 rows=4 width=112) (actual rows= loops=)

633. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 128:3) (cost=0.00..431.00 rows=4 width=112) (actual rows= loops=)

634. 0.000 0.000 ↓ 0.0

Hash (cost=862.55..862.55 rows=28 width=146) (actual rows= loops=)

635. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice131; segments: 304) (cost=0.00..862.55 rows=28 width=146) (actual rows= loops=)

  • Hash Key: toms_hub.dim_fg_requisition.requisition_id
636. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.54 rows=28 width=146) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_fg_requisition.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
637. 0.000 0.000 ↓ 0.0

Table Scan on dim_fg_requisition (cost=0.00..431.27 rows=460 width=150) (actual rows= loops=)

638. 0.000 0.000 ↓ 0.0

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

639. 0.000 0.000 ↓ 0.0

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

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

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

641. 0.000 0.000 ↓ 0.0

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

642. 0.000 0.000 ↓ 0.0

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

643. 0.000 0.000 ↓ 0.0

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

644. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_fg_requisition'::text AND table_schema::text = 'toms_hub'::text
645. 0.000 0.000 ↓ 0.0

Hash (cost=1,726.67..1,726.67 rows=4 width=41) (actual rows= loops=)

646. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice137; segments: 304) (cost=0.00..1,726.67 rows=4 width=41) (actual rows= loops=)

  • Hash Key: share3_ref3.req_number
647. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,726.67 rows=4 width=41) (actual rows= loops=)

  • Hash Cond: (max((max(toms_hub.cfg_lookup_param.lookup_val_int_1)))) = toms_hub.cfg_lookup_param.lookup_val_int_1
648. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice135; segments: 304) (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

  • Hash Key: (max((max(toms_hub.cfg_lookup_param.lookup_val_int_1))))
649. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

650. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

  • Group By: share3_ref3.req_number
651. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice134; segments: 304) (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

  • Hash Key: share3_ref3.req_number
652. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

653. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,295.66 rows=4 width=12) (actual rows= loops=)

  • Group By: share3_ref3.req_number
654. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,295.25 rows=3,324 width=12) (actual rows= loops=)

  • Hash Cond: "varchar"(COALESCE((share4_ref3.step || ' - '::text) || share4_ref3.status, 'No - Candidates'::text)::character varying, 504, true)::text = toms_hub.cfg_lookup_param.lookup_code_string::text
655. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..863.60 rows=1,851 width=24) (actual rows= loops=)

  • Hash Cond: share3_ref3.gen_reqid = share4_ref3.gen_reqid
656. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 134:3) (cost=0.00..431.00 rows=4 width=16) (actual rows= loops=)

657. 0.000 0.000 ↓ 0.0

Hash (cost=431.25..431.25 rows=1,851 width=24) (actual rows= loops=)

658. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice132; segments: 304) (cost=0.00..431.25 rows=1,851 width=24) (actual rows= loops=)

  • Hash Key: share4_ref3.gen_reqid
659. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.11 rows=1,851 width=24) (actual rows= loops=)

660. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 132:4) (cost=0.00..431.11 rows=1,851 width=24) (actual rows= loops=)

661. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=4 width=9) (actual rows= loops=)

662. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice133; segments: 304) (cost=0.00..431.00 rows=4 width=9) (actual rows= loops=)

663. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=9) (actual rows= loops=)

  • Filter: title::text = 'TALEO_STATUS'::text AND lookup_val_string_6::text = 'Y'::text AND is_deleted = 'N'::bpchar
664. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=1 width=37) (actual rows= loops=)

665. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice136; segments: 304) (cost=0.00..431.00 rows=1 width=37) (actual rows= loops=)

  • Hash Key: toms_hub.cfg_lookup_param.lookup_val_int_1
666. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=37) (actual rows= loops=)

  • Filter: title::text = 'TALEO_STATUS'::text AND lookup_val_string_6::text = 'Y'::text AND is_deleted = 'N'::bpchar
667. 0.000 0.000 ↓ 0.0

Hash (cost=431.28..431.28 rows=22,663 width=8) (actual rows= loops=)

668. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice139; segments: 304) (cost=0.00..431.28 rows=22,663 width=8) (actual rows= loops=)

669. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 139:2) (cost=0.00..431.00 rows=75 width=8) (actual rows= loops=)

670. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=87 width=14) (actual rows= loops=)

671. 0.000 0.000 ↓ 0.0

Table Scan on fact_fg_contingent_tenure_calc (cost=0.00..431.00 rows=87 width=14) (actual rows= loops=)

672. 0.000 0.000 ↓ 0.0

Hash (cost=15,486.20..15,486.20 rows=315,126 width=101) (actual rows= loops=)

673. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice153; segments: 304) (cost=0.00..15,486.20 rows=315,126 width=101) (actual rows= loops=)

  • Hash Key: share0_ref2.ms_id
674. 0.000 0.000 ↓ 0.0

Result (cost=0.00..15,386.58 rows=315,126 width=101) (actual rows= loops=)

675. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..15,386.58 rows=315,126 width=101) (actual rows= loops=)

  • Group By: share0_ref2.snapshot_type, share0_ref2.transaction_type, share0_ref2.ms_id, share0_ref2.transaction_date
676. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice152; segments: 304) (cost=0.00..14,954.93 rows=787,815 width=101) (actual rows= loops=)

  • Hash Key: share0_ref2.snapshot_type, share0_ref2.transaction_type, share0_ref2.ms_id, share0_ref2.transaction_date
677. 0.000 0.000 ↓ 0.0

Result (cost=0.00..14,705.88 rows=787,815 width=101) (actual rows= loops=)

678. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..14,705.88 rows=787,815 width=101) (actual rows= loops=)

  • Group By: share0_ref2.snapshot_type, share0_ref2.transaction_type, share0_ref2.ms_id, share0_ref2.transaction_date
679. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..11,126.23 rows=6,426,063 width=131) (actual rows= loops=)

  • Hash Cond: secured_fact_work_order.pay_currency::text = horizon_fx_rates.currency_code::text
680. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,882.12 rows=3,442,872 width=128) (actual rows= loops=)

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

Hash Left Join (cost=0.00..3,881.83 rows=2,465,364 width=72) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice145; segments: 304) (cost=0.00..2,133.93 rows=1,355,199 width=21) (actual rows= loops=)

  • Hash Key: secured_fact_resource_fg_status.work_order_fact_key
683. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,044.85 rows=1,355,199 width=21) (actual rows= loops=)

  • Hash Cond: share0_ref2.ms_id::text = secured_fact_resource_fg_status.ms_id::text
  • Join Filter: share0_ref2.transaction_date >= secured_fact_resource_fg_status.business_eff_start_dt AND share0_ref2.transaction_date <= secured_fact_resource_fg_status.business_eff_end_dt
684. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice141; segments: 304) (cost=0.00..732.07 rows=787,815 width=13) (actual rows= loops=)

  • Hash Key: share0_ref2.ms_id
685. 0.000 0.000 ↓ 0.0

Result (cost=0.00..700.02 rows=787,815 width=13) (actual rows= loops=)

  • Filter: NOT share0_ref2.ms_id::text = 'N/A'::text AND NOT share0_ref2.ms_id IS NULL AND (share0_ref2.transaction_type < 'P'::bpchar OR share0_ref2.transaction_type > 'P'::bpchar)
686. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 141:0) (cost=0.00..517.77 rows=2,769,661 width=13) (actual rows= loops=)

687. 0.000 0.000 ↓ 0.0

Hash (cost=864.40..864.40 rows=317 width=21) (actual rows= loops=)

688. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice144; segments: 304) (cost=0.00..864.40 rows=317 width=21) (actual rows= loops=)

  • Hash Key: secured_fact_resource_fg_status.ms_id
689. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..864.38 rows=317 width=21) (actual rows= loops=)

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

Table Scan on secured_fact_resource_fg_status (cost=0.00..432.34 rows=5,334 width=25) (actual rows= loops=)

  • Filter: ms_id::text < 'N/A'::text OR ms_id::text > 'N/A'::text
691. 0.000 0.000 ↓ 0.0

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

692. 0.000 0.000 ↓ 0.0

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

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

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

694. 0.000 0.000 ↓ 0.0

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

695. 0.000 0.000 ↓ 0.0

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

696. 0.000 0.000 ↓ 0.0

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

697. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'secured_fact_resource_fg_status'::text AND table_schema::text = 'toms_hub'::text
698. 0.000 0.000 ↓ 0.0

Hash (cost=872.31..872.31 rows=1,013 width=59) (actual rows= loops=)

699. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..872.31 rows=1,013 width=59) (actual rows= loops=)

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

Table Scan on secured_fact_work_order (cost=0.00..435.43 rows=17,205 width=63) (actual rows= loops=)

701. 0.000 0.000 ↓ 0.0

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

702. 0.000 0.000 ↓ 0.0

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

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

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

704. 0.000 0.000 ↓ 0.0

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

705. 0.000 0.000 ↓ 0.0

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

706. 0.000 0.000 ↓ 0.0

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

707. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'secured_fact_work_order'::text AND table_schema::text = 'toms_hub'::text
708. 0.000 0.000 ↓ 0.0

Hash (cost=866.92..866.92 rows=35,022 width=64) (actual rows= loops=)

709. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice150; segments: 304) (cost=0.00..866.92 rows=35,022 width=64) (actual rows= loops=)

710. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.52 rows=116 width=64) (actual rows= loops=)

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

Table Scan on secured_dim_work_order (cost=0.00..431.83 rows=1,940 width=68) (actual rows= loops=)

712. 0.000 0.000 ↓ 0.0

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

713. 0.000 0.000 ↓ 0.0

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

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

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

715. 0.000 0.000 ↓ 0.0

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

716. 0.000 0.000 ↓ 0.0

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

717. 0.000 0.000 ↓ 0.0

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

718. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'secured_dim_work_order'::text AND table_schema::text = 'toms_hub'::text
719. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=22 width=11) (actual rows= loops=)

720. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice151; segments: 304) (cost=0.00..431.00 rows=22 width=11) (actual rows= loops=)

721. 0.000 0.000 ↓ 0.0

Table Scan on horizon_fx_rates (cost=0.00..431.00 rows=1 width=11) (actual rows= loops=)

  • Filter: is_current = 'Y'::bpchar
722. 0.000 0.000 ↓ 0.0

Hash (cost=2,700.71..2,700.71 rows=1 width=60) (actual rows= loops=)

723. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice168; segments: 304) (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

724. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

725. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

  • Group By: toms_hub.pt_requisition.resource_id, toms_hub.cfg_lookup_param.lookup_code_string, toms_hub.cfg_lookup_param.lookup_val_string_3, toms_hub.cfg_lookup_param.lookup_val_string_4, toms_hub.cfg_lookup_param.lookup_val_string_5, toms_hub.cfg_lookup_param.lookup_val_string_8, "outer".fieldglass_requisition_candidate_status
726. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

  • Sort Key: toms_hub.pt_requisition.resource_id, toms_hub.cfg_lookup_param.lookup_code_string, toms_hub.cfg_lookup_param.lookup_val_string_3, toms_hub.cfg_lookup_param.lookup_val_string_4, toms_hub.cfg_lookup_param.lookup_val_string_5, toms_hub.cfg_lookup_param.lookup_val_string_8, "outer".fieldglass_requisition_candidate_status
727. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice167; segments: 304) (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

  • Hash Key: toms_hub.pt_requisition.resource_id, toms_hub.cfg_lookup_param.lookup_code_string, toms_hub.cfg_lookup_param.lookup_val_string_3, toms_hub.cfg_lookup_param.lookup_val_string_4, toms_hub.cfg_lookup_param.lookup_val_string_5, toms_hub.cfg_lookup_param.lookup_val_string_8, "outer".fieldglass_requisition_candidate_status
728. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

729. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..2,700.71 rows=1 width=60) (actual rows= loops=)

  • Group By: toms_hub.pt_requisition.resource_id, toms_hub.cfg_lookup_param.lookup_code_string, toms_hub.cfg_lookup_param.lookup_val_string_3, toms_hub.cfg_lookup_param.lookup_val_string_4, toms_hub.cfg_lookup_param.lookup_val_string_5, toms_hub.cfg_lookup_param.lookup_val_string_8, "outer".fieldglass_requisition_candidate_status
730. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..2,700.71 rows=1 width=53) (actual rows= loops=)

  • Sort Key: toms_hub.pt_requisition.resource_id, toms_hub.cfg_lookup_param.lookup_code_string, toms_hub.cfg_lookup_param.lookup_val_string_3, toms_hub.cfg_lookup_param.lookup_val_string_4, toms_hub.cfg_lookup_param.lookup_val_string_5, toms_hub.cfg_lookup_param.lookup_val_string_8, "outer".fieldglass_requisition_candidate_status
731. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,700.71 rows=1 width=53) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_requisition.req_nbr::text = share3_ref2.req_number
732. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice154; segments: 304) (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Hash Key: toms_hub.pt_requisition.req_nbr
733. 0.000 0.000 ↓ 0.0

Table Scan on pt_requisition (cost=0.00..431.00 rows=1 width=12) (actual rows= loops=)

  • Filter: primary_req = 1
734. 0.000 0.000 ↓ 0.0

Hash (cost=2,168.56..2,168.56 rows=72,566 width=57) (actual rows= loops=)

735. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice166; segments: 304) (cost=0.00..2,168.56 rows=72,566 width=57) (actual rows= loops=)

  • Hash Key: share3_ref2.req_number
736. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,155.62 rows=72,566 width=57) (actual rows= loops=)

737. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,155.62 rows=72,566 width=57) (actual rows= loops=)

738. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,314.34 rows=72,534 width=57) (actual rows= loops=)

739. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice157; segments: 304) (cost=0.00..1,310.21 rows=72,534 width=49) (actual rows= loops=)

  • Hash Key: share3_ref2.gen_reqid
740. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,310.21 rows=72,534 width=57) (actual rows= loops=)

  • Hash Cond: "varchar"(COALESCE((share4_ref2.step || ' - '::text) || share4_ref2.status, 'No - Candidates'::text)::character varying, 504, true)::text = toms_hub.cfg_lookup_param.lookup_code_string::text
741. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..864.12 rows=1,851 width=40) (actual rows= loops=)

  • Hash Cond: share3_ref2.gen_reqid = share4_ref2.gen_reqid
742. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 157:3) (cost=0.00..431.00 rows=4 width=16) (actual rows= loops=)

743. 0.000 0.000 ↓ 0.0

Hash (cost=431.33..431.33 rows=1,851 width=32) (actual rows= loops=)

744. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice155; segments: 304) (cost=0.00..431.33 rows=1,851 width=32) (actual rows= loops=)

  • Hash Key: share4_ref2.gen_reqid
745. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.14 rows=1,851 width=32) (actual rows= loops=)

746. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 155:4) (cost=0.00..431.14 rows=1,851 width=32) (actual rows= loops=)

747. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=97 width=33) (actual rows= loops=)

748. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice156; segments: 304) (cost=0.00..431.01 rows=97 width=33) (actual rows= loops=)

749. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=33) (actual rows= loops=)

  • Filter: title::text = 'TALEO_STATUS'::text AND is_deleted = 'N'::bpchar
750. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,155.62 rows=32 width=65) (actual rows= loops=)

751. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice165; segments: 304) (cost=0.00..2,155.62 rows=32 width=65) (actual rows= loops=)

  • Hash Key: toms_hub.dim_fg_requisition.requisition_id
752. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,155.62 rows=32 width=73) (actual rows= loops=)

753. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,155.62 rows=32 width=37) (actual rows= loops=)

  • Hash Cond: COALESCE(dim_fg_requisition_candidate.candidate_status, 'No - Candidates'::character varying)::text = toms_hub.cfg_lookup_param.lookup_code_string::text
754. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,724.60 rows=32 width=39) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_fg_requisition.requisition_id::text = dim_fg_requisition_candidate.requisition_id::text
  • Join Filter: toms_hub.dim_fg_requisition.current_flag = 'Y'::bpchar
755. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice160; segments: 304) (cost=0.00..862.38 rows=28 width=16) (actual rows= loops=)

  • Hash Key: toms_hub.dim_fg_requisition.requisition_id
756. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.38 rows=28 width=16) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_fg_requisition.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
757. 0.000 0.000 ↓ 0.0

Table Scan on dim_fg_requisition (cost=0.00..431.27 rows=460 width=20) (actual rows= loops=)

758. 0.000 0.000 ↓ 0.0

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

759. 0.000 0.000 ↓ 0.0

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

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

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

761. 0.000 0.000 ↓ 0.0

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

762. 0.000 0.000 ↓ 0.0

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

763. 0.000 0.000 ↓ 0.0

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

764. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_fg_requisition'::text AND table_schema::text = 'toms_hub'::text
765. 0.000 0.000 ↓ 0.0

Hash (cost=862.18..862.18 rows=26 width=39) (actual rows= loops=)

766. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice163; segments: 304) (cost=0.00..862.18 rows=26 width=39) (actual rows= loops=)

  • Hash Key: dim_fg_requisition_candidate.requisition_id
767. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.18 rows=26 width=39) (actual rows= loops=)

  • Hash Cond: dim_fg_requisition_candidate.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
768. 0.000 0.000 ↓ 0.0

Table Scan on dim_fg_requisition_candidate (cost=0.00..431.05 rows=428 width=43) (actual rows= loops=)

769. 0.000 0.000 ↓ 0.0

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

770. 0.000 0.000 ↓ 0.0

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

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

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

772. 0.000 0.000 ↓ 0.0

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

773. 0.000 0.000 ↓ 0.0

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

774. 0.000 0.000 ↓ 0.0

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

775. 0.000 0.000 ↓ 0.0

Table Scan on cfg_gpload_version_ctrl (cost=0.00..431.00 rows=1 width=4) (actual rows= loops=)

  • Filter: table_name::text = 'dim_fg_requisition_candidate'::text AND table_schema::text = 'toms_hub'::text
776. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=7 width=14) (actual rows= loops=)

777. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice164; segments: 304) (cost=0.00..431.00 rows=7 width=14) (actual rows= loops=)

778. 0.000 0.000 ↓ 0.0

Table Scan on cfg_lookup_param (cost=0.00..431.00 rows=1 width=14) (actual rows= loops=)

  • Filter: title::text = 'FG_CANDIDATE_STATUS'::text AND is_deleted = 'N'::bpcharSettings: gp_cte_sharing=on; gp_enable_relsize_collection=on; optimizer_join_arity_for_associativity_commutativity=7Optimizer status: PQO version 3.92.0