explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bbQk

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

The command completed with no results returnedInsert (cost=0.00..89,159,768,362.94 rows=17,086,112,377 width=1,322) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=0.00..659,045,663.66 rows=17,086,112,377 width=1,326) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice150; segments: 304) (cost=0.00..636,389,478.65 rows=17,086,112,377 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..565,689,537.69 rows=17,086,112,377 width=1,322) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150: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 (slice136; 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 (slice135; 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 (slice149; 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 (slice146; 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 (slice139; 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 (slice138; 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 (slice137; 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 (slice145; 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 (slice142; 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 (slice141; 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 (slice140; 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 (slice144; 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 (slice143; 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 (slice148; 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 (slice147; 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..543,099,507.66 rows=17,086,112,377 width=1,322) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150: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 (slice133; 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 (slice120; 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 (slice117; 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 (slice110; 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 (slice109; 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 (slice108; 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 (slice116; 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 (slice113; 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 (slice112; 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 (slice111; 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 (slice115; 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 (slice114; 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 (slice119; 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 (slice118; 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 (slice126; 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 (slice123; 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) = '2019'::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 (slice122; 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 (slice121; 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 (slice125; 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 (slice124; 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 (slice129; 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 (slice128; 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 (slice127; 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 (slice132; 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 (slice131; 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 (slice130; 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 (slice134; 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 134: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..520,503,977.50 rows=17,086,112,377 width=1,322) (actual rows= loops=)

170. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150: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 (slice105; 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 105: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 (slice106; 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 106: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 (slice107; 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 107: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..497,910,124.70 rows=17,086,112,377 width=1,322) (actual rows= loops=)

186. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150: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 150: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..475,317,242.82 rows=17,086,112,377 width=1,322) (actual rows= loops=)

192. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150:7) (cost=0.00..6,795,915.77 rows=261,188,653 width=1) (actual rows= loops=)

193. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..6,795,915.77 rows=261,188,653 width=1) (actual rows= loops=)

194. 0.000 0.000 ↓ 0.0

Result (cost=0.00..6,795,654.58 rows=261,188,653 width=160) (actual rows= loops=)

195. 0.000 0.000 ↓ 0.0

Window (cost=0.00..6,753,864.40 rows=261,188,653 width=136) (actual rows= loops=)

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

Sort (cost=0.00..6,753,864.40 rows=261,188,653 width=94) (actual rows= loops=)

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

Hash Left Join (cost=0.00..2,861,527.59 rows=261,188,653 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
198. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice103; segments: 304) (cost=0.00..2,647,998.62 rows=261,188,653 width=86) (actual rows= loops=)

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

Hash Left Join (cost=0.00..2,577,691.86 rows=261,188,653 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
200. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice101; segments: 304) (cost=0.00..2,221,825.61 rows=261,188,653 width=78) (actual rows= loops=)

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

Result (cost=0.00..2,158,059.02 rows=261,188,653 width=78) (actual rows= loops=)

202. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..2,158,059.02 rows=261,188,653 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
203. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice100; segments: 304) (cost=0.00..1,844,010.48 rows=261,188,653 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
204. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,780,243.88 rows=261,188,653 width=78) (actual rows= loops=)

205. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,780,243.88 rows=261,188,653 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
206. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,466,195.35 rows=261,188,653 width=66) (actual rows= loops=)

207. 0.000 0.000 ↓ 0.0

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

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

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

209. 0.000 0.000 ↓ 0.0

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

210. 0.000 0.000 ↓ 0.0

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

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

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

212. 0.000 0.000 ↓ 0.0

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

213. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice99; segments: 304) (cost=0.00..1,466,195.35 rows=256,433,097 width=66) (actual rows= loops=)

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

Result (cost=0.00..1,466,195.35 rows=256,433,097 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
215. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,445,103.73 rows=641,082,742 width=66) (actual rows= loops=)

216. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..1,402,792.27 rows=641,082,742 width=73) (actual rows= loops=)

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

Hash Left Join (cost=0.00..1,231,449.48 rows=29,998,376 width=65) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice94; segments: 304) (cost=0.00..1,223,204.46 rows=1,403,723 width=57) (actual rows= loops=)

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

Hash Left Join (cost=0.00..1,222,954.03 rows=1,403,723 width=57) (actual rows= loops=)

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

Hash Left Join (cost=0.00..1,221,637.40 rows=850,143 width=51) (actual rows= loops=)

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

Append (cost=0.00..1,220,580.32 rows=170,029 width=41) (actual rows= loops=)

222. 0.000 0.000 ↓ 0.0

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

223. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice54; 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
224. 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, '2019'::text, share2_ref4.ms_id, share2_ref4.employee_id, share2_ref4.cc_code, share2_ref4.vendor_id, share2_ref4.location_code, '2019-12-31'::date, share2_ref4.cc_vendor_flag, 0, 0, 0
225. 0.000 0.000 ↓ 0.0

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

226. 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
227. 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[]))
228. 0.000 0.000 ↓ 0.0

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

229. 0.000 0.000 ↓ 0.0

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

230. 0.000 0.000 ↓ 0.0

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

  • Hash Key: share0_ref4.ms_id
231. 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 <= '2019-12-31'::date AND share0_ref4.effective_end_date >= '2019-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[]))
232. 0.000 0.000 ↓ 0.0

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

233. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,220,580.32 rows=75,392 width=41) (actual rows= loops=)

234. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice59; segments: 304) (cost=0.00..1,220,580.32 rows=75,392 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
235. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,220,567.13 rows=75,392 width=61) (actual rows= loops=)

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

Result (cost=0.00..1,220,449.81 rows=75,392 width=61) (actual rows= loops=)

237. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,220,445.21 rows=75,392 width=29) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice57; segments: 304) (cost=0.00..1,219,978.36 rows=146,055 width=29) (actual rows= loops=)

  • Hash Key: share3_ref4.ms_id
239. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,219,965.11 rows=146,055 width=29) (actual rows= loops=)

  • Filter: share2_ref5.employee_id IS NULL
240. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..967,796.43 rows=7,664,701,312 width=36) (actual rows= loops=)

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

Redistribute Motion 304:304 (slice55; segments: 304) (cost=0.00..868.37 rows=146,055 width=29) (actual rows= loops=)

  • Hash Key: share3_ref4.employee_id
242. 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[]))
243. 0.000 0.000 ↓ 0.0

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

244. 0.000 0.000 ↓ 0.0

Hash (cost=524.37..524.37 rows=2,407,743 width=7) (actual rows= loops=)

245. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice56; segments: 304) (cost=0.00..524.37 rows=2,407,743 width=7) (actual rows= loops=)

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

Result (cost=0.00..471.62 rows=2,407,743 width=7) (actual rows= loops=)

247. 0.000 0.000 ↓ 0.0

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

248. 0.000 0.000 ↓ 0.0

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

249. 0.000 0.000 ↓ 0.0

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

  • Hash Key: share0_ref5.ms_id
250. 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[]))
251. 0.000 0.000 ↓ 0.0

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

252. 0.000 0.000 ↓ 0.0

Result (cost=0.00..9,473.38 rows=1 width=40) (actual rows= loops=)

253. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice87; segments: 304) (cost=0.00..9,473.38 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
254. 0.000 0.000 ↓ 0.0

Result (cost=0.00..9,473.38 rows=1 width=60) (actual rows= loops=)

255. 0.000 0.000 ↓ 0.0

Result (cost=0.00..9,473.38 rows=1 width=28) (actual rows= loops=)

  • Filter: share1_ref7.employee_id IS NULL
256. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..9,473.08 rows=163 width=35) (actual rows= loops=)

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

Hash Join (cost=0.00..4,775.25 rows=1 width=28) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.ms_id::text = toms_hub.dim_resource.ms_id::text
258. 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))))
259. 0.000 0.000 ↓ 0.0

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

260. 0.000 0.000 ↓ 0.0

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

261. 0.000 0.000 ↓ 0.0

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

262. 0.000 0.000 ↓ 0.0

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

263. 0.000 0.000 ↓ 0.0

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

264. 0.000 0.000 ↓ 0.0

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

265. 0.000 0.000 ↓ 0.0

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

266. 0.000 0.000 ↓ 0.0

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

267. 0.000 0.000 ↓ 0.0

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

268. 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
269. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.ms_id
270. 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
271. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.lkp_pt_vendor.vendor_id
272. 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
273. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.vendor_code
274. 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
275. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.manager_ms_id
276. 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
277. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.hr_cc_code
278. 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)
279. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.location_code
280. 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
281. 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)
282. 0.000 0.000 ↓ 0.0

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

283. 0.000 0.000 ↓ 0.0

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

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

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

285. 0.000 0.000 ↓ 0.0

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

286. 0.000 0.000 ↓ 0.0

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

287. 0.000 0.000 ↓ 0.0

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

288. 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
289. 0.000 0.000 ↓ 0.0

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

290. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_location.location_code
291. 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
292. 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
293. 0.000 0.000 ↓ 0.0

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

294. 0.000 0.000 ↓ 0.0

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

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

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

296. 0.000 0.000 ↓ 0.0

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

297. 0.000 0.000 ↓ 0.0

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

298. 0.000 0.000 ↓ 0.0

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

299. 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
300. 0.000 0.000 ↓ 0.0

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

301. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_integrated_cc.cc_id
302. 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
303. 0.000 0.000 ↓ 0.0

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

304. 0.000 0.000 ↓ 0.0

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

305. 0.000 0.000 ↓ 0.0

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

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

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

307. 0.000 0.000 ↓ 0.0

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

308. 0.000 0.000 ↓ 0.0

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

309. 0.000 0.000 ↓ 0.0

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

310. 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
311. 0.000 0.000 ↓ 0.0

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

312. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.dim_resource.ms_id
313. 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
314. 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
315. 0.000 0.000 ↓ 0.0

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

316. 0.000 0.000 ↓ 0.0

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

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

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

318. 0.000 0.000 ↓ 0.0

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

319. 0.000 0.000 ↓ 0.0

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

320. 0.000 0.000 ↓ 0.0

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

321. 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
322. 0.000 0.000 ↓ 0.0

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

323. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.lkp_pt_vendor.vendor_code
324. 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))))
325. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.01 rows=92 width=14) (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

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

328. 0.000 0.000 ↓ 0.0

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

329. 0.000 0.000 ↓ 0.0

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

330. 0.000 0.000 ↓ 0.0

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

331. 0.000 0.000 ↓ 0.0

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

332. 0.000 0.000 ↓ 0.0

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

333. 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))))
334. 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
335. 0.000 0.000 ↓ 0.0

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

336. 0.000 0.000 ↓ 0.0

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

337. 0.000 0.000 ↓ 0.0

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

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

339. 0.000 0.000 ↓ 0.0

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

340. 0.000 0.000 ↓ 0.0

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

341. 0.000 0.000 ↓ 0.0

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

342. 0.000 0.000 ↓ 0.0

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

  • Hash Key: share0_ref6.ms_id
343. 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[]))
344. 0.000 0.000 ↓ 0.0

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

345. 0.000 0.000 ↓ 0.0

Hash (cost=886.25..886.25 rows=11,739,183 width=7) (actual rows= loops=)

346. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice86; segments: 304) (cost=0.00..886.25 rows=11,739,183 width=7) (actual rows= loops=)

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

Result (cost=0.00..629.04 rows=11,739,183 width=7) (actual rows= loops=)

348. 0.000 0.000 ↓ 0.0

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

349. 0.000 0.000 ↓ 0.0

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

350. 0.000 0.000 ↓ 0.0

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

351. 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))))
352. 0.000 0.000 ↓ 0.0

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

