explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UKAn : Optimization for: plan #bUBJ

Settings

Optimization path:

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

Subquery Scan all_claims (cost=2,662,856,920.040..2,673,133,093.470 rows=29,466 width=5,760) (actual rows= loops=)

  • Filter: xray_romeo::numeric = 1::numeric
  • Rows out: 3185211 rows with 782940 ms to first row, 2182303 ms to end, start offset by 41936 ms.
  • Slice statistics:
  • (slice0) Executor memory: 525672K bytes.
  • (slice1) Executor memory: 55265K bytes avg x 108 workers, 55265K bytes max (seg0). Work_mem: 44025K bytes max.
  • (slice2) Executor memory: 12424K bytes avg x 108 workers, 12450K bytes max (seg1).
  • (slice3) Executor memory: 12547K bytes avg x 108 workers, 12651K bytes max (seg0).
  • (slice4) Executor memory: 11566K bytes avg x 108 workers, 11574K bytes max (seg0). Work_mem: 145K bytes max.
  • (slice5) Executor memory: 10302K bytes avg x 108 workers, 10308K bytes max (seg2).
  • (slice6) Executor memory: 14106K bytes avg x 108 workers, 14136K bytes max (seg28). Work_mem: 150K bytes max.
  • (slice7) Executor memory: 10294K bytes (seg55).
  • (slice8) Executor memory: 88847K bytes avg x 108 workers, 89023K bytes max (seg3). Work_mem: 35833K bytes max.
  • (slice9) Executor memory: 11093K bytes avg x 108 workers, 11181K bytes max (seg1).
  • (slice10) Executor memory: 10480K bytes avg x 108 workers, 10557K bytes max (seg23).
  • (slice11) Executor memory: 17636K bytes avg x 108 workers, 17684K bytes max (seg0). Work_mem: 2509K bytes max.
  • (slice12) Executor memory: 21118K bytes avg x 108 workers, 21118K bytes max (seg0). Work_mem: 9721K bytes max.
  • (slice13) Executor memory: 20566K bytes avg x 108 workers, 20764K bytes max (seg16). Work_mem: 4223K bytes max.
  • (slice14) Executor memory: 40752K bytes avg x 108 workers, 40772K bytes max (seg3). Work_mem: 17913K bytes max.
  • (slice15) Executor memory: 29403K bytes avg x 108 workers, 29407K bytes max (seg0). Work_mem: 17913K bytes max.
  • (slice16) Executor memory: 55314K bytes avg x 108 workers, 55314K bytes max (seg0). Work_mem: 44025K bytes max.
  • (slice17) Executor memory: 12481K bytes avg x 108 workers, 12507K bytes max (seg1).
  • (slice18) Executor memory: 12612K bytes avg x 108 workers, 12716K bytes max (seg0).
  • (slice19) Executor memory: 11639K bytes avg x 108 workers, 11647K bytes max (seg0). Work_mem: 145K bytes max.
  • (slice20) Executor memory: 10382K bytes avg x 108 workers, 10390K bytes max (seg0).
  • (slice21) Executor memory: 14196K bytes avg x 108 workers, 14225K bytes max (seg28). Work_mem: 150K bytes max.
  • (slice22) Executor memory: 10391K bytes (seg55).
  • (slice23) Executor memory: 88951K bytes avg x 108 workers, 89120K bytes max (seg7). Work_mem: 35833K bytes max.
  • (slice24) Executor memory: 11191K bytes avg x 108 workers, 11294K bytes max (seg1).
  • (slice25) Executor memory: 10601K bytes avg x 108 workers, 10679K bytes max (seg23).
  • (slice26) Executor memory: 17759K bytes avg x 108 workers, 17806K bytes max (seg0). Work_mem: 2509K bytes max.
  • (slice27) Executor memory: 21240K bytes avg x 108 workers, 21240K bytes max (seg0). Work_mem: 9721K bytes max.
  • (slice28) Executor memory: 20637K bytes avg x 108 workers, 20885K bytes max (seg39). Work_mem: 4223K bytes max.
  • (slice29) Executor memory: 40874K bytes avg x 108 workers, 40894K bytes max (seg3). Work_mem: 17913K bytes max.
  • (slice30) Executor memory: 29483K bytes avg x 108 workers, 29528K bytes max (seg0). Work_mem: 17913K bytes max.
  • (slice31) Executor memory: 43592K bytes avg x 108 workers, 43874K bytes max (seg7). Work_mem: 2759K bytes max.
  • (slice32) Executor memory: 28591K bytes avg x 108 workers, 28788K bytes max (seg1).
  • (slice33) Executor memory: 11255K bytes avg x 108 workers, 11359K bytes max (seg2).
  • (slice34) Executor memory: 131328K bytes avg x 108 workers, 131330K bytes max (seg2). Work_mem: 77817K bytes max.
  • (slice35) * Executor memory: 1216658K bytes avg x 108 workers, 1236990K bytes max (seg65). Work_mem: 479225K bytes max, 468855K bytes wanted.
  • (slice36) Executor memory: 1382998K bytes avg x 108 workers, 1390599K bytes max (seg5). Work_mem: 471033K bytes max.
  • Statement statistics:
  • Memory used: 2046976K bytes
  • Memory wanted: 39397736K bytes
  • Optimizer status: legacy query optimizer
  • Total runtime: 2224788.199 ms
2. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=2,662,856,920.040..2,673,133,093.470 rows=29,465,731 width=5,168) (actual rows= loops=)

  • Rows out: 44646595 rows with 782940 ms to first row, 2161768 ms to end, start offset by 41936 ms.
3. 0.000 0.000 ↓ 0.0

Window (cost=2,662,856,920.040..2,663,593,563.290 rows=29,465,731 width=5,168) (actual rows= loops=)

  • Order By: coplan.unnamed_attr_97
  • Rows out: 44646595 rows with 782940 ms to first row, 1021126 ms to end, start offset by 41936 ms.
4. 0.000 0.000 ↓ 0.0

Gather Motion 108:1 (slice36; segments: 108) (cost=2,662,856,920.040..2,663,519,898.970 rows=29,465,731 width=5,168) (actual rows= loops=)

  • Merge Key: coplan.unnamed_attr_97
  • Rows out: 44646595 rows at destination with 189701 ms to first row, 682443 ms to end, start offset by 41936 ms.
5. 0.000 0.000 ↓ 0.0

