explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AX0K

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

Insert (cost=0.00..1,896,255,768,849.36 rows=363,410,675,613 width=1,322) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=0.00..13,902,035,013.43 rows=363,410,675,613 width=1,326) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice152; segments: 304) (cost=0.00..13,420,152,457.56 rows=363,410,675,613 width=1,322) (actual rows= loops=)

  • Hash Key: (share7_ref3.furlough_year::smallint), share7_ref3.furlough_date_key, share7_ref3.resource_key
4. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..11,916,409,959.37 rows=363,410,675,613 width=1,322) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

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

7. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,189.47 rows=1 width=56) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,189.47 rows=1 width=44) (actual rows= loops=)

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

Hash Join (cost=0.00..438.25 rows=36 width=27) (actual rows= loops=)

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

Table Scan on secured_fact_work_order (cost=0.00..432.04 rows=1,072 width=31) (actual rows= loops=)

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

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

12. 0.000 0.000 ↓ 0.0

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

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

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

14. 0.000 0.000 ↓ 0.0

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

15. 0.000 0.000 ↓ 0.0

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

16. 0.000 0.000 ↓ 0.0

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

17. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=1,751.21..1,751.21 rows=1 width=25) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice151; segments: 304) (cost=0.00..1,751.21 rows=1 width=25) (actual rows= loops=)

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

Hash Join (cost=0.00..1,751.21 rows=1 width=25) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice148; segments: 304) (cost=0.00..1,313.78 rows=2 width=29) (actual rows= loops=)

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

Hash Join (cost=0.00..1,313.78 rows=2 width=29) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice141; segments: 304) (cost=0.00..437.81 rows=81 width=25) (actual rows= loops=)

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

Hash Join (cost=0.00..437.81 rows=81 width=25) (actual rows= loops=)

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

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.34 rows=2,384 width=29) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-07-02'::date
26. 0.000 0.000 ↓ 0.0

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

27. 0.000 0.000 ↓ 0.0

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

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

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

29. 0.000 0.000 ↓ 0.0

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

30. 0.000 0.000 ↓ 0.0

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

31. 0.000 0.000 ↓ 0.0

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

32. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=875.95..875.95 rows=3 width=9) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

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

Sort (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

  • Sort Key: toms_hub.secured_fact_resource_fg_status.ms_id
36. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice147; segments: 304) (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

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

Result (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

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

Sort (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

  • Sort Key: toms_hub.secured_fact_resource_fg_status.ms_id
40. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..875.95 rows=3 width=9) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice144; segments: 304) (cost=0.00..437.74 rows=81 width=13) (actual rows= loops=)

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

Hash Join (cost=0.00..437.73 rows=81 width=13) (actual rows= loops=)

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

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.29 rows=2,384 width=17) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-07-02'::date
44. 0.000 0.000 ↓ 0.0

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

45. 0.000 0.000 ↓ 0.0

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

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

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

47. 0.000 0.000 ↓ 0.0

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

48. 0.000 0.000 ↓ 0.0

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

49. 0.000 0.000 ↓ 0.0

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

50. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=438.19..438.19 rows=36 width=4) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..438.19 rows=36 width=4) (actual rows= loops=)

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

Table Scan on secured_fact_work_order (cost=0.00..431.99 rows=1,072 width=8) (actual rows= loops=)

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

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

55. 0.000 0.000 ↓ 0.0

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

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

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

57. 0.000 0.000 ↓ 0.0

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

58. 0.000 0.000 ↓ 0.0

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

59. 0.000 0.000 ↓ 0.0

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

60. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.43..437.43 rows=23 width=4) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

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

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

Table Scan on secured_dim_work_order (cost=0.00..431.29 rows=684 width=8) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

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

65. 0.000 0.000 ↓ 0.0

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

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

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

67. 0.000 0.000 ↓ 0.0

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

68. 0.000 0.000 ↓ 0.0

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

69. 0.000 0.000 ↓ 0.0

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

70. 0.000 0.000 ↓ 0.0

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

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

Sequence (cost=0.00..11,435,978,856.74 rows=363,410,675,613 width=1,322) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:1) (cost=0.00..7,689.60 rows=671,753 width=1) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..7,689.60 rows=671,753 width=1) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Result (cost=0.00..7,688.93 rows=671,753 width=160) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..7,581.45 rows=671,753 width=132) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.ms_id::text = share0_ref2.ms_id::text
  • Join Filter: to_date(toms_hub.fms_furlough_dtls.furlough_date::text, 'Mon dd yyyy'::text) >= share0_ref2.business_eff_start_dt AND to_date(toms_hub.fms_furlough_dtls.furlough_date::text, 'Mon dd yyyy'::text) <= share0_ref2.effective_end_date
76. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice135; segments: 304) (cost=0.00..6,732.75 rows=209,028 width=122) (actual rows= loops=)

  • Hash Key: toms_hub.pt_employee.ms_id
77. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,652.93 rows=209,028 width=122) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
78. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..5,691.03 rows=41,806 width=118) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.furlough_status_id::text = toms_hub.lkp_fms_furlough_status.furlough_status_id::text
79. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..4,807.84 rows=16,080 width=114) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.employee_id::text = toms_hub.fms_furlough_dtls.employee_id::text
80. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice122; segments: 304) (cost=0.00..3,056.28 rows=2,566 width=48) (actual rows= loops=)

  • Hash Key: toms_hub.pt_employee.employee_id
81. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..3,055.89 rows=2,566 width=48) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
82. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice119; segments: 304) (cost=0.00..2,193.16 rows=1,459 width=44) (actual rows= loops=)

  • Hash Key: toms_hub.lkp_pt_vendor.vendor_id
83. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,192.96 rows=1,459 width=44) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.ms_id::text = toms_hub.pt_employee.ms_id::text
84. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice112; segments: 304) (cost=0.00..440.44 rows=73 width=19) (actual rows= loops=)

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

Hash Join (cost=0.00..440.44 rows=73 width=19) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..434.03 rows=2,151 width=23) (actual rows= loops=)

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

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

88. 0.000 0.000 ↓ 0.0

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

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

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

90. 0.000 0.000 ↓ 0.0

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

91. 0.000 0.000 ↓ 0.0

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

92. 0.000 0.000 ↓ 0.0

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

93. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=1,732.30..1,732.30 rows=25,583 width=30) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice118; segments: 304) (cost=0.00..1,732.30 rows=25,583 width=30) (actual rows= loops=)

  • Hash Key: toms_hub.pt_employee.ms_id
96. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,729.90 rows=25,583 width=30) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.vendor_id::text = toms_hub.lkp_pt_vendor.vendor_id::text
97. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice115; segments: 304) (cost=0.00..864.19 rows=5,117 width=20) (actual rows= loops=)

  • Hash Key: toms_hub.pt_employee.vendor_id
98. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.87 rows=5,117 width=20) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.gpload_version_id = (max((max(toms_hub.pt_employee.gpload_version_id))))
99. 0.000 0.000 ↓ 0.0

Table Scan on pt_employee (cost=0.00..431.14 rows=5,117 width=24) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

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

101. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice114; segments: 1) (cost=0.00..431.18 rows=304 width=4) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

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

103. 0.000 0.000 ↓ 0.0

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

104. 0.000 0.000 ↓ 0.0

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

105. 0.000 0.000 ↓ 0.0