353. 0.000 0.000 ↓ 0.0

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

354. 0.000 0.000 ↓ 0.0

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

355. 0.000 0.000 ↓ 0.0

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

356. 0.000 0.000 ↓ 0.0

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

357. 0.000 0.000 ↓ 0.0

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

358. 0.000 0.000 ↓ 0.0

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

359. 0.000 0.000 ↓ 0.0

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

360. 0.000 0.000 ↓ 0.0

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

361. 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))))
362. 0.000 0.000 ↓ 0.0

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

363. 0.000 0.000 ↓ 0.0

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

364. 0.000 0.000 ↓ 0.0

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

365. 0.000 0.000 ↓ 0.0

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

366. 0.000 0.000 ↓ 0.0

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

367. 0.000 0.000 ↓ 0.0

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

368. 0.000 0.000 ↓ 0.0

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

369. 0.000 0.000 ↓ 0.0

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

370. 0.000 0.000 ↓ 0.0

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

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

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

372. 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
373. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice95; 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
374. 0.000 0.000 ↓ 0.0

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

375. 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
376. 0.000 0.000 ↓ 0.0

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

377. 0.000 0.000 ↓ 0.0

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

378. 0.000 0.000 ↓ 0.0

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

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

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

380. 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
381. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice97; 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
382. 0.000 0.000 ↓ 0.0

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