Sort (cost=2,662,856,920.040..2,662,930,584.360 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.uniform_romeo97
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 184965 ms to first row, 185391 ms to end, start offset by 42045 ms.
  • Executor memory: 436217K bytes avg, 438265K bytes max (seg0).
  • Work_mem used: 436217K bytes avg, 438265K bytes max (seg0). Workfile: (0 spilling)
6. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=2,418,244,274.990..2,418,759,925.270 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 174919 ms to first row, 180468 ms to end, start offset by 42046 ms.
7. 0.000 0.000 ↓ 0.0

Window (cost=2,418,244,274.990..2,418,465,267.960 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number
  • Order By: coplan.transaction_created_date
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 174919 ms to first row, 180321 ms to end, start offset by 42046 ms.
8. 0.000 0.000 ↓ 0.0

Sort (cost=2,418,244,274.990..2,418,317,939.310 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.zulu_foxtrot
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 174919 ms to first row, 175281 ms to end, start offset by 42046 ms.
  • Executor memory: 468378K bytes avg, 471033K bytes max (seg0).
  • Work_mem used: 468378K bytes avg, 471033K bytes max (seg0). Workfile: (0 spilling)
9. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=2,173,557,965.610..2,174,147,280.210 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 165691 ms to first row, 170427 ms to end, start offset by 42046 ms.
10. 0.000 0.000 ↓ 0.0

Window (cost=2,173,557,965.610..2,173,852,622.910 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number
  • Order By: coplan.unnamed_attr_100, coplan.unnamed_attr_101
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 165691 ms to first row, 170289 ms to end, start offset by 42046 ms.
11. 0.000 0.000 ↓ 0.0

Sort (cost=2,173,557,965.610..2,173,631,629.930 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.uniform_romeo100, yankee_india.uniform_romeo101
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 165690 ms to first row, 166009 ms to end, start offset by 42046 ms.
  • Executor memory: 468378K bytes avg, 471033K bytes max (seg0).
  • Work_mem used: 468378K bytes avg, 471033K bytes max (seg0). Workfile: (0 spilling)
12. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=1,928,871,656.230..1,929,460,970.840 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 156504 ms to first row, 161363 ms to end, start offset by 42046 ms.
13. 0.000 0.000 ↓ 0.0

Window (cost=1,928,871,656.230..1,929,166,313.530 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number
  • Order By: coplan.unnamed_attr_98, coplan.unnamed_attr_99
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 156504 ms to first row, 161291 ms to end, start offset by 42046 ms.
14. 0.000 0.000 ↓ 0.0

Sort (cost=1,928,871,656.230..1,928,945,320.560 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.uniform_romeo98, yankee_india.uniform_romeo99
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 156503 ms to first row, 156763 ms to end, start offset by 42046 ms.
  • Executor memory: 468378K bytes avg, 471033K bytes max (seg0).
  • Work_mem used: 468378K bytes avg, 471033K bytes max (seg0). Workfile: (0 spilling)
15. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice35; segments: 108) (cost=1,683,596,032.250..1,684,774,661.460 rows=272,831 width=5,168) (actual rows= loops=)

  • Hash Key: coplan.claim_number
  • Rows out: Avg 413394.4 rows x 108 workers at destination. Max 419176 rows (seg107) with 125020 ms to first row, 147432 ms to end, start offset by 42046 ms.
16. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=1,683,596,032.250..1,684,185,346.850 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 133464 ms to first row, 139440 ms to end, start offset by 42221 ms.
17. 0.000 0.000 ↓ 0.0

Window (cost=1,683,596,032.250..1,683,890,689.550 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number, coplan.risk_code
  • Order By: coplan.unnamed_attr_106
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 133464 ms to first row, 139347 ms to end, start offset by 42221 ms.
18. 0.000 0.000 ↓ 0.0

Sort (cost=1,683,596,032.250..1,683,669,696.570 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.india_three, yankee_india.uniform_romeo106
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 133464 ms to first row, 133764 ms to end, start offset by 42221 ms.
  • Executor memory: 468833K bytes avg, 479225K bytes max (seg12).
  • Work_mem used: 468833K bytes avg, 479225K bytes max (seg12). Workfile: (0 spilling)
19. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=1,438,909,722.870..1,439,499,037.470 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 125847 ms to first row, 129692 ms to end, start offset by 42222 ms.
20. 0.000 0.000 ↓ 0.0

Window (cost=1,438,909,722.870..1,439,204,380.170 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number, coplan.risk_code
  • Order By: coplan.transaction_created_date
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 125847 ms to first row, 129600 ms to end, start offset by 42222 ms.
21. 0.000 0.000 ↓ 0.0

Sort (cost=1,438,909,722.870..1,438,983,387.190 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.india_three, yankee_india.zulu_foxtrot
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 125847 ms to first row, 126207 ms to end, start offset by 42222 ms.
  • Executor memory: 468833K bytes avg, 479225K bytes max (seg12).
  • Work_mem used: 468833K bytes avg, 479225K bytes max (seg12). Workfile: (0 spilling)
22. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=1,194,149,749.170..1,194,812,728.100 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 117115 ms to first row, 121608 ms to end, start offset by 42222 ms.
23. 0.000 0.000 ↓ 0.0

Window (cost=1,194,149,749.170..1,194,518,070.790 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number, coplan.risk_code
  • Order By: coplan.unnamed_attr_105, coplan.claimant_date_of_birth
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 117115 ms to first row, 121529 ms to end, start offset by 42222 ms.
24. 0.000 0.000 ↓ 0.0

Sort (cost=1,194,149,749.170..1,194,223,413.490 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.india_three, yankee_india.uniform_romeo105, yankee_india.oscar_quebec
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 117115 ms to first row, 117238 ms to end, start offset by 42222 ms.
  • Executor memory: 468757K bytes avg, 479225K bytes max (seg65).
  • Work_mem used: 468757K bytes avg, 479225K bytes max (seg65). Workfile: (0 spilling)
25. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=949,389,775.460..950,052,754.390 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 108395 ms to first row, 112895 ms to end, start offset by 42223 ms.
26. 0.000 0.000 ↓ 0.0

Window (cost=949,389,775.460..949,758,097.090 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number, coplan.risk_code
  • Order By: coplan.unnamed_attr_104, coplan.driver_date_of_birth
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 108395 ms to first row, 112807 ms to end, start offset by 42223 ms.
27. 0.000 0.000 ↓ 0.0

Sort (cost=949,389,775.460..949,463,439.790 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.india_three, yankee_india.uniform_romeo104, yankee_india.india_whiskey_xray
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 108394 ms to first row, 108807 ms to end, start offset by 42223 ms.
  • Executor memory: 468757K bytes avg, 479225K bytes max (seg65).
  • Work_mem used: 468757K bytes avg, 479225K bytes max (seg65). Workfile: (0 spilling)
28. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=704,703,466.080..705,292,780.690 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 99087 ms to first row, 103381 ms to end, start offset by 42223 ms.
29. 0.000 0.000 ↓ 0.0

Window (cost=704,703,466.080..704,998,123.390 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: coplan.claim_number, coplan.risk_code
  • Order By: coplan.unnamed_attr_103
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 99087 ms to first row, 102708 ms to end, start offset by 42223 ms.
30. 0.000 0.000 ↓ 0.0

Sort (cost=704,703,466.080..704,777,130.410 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: yankee_india.zulu_quebec, yankee_india.india_three, yankee_india.uniform_romeo103
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 99087 ms to first row, 99342 ms to end, start offset by 42223 ms.
  • Executor memory: 468757K bytes avg, 479225K bytes max (seg65).
  • Work_mem used: 468757K bytes avg, 479225K bytes max (seg65). Workfile: (0 spilling)
31. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=459,280,513.450..460,606,471.310 rows=272,831 width=5,168) (actual rows= loops=)

  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 88517 ms to first row, 94124 ms to end, start offset by 42223 ms.
32. 0.000 0.000 ↓ 0.0

Window (cost=459,280,513.450..460,311,814.010 rows=272,831 width=5,168) (actual rows= loops=)

  • Partition By: clm_trn_det.claim_number, exp_risk.risk_code
  • Order By: "?column102?
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 88517 ms to first row, 93993 ms to end, start offset by 42223 ms.
33. 0.000 0.000 ↓ 0.0

Sort (cost=459,280,513.450..459,354,177.780 rows=272,831 width=5,168) (actual rows= loops=)

  • Sort Key: oscar_uniform.zulu_quebec, two_alpha.india_three, "?victor_juliet102?
  • Rows out: Avg 413394.4 rows x 108 workers. Max 421158 rows (seg90) with 88517 ms to first row, 89862 ms to end, start offset by 42223 ms.
  • Executor memory: 300192K bytes avg, 300192K bytes max (seg0).
  • Work_mem used: 300192K bytes avg, 300192K bytes max (seg0). Workfile: (108 spilling)
  • Work_mem wanted: 460212K bytes avg, 468855K bytes max (seg90) to lessen workfile I/O affecting 108 workers.
34. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice34; segments: 108) (cost=192,935,545.970..215,183,518.680 rows=272,831 width=5,168) (actual rows= loops=)

  • Hash Key: clm_trn_det.claim_number, exp_risk.risk_code
  • Rows out: Avg 413394.4 rows x 108 workers at destination. Max 421158 rows (seg90) with 56352 ms to first row, 77380 ms to end, start offset by 42223 ms.
35. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=192,935,545.970..214,594,204.070 rows=272,831 width=5,168) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = sierra_juliet.zulu_quebec AND oscar_uniform.two_victor = sierra_juliet.two_victor
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 59253 ms to first row, 76816 ms to end, start offset by 42295 ms.
  • Executor memory: 3380K bytes avg, 3412K bytes max (seg86).
  • Work_mem used: 3380K bytes avg, 3412K bytes max (seg86). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.2 avg, 5 max, using 65759 of 262151 buckets.
36. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=192,603,480.500..213,083,315.740 rows=272,831 width=5,200) (actual rows= loops=)

  • Hash Cond: oscar_uniform.kilo_papa_quebec::text = "quebec_kilo".victor_juliet1
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 58809 ms to first row, 73875 ms to end, start offset by 42736 ms.
  • Executor memory: 4K bytes avg, 4K bytes max (seg0).
  • Work_mem used: 4K bytes avg, 4K bytes max (seg0). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.0 avg, 1 max, using 68 of 65539 buckets.
37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=192,603,478.800..212,709,983.240 rows=272,831 width=5,200) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = golf_juliet.zulu_quebec::text AND oscar_uniform.victor_bravo = golf_juliet.tango_three::text
  • Rows out: Avg 413394.4 rows x 108 workers. Max 419176 rows (seg107) with 58804 ms to first row, 72897 ms to end, start offset by 42740 ms.
  • Executor memory: 1968K bytes avg, 2012K bytes max (seg4).
  • Work_mem used: 1968K bytes avg, 2012K bytes max (seg4). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.1 avg, 4 max, using 9478 of 65539 buckets.
38. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=192,471,803.900..212,136,169.450 rows=272,831 width=5,074) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = india_bravo.zulu_quebec::text AND two_alpha.india_three = india_bravo.india_three
  • Rows out: Avg 413391.1 rows x 108 workers. Max 419176 rows (seg107) with 57837 ms to first row, 70955 ms to end, start offset by 43706 ms.
  • Executor memory: 6238K bytes avg, 6330K bytes max (seg7).
  • Work_mem used: 6238K bytes avg, 6330K bytes max (seg7). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.2 avg, 6 max, using 23978 of 65539 buckets.
39. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=112,705,508.450..131,780,559.400 rows=272,831 width=4,466) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = seven_three.zulu_quebec AND oscar_uniform.victor_bravo = seven_three.tango_seven
  • Rows out: Avg 413391.1 rows x 108 workers. Max 419176 rows (seg107) with 10731 ms to first row, 22262 ms to end, start offset by 90811 ms.
  • Executor memory: 2716K bytes avg, 2751K bytes max (seg67).
  • Work_mem used: 2716K bytes avg, 2751K bytes max (seg67). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.1 avg, 6 max, using 29957 of 131111 buckets.
40. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=112,391,655.930..131,024,562.410 rows=272,831 width=4,439) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = zulu_six.zulu_quebec::text
  • Rows out: Avg 413387.3 rows x 108 workers. Max 419176 rows (seg107) with 10459 ms to first row, 21030 ms to end, start offset by 91083 ms.
  • Executor memory: 1399K bytes avg, 1419K bytes max (seg39).
  • Work_mem used: 1399K bytes avg, 1419K bytes max (seg39). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.5 avg, 7 max, using 19363 of 32779 buckets.
41. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59,406,095.440..77,597,015.960 rows=272,831 width=4,343) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = two_alpha.zulu_quebec::text AND oscar_uniform.victor_bravo = two_alpha.victor_bravo
  • Join Filter: oscar_uniform.two_victor = two_alpha.two_victor OR (oscar_uniform.two_victor five_romeo_foxtrot NULL AND two_alpha.quebec_zulu = 'uniform_five'::text)
  • Rows out: Avg 413387.3 rows x 108 workers. Max 419176 rows (seg107) with 239 ms to first row, 9927 ms to end, start offset by 101302 ms.
  • Executor memory: 5138K bytes avg, 5210K bytes max (seg39).
  • Work_mem used: 5138K bytes avg, 5210K bytes max (seg39). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.7 avg, 11 max, using 23709 of 65539 buckets.
42. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..16,433,018.920 rows=272,831 width=380) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('oscar_tango'::text[])) AND (four_tango = ANY ('alpha'::text[])) AND (xray_echo::text = ANY ('mike_three'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 412991.4 rows x 108 workers. Max 418781 rows (seg107) with 174 ms to first row, 8084 ms to end, start offset by 101367 ms.
43. 0.000 0.000 ↓ 0.0

Hash (cost=59,339,106.650..59,339,106.650 rows=41,352 width=424) (actual rows= loops=)

  • Rows in: Avg 38689.8 rows x 108 workers. Max 39233 rows (seg39) with 56 ms to end, start offset by 100021 ms.
44. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice15; segments: 108) (cost=59,048,821.920..59,339,106.650 rows=41,352 width=424) (actual rows= loops=)

  • Hash Key: exp_risk.claim_number::text
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 39233 rows (seg39) with 0.196 ms to first row, 29 ms to end, start offset by 100021 ms.
45. 0.000 0.000 ↓ 0.0

Subquery Scan exp_risk (cost=59,048,821.920..59,249,788.270 rows=41,352 width=424) (actual rows= loops=)

  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 26546 ms to first row, 26835 ms to end, start offset by 43088 ms.
46. 0.000 0.000 ↓ 0.0

Window (cost=59,048,821.920..59,205,129.080 rows=41,352 width=602) (actual rows= loops=)

  • Partition By: t.source_system, t.claim_id, t.claim_exposure_id
  • Order By: t.risk_proportion, t.risk_code
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 26546 ms to first row, 26824 ms to end, start offset by 43088 ms.
47. 0.000 0.000 ↓ 0.0

Sort (cost=59,048,821.920..59,059,986.720 rows=41,352 width=602) (actual rows= loops=)

  • Sort Key: romeo.victor_bravo, romeo.india_zulu, romeo.two_victor, romeo.tango_two, romeo.india_three
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 26545 ms to first row, 26557 ms to end, start offset by 43088 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
48. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice14; segments: 108) (cost=37,990,677.700..58,555,549.430 rows=41,352 width=602) (actual rows= loops=)

  • Hash Key: t.source_system, t.claim_id, t.claim_exposure_id
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 38974 rows (seg48) with 11779 ms to first row, 26417 ms to end, start offset by 43088 ms.
49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=37,990,677.700..58,466,231.050 rows=41,352 width=602) (actual rows= loops=)

  • Hash Cond: romeo.victor_bravo = lima_delta.victor_bravo AND romeo.zulu_quebec::text = lima_delta.zulu_quebec::text AND romeo.two_victor = lima_delta.two_victor
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39233 rows (seg39) with 12392 ms to first row, 26852 ms to end, start offset by 42392 ms.
  • Executor memory: 2115K bytes avg, 2145K bytes max (seg39).
  • Work_mem used: 2115K bytes avg, 2145K bytes max (seg39). Workfile: (0 spilling)
  • (seg39) Hash chain length 1.7 avg, 7 max, using 22826 of 32779 buckets.
50. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice13; segments: 108) (cost=20,919,049.050..41,316,368.060 rows=41,352 width=570) (actual rows= loops=)

  • Hash Key: t.claim_number::text
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 39233 rows (seg39) with 3545 ms to first row, 17915 ms to end, start offset by 51238 ms.
51. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,919,049.050..41,227,049.680 rows=41,352 width=570) (actual rows= loops=)

  • Hash Cond: romeo.victor_bravo = papa.victor_bravo AND romeo.india_zulu = papa.india_zulu AND romeo.two_victor::bigint = papa.two_victor
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38948 rows (seg100) with 12385 ms to first row, 27028 ms to end, start offset by 42199 ms.
  • Executor memory: 4200K bytes avg, 4223K bytes max (seg100).
  • Work_mem used: 4200K bytes avg, 4223K bytes max (seg100). Workfile: (0 spilling)
  • (seg100) Hash chain length 1.7 avg, 9 max, using 34155 of 65539 buckets.
52. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice8; segments: 108) (cost=18,865,756.350..39,095,326.480 rows=41,352 width=442) (actual rows= loops=)

  • Hash Key: t.claim_exposure_id::bigint, t.claim_id, t.source_system
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 38948 rows (seg100) with 6977 ms to first row, 21495 ms to end, start offset by 47606 ms.
53. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,865,756.350..39,006,008.100 rows=41,352 width=344) (actual rows= loops=)

  • Hash Cond: three_hotel.juliet_alpha_uniform2mike_seven = sierra_yankee.juliet_alpha_uniform2mike_seven
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39113 rows (seg41) with 12731 ms to first row, 22253 ms to end, start offset by 42331 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 1.0 avg, 1 max, using 16 of 65539 buckets.
54. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,865,717.110..38,813,621.730 rows=41,352 width=1,038) (actual rows= loops=)

  • Hash Cond: juliet_alpha_golf.victor_bravo = delta_romeo.victor_bravo AND juliet_alpha_golf.india_zulu = delta_romeo.india_zulu AND juliet_alpha_golf.two_victor = delta_romeo.two_victor::text
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39113 rows (seg41) with 12511 ms to first row, 21918 ms to end, start offset by 42550 ms.
  • Executor memory: 13896K bytes avg, 13896K bytes max (seg0).
  • Work_mem used: 13896K bytes avg, 13896K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 2.0 avg, 10 max, using 107852 of 131111 buckets.
55. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,024,901.140..37,536,279.910 rows=41,352 width=1,018) (actual rows= loops=)

  • Hash Cond: juliet_alpha_golf.victor_bravo = charlie_echo.victor_bravo AND juliet_alpha_golf.tango_echo::bigint = charlie_echo.tango_echo
  • Rows out: Avg 38672.5 rows x 108 workers. Max 39093 rows (seg41) with 10733 ms to first row, 19758 ms to end, start offset by 44328 ms.
  • Executor memory: 2232K bytes avg, 2232K bytes max (seg0).
  • Work_mem used: 2232K bytes avg, 2232K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 1.2 avg, 6 max, using 40348 of 131111 buckets.
56. 0.000 0.000 ↓ 0.0

Append (cost=17,451,364.290..36,742,072.840 rows=41,352 width=2,450) (actual rows= loops=)

  • Rows out: Avg 38672.5 rows x 108 workers. Max 39093 rows (seg41) with 10682 ms to first row, 19656 ms to end, start offset by 44379 ms.
57. 0.000 0.000 ↓ 0.0

Subquery Scan mv_claim_transaction_details_all (cost=17,451,364.290..17,713,422.170 rows=1 width=1,496) (actual rows= loops=)

  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 10682 ms to first row, 10842 ms to end, start offset by 44379 ms.
58. 0.000 0.000 ↓ 0.0

Unique (cost=17,451,364.290..17,713,422.120 rows=0 width=139) (actual rows= loops=)

  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 10681 ms to first row, 10763 ms to end, start offset by 44379 ms.
59. 0.000 0.000 ↓ 0.0

Sort (cost=17,451,364.290..17,468,834.810 rows=64,706 width=139) (actual rows= loops=)

  • Sort Key (Distinct): pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 10681 ms to first row, 10722 ms to end, start offset by 44379 ms.
  • Executor memory: 35833K bytes avg, 35833K bytes max (seg0).
  • Work_mem used: 35833K bytes avg, 35833K bytes max (seg0). Workfile: (0 spilling)
60. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice1; segments: 108) (cost=16,412,340.230..16,656,927.540 rows=64,706 width=139) (actual rows= loops=)

  • Hash Key: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 91062.5 rows x 108 workers at destination. Max 92244 rows (seg97) with 4345 ms to first row, 9183 ms to end, start offset by 44479 ms.
61. 0.000 0.000 ↓ 0.0

Window (cost=16,412,340.230..16,517,163.360 rows=64,706 width=139) (actual rows= loops=)

  • Partition By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.claim_exposure_id
  • Order By: pub.mv_claim_transaction_details_all.transaction_source, pub.mv_claim_transaction_details_all.transaction_date
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 7831 ms to first row, 8775 ms to end, start offset by 42061 ms.
62. 0.000 0.000 ↓ 0.0

Sort (cost=16,412,340.230..16,429,810.750 rows=64,706 width=139) (actual rows= loops=)

  • Sort Key: hotel_four.yankee_whiskey.victor_bravo, hotel_four.yankee_whiskey.zulu_quebec, hotel_four.yankee_whiskey.two_victor, hotel_four.yankee_whiskey.four_tango, hotel_four.yankee_whiskey.six
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 7831 ms to first row, 7878 ms to end, start offset by 42061 ms.
  • Executor memory: 44025K bytes avg, 44025K bytes max (seg0).
  • Work_mem used: 44025K bytes avg, 44025K bytes max (seg0). Workfile: (0 spilling)
63. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,617,903.480 rows=64,706 width=139) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (four_tango = ANY ('oscar_yankee'::text[])) AND (xray_echo::text = ANY ('mike_three'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 1032 ms to first row, 6216 ms to end, start offset by 42062 ms.
64. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=17,540,969.130..19,028,650.660 rows=41,352 width=2,450) (actual rows= loops=)

  • Rows out: Avg 80.6 rows x 108 workers. Max 100 rows (seg29) with 11586 ms to first row, 11624 ms to end, start offset by 55450 ms.
65. 0.000 0.000 ↓ 0.0

HashAggregate (cost=17,540,969.130..18,983,991.480 rows=41,352 width=998) (actual rows= loops=)

  • Filter: whiskey_three(hotel_four.yankee_whiskey.two_victor::integer) five_romeo_foxtrot NULL
  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number
  • Rows out: Avg 80.6 rows x 108 workers. Max 100 rows (seg29) with 11586 ms to first row, 11624 ms to end, start offset by 55450 ms.
  • Executor memory: 7483K bytes avg, 7565K bytes max (seg0).
66. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,210,345.760 rows=413,511 width=77) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (xray_echo::text = ANY ('charlie_uniform'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 465956.8 rows x 108 workers. Max 472454 rows (seg107) with 28 ms to first row, 3966 ms to end, start offset by 55676 ms.
67. 0.000 0.000 ↓ 0.0

Hash (cost=504,712.740..504,712.740 rows=42,485 width=60) (actual rows= loops=)

  • Rows in: Avg 47616.0 rows x 108 workers. Max 47616 rows (seg0) with 69 ms to end, start offset by 44349 ms.
68. 0.000 0.000 ↓ 0.0

Broadcast Motion 108:108 (slice4; segments: 108) (cost=457,449.280..504,712.740 rows=42,485 width=60) (actual rows= loops=)

  • Rows out: Avg 47616.0 rows x 108 workers at destination. Max 47616 rows (seg0) with 0.101 ms to first row, 47 ms to end, start offset by 44349 ms.
69. 0.000 0.000 ↓ 0.0

Subquery Scan landlords (cost=457,449.280..458,405.170 rows=394 width=80) (actual rows= loops=)

  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 1927 ms to first row, 1929 ms to end, start offset by 42279 ms.
70. 0.000 0.000 ↓ 0.0

Unique (cost=457,449.280..457,980.330 rows=394 width=14) (actual rows= loops=)

  • Group By: source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 1927 ms to first row, 1928 ms to end, start offset by 42279 ms.
71. 0.000 0.000 ↓ 0.0

Sort (cost=457,449.280..457,555.490 rows=394 width=14) (actual rows= loops=)

  • Sort Key (Distinct): source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 1927 ms to end, start offset by 42279 ms.
  • Executor memory: 137K bytes avg, 145K bytes max (seg0).
  • Work_mem used: 137K bytes avg, 145K bytes max (seg0). Workfile: (0 spilling)
72. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice3; segments: 108) (cost=0.000..454,183.400 rows=394 width=14) (actual rows= loops=)

  • Hash Key: source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers at destination. Max 495 rows (seg92) with 1906 ms to first row, 1926 ms to end, start offset by 42280 ms.
73. 0.000 0.000 ↓ 0.0

Append (cost=0.000..454,183.400 rows=394 width=14) (actual rows= loops=)

  • Rows out: Avg 440.9 rows x 108 workers. Max 501 rows (seg82) with 61 ms to first row, 1832 ms to end, start offset by 42357 ms.
74. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=0.000..91,280.930 rows=394 width=13) (actual rows= loops=)

  • Rows out: Avg 440.3 rows x 108 workers. Max 500 rows (seg82) with 61 ms to first row, 162 ms to end, start offset by 42357 ms.
75. 0.000 0.000 ↓ 0.0

Seq Scan on xray_juliet (cost=0.000..90,856.120 rows=394 width=13) (actual rows= loops=)

  • Filter: charlie_tango::text = ANY ('three_three'::text[])
  • Rows out: Avg 440.3 rows x 108 workers. Max 500 rows (seg82) with 61 ms to first row, 162 ms to end, start offset by 42357 ms.
76. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=362,902.390..362,902.460 rows=1 width=80) (actual rows= loops=)

  • Rows out: Avg 1.2 rows x 54 workers. Max 3 rows (seg19) with 1742 ms to first row, 1743 ms to end, start offset by 42442 ms.
77. 0.000 0.000 ↓ 0.0

HashAggregate (cost=362,902.390..362,902.430 rows=1 width=80) (actual rows= loops=)

  • Group By: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.2 rows x 54 workers. Max 3 rows (seg19) with 1742 ms to first row, 1743 ms to end, start offset by 42442 ms.
  • Executor memory: 2101K bytes avg, 2137K bytes max (seg0).
78. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice2; segments: 108) (cost=362,902.260..362,902.340 rows=1 width=48) (actual rows= loops=)

  • Hash Key: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.4 rows x 54 workers at destination. Max 4 rows (seg19) with 53 ms to first row, 1741 ms to end, start offset by 42444 ms.
79. 0.000 0.000 ↓ 0.0

HashAggregate (cost=362,902.260..362,902.280 rows=1 width=48) (actual rows= loops=)

  • Group By: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.4 rows x 56 workers. Max 4 rows (seg37) with 467 ms to end, start offset by 42418 ms.
  • Executor memory: 2102K bytes avg, 2137K bytes max (seg1).
80. 0.000 0.000 ↓ 0.0