Table Scan on pt_employee (cost=0.00..431.14 rows=5,117 width=4) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Hash (cost=862.04..862.04 rows=92 width=10) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: toms_hub.lkp_pt_vendor.gpload_version_id = (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
108. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

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

110. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice117; segments: 1) (cost=0.00..431.01 rows=304 width=4) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

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

112. 0.000 0.000 ↓ 0.0

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

113. 0.000 0.000 ↓ 0.0

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

114. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=4) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Hash (cost=862.00..862.00 rows=3 width=14) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=3 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_vendor_rules.gpload_version_id = (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
117. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=18) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

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

119. 0.000 0.000 ↓ 0.0

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

120. 0.000 0.000 ↓ 0.0

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

121. 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=)

122. 0.000 0.000 ↓ 0.0

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

123. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=4) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash (cost=1,730.67..1,730.67 rows=7,941 width=73) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice128; segments: 304) (cost=0.00..1,730.67 rows=7,941 width=73) (actual rows= loops=)

  • Hash Key: toms_hub.fms_furlough_dtls.employee_id
126. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,728.86 rows=7,941 width=73) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.vendor_id::text = toms_hub.lkp_pt_vendor.vendor_id::text
127. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice125; segments: 304) (cost=0.00..864.15 rows=1,589 width=63) (actual rows= loops=)

  • Hash Key: toms_hub.fms_furlough_dtls.vendor_id
128. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.77 rows=1,589 width=63) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.gpload_version_id = (max((max(toms_hub.fms_furlough_dtls.gpload_version_id))))
129. 0.000 0.000 ↓ 0.0

Table Scan on fms_furlough_dtls (cost=0.00..431.69 rows=1,589 width=67) (actual rows= loops=)

  • Filter: to_char(to_date(furlough_date::text, 'Mon dd yyyy'::text)::timestamp with time zone, 'yyyy'::text) = '2020'::text
130. 0.000 0.000 ↓ 0.0

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

131. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice124; segments: 1) (cost=0.00..431.39 rows=304 width=4) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

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

133. 0.000 0.000 ↓ 0.0

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

134. 0.000 0.000 ↓ 0.0

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

135. 0.000 0.000 ↓ 0.0

Table Scan on fms_furlough_dtls (cost=0.00..431.36 rows=3,971 width=4) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Hash (cost=862.04..862.04 rows=92 width=10) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: toms_hub.lkp_pt_vendor.gpload_version_id = (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
138. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

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

140. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice127; segments: 1) (cost=0.00..431.01 rows=304 width=4) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

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

142. 0.000 0.000 ↓ 0.0

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

143. 0.000 0.000 ↓ 0.0

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

144. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=4) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=13 width=6) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice131; segments: 304) (cost=0.00..862.01 rows=13 width=6) (actual rows= loops=)

147. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=1 width=6) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_fms_furlough_status.gpload_version_id = (max((max(toms_hub.lkp_fms_furlough_status.gpload_version_id))))
148. 0.000 0.000 ↓ 0.0

Table Scan on lkp_fms_furlough_status (cost=0.00..431.00 rows=1 width=10) (actual rows= loops=)

  • Filter: furlough_desc::text = ANY ('{PLANNED,PUBLISHED,SERVED}'::text[])
149. 0.000 0.000 ↓ 0.0

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

150. 0.000 0.000 ↓ 0.0

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

151. 0.000 0.000 ↓ 0.0

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

152. 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=)

153. 0.000 0.000 ↓ 0.0

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

154. 0.000 0.000 ↓ 0.0

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

155. 0.000 0.000 ↓ 0.0

Hash (cost=862.03..862.03 rows=840 width=14) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice134; segments: 304) (cost=0.00..862.03 rows=840 width=14) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=3 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_vendor_rules.gpload_version_id = (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
158. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=18) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

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

160. 0.000 0.000 ↓ 0.0

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

161. 0.000 0.000 ↓ 0.0

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

162. 0.000 0.000 ↓ 0.0

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

163. 0.000 0.000 ↓ 0.0

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

164. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=4) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Hash (cost=431.14..431.14 rows=1,108 width=23) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice136; segments: 304) (cost=0.00..431.14 rows=1,108 width=23) (actual rows= loops=)

  • Hash Key: share0_ref2.ms_id
167. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.06 rows=1,108 width=23) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 136:0) (cost=0.00..431.06 rows=1,108 width=23) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..10,955,542,253.99 rows=363,410,675,613 width=1,322) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:2) (cost=0.00..6,012.24 rows=2,407,743 width=1) (actual rows= loops=)

171. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..6,012.24 rows=2,407,743 width=1) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Append (cost=0.00..6,009.83 rows=2,407,743 width=89) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,519.42 rows=412,379 width=89) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice107; segments: 304) (cost=0.00..5,482.72 rows=412,379 width=73) (actual rows= loops=)

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

Result (cost=0.00..5,482.72 rows=412,379 width=73) (actual rows= loops=)

  • Filter: share1_ref2.vendor_id::text = share1_ref2.vendor_id::text AND share1_ref2.cc_code::text = share1_ref2.cc_code::text AND share1_ref2.empl_status_code <> 'T'::bpchar AND (share1_ref2.consult_category_code::text = ANY ('{198,199,196}'::text[])) AND (share1_ref2.worker_pay_type_code::text <> ALL ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[]))
176. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 107:1) (cost=0.00..2,779.19 rows=11,739,183 width=83) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6,009.83 rows=1,582,987 width=89) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice108; segments: 304) (cost=0.00..5,868.94 rows=1,582,987 width=73) (actual rows= loops=)

  • Hash Key: share1_ref3.ms_id
179. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,868.94 rows=1,582,987 width=73) (actual rows= loops=)

  • Filter: share1_ref3.vendor_id::text = share1_ref3.vendor_id::text AND share1_ref3.cc_code::text = share1_ref3.cc_code::text AND (share1_ref3.empl_status_code = 'T'::bpchar OR (share1_ref3.consult_category_code::text <> ALL ('{198,199,196}'::text[])) OR (share1_ref3.worker_pay_type_code::text = ANY ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[]))) AND share1_ref3.furlough_code::text = 'SER'::text
180. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 108:1) (cost=0.00..2,779.19 rows=11,739,183 width=83) (actual rows= loops=)

181. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,905.64 rows=412,379 width=89) (actual rows= loops=)

182. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice109; segments: 304) (cost=0.00..5,868.94 rows=412,379 width=73) (actual rows= loops=)

  • Hash Key: share1_ref4.ms_id
183. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,868.94 rows=412,379 width=73) (actual rows= loops=)

  • Filter: (share1_ref4.vendor_id::text <> share1_ref4.vendor_id::text OR share1_ref4.cc_code::text <> share1_ref4.cc_code::text) AND share1_ref4.empl_status_code <> 'T'::bpchar AND (share1_ref4.consult_category_code::text = ANY ('{198,199,196}'::text[])) AND (share1_ref4.worker_pay_type_code::text <> ALL ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[])) AND (share1_ref4.furlough_code::text = ANY ('{PUB,PLAN}'::text[]))
184. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 109:1) (cost=0.00..2,779.19 rows=11,739,183 width=83) (actual rows= loops=)

185. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..10,475,107,328.59 rows=363,410,675,613 width=1,322) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:3) (cost=0.00..5,041.33 rows=2,347,814 width=1) (actual rows= loops=)

187. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..5,041.33 rows=2,347,814 width=1) (actual rows= loops=)

188. 0.000 0.000 ↓ 0.0

Result (cost=0.00..5,038.98 rows=2,347,814 width=140) (actual rows= loops=)

189. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,710.28 rows=2,347,814 width=83) (actual rows= loops=)

  • Filter: (share1_ref5.vendor_id::text <> share1_ref5.vendor_id::text OR share1_ref5.cc_code::text <> share1_ref5.cc_code::text OR (share1_ref5.vendor_id IS NULL AND share1_ref5.vendor_id::text = ''::text)) AND share1_ref5.furlough_code::text = 'SER'::text
190. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:1) (cost=0.00..2,779.19 rows=11,739,183 width=83) (actual rows= loops=)

191. 0.000 0.000 ↓ 0.0

Sequence (cost=0.00..9,994,673,374.10 rows=363,410,675,613 width=1,322) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:7) (cost=0.00..46,017,432.96 rows=1,975,272,077 width=1) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..46,017,432.96 rows=1,975,272,077 width=1) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Result (cost=0.00..46,015,457.69 rows=1,975,272,077 width=160) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice106; segments: 304) (cost=0.00..45,699,414.15 rows=1,975,272,077 width=136) (actual rows= loops=)

  • Hash Key: share2_ref2.cc_code
196. 0.000 0.000 ↓ 0.0

Result (cost=0.00..44,858,580.34 rows=1,975,272,077 width=136) (actual rows= loops=)

197. 0.000 0.000 ↓ 0.0

Window (cost=0.00..44,858,580.34 rows=1,975,272,077 width=136) (actual rows= loops=)

  • Partition By: share2_ref2.ms_id
198. 0.000 0.000 ↓ 0.0

Sort (cost=0.00..44,858,580.34 rows=1,975,272,077 width=94) (actual rows= loops=)

  • Sort Key: share2_ref2.ms_id
199. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..12,349,345.35 rows=1,975,272,077 width=94) (actual rows= loops=)

  • Hash Cond: share2_ref2.ms_id::text = share0_ref3.ms_id::text
  • Join Filter: share2_ref2.furlough_date >= share0_ref3.business_eff_start_dt AND share2_ref2.furlough_date <= share0_ref3.effective_end_date
200. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice104; segments: 304) (cost=0.00..10,737,340.29 rows=1,975,272,077 width=86) (actual rows= loops=)

  • Hash Key: share2_ref2.ms_id
201. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..10,205,636.55 rows=1,975,272,077 width=86) (actual rows= loops=)

  • Hash Cond: share2_ref2.employee_id::text = share1_ref6.employee_id::text AND share2_ref2.furlough_date = share1_ref6.furlough_date
202. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice102; segments: 304) (cost=0.00..7,582,037.93 rows=1,975,272,077 width=78) (actual rows= loops=)

  • Hash Key: share2_ref2.employee_id, share2_ref2.furlough_date
203. 0.000 0.000 ↓ 0.0

Result (cost=0.00..7,099,795.01 rows=1,975,272,077 width=78) (actual rows= loops=)

204. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..7,099,795.01 rows=1,975,272,077 width=78) (actual rows= loops=)

  • Group By: share2_ref2.resource_key, share2_ref2.furlough_year, share2_ref2.ms_id, share2_ref2.employee_id, share2_ref2.cc_code, share2_ref2.vendor_id, share2_ref2.furlough_date, share2_ref2.vendor_code, share2_ref2.location_code
205. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice101; segments: 304) (cost=0.00..4,724,763.42 rows=1,975,272,077 width=78) (actual rows= loops=)

  • Hash Key: share2_ref2.resource_key, share2_ref2.furlough_year, share2_ref2.ms_id, share2_ref2.employee_id, share2_ref2.cc_code, share2_ref2.vendor_id, share2_ref2.furlough_date, share2_ref2.vendor_code, share2_ref2.location_code
206. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,242,520.49 rows=1,975,272,077 width=78) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..4,242,520.49 rows=1,975,272,077 width=78) (actual rows= loops=)

  • Group By: share2_ref2.resource_key, share2_ref2.furlough_year, share2_ref2.ms_id, share2_ref2.employee_id, share2_ref2.cc_code, share2_ref2.vendor_id, share2_ref2.furlough_date, share2_ref2.vendor_code, share2_ref2.location_code
208. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,867,488.90 rows=1,975,272,077 width=66) (actual rows= loops=)

209. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice53; segments: 304) (cost=0.00..813.98 rows=2,407,743 width=66) (actual rows= loops=)

  • Hash Key: share2_ref2.ms_id
210. 0.000 0.000 ↓ 0.0

Result (cost=0.00..813.98 rows=2,407,743 width=66) (actual rows= loops=)

211. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 53:2) (cost=0.00..813.98 rows=2,407,743 width=66) (actual rows= loops=)

212. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice54; segments: 304) (cost=0.00..821.42 rows=2,347,814 width=69) (actual rows= loops=)

  • Hash Key: share3_ref2.ms_id
213. 0.000 0.000 ↓ 0.0

Result (cost=0.00..821.42 rows=2,347,814 width=69) (actual rows= loops=)

214. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 54:3) (cost=0.00..821.42 rows=2,347,814 width=69) (actual rows= loops=)

215. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice100; segments: 304) (cost=0.00..1,867,488.90 rows=1,970,516,522 width=66) (actual rows= loops=)

  • Hash Key: share2_ref4.employee_id
216. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,867,488.90 rows=1,970,516,522 width=66) (actual rows= loops=)

  • Filter: (int4(COALESCE(toms_hub.fms_vendor_rules.num_days_cap::integer, 0) - (COALESCE((count((count()))), 0::bigint) + COALESCE((count((count()))), 0::bigint)))) > 0
217. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,705,413.92 rows=4,926,291,303 width=66) (actual rows= loops=)

218. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,380,278.69 rows=4,926,291,303 width=73) (actual rows= loops=)

  • Hash Cond: share2_ref4.employee_id::text = share2_ref3.employee_id::text
219. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..71,277.37 rows=230,517,415 width=65) (actual rows= loops=)

  • Hash Cond: share2_ref4.employee_id::text = share3_ref3.employee_id::text
220. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice95; segments: 304) (cost=0.00..15,457.80 rows=10,786,671 width=57) (actual rows= loops=)

  • Hash Key: share2_ref4.employee_id
221. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..13,533.35 rows=10,786,671 width=57) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
222. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..9,180.69 rows=6,532,772 width=51) (actual rows= loops=)

  • Hash Cond: share2_ref4.vendor_id::text = toms_hub.lkp_pt_vendor.vendor_id::text
223. 0.000 0.000 ↓ 0.0

Append (cost=0.00..6,883.36 rows=1,306,555 width=41) (actual rows= loops=)

224. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,482.13 rows=94,597 width=41) (actual rows= loops=)

225. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice56; segments: 304) (cost=0.00..1,482.13 rows=94,597 width=41) (actual rows= loops=)

  • Hash Key: share2_ref4.resource_key, "outer".furlough_year, share2_ref4.ms_id, share2_ref4.employee_id, share2_ref4.cc_code, share2_ref4.vendor_id, share2_ref4.location_code, "outer".furlough_date, share2_ref4.cc_vendor_flag, "outer".furlough_days_planned, "outer".furlough_days_served, "outer".furlough_days_unplanned
226. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,465.58 rows=94,597 width=61) (actual rows= loops=)

  • Group By: share2_ref4.resource_key, '2020'::text, share2_ref4.ms_id, share2_ref4.employee_id, share2_ref4.cc_code, share2_ref4.vendor_id, share2_ref4.location_code, '2020-12-31'::date, share2_ref4.cc_vendor_flag, 0, 0, 0
227. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,318.37 rows=94,597 width=61) (actual rows= loops=)

228. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,312.60 rows=94,597 width=37) (actual rows= loops=)

  • Hash Cond: share2_ref4.ms_id::text = share0_ref4.ms_id::text
229. 0.000 0.000 ↓ 0.0

Result (cost=0.00..833.14 rows=183,259 width=37) (actual rows= loops=)

  • Filter: share2_ref4.empl_status_code <> 'T'::bpchar AND (share2_ref4.consult_category_code::text = ANY ('{198,199,196}'::text[]))
230. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 56:2) (cost=0.00..674.71 rows=2,407,743 width=42) (actual rows= loops=)

231. 0.000 0.000 ↓ 0.0

Hash (cost=431.17..431.17 rows=259 width=5) (actual rows= loops=)

232. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice55; segments: 304) (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Hash Key: share0_ref4.ms_id
233. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Filter: share0_ref4.business_eff_start_dt <= '2020-12-31'::date AND share0_ref4.effective_end_date >= '2020-12-31'::date AND (share0_ref4.worker_pay_type_code::text <> ALL ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[]))
234. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 55:0) (cost=0.00..431.06 rows=1,108 width=23) (actual rows= loops=)

235. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,222.03 rows=30,157 width=41) (actual rows= loops=)

236. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice60; segments: 304) (cost=0.00..2,222.03 rows=30,157 width=41) (actual rows= loops=)

  • Hash Key: share3_ref4.resource_key, "outer".furlough_year, share3_ref4.ms_id, share3_ref4.employee_id, share3_ref4.cc_code, share3_ref4.vendor_id, share3_ref4.location_code, "outer".furlough_date, "outer".cc_vendor_flag, "outer".furlough_days_planned, "outer".furlough_days_served, "outer".furlough_days_unplanned
237. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,216.76 rows=30,157 width=61) (actual rows= loops=)

  • Group By: share3_ref4.resource_key, '2020'::text, share3_ref4.ms_id, share3_ref4.employee_id, share3_ref4.cc_code, share3_ref4.vendor_id, share3_ref4.location_code, '2020-12-31'::date, 'New'::character varying(10), 0, 0, 0
238. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,169.83 rows=30,157 width=61) (actual rows= loops=)

239. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,167.99 rows=30,157 width=29) (actual rows= loops=)

  • Hash Cond: share3_ref4.ms_id::text = share0_ref5.ms_id::text
240. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,722.51 rows=58,422 width=29) (actual rows= loops=)

  • Filter: COALESCE((count((count()))), 0::bigint) = 0::bigint
241. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,712.90 rows=292,110 width=37) (actual rows= loops=)

242. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,702.09 rows=292,110 width=37) (actual rows= loops=)

  • Hash Cond: share3_ref4.employee_id::text = share2_ref5.employee_id::text
243. 0.000 0.000 ↓ 0.0

Result (cost=0.00..855.11 rows=146,055 width=29) (actual rows= loops=)

  • Filter: NOT share3_ref4.vendor_id IS NULL AND share3_ref4.vendor_id::text <> ''::text AND share3_ref4.empl_status_code <> 'T'::bpchar AND (share3_ref4.consult_category_code::text = ANY ('{198,199,196}'::text[]))
244. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 60:3) (cost=0.00..623.38 rows=2,347,814 width=34) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Hash (cost=775.05..775.05 rows=13,948 width=15) (actual rows= loops=)

246. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice58; segments: 304) (cost=0.00..775.05 rows=13,948 width=15) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

Result (cost=0.00..774.73 rows=46 width=15) (actual rows= loops=)

248. 0.000 0.000 ↓ 0.0

Result (cost=0.00..774.73 rows=46 width=15) (actual rows= loops=)

249. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..774.73 rows=46 width=15) (actual rows= loops=)

  • Group By: share2_ref5.employee_id
250. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice57; segments: 304) (cost=0.00..774.73 rows=46 width=15) (actual rows= loops=)

  • Hash Key: share2_ref5.employee_id
251. 0.000 0.000 ↓ 0.0

Result (cost=0.00..774.72 rows=46 width=15) (actual rows= loops=)

252. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..774.72 rows=46 width=15) (actual rows= loops=)

  • Group By: share2_ref5.employee_id
253. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 57:2) (cost=0.00..471.62 rows=2,407,743 width=7) (actual rows= loops=)

254. 0.000 0.000 ↓ 0.0

Hash (cost=431.17..431.17 rows=259 width=5) (actual rows= loops=)

255. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice59; segments: 304) (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Hash Key: share0_ref5.ms_id
256. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Filter: share0_ref5.business_eff_start_dt <= '2020-12-31'::date AND share0_ref5.effective_end_date >= '2020-12-31'::date AND (share0_ref5.worker_pay_type_code::text <> ALL ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[]))
257. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 59:0) (cost=0.00..431.06 rows=1,108 width=23) (actual rows= loops=)

258. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6,883.36 rows=1 width=40) (actual rows= loops=)

259. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice88; segments: 304) (cost=0.00..6,883.36 rows=1 width=40) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.resource_key, "outer".furlough_year, toms_hub.dim_resource.ms_id, toms_hub.pt_employee.employee_id, toms_hub.pt_employee.cc_code, toms_hub.pt_employee.vendor_id, toms_hub.dim_resource.location_code, "outer".furlough_date, "outer".cc_vendor_flag, "outer".furlough_days_planned, "outer".furlough_days_served, "outer".furlough_days_unplanned
260. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6,883.36 rows=1 width=60) (actual rows= loops=)

261. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..6,883.36 rows=1 width=28) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.ms_id::text = toms_hub.dim_resource.ms_id::text
262. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,972.55 rows=2,047 width=20) (actual rows= loops=)

  • Filter: COALESCE((count((count()))), 0::bigint) = 0::bigint
263. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,972.38 rows=5,302 width=28) (actual rows= loops=)

264. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,972.23 rows=5,302 width=28) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.employee_id::text = share1_ref7.employee_id::text
265. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..863.87 rows=5,117 width=20) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.gpload_version_id = (max((max(toms_hub.pt_employee.gpload_version_id))))
266. 0.000 0.000 ↓ 0.0

Table Scan on pt_employee (cost=0.00..431.14 rows=5,117 width=24) (actual rows= loops=)

267. 0.000 0.000 ↓ 0.0

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

268. 0.000 0.000 ↓ 0.0

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

269. 0.000 0.000 ↓ 0.0

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

270. 0.000 0.000 ↓ 0.0

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

271. 0.000 0.000 ↓ 0.0

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

272. 0.000 0.000 ↓ 0.0

Table Scan on pt_employee (cost=0.00..431.14 rows=5,117 width=4) (actual rows= loops=)

273. 0.000 0.000 ↓ 0.0

Hash (cost=2,106.87..2,106.87 rows=46 width=15) (actual rows= loops=)

274. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,106.87 rows=46 width=15) (actual rows= loops=)

275. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,106.86 rows=46 width=15) (actual rows= loops=)

  • Group By: share1_ref7.employee_id
276. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice63; segments: 304) (cost=0.00..2,106.86 rows=46 width=15) (actual rows= loops=)

  • Hash Key: share1_ref7.employee_id
277. 0.000 0.000 ↓ 0.0

Result (cost=0.00..2,106.86 rows=46 width=15) (actual rows= loops=)

278. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,106.86 rows=46 width=15) (actual rows= loops=)

  • Group By: share1_ref7.employee_id
279. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 63:1) (cost=0.00..629.04 rows=11,739,183 width=7) (actual rows= loops=)

280. 0.000 0.000 ↓ 0.0

Hash (cost=3,910.42..3,910.42 rows=2 width=14) (actual rows= loops=)

281. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice87; segments: 304) (cost=0.00..3,910.42 rows=2 width=14) (actual rows= loops=)

282. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,910.42 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.ms_id::text = share0_ref6.ms_id::text
283. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice85; segments: 304) (cost=0.00..3,479.19 rows=1 width=14) (actual rows= loops=)

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

Hash Join (cost=0.00..3,479.19 rows=1 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
285. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice82; segments: 304) (cost=0.00..2,617.19 rows=1 width=19) (actual rows= loops=)

  • Hash Key: toms_hub.lkp_pt_vendor.vendor_id
286. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,617.19 rows=1 width=19) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.vendor_code::text = toms_hub.lkp_pt_vendor.vendor_code::text
287. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice78; segments: 304) (cost=0.00..1,755.12 rows=1 width=18) (actual rows= loops=)

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

Hash Join (cost=0.00..1,755.12 rows=1 width=18) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.manager_ms_id::text = toms_hub.dim_resource.ms_id::text
289. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice74; segments: 304) (cost=0.00..1,314.74 rows=1 width=23) (actual rows= loops=)

  • Hash Key: toms_hub.dim_resource.manager_ms_id
290. 0.000 0.000 ↓ 0.0

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

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

Redistribute Motion 304:304 (slice70; segments: 304) (cost=0.00..877.45 rows=1 width=28) (actual rows= loops=)

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

Hash Join (cost=0.00..877.45 rows=1 width=28) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.location_code::text = toms_hub.dim_location.location_code::text
  • Join Filter: toms_hub.dim_resource.consult_category_code::text <> '196'::text OR (toms_hub.dim_resource.consult_category_code::text = '196'::text AND toms_hub.dim_location.region_code::text <> 'NJ'::text)
293. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice66; segments: 304) (cost=0.00..440.43 rows=3 width=31) (actual rows= loops=)

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

Hash Join (cost=0.00..440.43 rows=3 width=31) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..434.41 rows=71 width=35) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar AND empl_status_code = 'A'::bpchar AND funding_source_code::text <> 'FRE'::text AND (consult_category_code::text = ANY ('{196,198,199}'::text[])) AND headcount_level_code::text = '60'::text AND manager_type::text = 'ASGN_CONT'::text AND (consult_category_code::text <> '196'::text OR consult_category_code::text = '196'::text)
296. 0.000 0.000 ↓ 0.0

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

297. 0.000 0.000 ↓ 0.0

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

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

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

299. 0.000 0.000 ↓ 0.0

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

300. 0.000 0.000 ↓ 0.0

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

301. 0.000 0.000 ↓ 0.0

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

302. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.02..437.02 rows=2 width=7) (actual rows= loops=)

304. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice69; segments: 304) (cost=0.00..437.02 rows=2 width=7) (actual rows= loops=)

  • Hash Key: toms_hub.dim_location.location_code
305. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.02 rows=2 width=7) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.01 rows=36 width=11) (actual rows= loops=)

  • Filter: country_code::text <> 'AUS'::text
307. 0.000 0.000 ↓ 0.0

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

308. 0.000 0.000 ↓ 0.0

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

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

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

310. 0.000 0.000 ↓ 0.0

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

311. 0.000 0.000 ↓ 0.0

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

312. 0.000 0.000 ↓ 0.0

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

313. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.28..437.28 rows=11 width=5) (actual rows= loops=)

315. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice73; segments: 304) (cost=0.00..437.28 rows=11 width=5) (actual rows= loops=)

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

Hash Join (cost=0.00..437.28 rows=11 width=5) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_integrated_cc.gpload_version_id = toms_hub.cfg_gpload_version_ctrl.curr_version_id
317. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.21 rows=327 width=9) (actual rows= loops=)

318. 0.000 0.000 ↓ 0.0

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

319. 0.000 0.000 ↓ 0.0

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

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

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

321. 0.000 0.000 ↓ 0.0

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

322. 0.000 0.000 ↓ 0.0

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

323. 0.000 0.000 ↓ 0.0

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

324. 0.000 0.000 ↓ 0.0

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

  • Index Cond: table_schema::text = 'toms_hub'::text AND table_name::text = 'dim_integrated_cc'::text
325. 0.000 0.000 ↓ 0.0

Hash (cost=440.36..440.36 rows=73 width=5) (actual rows= loops=)

326. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice77; segments: 304) (cost=0.00..440.36 rows=73 width=5) (actual rows= loops=)

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

Hash Join (cost=0.00..440.36 rows=73 width=5) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.97 rows=2,151 width=9) (actual rows= loops=)

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

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

330. 0.000 0.000 ↓ 0.0

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

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

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

332. 0.000 0.000 ↓ 0.0

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

333. 0.000 0.000 ↓ 0.0

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

334. 0.000 0.000 ↓ 0.0

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

335. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=862.04..862.04 rows=92 width=10) (actual rows= loops=)

337. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice81; segments: 304) (cost=0.00..862.04 rows=92 width=10) (actual rows= loops=)

  • Hash Key: toms_hub.lkp_pt_vendor.vendor_code
338. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: toms_hub.lkp_pt_vendor.gpload_version_id = (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
339. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (actual rows= loops=)

340. 0.000 0.000 ↓ 0.0

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

341. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:304 (slice80; segments: 1) (cost=0.00..431.01 rows=304 width=4) (actual rows= loops=)

342. 0.000 0.000 ↓ 0.0

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

343. 0.000 0.000 ↓ 0.0

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

344. 0.000 0.000 ↓ 0.0

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

345. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=4) (actual rows= loops=)

346. 0.000 0.000 ↓ 0.0

Hash (cost=862.00..862.00 rows=3 width=5) (actual rows= loops=)

347. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=3 width=5) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_vendor_rules.gpload_version_id = (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
348. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=9) (actual rows= loops=)

  • Filter: furlough_agreement::text = '1'::text
349. 0.000 0.000 ↓ 0.0

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

350. 0.000 0.000 ↓ 0.0

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

351. 0.000 0.000 ↓ 0.0

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

352. 0.000 0.000 ↓ 0.0

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

353. 0.000 0.000 ↓ 0.0

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

354. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=4) (actual rows= loops=)

355. 0.000 0.000 ↓ 0.0

Hash (cost=431.17..431.17 rows=259 width=5) (actual rows= loops=)

356. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice86; segments: 304) (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Hash Key: share0_ref6.ms_id
357. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.17 rows=259 width=5) (actual rows= loops=)

  • Filter: share0_ref6.business_eff_start_dt <= '2020-12-31'::date AND share0_ref6.effective_end_date >= '2020-12-31'::date AND (share0_ref6.worker_pay_type_code::text <> ALL ('{"Direct PAYE | Above 15/Hr","Direct PAYE | Under 15/Hr","Referral PAYE | Above 15/Hr","Referral PAYE | Under 15/Hr","Recruited PAYE | Above 15/Hr","Recruited PAYE | Under 15/Hr"}'::text[]))
358. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 86:0) (cost=0.00..431.06 rows=1,108 width=23) (actual rows= loops=)

359. 0.000 0.000 ↓ 0.0

Hash (cost=862.46..862.46 rows=27,764 width=10) (actual rows= loops=)

360. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice91; segments: 304) (cost=0.00..862.46 rows=27,764 width=10) (actual rows= loops=)

361. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: toms_hub.lkp_pt_vendor.gpload_version_id = (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
362. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (actual rows= loops=)

363. 0.000 0.000 ↓ 0.0

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

364. 0.000 0.000 ↓ 0.0

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

365. 0.000 0.000 ↓ 0.0

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

366. 0.000 0.000 ↓ 0.0

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

367. 0.000 0.000 ↓ 0.0

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

368. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=4) (actual rows= loops=)

369. 0.000 0.000 ↓ 0.0

Hash (cost=862.03..862.03 rows=840 width=16) (actual rows= loops=)

370. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice94; segments: 304) (cost=0.00..862.03 rows=840 width=16) (actual rows= loops=)

371. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=3 width=16) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_vendor_rules.gpload_version_id = (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
372. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=20) (actual rows= loops=)

373. 0.000 0.000 ↓ 0.0

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

374. 0.000 0.000 ↓ 0.0

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

375. 0.000 0.000 ↓ 0.0

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

376. 0.000 0.000 ↓ 0.0

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

377. 0.000 0.000 ↓ 0.0

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

378. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=4) (actual rows= loops=)

379. 0.000 0.000 ↓ 0.0

Hash (cost=1,116.33..1,116.33 rows=25,809 width=15) (actual rows= loops=)

380. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice97; segments: 304) (cost=0.00..1,116.33 rows=25,809 width=15) (actual rows= loops=)

  • Hash Key: share3_ref3.employee_id
381. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,115.11 rows=25,809 width=15) (actual rows= loops=)

382. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,115.11 rows=25,809 width=15) (actual rows= loops=)

  • Group By: share3_ref3.employee_id, share3_ref3.furlough_year
383. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice96; segments: 304) (cost=0.00..1,108.62 rows=25,809 width=23) (actual rows= loops=)

  • Hash Key: share3_ref3.employee_id, share3_ref3.furlough_year
384. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,106.76 rows=25,809 width=23) (actual rows= loops=)

385. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,106.76 rows=25,809 width=23) (actual rows= loops=)

  • Group By: share3_ref3.employee_id, share3_ref3.furlough_year
386. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 96:3) (cost=0.00..515.87 rows=2,347,814 width=15) (actual rows= loops=)

387. 0.000 0.000 ↓ 0.0

Hash (cost=1,133.57..1,133.57 rows=25,809 width=15) (actual rows= loops=)

388. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice99; segments: 304) (cost=0.00..1,133.57 rows=25,809 width=15) (actual rows= loops=)

  • Hash Key: share2_ref3.employee_id
389. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,132.36 rows=25,809 width=15) (actual rows= loops=)

390. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,132.36 rows=25,809 width=15) (actual rows= loops=)

  • Group By: share2_ref3.employee_id, share2_ref3.furlough_year
391. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice98; segments: 304) (cost=0.00..1,125.86 rows=25,809 width=23) (actual rows= loops=)

  • Hash Key: share2_ref3.employee_id, share2_ref3.furlough_year
392. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,124.00 rows=25,809 width=23) (actual rows= loops=)

393. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,124.00 rows=25,809 width=23) (actual rows= loops=)

  • Group By: share2_ref3.employee_id, share2_ref3.furlough_year
394. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 98:2) (cost=0.00..518.04 rows=2,407,743 width=15) (actual rows= loops=)

395. 0.000 0.000 ↓ 0.0

Hash (cost=1,666.67..1,666.67 rows=11,739,183 width=19) (actual rows= loops=)

396. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice103; segments: 304) (cost=0.00..1,666.67 rows=11,739,183 width=19) (actual rows= loops=)

  • Hash Key: share1_ref6.employee_id, share1_ref6.furlough_date
397. 0.000 0.000 ↓ 0.0

Result (cost=0.00..968.54 rows=11,739,183 width=19) (actual rows= loops=)

398. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 103:1) (cost=0.00..968.54 rows=11,739,183 width=19) (actual rows= loops=)

399. 0.000 0.000 ↓ 0.0

Hash (cost=431.13..431.13 rows=1,108 width=21) (actual rows= loops=)

400. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice105; segments: 304) (cost=0.00..431.13 rows=1,108 width=21) (actual rows= loops=)

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

Result (cost=0.00..431.06 rows=1,108 width=21) (actual rows= loops=)

402. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 105:0) (cost=0.00..431.06 rows=1,108 width=21) (actual rows= loops=)

403. 0.000 0.000 ↓ 0.0

Result (cost=0.00..9,468,227,027.99 rows=363,410,675,613 width=1,322) (actual rows= loops=)

404. 0.000 0.000 ↓ 0.0

Result (cost=0.00..9,468,227,027.99 rows=363,410,675,613 width=1,322) (actual rows= loops=)

405. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..8,987,798,114.83 rows=363,410,675,613 width=1,859) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.ms_id::text = share0_ref7.ms_id::text
406. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,295,478,793.84 rows=252,174,918,279 width=1,849) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
407. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..4,373,177,432.67 rows=224,954,803,739 width=1,834) (actual rows= loops=)

  • Hash Cond: secured_dim_vendor.vendor_code::text = toms_hub.lkp_pt_vendor.vendor_code::text
408. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,871,121,572.96 rows=44,990,960,748 width=1,834) (actual rows= loops=)

  • Hash Cond: share7_ref3.vendor_code::text = secured_dim_vendor.vendor_code::text
409. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,530,135,342.34 rows=42,165,181,965 width=1,747) (actual rows= loops=)

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

Hash Left Join (cost=0.00..2,220,502,193.16 rows=42,068,756,823 width=1,737) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_category_code::text = toms_hub.dim_resource_category.resource_category_code::text
411. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,913,136,438.86 rows=42,068,756,823 width=1,729) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.co_mgr_ms_id_1::text = toms_hub.dim_resource.ms_id::text
412. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,607,409,749.59 rows=42,068,756,823 width=1,711) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_category_code::text = toms_hub.dim_resource_category.resource_category_code::text
413. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,304,538,368.86 rows=42,068,756,823 width=1,703) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.manager_ms_id::text = toms_hub.dim_resource.ms_id::text
414. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,009,380,364.64 rows=36,764,130,334 width=1,698) (actual rows= loops=)

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

Hash Left Join (cost=0.00..746,886,978.14 rows=36,764,130,334 width=1,680) (actual rows= loops=)

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

Hash Left Join (cost=0.00..487,090,350.88 rows=36,764,130,334 width=1,663) (actual rows= loops=)

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

Hash Left Join (cost=0.00..258,562,179.86 rows=12,248,947,373 width=1,664) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_resource.resource_category_code::text = toms_hub.dim_resource_category.resource_category_code::text
418. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..173,584,829.69 rows=12,248,947,373 width=1,543) (actual rows= loops=)

  • Hash Cond: share7_ref3.resource_key = toms_hub.dim_resource.resource_key
419. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..97,546,813.99 rows=12,248,947,373 width=1,040) (actual rows= loops=)

  • Hash Cond: toms_hub.dim_integrated_cc.home_company_id::text = cfg_home_company_tax.home_company_code::text
420. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..44,862,883.14 rows=10,676,297,711 width=960) (actual rows= loops=)

  • Hash Cond: share7_ref3.cc_code::text = toms_hub.dim_integrated_cc.cc_id::text
421. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..7,819,031.61 rows=3,557,092,406 width=255) (actual rows= loops=)

  • Hash Cond: share7_ref3.location_code::text = toms_hub.dim_location.location_code::text
422. 0.000 0.000 ↓ 0.0

Result (cost=0.00..3,786,460.98 rows=3,333,271,630 width=137) (actual rows= loops=)

423. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,329,802.77 rows=3,333,271,630 width=111) (actual rows= loops=)

  • Hash Cond: share7_ref3.furlough_year = share7_ref2.furlough_year AND share7_ref3.vendor_code::text = share7_ref2.vendor_code::text
424. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 152:7) (cost=0.00..490,752.79 rows=1,975,272,077 width=103) (actual rows= loops=)

425. 0.000 0.000 ↓ 0.0

Hash (cost=733,558.56..733,558.56 rows=11,715 width=21) (actual rows= loops=)

426. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice2; segments: 304) (cost=0.00..733,558.56 rows=11,715 width=21) (actual rows= loops=)

427. 0.000 0.000 ↓ 0.0

Result (cost=0.00..733,558.19 rows=39 width=21) (actual rows= loops=)

428. 0.000 0.000 ↓ 0.0

Result (cost=0.00..733,558.19 rows=39 width=21) (actual rows= loops=)

429. 0.000 0.000 ↓ 0.0

Result (cost=0.00..733,558.19 rows=39 width=37) (actual rows= loops=)

430. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..733,558.19 rows=39 width=45) (actual rows= loops=)

  • Group By: share7_ref2.vendor_code, share7_ref2.furlough_year
431. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice1; segments: 304) (cost=0.00..733,558.18 rows=39 width=45) (actual rows= loops=)

  • Hash Key: share7_ref2.vendor_code, share7_ref2.furlough_year
432. 0.000 0.000 ↓ 0.0

Result (cost=0.00..733,558.17 rows=39 width=45) (actual rows= loops=)

433. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..733,558.17 rows=39 width=45) (actual rows= loops=)

  • Group By: share7_ref2.vendor_code, share7_ref2.furlough_year
434. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 1:7) (cost=0.00..214,649.26 rows=1,975,272,077 width=45) (actual rows= loops=)

435. 0.000 0.000 ↓ 0.0

Hash (cost=437.10..437.10 rows=378 width=123) (actual rows= loops=)

436. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice5; segments: 304) (cost=0.00..437.10 rows=378 width=123) (actual rows= loops=)

437. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.03 rows=2 width=123) (actual rows= loops=)

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

Table Scan on dim_location (cost=0.00..431.01 rows=37 width=127) (actual rows= loops=)

439. 0.000 0.000 ↓ 0.0

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

440. 0.000 0.000 ↓ 0.0

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

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

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

442. 0.000 0.000 ↓ 0.0

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

443. 0.000 0.000 ↓ 0.0

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

444. 0.000 0.000 ↓ 0.0

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

445. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=864.60..864.60 rows=327 width=710) (actual rows= loops=)

447. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice8; segments: 304) (cost=0.00..864.60 rows=327 width=710) (actual rows= loops=)

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

Hash Join (cost=0.00..863.88 rows=327 width=710) (actual rows= loops=)

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

Table Scan on dim_integrated_cc (cost=0.00..431.21 rows=327 width=714) (actual rows= loops=)

450. 0.000 0.000 ↓ 0.0

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

451. 0.000 0.000 ↓ 0.0

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

452. 0.000 0.000 ↓ 0.0

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

453. 0.000 0.000 ↓ 0.0

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

454. 0.000 0.000 ↓ 0.0

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

455. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.21 rows=327 width=4) (actual rows= loops=)

456. 0.000 0.000 ↓ 0.0

Hash (cost=431.04..431.04 rows=71 width=85) (actual rows= loops=)

457. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice9; segments: 304) (cost=0.00..431.04 rows=71 width=85) (actual rows= loops=)

458. 0.000 0.000 ↓ 0.0

Table Scan on cfg_home_company_tax (cost=0.00..431.00 rows=1 width=85) (actual rows= loops=)

459. 0.000 0.000 ↓ 0.0

Hash (cost=460.20..460.20 rows=21,953 width=507) (actual rows= loops=)

460. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice12; segments: 304) (cost=0.00..460.20 rows=21,953 width=507) (actual rows= loops=)

461. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..443.36 rows=73 width=507) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..436.18 rows=2,151 width=511) (actual rows= loops=)

  • Filter: current_flag = 'Y'::bpchar AND is_deleted = 'N'::bpchar AND resource_rec_type = 'E'::bpchar
463. 0.000 0.000 ↓ 0.0

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

464. 0.000 0.000 ↓ 0.0

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

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

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

466. 0.000 0.000 ↓ 0.0

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

467. 0.000 0.000 ↓ 0.0

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

468. 0.000 0.000 ↓ 0.0

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

469. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.01..437.01 rows=3 width=126) (actual rows= loops=)

471. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice15; segments: 304) (cost=0.00..437.01 rows=3 width=126) (actual rows= loops=)

472. 0.000 0.000 ↓ 0.0

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

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

Table Scan on dim_resource_category (cost=0.00..431.00 rows=1 width=130) (actual rows= loops=)

474. 0.000 0.000 ↓ 0.0

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

475. 0.000 0.000 ↓ 0.0

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

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

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

477. 0.000 0.000 ↓ 0.0

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

478. 0.000 0.000 ↓ 0.0

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

479. 0.000 0.000 ↓ 0.0

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

480. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=863.86..863.86 rows=99,262 width=9) (actual rows= loops=)

482. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice18; segments: 304) (cost=0.00..863.86 rows=99,262 width=9) (actual rows= loops=)

483. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.51 rows=327 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))))
484. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.21 rows=327 width=13) (actual rows= loops=)

485. 0.000 0.000 ↓ 0.0

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

486. 0.000 0.000 ↓ 0.0

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

487. 0.000 0.000 ↓ 0.0

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

488. 0.000 0.000 ↓ 0.0

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

489. 0.000 0.000 ↓ 0.0

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

490. 0.000 0.000 ↓ 0.0

Table Scan on dim_integrated_cc (cost=0.00..431.21 rows=327 width=4) (actual rows= loops=)

491. 0.000 0.000 ↓ 0.0

Hash (cost=437.05..437.05 rows=4 width=27) (actual rows= loops=)

492. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice21; segments: 304) (cost=0.00..437.05 rows=4 width=27) (actual rows= loops=)

493. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.05 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
494. 0.000 0.000 ↓ 0.0

Table Scan on dim_report_lookup (cost=0.00..431.05 rows=1 width=31) (actual rows= loops=)

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

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

496. 0.000 0.000 ↓ 0.0

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

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

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

498. 0.000 0.000 ↓ 0.0

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

