explain.depesz.com

PostgreSQL's explain analyze made readable

Result: daia

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

Gather Motion 304:1 (slice47; segments: 304) (cost=0.00..10,781.67 rows=6 width=156) (actual rows= loops=)

  • Rows out: 0 rows at destination with 1031 ms to end.
  • (slice0) Executor memory: 5,346K bytes.
  • (slice1) Executor memory: 350K bytes avg x 304 workers, 350K bytes max (seg0).
  • (slice2) Executor memory: 5,141K bytes (entry db).
  • (slice3) Executor memory: 349K bytes avg x 304 workers, 350K bytes max (seg10).
  • (slice4) Executor memory: 5,141K bytes (entry db).
  • (slice5) Executor memory: 318K bytes avg x 304 workers, 318K bytes max (seg0).
  • (slice6) Executor memory: 5,141K bytes (entry db).
  • (slice7) Executor memory: 3,284K bytes avg x 304 workers, 3284K bytes max (seg0).
  • (slice8) Executor memory: 3,701K bytes avg x 304 workers, 3720K bytes max (seg51). Work_mem: 1K bytes max.
  • (slice9) Executor memory: 6,503K bytes avg x 304 workers, 6505K bytes max (seg66). Work_mem: 1K bytes max.
  • (slice10) Executor memory: 2,544K bytes avg x 304 workers, 2571K bytes max (seg97). Work_mem: 31K bytes max.
  • (slice11) Executor memory: 1,167K bytes avg x 304 workers, 1168K bytes max (seg165).
  • (slice12) Executor memory: 222K bytes avg x 304 workers, 222K bytes max (seg0).
  • (slice13) Executor memory: 7,278K bytes (entry db). Work_mem: 1K bytes max.
  • (slice14) Executor memory: 351K bytes avg x 304 workers, 351K bytes max (seg0).
  • (slice15) Executor memory: 5,181K bytes (entry db).
  • (slice16) Executor memory: 3,237K bytes avg x 304 workers, 3237K bytes max (seg0).
  • (slice17) Executor memory: 3,793K bytes avg x 304 workers, 7264K bytes max (seg97). Work_mem: 272K bytes max.
  • (slice18) Executor memory: 383K bytes avg x 304 workers, 383K bytes max (seg0).
  • (slice19) Executor memory: 5,214K bytes (entry db).
  • (slice20) Executor memory: 3,269K bytes avg x 304 workers, 3269K bytes max (seg0).
  • (slice21) Executor memory: 3,791K bytes avg x 304 workers, 3825K bytes max (seg51). Work_mem: 10K bytes max.
  • (slice22) Executor memory: 416K bytes avg x 304 workers, 416K bytes max (seg0).
  • (slice23) Executor memory: 5,246K bytes (entry db).
  • (slice24) Executor memory: 3,302K bytes avg x 304 workers, 3302K bytes max (seg0).
  • (slice25) Executor memory: 3,858K bytes avg x 304 workers, 7329K bytes max (seg97). Work_mem: 272K bytes max.
  • (slice26) Executor memory: 448K bytes avg x 304 workers, 448K bytes max (seg0).
  • (slice27) Executor memory: 5,279K bytes (entry db).
  • (slice28) Executor memory: 3,334K bytes avg x 304 workers, 3334K bytes max (seg0).
  • (slice29) Executor memory: 3,856K bytes avg x 304 workers, 3890K bytes max (seg51). Work_mem: 10K bytes max.
  • (slice30) Executor memory: 8,738K bytes avg x 304 workers, 8738K bytes max (seg0). Work_mem: 272K bytes max.
  • (slice31) Executor memory: 521K bytes avg x 304 workers, 521K bytes max (seg0).
  • (slice32) Executor memory: 5,319K bytes (entry db).
  • (slice33) Executor memory: 5,123K bytes avg x 304 workers, 5123K bytes max (seg0). Work_mem: 1K bytes max.
  • (slice34) Executor memory: 545K bytes avg x 304 workers, 545K bytes max (seg0).
  • (slice35) Executor memory: 5,344K bytes (entry db).
  • (slice36) Executor memory: 4,691K bytes avg x 304 workers, 4691K bytes max (seg0). Work_mem: 1K bytes max.
  • (slice37) Executor memory: 569K bytes avg x 304 workers, 569K bytes max (seg0).
  • (slice38) Executor memory: 5,368K bytes (entry db).
  • (slice39) Executor memory: 6,068K bytes avg x 304 workers, 6073K bytes max (seg0). Work_mem: 14K bytes max.
  • (slice40) Executor memory: 4,784K bytes avg x 304 workers, 4784K bytes max (seg0). Work_mem: 5K bytes max.
  • (slice41) Executor memory: 602K bytes avg x 304 workers, 602K bytes max (seg0).
  • (slice42) Executor memory: 5,401K bytes (entry db).
  • (slice43) Executor memory: 5,811K bytes avg x 304 workers, 5811K bytes max (seg0). Work_mem: 9K bytes max.
  • (slice44) Executor memory: 626K bytes avg x 304 workers, 626K bytes max (seg0).
  • (slice45) Executor memory: 5,425K bytes (entry db).
  • (slice46) Executor memory: 5,730K bytes avg x 304 workers, 5730K bytes max (seg0). Work_mem: 22K bytes max.
  • (slice47) Executor memory: 2,302K bytes avg x 304 workers, 2302K bytes max (seg0). Work_mem: 32K bytes max.Statement statistics:
  • Memory used: 262,144K bytesSettings: gp_cte_sharing=on; gp_enable_relsize_collection=on; optimizer_join_arity_for_associativity_commutativity=7Optimizer status: PQO version 3.101.0