Seq Scan on victor_november (cost=0.000..362,901.840 rows=1 width=13) (actual rows= loops=)

  • Filter: india_whiskey_five::text = 'mike_romeo'::text AND echo::text = 'whiskey_six'::text AND (golf_bravo::text = ANY ('three_india'::text[]))
  • Rows out: Avg 1.4 rows x 56 workers. Max 4 rows (seg37) with 453 ms to first row, 465 ms to end, start offset by 42419 ms.
81. 0.000 0.000 ↓ 0.0

Hash (cost=410,266.410..410,266.410 rows=227,804 width=68) (actual rows= loops=)

  • Rows in: Avg 220273.0 rows x 108 workers. Max 220273 rows (seg0) with 1816 ms to end, start offset by 42531 ms.
82. 0.000 0.000 ↓ 0.0

Broadcast Motion 108:108 (slice6; segments: 108) (cost=154,271.670..410,266.410 rows=227,804 width=68) (actual rows= loops=)

  • Rows out: Avg 220273.0 rows x 108 workers at destination. Max 220273 rows (seg0) with 972 ms to first row, 1459 ms to end, start offset by 42531 ms.
83. 0.000 0.000 ↓ 0.0

HashAggregate (cost=154,271.670..161,960.050 rows=2,110 width=76) (actual rows= loops=)

  • Filter: five_hotel(bravo.lima_five.kilo_echo) > 0::numeric
  • Group By: 'CC_PI'::text, e.claim_id, e.exposure_id, e.claim_order, CASE WHEN sor_cc_pi.ccx_coverageapportionment_ext.claimcentercover::text = ANY ('{"Portable Clothes and Luggage","Portable Sport and Recreational","Portable Electronic Devices","Portable Mobility Scooters","Portable Jewellery and Watches","Portable Glasses and Medical","Unspecified Portable Valuables"}'::text[]) THEN 'HE'::text ELSE NULL::text END::character(2)
  • Rows out: Avg 2039.6 rows x 108 workers. Max 2148 rows (seg85) with 1455 ms to first row, 1467 ms to end, start offset by 42056 ms.
  • Executor memory: 1275K bytes avg, 1289K bytes max (seg1).
84. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,768.710..150,285.080 rows=2,110 width=45) (actual rows= loops=)

  • Hash Cond: lima_delta.delta_five = bravo.lima_five.seven_delta
  • Rows out: Avg 2116.1 rows x 108 workers. Max 2221 rows (seg85) with 1412 ms to first row, 1451 ms to end, start offset by 42056 ms.
  • Executor memory: 143K bytes avg, 150K bytes max (seg51).
  • Work_mem used: 143K bytes avg, 150K bytes max (seg51). Workfile: (0 spilling)
  • (seg85) Hash chain length 1.0 avg, 3 max, using 2123 of 131111 buckets.
85. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot lima_delta (cost=0.000..123,674.600 rows=38,635 width=24) (actual rows= loops=)

  • Rows out: Avg 38603.0 rows x 108 workers. Max 38746 rows (seg30) with 0.118 ms to first row, 91 ms to end, start offset by 43459 ms.
86. 0.000 0.000 ↓ 0.0

Hash (cost=7,921.150..7,921.150 rows=2,110 width=29) (actual rows= loops=)

  • Rows in: Avg 2116.1 rows x 108 workers. Max 2221 rows (seg85) with 1397 ms to end, start offset by 42058 ms.
87. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice5; segments: 108) (cost=0.000..7,921.150 rows=2,110 width=29) (actual rows= loops=)

  • Hash Key: sor_cc_pi.ccx_coverageapportionment_ext.exposureid
  • Rows out: Avg 2116.1 rows x 108 workers at destination. Max 2221 rows (seg85) with 0.045 ms to first row, 1395 ms to end, start offset by 42058 ms.
88. 0.000 0.000 ↓ 0.0

Seq Scan on lima_five (cost=0.000..3,365.050 rows=2,110 width=29) (actual rows= loops=)

  • Rows out: Avg 2116.1 rows x 108 workers. Max 2193 rows (seg41) with 31 ms to first row, 54 ms to end, start offset by 42037 ms.
89. 0.000 0.000 ↓ 0.0

Hash (cost=17.640..17.640 rows=16 width=94) (actual rows= loops=)

  • Rows in: Avg 16.0 rows x 108 workers. Max 16 rows (seg0) with 203 ms to end, start offset by 42326 ms.
90. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:108 (slice7; segments: 1) (cost=0.000..17.640 rows=1,728 width=94) (actual rows= loops=)

  • Rows out: Avg 16.0 rows x 108 workers at destination. Max 16 rows (seg0) with 203 ms to end, start offset by 42326 ms.
91. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.000..0.200 rows=1 width=94) (actual rows= loops=)

  • Rows out: 16 rows with 0.018 ms to first row, 0.070 ms to end, start offset by 42526 ms.
92. 0.000 0.000 ↓ 0.0

Hash (cost=1,944,779.940..1,944,779.940 rows=57,415 width=176) (actual rows= loops=)

  • Rows in: Avg 57376.5 rows x 108 workers. Max 57685 rows (seg52) with 5292 ms to end, start offset by 42317 ms.
93. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice12; segments: 108) (cost=1,696,750.780..1,944,779.940 rows=57,415 width=176) (actual rows= loops=)

  • Hash Key: si.claim_exposure_id, si.claim_id, si.source_system
  • Rows out: Avg 57376.5 rows x 108 workers at destination. Max 57685 rows (seg52) with 4414 ms to first row, 5251 ms to end, start offset by 42317 ms.
94. 0.000 0.000 ↓ 0.0

Unique (cost=1,696,750.780..1,820,765.360 rows=57,415 width=55) (actual rows= loops=)

  • Group By: "?column1?", "?column2?", "?column3?", "?column4?", "?column5?", "?column6?", "?column7?
  • Rows out: Avg 57376.5 rows x 108 workers. Max 57969 rows (seg5) with 4323 ms to first row, 4373 ms to end, start offset by 42492 ms.
95. 0.000 0.000 ↓ 0.0

Sort (cost=1,696,750.780..1,712,252.600 rows=57,415 width=55) (actual rows= loops=)

  • Sort Key (Distinct): source_system, claim_id, claim_exposure_id, bldg_sum_insured, cont_sum_insured, pval_sum_insured, total_sum_insured
  • Rows out: Avg 57376.5 rows x 108 workers. Max 57969 rows (seg5) with 4323 ms to first row, 4338 ms to end, start offset by 42492 ms.
  • Executor memory: 9721K bytes avg, 9721K bytes max (seg0).
  • Work_mem used: 9721K bytes avg, 9721K bytes max (seg0). Workfile: (0 spilling)
96. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice11; segments: 108) (cost=126,151.040..997,184.330 rows=57,415 width=55) (actual rows= loops=)

  • Hash Key: source_system, claim_id, claim_exposure_id, bldg_sum_insured, cont_sum_insured, pval_sum_insured, total_sum_insured
  • Rows out: Avg 57376.5 rows x 108 workers at destination. Max 57969 rows (seg5) with 0.113 ms to first row, 4112 ms to end, start offset by 42493 ms.
97. 0.000 0.000 ↓ 0.0

Append (cost=126,151.040..997,184.330 rows=57,415 width=55) (actual rows= loops=)

  • Rows out: Avg 57376.5 rows x 108 workers. Max 57892 rows (seg9) with 447 ms to first row, 870 ms to end, start offset by 43214 ms.
98. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=126,151.040..521,042.040 rows=38,635 width=70) (actual rows= loops=)

  • Rows out: Avg 38602.7 rows x 108 workers. Max 38937 rows (seg24) with 248 ms to first row, 1528 ms to end, start offset by 42280 ms.
99. 0.000 0.000 ↓ 0.0

Hash Join (cost=126,151.040..479,316.440 rows=38,635 width=70) (actual rows= loops=)

  • Hash Cond: lima_delta.four_oscar = quebec_sierra.four_oscar
  • Rows out: Avg 38602.7 rows x 108 workers. Max 38937 rows (seg24) with 248 ms to first row, 1514 ms to end, start offset by 42280 ms.
  • Executor memory: 2500K bytes avg, 2509K bytes max (seg49).
  • Work_mem used: 2500K bytes avg, 2509K bytes max (seg49). Workfile: (0 spilling)
  • (seg24) Hash chain length 1.1 avg, 5 max, using 32914 of 131111 buckets.
100. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice9; segments: 108) (cost=0.000..217,557.200 rows=38,635 width=24) (actual rows= loops=)

  • Hash Key: e.coverage_id
  • Rows out: Avg 38602.7 rows x 108 workers at destination. Max 38937 rows (seg24) with 0.093 ms to first row, 1193 ms to end, start offset by 42528 ms.
101. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot lima_delta (cost=0.000..134,106.000 rows=38,635 width=24) (actual rows= loops=)

  • Filter: three_uniform_kilo = 0
  • Rows out: Avg 38602.7 rows x 108 workers. Max 38745 rows (seg30) with 0.148 ms to first row, 172 ms to end, start offset by 42125 ms.
102. 0.000 0.000 ↓ 0.0

Hash (cost=76,038.240..76,038.240 rows=37,121 width=62) (actual rows= loops=)

  • Rows in: Avg 37069.1 rows x 108 workers. Max 37174 rows (seg9) with 443 ms to end, start offset by 43218 ms.
103. 0.000 0.000 ↓ 0.0

Seq Scan on victor_hotel quebec_sierra (cost=0.000..76,038.240 rows=37,121 width=62) (actual rows= loops=)

  • Rows out: Avg 37069.1 rows x 108 workers. Max 37174 rows (seg9) with 85 ms to first row, 398 ms to end, start offset by 43218 ms.
104. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=133,834.600..476,142.290 rows=18,780 width=23) (actual rows= loops=)

  • Rows out: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 18 ms to first row, 334 ms to end, start offset by 43853 ms.
105. 0.000 0.000 ↓ 0.0

Hash Join (cost=133,834.600..455,860.600 rows=18,780 width=23) (actual rows= loops=)

  • Hash Cond: quebec_sierra.four_oscar = lima_delta.four_oscar
  • Rows out: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 18 ms to first row, 327 ms to end, start offset by 43853 ms.
  • Executor memory: 1027K bytes avg, 1044K bytes max (seg63).
  • Work_mem used: 1027K bytes avg, 1044K bytes max (seg63). Workfile: (0 spilling)
  • (seg63) Hash chain length 1.2 avg, 7 max, using 15588 of 131111 buckets.
106. 0.000 0.000 ↓ 0.0

Seq Scan on victor_november quebec_sierra (cost=0.000..263,559.910 rows=122,645 width=15) (actual rows= loops=)

  • Rows out: Avg 122651.4 rows x 108 workers. Max 122795 rows (seg61) with 0.091 ms to first row, 111 ms to end, start offset by 43899 ms.
107. 0.000 0.000 ↓ 0.0

Hash (cost=108,482.490..108,482.490 rows=18,780 width=24) (actual rows= loops=)

  • Rows in: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 17 ms to end, start offset by 43854 ms.
108. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice10; segments: 108) (cost=0.000..108,482.490 rows=18,780 width=24) (actual rows= loops=)

  • Hash Key: e.coverage_id
  • Rows out: Avg 18773.8 rows x 108 workers at destination. Max 19073 rows (seg63) with 0.123 ms to first row, 9.558 ms to end, start offset by 43854 ms.