383. 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
384. 0.000 0.000 ↓ 0.0

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

385. 0.000 0.000 ↓ 0.0

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

386. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice102; 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
387. 0.000 0.000 ↓ 0.0

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

388. 0.000 0.000 ↓ 0.0

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

389. 0.000 0.000 ↓ 0.0

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

390. 0.000 0.000 ↓ 0.0

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

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

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

392. 0.000 0.000 ↓ 0.0

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

393. 0.000 0.000 ↓ 0.0

Result (cost=0.00..445,933,486.48 rows=17,086,112,377 width=1,322) (actual rows= loops=)

394. 0.000 0.000 ↓ 0.0

Result (cost=0.00..445,933,486.48 rows=17,086,112,377 width=1,322) (actual rows= loops=)

395. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..423,345,645.92 rows=17,086,112,377 width=1,859) (actual rows= loops=)

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

Hash Left Join (cost=0.00..296,763,149.54 rows=11,856,253,219 width=1,849) (actual rows= loops=)

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

Hash Left Join (cost=0.00..206,383,427.57 rows=10,576,472,609 width=1,834) (actual rows= loops=)

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

Hash Left Join (cost=0.00..135,761,955.03 rows=2,115,294,522 width=1,834) (actual rows= loops=)

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

Hash Left Join (cost=0.00..119,729,732.65 rows=1,982,437,738 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
400. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..105,171,190.12 rows=1,977,904,214 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
401. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..90,719,668.69 rows=1,977,904,214 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
402. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..76,345,192.50 rows=1,977,904,214 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
403. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..62,104,978.49 rows=1,977,904,214 width=1,703) (actual rows= loops=)

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