2. 0.000 0.000 ↓ 0.0

Result (cost=0.00..10,781.67 rows=1 width=156) (actual rows= loops=)

  • Rows out: 0 rows (seg0) with 1330 ms to end.
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..10,781.67 rows=1 width=129) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.ms_id::text = toms_hub.secured_fact_resource_fg_status.ms_id::text
  • Join Filter: to_date(toms_hub.fms_furlough_dtls.furlough_date::text, 'Mon dd yyyy'::text) >= toms_hub.secured_fact_resource_fg_status.business_eff_start_dt AND to_date(toms_hub.fms_furlough_dtls.furlough_date::text, 'Mon dd yyyy'::text) <= (CASE WHEN toms_hub.secured_fact_resource_fg_status.business_eff_start_dt = (max((max(toms_hub.secured_fact_resource_fg_status.business_eff_start_dt)))) AND toms_hub.secured_fact_resource_fg_status.business_eff_end_dt > '2020-07-01'::date THEN '9999-12-31'::date ELSE toms_hub.secured_fact_resource_fg_status.business_eff_end_dt END)
  • Rows out: 0 rows (seg0) with 1330 ms to end.
  • Executor memory: 23K bytes avg, 32K bytes max (seg27).
  • Work_mem used: 23K bytes avg, 32K bytes max (seg27). Workfile: (0 spilling)
  • (seg27) Hash chain length 4.8 avg, 15 max, using 125 of 65536 buckets.
4. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice30; segments: 304) (cost=0.00..6,471.03 rows=1 width=121) (actual rows= loops=)

  • Hash Key: toms_hub.pt_employee.ms_id
  • Rows out: 0 rows at destination (seg0) with 725 ms to end.
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..6,471.03 rows=1 width=121) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
  • Rows out: 0 rows (seg0) with 1035 ms to end.
  • Executor memory: 9K bytes avg, 9K bytes max (seg0).
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0). Workfile: (0 spilling)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..5,609.03 rows=1 width=117) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.vendor_id::text = toms_hub.lkp_pt_vendor.vendor_id::text
  • Rows out: 0 rows (seg0) with 809 ms to end.
  • Executor memory: 272K bytes avg, 272K bytes max (seg0).
  • Work_mem used: 272K bytes avg, 272K bytes max (seg0). Workfile: (0 spilling)
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..4,747.03 rows=1 width=107) (actual rows= loops=)

  • Hash Cond: toms_hub.lkp_pt_vendor.vendor_id::text = toms_hub.fms_vendor_rules.vendor_id::text
  • Rows out: 0 rows (seg0) with 650 ms to end.
  • Executor memory: 9K bytes avg, 9K bytes max (seg0).
  • Work_mem used: 9K bytes avg, 9K bytes max (seg0). Workfile: (0 spilling)
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=0.00..3,885.02 rows=1 width=103) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.vendor_id::text = toms_hub.lkp_pt_vendor.vendor_id::text
  • Rows out: 0 rows (seg0) with 649 ms to end.
  • Executor memory: 272K bytes avg, 272K bytes max (seg0).
  • Work_mem used: 272K bytes avg, 272K bytes max (seg0). Workfile: (0 spilling)
9. 0.000 0.000 ↓ 0.0

Redistribute Motion 1:304 (slice13) (cost=0.00..3,023.02 rows=1 width=93) (actual rows= loops=)

  • Rows out: 0 rows at destination (seg0) with 586 ms to end.
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,023.02 rows=1 width=93) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.ms_id::text = dim_resource.ms_id::text
  • Rows out: 0 rows with 1046 ms to end.
11. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice10; segments: 304) (cost=0.00..2,586.02 rows=1 width=79) (actual rows= loops=)

  • Rows out: (No row requested) 0 rows at destination with 0 ms to end.
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,586.02 rows=1 width=79) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.employee_id::text = toms_hub.fms_furlough_dtls.employee_id::text
  • Rows out: Avg 155.6 rows x 304 workers. Max 278 rows (seg80) with 115 ms to first row, 118 ms to end.
  • Executor memory: 17K bytes avg, 31K bytes max (seg80).
  • Work_mem used: 17K bytes avg, 31K bytes max (seg80). Workfile: (0 spilling)
  • (seg80) Hash chain length 9.6 avg, 10 max, using 29 of 16384 buckets.
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=4 width=20) (actual rows= loops=)

  • Hash Cond: toms_hub.pt_employee.gpload_version_id = (max((max(toms_hub.pt_employee.gpload_version_id))))
  • Rows out: Avg 1279.2 rows x 304 workers. Max 1354 rows (seg118) with 5.134 ms to first row, 8.411 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg118) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
14. 0.000 0.000 ↓ 0.0

Table Scan on pt_employee (cost=0.00..431.00 rows=4 width=24) (actual rows= loops=)

  • Rows out: Avg 10230.6 rows x 304 workers. Max 10828 rows (seg118) with 1.915 ms to first row, 5.364 ms to end.
15. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.027 ms to end, start offset by 2372 ms.
16. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 0.020 ms to end.
17. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 345 ms to end.
18. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.020 ms to first row, 345 ms to end.
19. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 3.059 ms to end.
20. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 10230.6 rows x 304 workers. Max 10828 rows (seg118) with 0.729 ms to first row, 2.873 ms to end.
21. 0.000 0.000 ↓ 0.0

Hash (cost=1,724.01..1,724.01 rows=1 width=66) (actual rows= loops=)

  • Rows in: Avg 155.6 rows x 304 workers. Max 278 rows (seg80) with 112 ms to end, start offset by 2260 ms.
22. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice9; segments: 304) (cost=0.00..1,724.01 rows=1 width=66) (actual rows= loops=)

  • Hash Key: toms_hub.fms_furlough_dtls.employee_id
  • Rows out: Avg 155.6 rows x 304 workers at destination. Max 278 rows (seg80) with 84 ms to first row, 112 ms to end.
23. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,724.01 rows=1 width=66) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.furlough_status_id::text = toms_hub.lkp_fms_furlough_status.furlough_status_id::text
  • Rows out: Avg 155.6 rows x 304 workers. Max 194 rows (seg67) with 348 ms to first row, 360 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg67) Hash chain length 1.0 avg, 1 max, using 3 of 65536 buckets.
24. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=2 width=62) (actual rows= loops=)

  • Hash Cond: toms_hub.fms_furlough_dtls.gpload_version_id = (max((max(toms_hub.fms_furlough_dtls.gpload_version_id))))
  • Rows out: Avg 209.6 rows x 304 workers. Max 253 rows (seg282) with 9.019 ms to first row, 18 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg282) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
25. 0.000 0.000 ↓ 0.0

Table Scan on fms_furlough_dtls (cost=0.00..431.00 rows=2 width=66) (actual rows= loops=)

  • Filter: to_char(to_date(furlough_date::text, 'Mon dd yyyy'::text)::timestamp with time zone, 'yyyy'::text) = '2020'::text
  • Rows out: Avg 1666.9 rows x 304 workers. Max 2016 rows (seg282) with 2.487 ms to first row, 16 ms to end.
26. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.027 ms to end, start offset by 2330 ms.
27. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 0.020 ms to end.
28. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 341 ms to end.
29. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.032 ms to first row, 341 ms to end.
30. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 2.373 ms to first row, 2.374 ms to end.
31. 0.000 0.000 ↓ 0.0

Table Scan on fms_furlough_dtls (cost=0.00..431.00 rows=5 width=4) (actual rows= loops=)

  • Rows out: Avg 7935.3 rows x 304 workers. Max 8616 rows (seg66) with 0.868 ms to first row, 3.097 ms to end.
32. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 3.0 rows x 304 workers. Max 3 rows (seg0) with 339 ms to end, start offset by 1991 ms.
33. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice8; segments: 304) (cost=0.00..862.00 rows=1 width=6) (actual rows= loops=)

  • Rows out: Avg 3.0 rows x 304 workers at destination. Max 3 rows (seg0) with 339 ms to end.
34. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (max((max(toms_hub.lkp_fms_furlough_status.gpload_version_id)))) = toms_hub.lkp_fms_furlough_status.gpload_version_id
  • Rows out: 3 rows (seg262) with 347 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg51).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg51). Workfile: (0 spilling)
  • (seg262) Hash chain length 3.0 avg, 3 max, using 1 of 32768 buckets.
35. 0.000 0.000 ↓ 0.0

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

  • Hash Key: (max((max(toms_hub.lkp_fms_furlough_status.gpload_version_id))))
  • Rows out: 1 rows at destination (seg262) with 1.021 ms to first row, 1.022 ms to end.
36. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 390 ms to end.
37. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.021 ms to first row, 390 ms to end.
38. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.748 ms to end.
39. 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=)

  • Rows out: Avg 9.0 rows x 5 workers. Max 9 rows (seg138) with 0.565 ms to first row, 0.574 ms to end.
40. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 3.0 rows x 9 workers. Max 3 rows (seg51) with 118 ms to end, start offset by 2206 ms.
41. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.lkp_fms_furlough_status.gpload_version_id
  • Rows out: Avg 3.0 rows x 9 workers at destination. Max 3 rows (seg51) with 0.076 ms to first row, 118 ms to end.
42. 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[])
  • Rows out: Avg 9.0 rows x 3 workers. Max 9 rows (seg140) with 0.660 ms to first row, 0.677 ms to end.
43. 0.000 0.000 ↓ 0.0

Hash (cost=437.00..437.00 rows=1 width=19) (actual rows= loops=)

  • Rows in: 0 rows with 1045 ms to end, start offset by 2018 ms.
44. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..437.00 rows=1 width=19) (actual rows= loops=)

  • Hash Cond: dim_resource.gpload_version_id = cfg_gpload_version_ctrl.curr_version_id
  • Rows out: 0 rows with 1045 ms to end.
  • Executor memory: 1K bytes.
  • Work_mem used: 1K bytes. Workfile: (0 spilling)
45. 0.000 0.000 ↓ 0.0

Gather Motion 304:1 (slice11; segments: 304) (cost=0.00..431.00 rows=17 width=23) (actual rows= loops=)

  • Rows out: 651,485 rows at destination with 0.065 ms to first row, 153 ms to end.
46. 0.000 0.000 ↓ 0.0

Table Scan on dim_resource (cost=0.00..431.00 rows=1 width=23) (actual rows= loops=)

  • Filter: resource_rec_type = 'E'::bpchar
  • Rows out: Avg 2143.0 rows x 304 workers. Max 2203 rows (seg264) with 1.678 ms to first row, 2.525 ms to end.
47. 0.000 0.000 ↓ 0.0

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

  • Rows in: 1 rows with 301 ms to end, start offset by 2019 ms.
48. 0.000 0.000 ↓ 0.0

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

  • Assert Cond: (row_number()) = 1
  • Rows out: 1 rows with 295 ms to first row, 301 ms to end.
  • Executor memory: 1K bytes.
49. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 295 ms to first row, 301 ms to end.
50. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows at destination with 295 ms to first row, 301 ms to end.
51. 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
  • Rows out: 1 rows (seg231) with 0.048 ms to first row, 0.049 ms to end.
52. 0.000 0.000 ↓ 0.0

Hash (cost=862.00..862.00 rows=1 width=10) (actual rows= loops=)

  • Rows in: Avg 6941.0 rows x 304 workers. Max 6941 rows (seg0) with 62 ms to end, start offset by 2416 ms.
53. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 6941.0 rows x 304 workers at destination. Max 6941 rows (seg0) with 0.131 ms to first row, 60 ms to end.
54. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (max((max(toms_hub.lkp_pt_vendor.gpload_version_id)))) = toms_hub.lkp_pt_vendor.gpload_version_id
  • Rows out: 6,941 rows (seg97) with 332 ms to first row, 334 ms to end.
  • Executor memory: 272K bytes avg, 272K bytes max (seg51).
  • Work_mem used: 272K bytes avg, 272K bytes max (seg51). Workfile: (0 spilling)
  • (seg97) Hash chain length 6941.0 avg, 6941 max, using 1 of 32768 buckets.
55. 0.000 0.000 ↓ 0.0

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

  • Hash Key: (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
  • Rows out: 1 rows at destination (seg97) with 1.092 ms to first row, 1.093 ms to end.
56. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 386 ms to end.
57. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.019 ms to first row, 386 ms to end.
58. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.773 ms to first row, 0.774 ms to end.
59. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 182.7 rows x 304 workers. Max 280 rows (seg2) with 0.607 ms to first row, 0.649 ms to end.
60. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 6941.0 rows x 8 workers. Max 6941 rows (seg51) with 336 ms to end, start offset by 1989 ms.
61. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.lkp_pt_vendor.gpload_version_id
  • Rows out: Avg 6941.0 rows x 8 workers at destination. Max 6941 rows (seg51) with 0.036 ms to first row, 334 ms to end.
62. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.00 rows=1 width=14) (actual rows= loops=)

  • Rows out: Avg 182.7 rows x 304 workers. Max 280 rows (seg2) with 0.956 ms to first row, 1.068 ms to end.
63. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 210.0 rows x 304 workers. Max 210 rows (seg0) with 0.334 ms to end, start offset by 2416 ms.
64. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 210.0 rows x 304 workers at destination. Max 210 rows (seg0) with 0.241 ms to first row, 0.289 ms to end.
65. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (max((max(toms_hub.fms_vendor_rules.gpload_version_id)))) = toms_hub.fms_vendor_rules.gpload_version_id
  • Rows out: 210 rows (seg262) with 313 ms to end.
  • Executor memory: 10K bytes avg, 10K bytes max (seg51).
  • Work_mem used: 10K bytes avg, 10K bytes max (seg51). Workfile: (0 spilling)
  • (seg262) Hash chain length 210.0 avg, 210 max, using 1 of 32768 buckets.
66. 0.000 0.000 ↓ 0.0

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

  • Hash Key: (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
  • Rows out: 1 rows at destination (seg262) with 143 ms to end.
67. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 386 ms to end.
68. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.021 ms to first row, 386 ms to end.
69. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.868 ms to first row, 0.869 ms to end.
70. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 12.4 rows x 152 workers. Max 36 rows (seg31) with 0.627 ms to first row, 0.639 ms to end.
71. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 210.0 rows x 9 workers. Max 210 rows (seg51) with 156 ms to end, start offset by 2019 ms.
72. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.fms_vendor_rules.gpload_version_id
  • Rows out: Avg 210.0 rows x 9 workers at destination. Max 210 rows (seg51) with 0.027 ms to first row, 156 ms to end.
73. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 12.4 rows x 152 workers. Max 36 rows (seg31) with 0.890 ms to first row, 0.908 ms to end.
74. 0.000 0.000 ↓ 0.0

Hash (cost=862.00..862.00 rows=1 width=10) (actual rows= loops=)

  • Rows in: Avg 6941.0 rows x 304 workers. Max 6941 rows (seg0) with 158 ms to end, start offset by 2258 ms.
75. 0.000 0.000 ↓ 0.0

Broadcast Motion 304:304 (slice25; segments: 304) (cost=0.00..862.00 rows=1 width=10) (actual rows= loops=)

  • Rows out: Avg 6941.0 rows x 304 workers at destination. Max 6941 rows (seg0) with 0.127 ms to first row, 156 ms to end.
76. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (max((max(toms_hub.lkp_pt_vendor.gpload_version_id)))) = toms_hub.lkp_pt_vendor.gpload_version_id
  • Rows out: 6,941 rows (seg97) with 6.605 ms to first row, 9.293 ms to end.
  • Executor memory: 272K bytes avg, 272K bytes max (seg51).
  • Work_mem used: 272K bytes avg, 272K bytes max (seg51). Workfile: (0 spilling)
  • (seg97) Hash chain length 6941.0 avg, 6941 max, using 1 of 32768 buckets.
77. 0.000 0.000 ↓ 0.0

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

  • Hash Key: (max((max(toms_hub.lkp_pt_vendor.gpload_version_id))))
  • Rows out: 1 rows at destination (seg97) with 0.023 ms to first row, 0.024 ms to end.
78. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 231 ms to end.
79. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.018 ms to first row, 231 ms to end.
80. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.810 ms to end.
81. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 182.7 rows x 304 workers. Max 280 rows (seg2) with 0.757 ms to first row, 0.807 ms to end.
82. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 6941.0 rows x 8 workers. Max 6941 rows (seg51) with 4.451 ms to end, start offset by 2227 ms.
83. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.lkp_pt_vendor.gpload_version_id
  • Rows out: Avg 6941.0 rows x 8 workers at destination. Max 6941 rows (seg51) with 0.046 ms to first row, 2.711 ms to end.
84. 0.000 0.000 ↓ 0.0

Table Scan on lkp_pt_vendor (cost=0.00..431.00 rows=1 width=14) (actual rows= loops=)

  • Rows out: Avg 182.7 rows x 304 workers. Max 280 rows (seg2) with 0.763 ms to first row, 0.822 ms to end.
85. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 210.0 rows x 304 workers. Max 210 rows (seg0) with 224 ms to end, start offset by 2033 ms.
86. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 210.0 rows x 304 workers at destination. Max 210 rows (seg0) with 224 ms to end.
87. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (max((max(toms_hub.fms_vendor_rules.gpload_version_id)))) = toms_hub.fms_vendor_rules.gpload_version_id
  • Rows out: 210 rows (seg262) with 51 ms to end.
  • Executor memory: 10K bytes avg, 10K bytes max (seg51).
  • Work_mem used: 10K bytes avg, 10K bytes max (seg51). Workfile: (0 spilling)
  • (seg262) Hash chain length 210.0 avg, 210 max, using 1 of 32768 buckets.
88. 0.000 0.000 ↓ 0.0

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

  • Hash Key: (max((max(toms_hub.fms_vendor_rules.gpload_version_id))))
  • Rows out: 1 rows at destination (seg262) with 0.034 ms to end.
89. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 275 ms to end.
90. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.031 ms to first row, 275 ms to end.
91. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 0.779 ms to end.
92. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 12.4 rows x 152 workers. Max 36 rows (seg31) with 0.698 ms to first row, 0.715 ms to end.
93. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 210.0 rows x 9 workers. Max 210 rows (seg51) with 35 ms to end, start offset by 2214 ms.
94. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.fms_vendor_rules.gpload_version_id
  • Rows out: Avg 210.0 rows x 9 workers at destination. Max 210 rows (seg51) with 0.031 ms to first row, 35 ms to end.
95. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 12.4 rows x 152 workers. Max 36 rows (seg31) with 0.695 ms to first row, 0.710 ms to end.
96. 0.000 0.000 ↓ 0.0

Hash (cost=4,310.54..4,310.54 rows=133 width=21) (actual rows= loops=)

  • Rows in: Avg 446.1 rows x 304 workers. Max 600 rows (seg27) with 604 ms to end, start offset by 1767 ms.
97. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice46; segments: 304) (cost=0.00..4,310.54 rows=133 width=21) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.ms_id
  • Rows out: Avg 446.1 rows x 304 workers at destination. Max 600 rows (seg27) with 577 ms to first row, 603 ms to end.
98. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,310.53 rows=133 width=21) (actual rows= loops=)

  • Rows out: Avg 446.1 rows x 304 workers. Max 513 rows (seg296) with 278 ms to first row, 281 ms to end.
99. 0.000 0.000 ↓ 0.0

Result (cost=0.00..4,310.53 rows=133 width=21) (actual rows= loops=)

  • Rows out: Avg 446.1 rows x 304 workers. Max 513 rows (seg296) with 278 ms to first row, 280 ms to end.
100. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..4,310.53 rows=1,987 width=29) (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
  • Rows out: Avg 446.1 rows x 304 workers. Max 513 rows (seg296) with 277 ms to first row, 280 ms to end.
  • Executor memory: 20K bytes avg, 22K bytes max (seg296).
  • Work_mem used: 20K bytes avg, 22K bytes max (seg296). Workfile: (0 spilling)
  • (seg296) Hash chain length 1.0 avg, 2 max, using 576 of 32768 buckets.
101. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice43; segments: 304) (cost=0.00..3,448.24 rows=108 width=23) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_fact_key
  • Rows out: Avg 529.5 rows x 304 workers at destination. Max 598 rows (seg56) with 54 ms to first row, 56 ms to end.
102. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,448.23 rows=108 width=23) (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
  • Rows out: Avg 529.5 rows x 304 workers. Max 686 rows (seg199) with 309 ms to first row, 318 ms to end.
  • Executor memory: 9K bytes avg, 9K bytes max (seg188).
  • Work_mem used: 9K bytes avg, 9K bytes max (seg188). Workfile: (0 spilling)
  • (seg199) Hash chain length 1.0 avg, 2 max, using 344 of 65536 buckets.
103. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice40; segments: 304) (cost=0.00..2,586.21 rows=32 width=27) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_dim_key
  • Rows out: Avg 529.5 rows x 304 workers at destination. Max 686 rows (seg199) with 10 ms to first row, 18 ms to end.
104. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,586.20 rows=32 width=27) (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
  • Rows out: Avg 529.5 rows x 304 workers. Max 716 rows (seg155) with 298 ms to first row, 300 ms to end.
  • Executor memory: 4K bytes avg, 5K bytes max (seg155).
  • Work_mem used: 4K bytes avg, 5K bytes max (seg155). Workfile: (0 spilling)
  • (seg155) Hash chain length 1.0 avg, 2 max, using 131 of 65536 buckets.
105. 0.000 0.000 ↓ 0.0

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

  • Hash Key: toms_hub.secured_fact_resource_fg_status.ms_id
  • Rows out: Avg 1190.9 rows x 304 workers at destination. Max 1425 rows (seg181) with 0.022 ms to first row, 0.717 ms to end.
106. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.02 rows=33 width=23) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.gpload_version_id = (max((max(toms_hub.secured_fact_resource_fg_status.gpload_version_id))))
  • Rows out: Avg 1190.9 rows x 304 workers. Max 1253 rows (seg11) with 291 ms to first row, 294 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg11) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
107. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.00 rows=33 width=27) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-07-01'::date
  • Rows out: Avg 36897.8 rows x 304 workers. Max 38831 rows (seg223) with 2.288 ms to first row, 16 ms to end.
108. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 269 ms to end, start offset by 1927 ms.
109. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 269 ms to end.
110. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 264 ms to end.
111. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.030 ms to first row, 263 ms to end.
112. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 15 ms to end.
113. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.00 rows=33 width=4) (actual rows= loops=)

  • Rows out: Avg 39736.1 rows x 304 workers. Max 41992 rows (seg11) with 1.017 ms to first row, 9.812 ms to end.
114. 0.000 0.000 ↓ 0.0

Hash (cost=1,724.16..1,724.16 rows=33 width=9) (actual rows= loops=)

  • Rows in: Avg 104.3 rows x 304 workers. Max 132 rows (seg155) with 297 ms to end, start offset by 2030 ms.
115. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,724.16 rows=33 width=9) (actual rows= loops=)

  • Group By: toms_hub.secured_fact_resource_fg_status.ms_id
  • Rows out: Avg 104.3 rows x 304 workers. Max 132 rows (seg155) with 297 ms to end.
  • Executor memory: 89K bytes avg, 89K bytes max (seg0).
  • (seg155) Hash chain length 4.1 avg, 9 max, using 32 of 32 buckets; total 0 expansions.
116. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice39; segments: 304) (cost=0.00..1,724.16 rows=33 width=9) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.ms_id
  • Rows out: Avg 365.7 rows x 304 workers at destination. Max 492 rows (seg27) with 281 ms to first row, 300 ms to end.
117. 0.000 0.000 ↓ 0.0

Result (cost=0.00..1,724.16 rows=33 width=9) (actual rows= loops=)

  • Rows out: Avg 365.7 rows x 304 workers. Max 421 rows (seg296) with 25 ms to end.
118. 0.000 0.000 ↓ 0.0

HashAggregate (cost=0.00..1,724.16 rows=33 width=9) (actual rows= loops=)

  • Group By: toms_hub.secured_fact_resource_fg_status.ms_id
  • Rows out: Avg 365.7 rows x 304 workers. Max 421 rows (seg296) with 25 ms to end.
  • Executor memory: 89K bytes avg, 89K bytes max (seg0).
  • (seg296) Hash chain length 3.4 avg, 9 max, using 123 of 128 buckets; total 2 expansions.
119. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,724.09 rows=594 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
  • Rows out: Avg 446.1 rows x 304 workers. Max 513 rows (seg296) with 13 ms to first row, 25 ms to end.
  • Executor memory: 13K bytes avg, 14K bytes max (seg296).
  • Work_mem used: 13K bytes avg, 14K bytes max (seg296). Workfile: (0 spilling)
  • (seg296) Hash chain length 1.0 avg, 2 max, using 580 of 65536 buckets.
120. 0.000 0.000 ↓ 0.0

Redistribute Motion 304:304 (slice36; segments: 304) (cost=0.00..862.02 rows=33 width=13) (actual rows= loops=)

  • Hash Key: toms_hub.secured_fact_resource_fg_status.work_order_fact_key
  • Rows out: Avg 1190.9 rows x 304 workers at destination. Max 1274 rows (seg227) with 0.059 ms to first row, 18 ms to end.
121. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.02 rows=33 width=13) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_resource_fg_status.gpload_version_id = (max((max(toms_hub.secured_fact_resource_fg_status.gpload_version_id))))
  • Rows out: Avg 1190.9 rows x 304 workers. Max 1253 rows (seg11) with 343 ms to first row, 347 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg11) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
122. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.00 rows=33 width=17) (actual rows= loops=)

  • Filter: business_eff_start_dt <= '2020-07-01'::date
  • Rows out: Avg 36897.8 rows x 304 workers. Max 38831 rows (seg223) with 1.666 ms to first row, 12 ms to end.
123. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 317 ms to end, start offset by 1938 ms.
124. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 317 ms to end.
125. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 318 ms to end.
126. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.030 ms to first row, 318 ms to end.
127. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 20 ms to end.
128. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_resource_fg_status (cost=0.00..431.00 rows=33 width=4) (actual rows= loops=)

  • Rows out: Avg 39736.1 rows x 304 workers. Max 41992 rows (seg11) with 1.127 ms to first row, 10 ms to end.
129. 0.000 0.000 ↓ 0.0

Hash (cost=862.03..862.03 rows=9 width=4) (actual rows= loops=)

  • Rows in: Avg 524.0 rows x 304 workers. Max 582 rows (seg296) with 13 ms to end, start offset by 2284 ms.
130. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.03 rows=9 width=4) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_work_order.gpload_version_id = (max((max(toms_hub.secured_fact_work_order.gpload_version_id))))
  • Rows out: Avg 524.0 rows x 304 workers. Max 582 rows (seg296) with 11 ms to first row, 13 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg296) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
131. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..431.02 rows=9 width=8) (actual rows= loops=)

  • Filter: NOT bill_rate IS NULL
  • Rows out: Avg 15705.6 rows x 304 workers. Max 17460 rows (seg296) with 1.275 ms to first row, 9.765 ms to end.
132. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 281 ms to end, start offset by 1985 ms.
133. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 281 ms to end.
134. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 329 ms to end.
135. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.020 ms to first row, 329 ms to end.
136. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 17 ms to end.
137. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..431.01 rows=27 width=4) (actual rows= loops=)

  • Rows out: Avg 48961.4 rows x 304 workers. Max 50137 rows (seg112) with 1.305 ms to first row, 13 ms to end.
138. 0.000 0.000 ↓ 0.0

Hash (cost=862.01..862.01 rows=2 width=4) (actual rows= loops=)

  • Rows in: Avg 341.5 rows x 304 workers. Max 357 rows (seg188) with 256 ms to end, start offset by 2067 ms.
139. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.01 rows=2 width=4) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_dim_work_order.gpload_version_id = (max((max(toms_hub.secured_dim_work_order.gpload_version_id))))
  • Rows out: Avg 341.5 rows x 304 workers. Max 357 rows (seg188) with 256 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg188) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
140. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_work_order (cost=0.00..431.00 rows=2 width=8) (actual rows= loops=)

  • Rows out: Avg 10239.2 rows x 304 workers. Max 10689 rows (seg188) with 2.270 ms to first row, 5.783 ms to end.
141. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 301 ms to end, start offset by 2015 ms.
142. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 301 ms to end.
143. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 382 ms to end.
144. 0.000 0.000 ↓ 0.0

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

  • Rows out: 304 rows at destination with 0.021 ms to first row, 382 ms to end.
145. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 5.543 ms to first row, 5.544 ms to end.
146. 0.000 0.000 ↓ 0.0

Table Scan on secured_dim_work_order (cost=0.00..431.00 rows=2 width=4) (actual rows= loops=)

  • Rows out: Avg 10239.2 rows x 304 workers. Max 10689 rows (seg188) with 0.832 ms to first row, 2.139 ms to end.
147. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 524.0 rows x 304 workers. Max 582 rows (seg296) with 225 ms to end, start offset by 2061 ms.
148. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..862.03 rows=9 width=14) (actual rows= loops=)

  • Hash Cond: toms_hub.secured_fact_work_order.gpload_version_id = (max((max(toms_hub.secured_fact_work_order.gpload_version_id))))
  • Rows out: Avg 524.0 rows x 304 workers. Max 582 rows (seg296) with 224 ms to first row, 225 ms to end.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg296) Hash chain length 1.0 avg, 1 max, using 1 of 65536 buckets.
149. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..431.02 rows=9 width=18) (actual rows= loops=)

  • Filter: NOT bill_rate IS NULL
  • Rows out: Avg 15705.6 rows x 304 workers. Max 17460 rows (seg296) with 2.231 ms to first row, 19 ms to end.
150. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 239 ms to end, start offset by 2023 ms.
151. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers at destination. Max 1 rows (seg0) with 239 ms to end.
152. 0.000 0.000 ↓ 0.0

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

  • Rows out: 1 rows with 327 ms to end.
153. 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=)

  • Rows out: 304 rows at destination with 0.018 ms to first row, 327 ms to end.
154. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 304 workers. Max 1 rows (seg0) with 27 ms to end.
155. 0.000 0.000 ↓ 0.0

Table Scan on secured_fact_work_order (cost=0.00..431.01 rows=27 width=4) (actual rows= loops=)

  • Rows out: Avg 48961.4 rows x 304 workers. Max 50137 rows (seg112) with 0.987 ms to first row, 12 ms to end.Slice statistics:
Total runtime : 3,102.263 ms