109. 0.000 0.000 ↓ 0.0

Seq Scan on india_yankee lima_delta (cost=0.000..67,919.110 rows=18,780 width=24) (actual rows= loops=)

  • Filter: three_uniform_kilo = 0
  • Rows out: Avg 18773.8 rows x 108 workers. Max 18877 rows (seg7) with 42 ms to first row, 302 ms to end, start offset by 42120 ms.
110. 0.000 0.000 ↓ 0.0

Hash (cost=17,029,434.560..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Rows in: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8845 ms to end, start offset by 42393 ms.
111. 0.000 0.000 ↓ 0.0

Subquery Scan e (cost=16,999,295.920..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8737 ms to first row, 8821 ms to end, start offset by 42393 ms.
112. 0.000 0.000 ↓ 0.0

Window (cost=16,999,295.920..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Partition By: exposure_reserve.source_system, exposure_reserve.claim_number
  • Order By: exposure_reserve.sum_reserve
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8737 ms to first row, 8812 ms to end, start offset by 42393 ms.
113. 0.000 0.000 ↓ 0.0

Sort (cost=16,999,295.920..17,005,323.650 rows=22,325 width=194) (actual rows= loops=)

  • Sort Key: charlie_four.victor_bravo, charlie_four.zulu_quebec, charlie_four.hotel_lima
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8737 ms to first row, 8743 ms to end, start offset by 42393 ms.
  • Executor memory: 9721K bytes avg, 9721K bytes max (seg0).
  • Work_mem used: 9721K bytes avg, 9721K bytes max (seg0). Workfile: (0 spilling)
114. 0.000 0.000 ↓ 0.0

Subquery Scan exposure_reserve (cost=16,683,367.610..16,743,705.160 rows=22,325 width=194) (actual rows= loops=)

  • Filter: two_victor five_romeo_foxtrot NOT NULL OR delta_mike = 1
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8582 ms to first row, 8683 ms to end, start offset by 42393 ms.
115. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=16,683,367.610..16,743,705.160 rows=22,348 width=194) (actual rows= loops=)

  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7167 ms to first row, 7422 ms to end, start offset by 42300 ms.
116. 0.000 0.000 ↓ 0.0

Window (cost=16,683,367.610..16,707,502.630 rows=22,348 width=194) (actual rows= loops=)

  • Partition By: coplan.source_system, coplan.claim_number
  • Order By: coplan.claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7167 ms to first row, 7364 ms to end, start offset by 42300 ms.
117. 0.000 0.000 ↓ 0.0

Sort (cost=16,683,367.610..16,689,401.370 rows=22,348 width=194) (actual rows= loops=)

  • Sort Key: yankee_india.victor_bravo, yankee_india.zulu_quebec, yankee_india.two_victor
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7167 ms to first row, 7187 ms to end, start offset by 42300 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
118. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=16,379,233.820..16,427,503.860 rows=22,348 width=194) (actual rows= loops=)

  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6709 ms to first row, 6996 ms to end, start offset by 42301 ms.
119. 0.000 0.000 ↓ 0.0

Window (cost=16,379,233.820..16,403,368.840 rows=22,348 width=194) (actual rows= loops=)

  • Partition By: "Window".source_system, "Window".claim_number
  • Order By: "Window".claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6709 ms to first row, 6984 ms to end, start offset by 42301 ms.
120. 0.000 0.000 ↓ 0.0

Sort (cost=16,379,233.820..16,385,267.570 rows=22,348 width=194) (actual rows= loops=)

  • Sort Key: "five_romeo_quebec".victor_bravo, "five_romeo_quebec".zulu_quebec, "five_romeo_quebec".two_victor
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6709 ms to first row, 6727 ms to end, start offset by 42301 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
121. 0.000 0.000 ↓ 0.0

HashAggregate (cost=16,063,032.510..16,099,235.040 rows=22,348 width=194) (actual rows= loops=)

  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6295 ms to first row, 6467 ms to end, start offset by 42301 ms.
  • Executor memory: 7590K bytes avg, 7628K bytes max (seg0).
122. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,821,682.340 rows=223,473 width=43) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (xray_echo::text = ANY ('charlie_uniform'::text[])) AND (four_tango = ANY ('golf_charlie'::text[]))
  • Rows out: Avg 331465.7 rows x 108 workers. Max 336080 rows (seg8) with 421 ms to first row, 5527 ms to end, start offset by 42302 ms.
123. 0.000 0.000 ↓ 0.0

Hash (cost=52,985,548.000..52,985,548.000 rows=10 width=194) (actual rows= loops=)

  • Rows in: Avg 29020.4 rows x 108 workers. Max 29440 rows (seg39) with 8710 ms to end, start offset by 91311 ms.
124. 0.000 0.000 ↓ 0.0

Subquery Scan t2 (cost=52,690,845.690..52,985,548.000 rows=10 width=162) (actual rows= loops=)

  • Rows out: Avg 29020.4 rows x 108 workers. Max 29440 rows (seg39) with 6904 ms to first row, 8653 ms to end, start offset by 91311 ms.
125. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=52,690,845.690..52,985,538.000 rows=10 width=162) (actual rows= loops=)

  • Group By: claim_transaction_details_all.claim_number
  • Rows out: Avg 29020.4 rows x 108 workers. Max 29440 rows (seg39) with 6904 ms to first row, 8617 ms to end, start offset by 91311 ms.
  • Executor memory: 1860043K bytes avg, 1886936K bytes max (seg39).
  • Work_mem used: 33K bytes avg, 49K bytes max (seg5).
126. 0.000 0.000 ↓ 0.0

Sort (cost=52,690,845.690..52,764,510.020 rows=272,831 width=678) (actual rows= loops=)

  • Sort Key: kilo_papa_uniform.zulu_quebec
  • Rows out: Avg 412991.4 rows x 108 workers. Max 418781 rows (seg107) with 8604 ms to first row, 8798 ms to end, start offset by 91083 ms.
  • Executor memory: 77817K bytes avg, 77817K bytes max (seg0).
  • Work_mem used: 77817K bytes avg, 77817K bytes max (seg0). Workfile: (0 spilling)
127. 0.000 0.000 ↓ 0.0

Subquery Scan claim_transaction_details_all (cost=0.000..16,433,018.920 rows=272,831 width=678) (actual rows= loops=)

  • Rows out: Avg 412991.4 rows x 108 workers. Max 418781 rows (seg107) with 69 ms to first row, 7273 ms to end, start offset by 91085 ms.
128. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..16,433,018.920 rows=272,831 width=380) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('oscar_tango'::text[])) AND (four_tango = ANY ('alpha'::text[])) AND (xray_echo::text = ANY ('mike_three'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 412991.4 rows x 108 workers. Max 418781 rows (seg107) with 69 ms to first row, 7134 ms to end, start offset by 91085 ms.
129. 0.000 0.000 ↓ 0.0

Hash (cost=258,903.880..258,903.880 rows=33,919 width=45) (actual rows= loops=)

  • Rows in: Avg 33905.3 rows x 108 workers. Max 34343 rows (seg78) with 237 ms to end, start offset by 90814 ms.
130. 0.000 0.000 ↓ 0.0

Seq Scan on four_hotel seven_three (cost=0.000..258,903.880 rows=33,919 width=45) (actual rows= loops=)

  • Filter: five_victor = ANY ('india_mike'::text[])
  • Rows out: Avg 33905.3 rows x 108 workers. Max 34343 rows (seg78) with 10 ms to first row, 208 ms to end, start offset by 90814 ms.
131. 0.000 0.000 ↓ 0.0

Hash (cost=79,751,295.450..79,751,295.450 rows=9,260 width=714) (actual rows= loops=)

  • Rows in: Avg 29485.8 rows x 108 workers. Max 29924 rows (seg7) with 47097 ms to end, start offset by 43714 ms.
132. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice32; segments: 108) (cost=79,666,295.450..79,751,295.450 rows=9,260 width=714) (actual rows= loops=)

  • Hash Key: aggregates_by_risk.claim_number::text
  • Rows out: Avg 29492.7 rows x 108 workers at destination. Max 29929 rows (seg7) with 46708 ms to first row, 47074 ms to end, start offset by 43714 ms.
133. 0.000 0.000 ↓ 0.0

HashAggregate (cost=79,666,295.450..79,731,295.450 rows=9,260 width=746) (actual rows= loops=)

  • Group By: clm_trn_det.claim_number, exp_risk.risk_code
  • Rows out: Avg 29492.7 rows x 108 workers. Max 29901 rows (seg90) with 47957 ms to first row, 48047 ms to end, start offset by 42462 ms.
  • Executor memory: 16975K bytes avg, 17172K bytes max (seg1).
134. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice31; segments: 108) (cost=79,291,295.450..79,598,795.450 rows=9,260 width=682) (actual rows= loops=)

  • Hash Key: clm_trn_det.claim_number, exp_risk.risk_code
  • Rows out: Avg 29492.7 rows x 108 workers at destination. Max 29901 rows (seg90) with 41698 ms to first row, 47835 ms to end, start offset by 42463 ms.
135. 0.000 0.000 ↓ 0.0

HashAggregate (cost=79,291,295.450..79,578,795.450 rows=9,260 width=682) (actual rows= loops=)

  • Group By: clm_trn_det.claim_number, exp_risk.risk_code
  • Rows out: Avg 29492.7 rows x 108 workers. Max 29929 rows (seg7) with 44920 ms to first row, 45003 ms to end, start offset by 42467 ms.
  • Executor memory: 22591K bytes avg, 22872K bytes max (seg7).
136. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=59,406,095.440..77,597,015.960 rows=272,831 width=1,533) (actual rows= loops=)

  • Hash Cond: oscar_uniform.zulu_quebec::text = two_alpha.zulu_quebec::text AND oscar_uniform.victor_bravo = two_alpha.victor_bravo
  • Join Filter: oscar_uniform.two_victor = two_alpha.two_victor OR (oscar_uniform.two_victor five_romeo_foxtrot NULL AND two_alpha.quebec_zulu = 'uniform_five'::text)
  • Rows out: Avg 413387.3 rows x 108 workers. Max 419176 rows (seg107) with 30657 ms to first row, 38263 ms to end, start offset by 42150 ms.
  • Executor memory: 2721K bytes avg, 2759K bytes max (seg39).
  • Work_mem used: 2721K bytes avg, 2759K bytes max (seg39). Workfile: (0 spilling)
  • (seg107) Hash chain length 1.5 avg, 9 max, using 26304 of 131111 buckets.
137. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..16,433,018.920 rows=272,831 width=380) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('oscar_tango'::text[])) AND (four_tango = ANY ('alpha'::text[])) AND (xray_echo::text = ANY ('mike_three'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 412991.4 rows x 108 workers. Max 418781 rows (seg107) with 94 ms to first row, 6552 ms to end, start offset by 72713 ms.
138. 0.000 0.000 ↓ 0.0

Hash (cost=59,339,106.650..59,339,106.650 rows=41,352 width=202) (actual rows= loops=)

  • Rows in: Avg 38689.8 rows x 108 workers. Max 39233 rows (seg39) with 30436 ms to end, start offset by 42273 ms.
139. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice30; segments: 108) (cost=59,048,821.920..59,339,106.650 rows=41,352 width=202) (actual rows= loops=)

  • Hash Key: exp_risk.claim_number::text
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 39233 rows (seg39) with 29340 ms to first row, 30411 ms to end, start offset by 42273 ms.
140. 0.000 0.000 ↓ 0.0

Subquery Scan exp_risk (cost=59,048,821.920..59,249,788.270 rows=41,352 width=202) (actual rows= loops=)

  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 28768 ms to first row, 29583 ms to end, start offset by 43043 ms.
141. 0.000 0.000 ↓ 0.0

Window (cost=59,048,821.920..59,205,129.080 rows=41,352 width=602) (actual rows= loops=)

  • Partition By: t.source_system, t.claim_id, t.claim_exposure_id
  • Order By: t.risk_proportion, t.risk_code
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 28768 ms to first row, 29551 ms to end, start offset by 43043 ms.
142. 0.000 0.000 ↓ 0.0

Sort (cost=59,048,821.920..59,059,986.720 rows=41,352 width=602) (actual rows= loops=)

  • Sort Key: romeo.victor_bravo, romeo.india_zulu, romeo.two_victor, romeo.tango_two, romeo.india_three
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38974 rows (seg48) with 28767 ms to first row, 28780 ms to end, start offset by 43043 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
143. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice29; segments: 108) (cost=37,990,677.700..58,555,549.430 rows=41,352 width=602) (actual rows= loops=)

  • Hash Key: t.source_system, t.claim_id, t.claim_exposure_id
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 38974 rows (seg48) with 12693 ms to first row, 28396 ms to end, start offset by 43044 ms.
144. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=37,990,677.700..58,466,231.050 rows=41,352 width=602) (actual rows= loops=)

  • Hash Cond: romeo.victor_bravo = lima_delta.victor_bravo AND romeo.zulu_quebec::text = lima_delta.zulu_quebec::text AND romeo.two_victor = lima_delta.two_victor
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39233 rows (seg39) with 13172 ms to first row, 28869 ms to end, start offset by 42482 ms.
  • Executor memory: 2115K bytes avg, 2145K bytes max (seg39).
  • Work_mem used: 2115K bytes avg, 2145K bytes max (seg39). Workfile: (0 spilling)
  • (seg39) Hash chain length 1.7 avg, 7 max, using 22826 of 32779 buckets.
145. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice28; segments: 108) (cost=20,919,049.050..41,316,368.060 rows=41,352 width=570) (actual rows= loops=)

  • Hash Key: t.claim_number::text
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 39233 rows (seg39) with 4526 ms to first row, 20140 ms to end, start offset by 51128 ms.
146. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=20,919,049.050..41,227,049.680 rows=41,352 width=570) (actual rows= loops=)

  • Hash Cond: romeo.victor_bravo = papa.victor_bravo AND romeo.india_zulu = papa.india_zulu AND romeo.two_victor::bigint = papa.two_victor
  • Rows out: Avg 38689.8 rows x 108 workers. Max 38948 rows (seg100) with 13049 ms to first row, 29011 ms to end, start offset by 42332 ms.
  • Executor memory: 4200K bytes avg, 4223K bytes max (seg100).
  • Work_mem used: 4200K bytes avg, 4223K bytes max (seg100). Workfile: (0 spilling)
  • (seg100) Hash chain length 1.7 avg, 9 max, using 34155 of 65539 buckets.
147. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice23; segments: 108) (cost=18,865,756.350..39,095,326.480 rows=41,352 width=442) (actual rows= loops=)

  • Hash Key: t.claim_exposure_id::bigint, t.claim_id, t.source_system
  • Rows out: Avg 38689.8 rows x 108 workers at destination. Max 38948 rows (seg100) with 7783 ms to first row, 23634 ms to end, start offset by 47597 ms.
148. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,865,756.350..39,006,008.100 rows=41,352 width=344) (actual rows= loops=)

  • Hash Cond: three_hotel.juliet_alpha_uniform2mike_seven = sierra_yankee.juliet_alpha_uniform2mike_seven
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39113 rows (seg41) with 13489 ms to first row, 25379 ms to end, start offset by 42163 ms.
  • Executor memory: 1K bytes avg, 1K bytes max (seg0).
  • Work_mem used: 1K bytes avg, 1K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 1.0 avg, 1 max, using 16 of 65539 buckets.
149. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,865,717.110..38,813,621.730 rows=41,352 width=1,038) (actual rows= loops=)

  • Hash Cond: juliet_alpha_golf.victor_bravo = delta_romeo.victor_bravo AND juliet_alpha_golf.india_zulu = delta_romeo.india_zulu AND juliet_alpha_golf.two_victor = delta_romeo.two_victor::text
  • Rows out: Avg 38689.8 rows x 108 workers. Max 39113 rows (seg41) with 13332 ms to first row, 25104 ms to end, start offset by 42319 ms.
  • Executor memory: 13896K bytes avg, 13896K bytes max (seg0).
  • Work_mem used: 13896K bytes avg, 13896K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 2.0 avg, 10 max, using 107852 of 131111 buckets.
150. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=18,024,901.140..37,536,279.910 rows=41,352 width=1,018) (actual rows= loops=)

  • Hash Cond: juliet_alpha_golf.victor_bravo = charlie_echo.victor_bravo AND juliet_alpha_golf.tango_echo::bigint = charlie_echo.tango_echo
  • Rows out: Avg 38672.5 rows x 108 workers. Max 39093 rows (seg41) with 11445 ms to first row, 22961 ms to end, start offset by 44206 ms.
  • Executor memory: 2232K bytes avg, 2232K bytes max (seg0).
  • Work_mem used: 2232K bytes avg, 2232K bytes max (seg0). Workfile: (0 spilling)
  • (seg41) Hash chain length 1.2 avg, 6 max, using 40348 of 131111 buckets.
151. 0.000 0.000 ↓ 0.0

Append (cost=17,451,364.290..36,742,072.840 rows=41,352 width=2,450) (actual rows= loops=)

  • Rows out: Avg 38672.5 rows x 108 workers. Max 39093 rows (seg41) with 11283 ms to first row, 22681 ms to end, start offset by 44367 ms.
152. 0.000 0.000 ↓ 0.0

Subquery Scan mv_claim_transaction_details_all (cost=17,451,364.290..17,713,422.170 rows=1 width=1,496) (actual rows= loops=)

  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 11283 ms to first row, 11493 ms to end, start offset by 44367 ms.
153. 0.000 0.000 ↓ 0.0

Unique (cost=17,451,364.290..17,713,422.120 rows=0 width=139) (actual rows= loops=)

  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 11283 ms to first row, 11376 ms to end, start offset by 44367 ms.
154. 0.000 0.000 ↓ 0.0

Sort (cost=17,451,364.290..17,468,834.810 rows=64,706 width=139) (actual rows= loops=)

  • Sort Key (Distinct): pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 38591.9 rows x 108 workers. Max 39008 rows (seg41) with 11283 ms to first row, 11315 ms to end, start offset by 44367 ms.
  • Executor memory: 35833K bytes avg, 35833K bytes max (seg0).
  • Work_mem used: 35833K bytes avg, 35833K bytes max (seg0). Workfile: (0 spilling)
155. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice16; segments: 108) (cost=16,412,340.230..16,656,927.540 rows=64,706 width=139) (actual rows= loops=)

  • Hash Key: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.policy_id, pub.mv_claim_transaction_details_all.policy_number, pub.mv_claim_transaction_details_all.claim_loss_type_name, pub.mv_claim_transaction_details_all.claim_exposure_id, claim_exposure_type_id, coverage_type, coverage_subtype, transaction_source, sap_product_class_code, line_of_business_code
  • Rows out: Avg 91062.5 rows x 108 workers at destination. Max 92244 rows (seg97) with 4294 ms to first row, 10075 ms to end, start offset by 44385 ms.
156. 0.000 0.000 ↓ 0.0

Window (cost=16,412,340.230..16,517,163.360 rows=64,706 width=139) (actual rows= loops=)

  • Partition By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.claim_exposure_id
  • Order By: pub.mv_claim_transaction_details_all.transaction_source, pub.mv_claim_transaction_details_all.transaction_date
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 7206 ms to first row, 7821 ms to end, start offset by 42010 ms.
157. 0.000 0.000 ↓ 0.0

Sort (cost=16,412,340.230..16,429,810.750 rows=64,706 width=139) (actual rows= loops=)

  • Sort Key: hotel_four.yankee_whiskey.victor_bravo, hotel_four.yankee_whiskey.zulu_quebec, hotel_four.yankee_whiskey.two_victor, hotel_four.yankee_whiskey.four_tango, hotel_four.yankee_whiskey.six
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 7206 ms to first row, 7255 ms to end, start offset by 42010 ms.
  • Executor memory: 44025K bytes avg, 44025K bytes max (seg0).
  • Work_mem used: 44025K bytes avg, 44025K bytes max (seg0). Workfile: (0 spilling)
158. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,617,903.480 rows=64,706 width=139) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (four_tango = ANY ('oscar_yankee'::text[])) AND (xray_echo::text = ANY ('mike_three'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 91062.5 rows x 108 workers. Max 92468 rows (seg8) with 1047 ms to first row, 6224 ms to end, start offset by 42010 ms.
159. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=17,540,969.130..19,028,650.660 rows=41,352 width=2,450) (actual rows= loops=)

  • Rows out: Avg 80.6 rows x 108 workers. Max 100 rows (seg29) with 10758 ms to first row, 10782 ms to end, start offset by 56457 ms.
160. 0.000 0.000 ↓ 0.0

HashAggregate (cost=17,540,969.130..18,983,991.480 rows=41,352 width=998) (actual rows= loops=)

  • Filter: whiskey_three(hotel_four.yankee_whiskey.two_victor::integer) five_romeo_foxtrot NULL
  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.policy_brand, pub.mv_claim_transaction_details_all.claim_id, pub.mv_claim_transaction_details_all.claim_number
  • Rows out: Avg 80.6 rows x 108 workers. Max 100 rows (seg29) with 10758 ms to first row, 10782 ms to end, start offset by 56457 ms.
  • Executor memory: 7483K bytes avg, 7565K bytes max (seg0).
161. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,210,345.760 rows=413,511 width=77) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (xray_echo::text = ANY ('charlie_uniform'::text[])) AND three_uniform_lima::text <> 'sierra_tango'::text
  • Rows out: Avg 465956.8 rows x 108 workers. Max 472454 rows (seg107) with 32 ms to first row, 5452 ms to end, start offset by 57929 ms.
162. 0.000 0.000 ↓ 0.0

Hash (cost=504,712.740..504,712.740 rows=42,485 width=60) (actual rows= loops=)

  • Rows in: Avg 47616.0 rows x 108 workers. Max 47616 rows (seg0) with 146 ms to end, start offset by 44207 ms.
163. 0.000 0.000 ↓ 0.0

Broadcast Motion 108:108 (slice19; segments: 108) (cost=457,449.280..504,712.740 rows=42,485 width=60) (actual rows= loops=)

  • Rows out: Avg 47616.0 rows x 108 workers at destination. Max 47616 rows (seg0) with 75 ms to first row, 123 ms to end, start offset by 44207 ms.
164. 0.000 0.000 ↓ 0.0