Hash Left Join (cost=0.00..48,227,406.13 rows=1,728,501,953 width=1,698) (actual rows= loops=)

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

Hash Left Join (cost=0.00..35,885,603.41 rows=1,728,501,953 width=1,680) (actual rows= loops=)

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

Hash Left Join (cost=0.00..23,670,591.50 rows=1,728,501,953 width=1,663) (actual rows= loops=)

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

Hash Left Join (cost=0.00..12,925,692.76 rows=575,896,377 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
408. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..8,929,982.12 rows=575,896,377 width=1,543) (actual rows= loops=)

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

Hash Left Join (cost=0.00..5,354,298.17 rows=575,896,377 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
410. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..2,876,900.14 rows=501,956,698 width=960) (actual rows= loops=)

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

Hash Left Join (cost=0.00..1,035,039.81 rows=470,351,494 width=255) (actual rows= loops=)

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

Result (cost=0.00..501,435.95 rows=440,755,851 width=137) (actual rows= loops=)

413. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..441,052.40 rows=440,755,851 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
414. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 150:7) (cost=0.00..65,265.86 rows=261,188,653 width=103) (actual rows= loops=)

415. 0.000 0.000 ↓ 0.0

Hash (cost=97,372.21..97,372.21 rows=11,715 width=21) (actual rows= loops=)

416. 0.000 0.000 ↓ 0.0

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

417. 0.000 0.000 ↓ 0.0

Result (cost=0.00..97,371.84 rows=39 width=21) (actual rows= loops=)

418. 0.000 0.000 ↓ 0.0

Result (cost=0.00..97,371.84 rows=39 width=21) (actual rows= loops=)

419. 0.000 0.000 ↓ 0.0