499. 0.000 0.000 ↓ 0.0

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

500. 0.000 0.000 ↓ 0.0

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

501. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.05..437.05 rows=4 width=27) (actual rows= loops=)

503. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice24; segments: 304) (cost=0.00..437.05 rows=4 width=27) (actual rows= loops=)

504. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.05 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
505. 0.000 0.000 ↓ 0.0

Table Scan on dim_report_lookup (cost=0.00..431.05 rows=1 width=31) (actual rows= loops=)

  • Filter: title::text = 'JOB_LEVEL'::text
506. 0.000 0.000 ↓ 0.0

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

507. 0.000 0.000 ↓ 0.0

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

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

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

509. 0.000 0.000 ↓ 0.0

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

510. 0.000 0.000 ↓ 0.0

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

511. 0.000 0.000 ↓ 0.0

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

512. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=440.72..440.72 rows=21,953 width=10) (actual rows= loops=)

514. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice27; segments: 304) (cost=0.00..440.72 rows=21,953 width=10) (actual rows= loops=)

515. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..440.39 rows=73 width=10) (actual rows= loops=)

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

Table Scan on dim_resource (cost=0.00..433.99 rows=2,151 width=14) (actual rows= loops=)

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

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

518. 0.000 0.000 ↓ 0.0

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

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

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

520. 0.000 0.000 ↓ 0.0

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

521. 0.000 0.000 ↓ 0.0

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

522. 0.000 0.000 ↓ 0.0

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

523. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.01..437.01 rows=3 width=22) (actual rows= loops=)

525. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice30; segments: 304) (cost=0.00..437.01 rows=3 width=22) (actual rows= loops=)

526. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.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
527. 0.000 0.000 ↓ 0.0

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

528. 0.000 0.000 ↓ 0.0

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

529. 0.000 0.000 ↓ 0.0

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

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

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

531. 0.000 0.000 ↓ 0.0

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

532. 0.000 0.000 ↓ 0.0

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

533. 0.000 0.000 ↓ 0.0

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

534. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=441.23..441.23 rows=21,953 width=23) (actual rows= loops=)

536. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice33; segments: 304) (cost=0.00..441.23 rows=21,953 width=23) (actual rows= loops=)

537. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..440.46 rows=73 width=23) (actual rows= loops=)

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

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

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

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

540. 0.000 0.000 ↓ 0.0

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

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

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

542. 0.000 0.000 ↓ 0.0

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

543. 0.000 0.000 ↓ 0.0

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

544. 0.000 0.000 ↓ 0.0

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

545. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.01..437.01 rows=3 width=22) (actual rows= loops=)

547. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice36; segments: 304) (cost=0.00..437.01 rows=3 width=22) (actual rows= loops=)

548. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.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
549. 0.000 0.000 ↓ 0.0

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

550. 0.000 0.000 ↓ 0.0

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

551. 0.000 0.000 ↓ 0.0

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

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

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

553. 0.000 0.000 ↓ 0.0

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

554. 0.000 0.000 ↓ 0.0

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

555. 0.000 0.000 ↓ 0.0

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

556. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=874.78..874.78 rows=349 width=10) (actual rows= loops=)

558. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice42; segments: 304) (cost=0.00..874.78 rows=349 width=10) (actual rows= loops=)

559. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..874.77 rows=2 width=10) (actual rows= loops=)

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

Hash Join (cost=0.00..437.44 rows=23 width=9) (actual rows= loops=)

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

Table Scan on secured_dim_work_order (cost=0.00..431.29 rows=684 width=13) (actual rows= loops=)

562. 0.000 0.000 ↓ 0.0

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

563. 0.000 0.000 ↓ 0.0

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

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

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

565. 0.000 0.000 ↓ 0.0

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

566. 0.000 0.000 ↓ 0.0

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

567. 0.000 0.000 ↓ 0.0

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

568. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.32..437.32 rows=18 width=9) (actual rows= loops=)

570. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice41; segments: 304) (cost=0.00..437.32 rows=18 width=9) (actual rows= loops=)

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

Hash Join (cost=0.00..437.32 rows=18 width=9) (actual rows= loops=)

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

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.22 rows=512 width=13) (actual rows= loops=)

  • Filter: is_latest_for_reporting = 'Y'::bpchar
573. 0.000 0.000 ↓ 0.0

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

574. 0.000 0.000 ↓ 0.0

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

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

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

576. 0.000 0.000 ↓ 0.0

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

577. 0.000 0.000 ↓ 0.0

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

578. 0.000 0.000 ↓ 0.0

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

579. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=437.09..437.09 rows=466 width=87) (actual rows= loops=)

581. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice45; segments: 304) (cost=0.00..437.09 rows=466 width=87) (actual rows= loops=)

582. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.03 rows=2 width=87) (actual rows= loops=)

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

Table Scan on secured_dim_vendor (cost=0.00..431.01 rows=46 width=91) (actual rows= loops=)

584. 0.000 0.000 ↓ 0.0

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

585. 0.000 0.000 ↓ 0.0

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

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

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

587. 0.000 0.000 ↓ 0.0

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

588. 0.000 0.000 ↓ 0.0

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

589. 0.000 0.000 ↓ 0.0

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

590. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=862.46..862.46 rows=27,764 width=10) (actual rows= loops=)

592. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice48; segments: 304) (cost=0.00..862.46 rows=27,764 width=10) (actual rows= loops=)

593. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: toms_hub.lkp_pt_vendor.gpload_version_id = (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
594. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (actual rows= loops=)

595. 0.000 0.000 ↓ 0.0

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

596. 0.000 0.000 ↓ 0.0

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

597. 0.000 0.000 ↓ 0.0

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

598. 0.000 0.000 ↓ 0.0

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

599. 0.000 0.000 ↓ 0.0

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

600. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=4) (actual rows= loops=)

601. 0.000 0.000 ↓ 0.0

Hash (cost=862.05..862.05 rows=840 width=25) (actual rows= loops=)

602. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice51; segments: 304) (cost=0.00..862.05 rows=840 width=25) (actual rows= loops=)

603. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.00 rows=3 width=25) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_vendor_rules.gpload_version_id = (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
604. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=29) (actual rows= loops=)

605. 0.000 0.000 ↓ 0.0

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

606. 0.000 0.000 ↓ 0.0

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

607. 0.000 0.000 ↓ 0.0

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

608. 0.000 0.000 ↓ 0.0

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

609. 0.000 0.000 ↓ 0.0

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

610. 0.000 0.000 ↓ 0.0

Table Scan on fms_vendor_rules (cost=0.00..431.00 rows=3 width=4) (actual rows= loops=)

611. 0.000 0.000 ↓ 0.0

Hash (cost=432.61..432.61 rows=67,111 width=15) (actual rows= loops=)

612. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice52; segments: 304) (cost=0.00..432.61 rows=67,111 width=15) (actual rows= loops=)

613. 0.000 0.000 ↓ 0.0

Result (cost=0.00..431.08 rows=221 width=15) (actual rows= loops=)

  • Filter: share0_ref7.is_latest_for_reporting = 'Y'::bpchar
  • -> Shared Scan (share slice:id 52:0) (cost=0.00..431.05 rows=1,108 width=17)Settings: gp_cte_sharing=on; gp_enable_relsize_collection=on; optimizer_join_arity_for_associativity_commutativity=7Optimizer status: PQO version 3.101.0