Subquery Scan landlords (cost=457,449.280..458,405.170 rows=394 width=80) (actual rows= loops=)

  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 2224 ms to first row, 2225 ms to end, start offset by 42065 ms.
165. 0.000 0.000 ↓ 0.0

Unique (cost=457,449.280..457,980.330 rows=394 width=14) (actual rows= loops=)

  • Group By: source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 2224 ms to end, start offset by 42065 ms.
166. 0.000 0.000 ↓ 0.0

Sort (cost=457,449.280..457,555.490 rows=394 width=14) (actual rows= loops=)

  • Sort Key (Distinct): source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers. Max 495 rows (seg92) with 2224 ms to end, start offset by 42065 ms.
  • Executor memory: 137K bytes avg, 145K bytes max (seg0).
  • Work_mem used: 137K bytes avg, 145K bytes max (seg0). Workfile: (0 spilling)
167. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice18; segments: 108) (cost=0.000..454,183.400 rows=394 width=14) (actual rows= loops=)

  • Hash Key: source_system, policy_id, risk_type, risk_count
  • Rows out: Avg 440.9 rows x 108 workers at destination. Max 495 rows (seg92) with 2141 ms to first row, 2214 ms to end, start offset by 42074 ms.
168. 0.000 0.000 ↓ 0.0

Append (cost=0.000..454,183.400 rows=394 width=14) (actual rows= loops=)

  • Rows out: Avg 440.9 rows x 108 workers. Max 501 rows (seg82) with 79 ms to first row, 2109 ms to end, start offset by 42108 ms.
169. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=0.000..91,280.930 rows=394 width=13) (actual rows= loops=)

  • Rows out: Avg 440.3 rows x 108 workers. Max 500 rows (seg82) with 79 ms to first row, 205 ms to end, start offset by 42108 ms.
170. 0.000 0.000 ↓ 0.0

Seq Scan on xray_juliet (cost=0.000..90,856.120 rows=394 width=13) (actual rows= loops=)

  • Filter: charlie_tango::text = ANY ('three_three'::text[])
  • Rows out: Avg 440.3 rows x 108 workers. Max 500 rows (seg82) with 79 ms to first row, 204 ms to end, start offset by 42108 ms.
171. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=362,902.390..362,902.460 rows=1 width=80) (actual rows= loops=)

  • Rows out: Avg 1.2 rows x 54 workers. Max 3 rows (seg19) with 1774 ms to end, start offset by 42440 ms.
172. 0.000 0.000 ↓ 0.0

HashAggregate (cost=362,902.390..362,902.430 rows=1 width=80) (actual rows= loops=)

  • Group By: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.2 rows x 54 workers. Max 3 rows (seg19) with 1774 ms to end, start offset by 42440 ms.
  • Executor memory: 2101K bytes avg, 2137K bytes max (seg0).
173. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice17; segments: 108) (cost=362,902.260..362,902.340 rows=1 width=48) (actual rows= loops=)

  • Hash Key: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.4 rows x 54 workers at destination. Max 4 rows (seg19) with 49 ms to first row, 1772 ms to end, start offset by 42441 ms.
174. 0.000 0.000 ↓ 0.0

HashAggregate (cost=362,902.260..362,902.280 rows=1 width=48) (actual rows= loops=)

  • Group By: ctx.mv_cc_ci_coverage.policy_id
  • Rows out: Avg 1.4 rows x 56 workers. Max 4 rows (seg37) with 329 ms to end, start offset by 42561 ms.
  • Executor memory: 2102K bytes avg, 2137K bytes max (seg1).
175. 0.000 0.000 ↓ 0.0

Seq Scan on victor_november (cost=0.000..362,901.840 rows=1 width=13) (actual rows= loops=)

  • Filter: india_whiskey_five::text = 'mike_romeo'::text AND echo::text = 'whiskey_six'::text AND (golf_bravo::text = ANY ('three_india'::text[]))
  • Rows out: Avg 1.4 rows x 56 workers. Max 4 rows (seg37) with 306 ms to first row, 327 ms to end, start offset by 42563 ms.
176. 0.000 0.000 ↓ 0.0

Hash (cost=410,266.410..410,266.410 rows=227,804 width=68) (actual rows= loops=)

  • Rows in: Avg 220273.0 rows x 108 workers. Max 220273 rows (seg0) with 1884 ms to end, start offset by 42321 ms.
177. 0.000 0.000 ↓ 0.0

Broadcast Motion 108:108 (slice21; segments: 108) (cost=154,271.670..410,266.410 rows=227,804 width=68) (actual rows= loops=)

  • Rows out: Avg 220273.0 rows x 108 workers at destination. Max 220273 rows (seg0) with 956 ms to first row, 1559 ms to end, start offset by 42321 ms.
178. 0.000 0.000 ↓ 0.0

HashAggregate (cost=154,271.670..161,960.050 rows=2,110 width=76) (actual rows= loops=)

  • Filter: five_hotel(bravo.lima_five.kilo_echo) > 0::numeric
  • Group By: 'CC_PI'::text, e.claim_id, e.exposure_id, e.claim_order, CASE WHEN sor_cc_pi.ccx_coverageapportionment_ext.claimcentercover::text = ANY ('{"Portable Clothes and Luggage","Portable Sport and Recreational","Portable Electronic Devices","Portable Mobility Scooters","Portable Jewellery and Watches","Portable Glasses and Medical","Unspecified Portable Valuables"}'::text[]) THEN 'HE'::text ELSE NULL::text END::character(2)
  • Rows out: Avg 2039.6 rows x 108 workers. Max 2148 rows (seg85) with 1023 ms to first row, 1028 ms to end, start offset by 42338 ms.
  • Executor memory: 1275K bytes avg, 1289K bytes max (seg1).
179. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,768.710..150,285.080 rows=2,110 width=45) (actual rows= loops=)

  • Hash Cond: lima_delta.delta_five = bravo.lima_five.seven_delta
  • Rows out: Avg 2116.1 rows x 108 workers. Max 2221 rows (seg85) with 945 ms to first row, 1016 ms to end, start offset by 42340 ms.
  • Executor memory: 143K bytes avg, 150K bytes max (seg51).
  • Work_mem used: 143K bytes avg, 150K bytes max (seg51). Workfile: (0 spilling)
  • (seg85) Hash chain length 1.0 avg, 3 max, using 2123 of 131111 buckets.
180. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot lima_delta (cost=0.000..123,674.600 rows=38,635 width=24) (actual rows= loops=)

  • Rows out: Avg 38603.0 rows x 108 workers. Max 38746 rows (seg30) with 0.148 ms to first row, 58 ms to end, start offset by 43242 ms.
181. 0.000 0.000 ↓ 0.0

Hash (cost=7,921.150..7,921.150 rows=2,110 width=29) (actual rows= loops=)

  • Rows in: Avg 2116.1 rows x 108 workers. Max 2221 rows (seg85) with 886 ms to end, start offset by 42342 ms.
182. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice20; segments: 108) (cost=0.000..7,921.150 rows=2,110 width=29) (actual rows= loops=)

  • Hash Key: sor_cc_pi.ccx_coverageapportionment_ext.exposureid
  • Rows out: Avg 2116.1 rows x 108 workers at destination. Max 2221 rows (seg85) with 0.054 ms to first row, 884 ms to end, start offset by 42342 ms.
183. 0.000 0.000 ↓ 0.0

Seq Scan on lima_five (cost=0.000..3,365.050 rows=2,110 width=29) (actual rows= loops=)

  • Rows out: Avg 2116.1 rows x 108 workers. Max 2193 rows (seg41) with 0.127 ms to first row, 13 ms to end, start offset by 42089 ms.
184. 0.000 0.000 ↓ 0.0

Hash (cost=17.640..17.640 rows=16 width=94) (actual rows= loops=)

  • Rows in: Avg 16.0 rows x 108 workers. Max 16 rows (seg0) with 79 ms to end, start offset by 42240 ms.
185. 0.000 0.000 ↓ 0.0

Broadcast Motion 1:108 (slice22; segments: 1) (cost=0.000..17.640 rows=1,728 width=94) (actual rows= loops=)

  • Rows out: Avg 16.0 rows x 108 workers at destination. Max 16 rows (seg0) with 79 ms to end, start offset by 42240 ms.
186. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.000..0.200 rows=1 width=94) (actual rows= loops=)

  • Rows out: 16 rows with 0.025 ms to first row, 0.082 ms to end, start offset by 42318 ms.
187. 0.000 0.000 ↓ 0.0

Hash (cost=1,944,779.940..1,944,779.940 rows=57,415 width=176) (actual rows= loops=)

  • Rows in: Avg 57376.5 rows x 108 workers. Max 57685 rows (seg52) with 5178 ms to end, start offset by 42407 ms.
188. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice27; segments: 108) (cost=1,696,750.780..1,944,779.940 rows=57,415 width=176) (actual rows= loops=)

  • Hash Key: si.claim_exposure_id, si.claim_id, si.source_system
  • Rows out: Avg 57376.5 rows x 108 workers at destination. Max 57685 rows (seg52) with 4204 ms to first row, 5141 ms to end, start offset by 42407 ms.
189. 0.000 0.000 ↓ 0.0

Unique (cost=1,696,750.780..1,820,765.360 rows=57,415 width=55) (actual rows= loops=)

  • Group By: "?column1?", "?column2?", "?column3?", "?column4?", "?column5?", "?column6?", "?column7?
  • Rows out: Avg 57376.5 rows x 108 workers. Max 57969 rows (seg5) with 3992 ms to first row, 4072 ms to end, start offset by 42614 ms.
190. 0.000 0.000 ↓ 0.0

Sort (cost=1,696,750.780..1,712,252.600 rows=57,415 width=55) (actual rows= loops=)

  • Sort Key (Distinct): source_system, claim_id, claim_exposure_id, bldg_sum_insured, cont_sum_insured, pval_sum_insured, total_sum_insured
  • Rows out: Avg 57376.5 rows x 108 workers. Max 57969 rows (seg5) with 3991 ms to first row, 4010 ms to end, start offset by 42614 ms.
  • Executor memory: 9721K bytes avg, 9721K bytes max (seg0).
  • Work_mem used: 9721K bytes avg, 9721K bytes max (seg0). Workfile: (0 spilling)
191. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice26; segments: 108) (cost=126,151.040..997,184.330 rows=57,415 width=55) (actual rows= loops=)

  • Hash Key: source_system, claim_id, claim_exposure_id, bldg_sum_insured, cont_sum_insured, pval_sum_insured, total_sum_insured
  • Rows out: Avg 57376.5 rows x 108 workers at destination. Max 57969 rows (seg5) with 0.103 ms to first row, 3885 ms to end, start offset by 42615 ms.
192. 0.000 0.000 ↓ 0.0

Append (cost=126,151.040..997,184.330 rows=57,415 width=55) (actual rows= loops=)

  • Rows out: Avg 57376.5 rows x 108 workers. Max 57892 rows (seg9) with 409 ms to first row, 825 ms to end, start offset by 43226 ms.
193. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=126,151.040..521,042.040 rows=38,635 width=70) (actual rows= loops=)

  • Rows out: Avg 38602.7 rows x 108 workers. Max 38937 rows (seg24) with 495 ms to first row, 1636 ms to end, start offset by 42037 ms.