Result (cost=0.00..97,371.84 rows=39 width=37) (actual rows= loops=)

420. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..97,371.84 rows=39 width=45) (actual rows= loops=)

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

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

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

Result (cost=0.00..97,371.82 rows=39 width=45) (actual rows= loops=)

423. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..97,371.82 rows=39 width=45) (actual rows= loops=)

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

Shared Scan (share slice:id 1:7) (cost=0.00..28,756.91 rows=261,188,653 width=45) (actual rows= loops=)

425. 0.000 0.000 ↓ 0.0

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

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

427. 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
428. 0.000 0.000 ↓ 0.0

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

429. 0.000 0.000 ↓ 0.0

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

430. 0.000 0.000 ↓ 0.0

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

  • Assert Cond: (row_number()) = 1
431. 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=)

432. 0.000 0.000 ↓ 0.0

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

433. 0.000 0.000 ↓ 0.0

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

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

435. 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
436. 0.000 0.000 ↓ 0.0

Hash (cost=441.46..441.46 rows=3,333 width=710) (actual rows= loops=)

437. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice8; segments: 304) (cost=0.00..441.46 rows=3,333 width=710) (actual rows= loops=)

438. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.88 rows=11 width=710) (actual rows= loops=)

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

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

440. 0.000 0.000 ↓ 0.0

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

441. 0.000 0.000 ↓ 0.0

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

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

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

443. 0.000 0.000 ↓ 0.0

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

444. 0.000 0.000 ↓ 0.0

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

445. 0.000 0.000 ↓ 0.0

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

446. 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
447. 0.000 0.000 ↓ 0.0

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

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

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

450. 0.000 0.000 ↓ 0.0

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

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

452. 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
453. 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
454. 0.000 0.000 ↓ 0.0

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

455. 0.000 0.000 ↓ 0.0

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

  • Assert Cond: (row_number()) = 1
456. 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=)

457. 0.000 0.000 ↓ 0.0

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

458. 0.000 0.000 ↓ 0.0

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

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

460. 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
461. 0.000 0.000 ↓ 0.0

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

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

463. 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
464. 0.000 0.000 ↓ 0.0

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

465. 0.000 0.000 ↓ 0.0

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

466. 0.000 0.000 ↓ 0.0

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

  • Assert Cond: (row_number()) = 1
467. 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=)

468. 0.000 0.000 ↓ 0.0

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

469. 0.000 0.000 ↓ 0.0

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

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

471. 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
472. 0.000 0.000 ↓ 0.0

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

473. 0.000 0.000 ↓ 0.0

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

474. 0.000 0.000 ↓ 0.0

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

475. 0.000 0.000 ↓ 0.0

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

476. 0.000 0.000 ↓ 0.0

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

477. 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
478. 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
479. 0.000 0.000 ↓ 0.0

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

480. 0.000 0.000 ↓ 0.0

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

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

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

482. 0.000 0.000 ↓ 0.0

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

483. 0.000 0.000 ↓ 0.0

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

484. 0.000 0.000 ↓ 0.0

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

485. 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
486. 0.000 0.000 ↓ 0.0

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

487. 0.000 0.000 ↓ 0.0

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

488. 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
489. 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
490. 0.000 0.000 ↓ 0.0

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

491. 0.000 0.000 ↓ 0.0

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

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

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

493. 0.000 0.000 ↓ 0.0

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

494. 0.000 0.000 ↓ 0.0

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

495. 0.000 0.000 ↓ 0.0

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

496. 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
497. 0.000 0.000 ↓ 0.0

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

498. 0.000 0.000 ↓ 0.0

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

499. 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
500. 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
501. 0.000 0.000 ↓ 0.0

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

502. 0.000 0.000 ↓ 0.0

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

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

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

504. 0.000 0.000 ↓ 0.0

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

505. 0.000 0.000 ↓ 0.0

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

506. 0.000 0.000 ↓ 0.0

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

507. 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
508. 0.000 0.000 ↓ 0.0

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

509. 0.000 0.000 ↓ 0.0

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

510. 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
511. 0.000 0.000 ↓ 0.0

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

512. 0.000 0.000 ↓ 0.0

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