194. 0.000 0.000 ↓ 0.0

Hash Join (cost=126,151.040..479,316.440 rows=38,635 width=70) (actual rows= loops=)

  • Hash Cond: lima_delta.four_oscar = quebec_sierra.four_oscar
  • Rows out: Avg 38602.7 rows x 108 workers. Max 38937 rows (seg24) with 495 ms to first row, 1613 ms to end, start offset by 42037 ms.
  • Executor memory: 2500K bytes avg, 2509K bytes max (seg49).
  • Work_mem used: 2500K bytes avg, 2509K bytes max (seg49). Workfile: (0 spilling)
  • (seg24) Hash chain length 1.1 avg, 5 max, using 32914 of 131111 buckets.
195. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice24; segments: 108) (cost=0.000..217,557.200 rows=38,635 width=24) (actual rows= loops=)

  • Hash Key: e.coverage_id
  • Rows out: Avg 38602.7 rows x 108 workers at destination. Max 38937 rows (seg24) with 0.067 ms to first row, 1049 ms to end, start offset by 42532 ms.
196. 0.000 0.000 ↓ 0.0

Seq Scan on foxtrot lima_delta (cost=0.000..134,106.000 rows=38,635 width=24) (actual rows= loops=)

  • Filter: three_uniform_kilo = 0
  • Rows out: Avg 38602.7 rows x 108 workers. Max 38745 rows (seg30) with 41 ms to first row, 252 ms to end, start offset by 42068 ms.
197. 0.000 0.000 ↓ 0.0

Hash (cost=76,038.240..76,038.240 rows=37,121 width=62) (actual rows= loops=)

  • Rows in: Avg 37069.1 rows x 108 workers. Max 37174 rows (seg9) with 407 ms to end, start offset by 43228 ms.
198. 0.000 0.000 ↓ 0.0

Seq Scan on victor_hotel quebec_sierra (cost=0.000..76,038.240 rows=37,121 width=62) (actual rows= loops=)

  • Rows out: Avg 37069.1 rows x 108 workers. Max 37174 rows (seg9) with 76 ms to first row, 318 ms to end, start offset by 43228 ms.
199. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=133,834.600..476,142.290 rows=18,780 width=23) (actual rows= loops=)

  • Rows out: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 23 ms to first row, 195 ms to end, start offset by 43743 ms.
200. 0.000 0.000 ↓ 0.0

Hash Join (cost=133,834.600..455,860.600 rows=18,780 width=23) (actual rows= loops=)

  • Hash Cond: quebec_sierra.four_oscar = lima_delta.four_oscar
  • Rows out: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 23 ms to first row, 188 ms to end, start offset by 43743 ms.
  • Executor memory: 1027K bytes avg, 1044K bytes max (seg63).
  • Work_mem used: 1027K bytes avg, 1044K bytes max (seg63). Workfile: (0 spilling)
  • (seg63) Hash chain length 1.2 avg, 7 max, using 15588 of 131111 buckets.
201. 0.000 0.000 ↓ 0.0

Seq Scan on victor_november quebec_sierra (cost=0.000..263,559.910 rows=122,645 width=15) (actual rows= loops=)

  • Rows out: Avg 122651.4 rows x 108 workers. Max 122795 rows (seg61) with 0.108 ms to first row, 186 ms to end, start offset by 43760 ms.
202. 0.000 0.000 ↓ 0.0

Hash (cost=108,482.490..108,482.490 rows=18,780 width=24) (actual rows= loops=)

  • Rows in: Avg 18773.8 rows x 108 workers. Max 19073 rows (seg63) with 22 ms to end, start offset by 43744 ms.
203. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice25; segments: 108) (cost=0.000..108,482.490 rows=18,780 width=24) (actual rows= loops=)

  • Hash Key: e.coverage_id
  • Rows out: Avg 18773.8 rows x 108 workers at destination. Max 19073 rows (seg63) with 0.091 ms to first row, 14 ms to end, start offset by 43744 ms.
204. 0.000 0.000 ↓ 0.0

Seq Scan on india_yankee lima_delta (cost=0.000..67,919.110 rows=18,780 width=24) (actual rows= loops=)

  • Filter: three_uniform_kilo = 0
  • Rows out: Avg 18773.8 rows x 108 workers. Max 18877 rows (seg7) with 0.139 ms to first row, 44 ms to end, start offset by 42397 ms.
205. 0.000 0.000 ↓ 0.0

Hash (cost=17,029,434.560..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Rows in: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8645 ms to end, start offset by 42482 ms.
206. 0.000 0.000 ↓ 0.0

Subquery Scan e (cost=16,999,295.920..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8488 ms to first row, 8605 ms to end, start offset by 42482 ms.
207. 0.000 0.000 ↓ 0.0

Window (cost=16,999,295.920..17,029,434.560 rows=22,325 width=194) (actual rows= loops=)

  • Partition By: exposure_reserve.source_system, exposure_reserve.claim_number
  • Order By: exposure_reserve.sum_reserve
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8487 ms to first row, 8595 ms to end, start offset by 42482 ms.
208. 0.000 0.000 ↓ 0.0

Sort (cost=16,999,295.920..17,005,323.650 rows=22,325 width=194) (actual rows= loops=)

  • Sort Key: charlie_four.victor_bravo, charlie_four.zulu_quebec, charlie_four.hotel_lima
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8487 ms to first row, 8499 ms to end, start offset by 42482 ms.
  • Executor memory: 9721K bytes avg, 9721K bytes max (seg0).
  • Work_mem used: 9721K bytes avg, 9721K bytes max (seg0). Workfile: (0 spilling)
209. 0.000 0.000 ↓ 0.0

Subquery Scan exposure_reserve (cost=16,683,367.610..16,743,705.160 rows=22,325 width=194) (actual rows= loops=)

  • Filter: two_victor five_romeo_foxtrot NOT NULL OR delta_mike = 1
  • Rows out: Avg 38672.3 rows x 108 workers. Max 39221 rows (seg39) with 8201 ms to first row, 8365 ms to end, start offset by 42483 ms.
210. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=16,683,367.610..16,743,705.160 rows=22,348 width=194) (actual rows= loops=)

  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7030 ms to first row, 7301 ms to end, start offset by 42428 ms.
211. 0.000 0.000 ↓ 0.0

Window (cost=16,683,367.610..16,707,502.630 rows=22,348 width=194) (actual rows= loops=)

  • Partition By: coplan.source_system, coplan.claim_number
  • Order By: coplan.claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7030 ms to first row, 7237 ms to end, start offset by 42428 ms.
212. 0.000 0.000 ↓ 0.0

Sort (cost=16,683,367.610..16,689,401.370 rows=22,348 width=194) (actual rows= loops=)

  • Sort Key: yankee_india.victor_bravo, yankee_india.zulu_quebec, yankee_india.two_victor
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 7030 ms to first row, 7040 ms to end, start offset by 42428 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
213. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=16,379,233.820..16,427,503.860 rows=22,348 width=194) (actual rows= loops=)

  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6537 ms to first row, 6780 ms to end, start offset by 42428 ms.
214. 0.000 0.000 ↓ 0.0

Window (cost=16,379,233.820..16,403,368.840 rows=22,348 width=194) (actual rows= loops=)

  • Partition By: "Window".source_system, "Window".claim_number
  • Order By: "Window".claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6537 ms to first row, 6769 ms to end, start offset by 42428 ms.
215. 0.000 0.000 ↓ 0.0

Sort (cost=16,379,233.820..16,385,267.570 rows=22,348 width=194) (actual rows= loops=)

  • Sort Key: "five_romeo_quebec".victor_bravo, "five_romeo_quebec".zulu_quebec, "five_romeo_quebec".two_victor
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6537 ms to first row, 6555 ms to end, start offset by 42428 ms.
  • Executor memory: 17913K bytes avg, 17913K bytes max (seg0).
  • Work_mem used: 17913K bytes avg, 17913K bytes max (seg0). Workfile: (0 spilling)
216. 0.000 0.000 ↓ 0.0

HashAggregate (cost=16,063,032.510..16,099,235.040 rows=22,348 width=194) (actual rows= loops=)

  • Group By: pub.mv_claim_transaction_details_all.source_system, pub.mv_claim_transaction_details_all.claim_number, pub.mv_claim_transaction_details_all.claim_exposure_id
  • Rows out: Avg 63244.7 rows x 108 workers. Max 64082 rows (seg8) with 6242 ms to first row, 6335 ms to end, start offset by 42428 ms.
  • Executor memory: 7590K bytes avg, 7628K bytes max (seg0).
217. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_whiskey (cost=0.000..15,821,682.340 rows=223,473 width=43) (actual rows= loops=)

  • Filter: (victor_bravo = ANY ('charlie_zulu'::text[])) AND (xray_echo::text = ANY ('charlie_uniform'::text[])) AND (four_tango = ANY ('golf_charlie'::text[]))
  • Rows out: Avg 331465.7 rows x 108 workers. Max 336080 rows (seg8) with 328 ms to first row, 5527 ms to end, start offset by 42429 ms.
218. 0.000 0.000 ↓ 0.0

Hash (cost=115,183.620..115,183.620 rows=10,180 width=144) (actual rows= loops=)

  • Rows in: Avg 10152.3 rows x 108 workers. Max 10381 rows (seg4) with 885 ms to end, start offset by 42787 ms.
219. 0.000 0.000 ↓ 0.0

Redistribute Motion 108:108 (slice33; segments: 108) (cost=0.000..115,183.620 rows=10,180 width=144) (actual rows= loops=)

  • Hash Key: motor.claim_number::text
  • Rows out: Avg 10153.7 rows x 108 workers at destination. Max 10381 rows (seg4) with 0.072 ms to first row, 879 ms to end, start offset by 42787 ms.
220. 0.000 0.000 ↓ 0.0

Seq Scan on five_seven golf_juliet (cost=0.000..93,195.250 rows=10,180 width=144) (actual rows= loops=)

  • Filter: two_juliet = ANY ('oscar_papa'::text[])
  • Rows out: Avg 10153.7 rows x 108 workers. Max 10297 rows (seg105) with 0.174 ms to first row, 58 ms to end, start offset by 42019 ms.
221. 0.000 0.000 ↓ 0.0

Hash (cost=0.850..0.850 rows=1 width=64) (actual rows= loops=)

  • Rows in: Avg 68.0 rows x 108 workers. Max 68 rows (seg0) with 0.083 ms to end, start offset by 42848 ms.
222. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.000..0.850 rows=1 width=64) (actual rows= loops=)

  • Rows out: Avg 68.0 rows x 108 workers. Max 68 rows (seg0) with 0.012 ms to first row, 0.053 ms to end, start offset by 42848 ms.
223. 0.000 0.000 ↓ 0.0

Hash (cost=208,820.390..208,820.390 rows=76,078 width=14) (actual rows= loops=)

  • Rows in: Avg 75588.7 rows x 108 workers. Max 76291 rows (seg86) with 379 ms to end, start offset by 42437 ms.
224. 0.000 0.000 ↓ 0.0

Seq Scan on uniform_seven sierra_juliet (cost=0.000..208,820.390 rows=76,078 width=14) (actual rows= loops=)

  • Rows out: Avg 76133.1 rows x 108 workers. Max 76853 rows (seg86) with 39 ms to first row, 324 ms to end, start offset by 42437 ms.