513. 0.000 0.000 ↓ 0.0

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

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

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

515. 0.000 0.000 ↓ 0.0

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

516. 0.000 0.000 ↓ 0.0

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

517. 0.000 0.000 ↓ 0.0

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

518. 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
519. 0.000 0.000 ↓ 0.0

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

520. 0.000 0.000 ↓ 0.0

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

521. 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
522. 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
523. 0.000 0.000 ↓ 0.0

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

524. 0.000 0.000 ↓ 0.0

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

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

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

526. 0.000 0.000 ↓ 0.0

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

527. 0.000 0.000 ↓ 0.0

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

528. 0.000 0.000 ↓ 0.0

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

529. 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
530. 0.000 0.000 ↓ 0.0

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

531. 0.000 0.000 ↓ 0.0

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

532. 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
533. 0.000 0.000 ↓ 0.0

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

534. 0.000 0.000 ↓ 0.0

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

535. 0.000 0.000 ↓ 0.0

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

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

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

537. 0.000 0.000 ↓ 0.0

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

538. 0.000 0.000 ↓ 0.0

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

539. 0.000 0.000 ↓ 0.0

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

540. 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
541. 0.000 0.000 ↓ 0.0

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

542. 0.000 0.000 ↓ 0.0

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

543. 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
544. 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
545. 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=)

546. 0.000 0.000 ↓ 0.0

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

547. 0.000 0.000 ↓ 0.0

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

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

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

549. 0.000 0.000 ↓ 0.0

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

550. 0.000 0.000 ↓ 0.0

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

551. 0.000 0.000 ↓ 0.0

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

552. 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
553. 0.000 0.000 ↓ 0.0

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

554. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice39; 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
555. 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
556. 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
557. 0.000 0.000 ↓ 0.0

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

558. 0.000 0.000 ↓ 0.0

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

  • Assert Cond: (row_number()) = 1
559. 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=)

560. 0.000 0.000 ↓ 0.0

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

561. 0.000 0.000 ↓ 0.0

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

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

563. 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
564. 0.000 0.000 ↓ 0.0

Hash (cost=437.09..437.09 rows=466 width=87) (actual rows= loops=)

565. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice43; segments: 304) (cost=0.00..437.09 rows=466 width=87) (actual rows= loops=)

566. 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
567. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_vendor (cost=0.00..431.01 rows=46 width=91) (actual rows= loops=)

568. 0.000 0.000 ↓ 0.0

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

569. 0.000 0.000 ↓ 0.0

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

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

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

571. 0.000 0.000 ↓ 0.0

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

572. 0.000 0.000 ↓ 0.0

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

573. 0.000 0.000 ↓ 0.0

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

574. 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
575. 0.000 0.000 ↓ 0.0

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

576. 0.000 0.000 ↓ 0.0

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

577. 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))))
578. 0.000 0.000 ↓ 0.0

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

579. 0.000 0.000 ↓ 0.0

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

580. 0.000 0.000 ↓ 0.0

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

581. 0.000 0.000 ↓ 0.0

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

582. 0.000 0.000 ↓ 0.0

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

583. 0.000 0.000 ↓ 0.0

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

584. 0.000 0.000 ↓ 0.0

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

585. 0.000 0.000 ↓ 0.0

Hash (cost=862.05..862.05 rows=840 width=25) (actual rows= loops=)

586. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice49; segments: 304) (cost=0.00..862.05 rows=840 width=25) (actual rows= loops=)

587. 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))))
588. 0.000 0.000 ↓ 0.0

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

589. 0.000 0.000 ↓ 0.0

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

590. 0.000 0.000 ↓ 0.0

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

591. 0.000 0.000 ↓ 0.0

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

592. 0.000 0.000 ↓ 0.0

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

593. 0.000 0.000 ↓ 0.0

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

594. 0.000 0.000 ↓ 0.0

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

595. 0.000 0.000 ↓ 0.0

Hash (cost=432.61..432.61 rows=67,111 width=15) (actual rows= loops=)

596. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice50; segments: 304) (cost=0.00..432.61 rows=67,111 width=15) (actual rows= loops=)

597. 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 50: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