explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tj37

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

Aggregate (cost=0.00..18,941.56 rows=1 width=8) (actual rows= loops=)

  • Rows out: 1 rows with 30665 ms to end.
  • (slice0) Executor memory: 2434K bytes.
  • (slice1) Executor memory: 183K bytes avg x 4 workers, 183K bytes max (seg0).
  • (slice2) Executor memory: 1189K bytes (entry db).
  • (slice3) Executor memory: 219K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice4) Executor memory: 219K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice5) Executor memory: 251K bytes avg x 4 workers, 251K bytes max (seg0).
  • (slice6) Executor memory: 251K bytes avg x 4 workers, 251K bytes max (seg0).
  • (slice7) Executor memory: 219K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice8) Executor memory: 219K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice9) Executor memory: 213K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice10) Executor memory: 219K bytes avg x 4 workers, 219K bytes max (seg0).
  • (slice11) Executor memory: 221K bytes avg x 4 workers, 227K bytes max (seg0).
  • (slice12) Executor memory: 235K bytes avg x 4 workers, 235K bytes max (seg0).
  • (slice13) Executor memory: 243K bytes avg x 4 workers, 243K bytes max (seg0).
  • (slice14) Executor memory: 246K bytes avg x 4 workers, 252K bytes max (seg0).
  • (slice15) Executor memory: 260K bytes avg x 4 workers, 260K bytes max (seg0).
  • (slice16) Executor memory: 262K bytes avg x 4 workers, 268K bytes max (seg0).
  • (slice17) Executor memory: 276K bytes avg x 4 workers, 276K bytes max (seg0).
  • (slice18) Executor memory: 26737K bytes avg x 4 workers, 26858K bytes max (seg3). Work_mem: 2341K bytes max.
  • (slice19) Executor memory: 294K bytes avg x 4 workers, 337K bytes max (seg1).
  • (slice20) Executor memory: 333K bytes avg x 4 workers, 333K bytes max (seg0).
  • (slice21) Executor memory: 341K bytes avg x 4 workers, 341K bytes max (seg0).
  • (slice22) Executor memory: 349K bytes avg x 4 workers, 349K bytes max (seg0).
  • (slice23) * Executor memory: 50552K bytes avg x 4 workers, 50552K bytes max (seg0). Work_mem: 16080K bytes max, 125286K bytes wanted.
  • (slice24) * Executor memory: 35245K bytes avg x 4 workers, 35245K bytes max (seg0). Work_mem: 18339K bytes max, 36633K bytes wanted.
  • Memory used: 524288K bytes
  • Memory wanted: 2763570K bytes
2. 0.000 0.000 ↓ 0.0

Gather Motion 4:1 (slice24; segments: 4) (cost=0.00..18,941.56 rows=1 width=8) (actual rows= loops=)

  • Rows out: 4 rows at destination with 30640 ms to first row, 30665 ms to end.
3. 0.000 0.000 ↓ 0.0

Aggregate (cost=0.00..18,941.56 rows=1 width=8) (actual rows= loops=)

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

Hash Join (cost=0.00..18,941.56 rows=613,495 width=1) (actual rows= loops=)

  • Hash Cond: bridge_rioolaansluiting_test.huisaansluiting_hkey::text = sat_awis_huisaansluiting.huisaansluiting_hkey::text
  • Rows out: Avg 636713.8 rows x 4 workers. Max 637336 rows (seg1) with 13464 ms to first row, 30348 ms to end.
  • Executor memory: 18317K bytes avg, 18339K bytes max (seg1).
  • Work_mem used: 18317K bytes avg, 18339K bytes max (seg1). Workfile: (4 spilling)
  • Work_mem wanted: 36609K bytes avg, 36633K bytes max (seg1) to lessen workfile I/O affecting 4 workers.
  • (seg1) Initial batch 0:
  • (seg1) Wrote 14400K bytes to inner workfile.
  • (seg1) Wrote 13696K bytes to outer workfile.
  • (seg1) Initial batch 1:
  • (seg1) Read 14409K bytes from inner workfile.
  • (seg1) Read 13704K bytes from outer workfile.
  • (seg1) Hash chain length 2.8 avg, 14 max, using 241886 of 262144 buckets.
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 4:4 (slice23; segments: 4) (cost=0.00..17,649.22 rows=613,495 width=33) (actual rows= loops=)

  • Hash Key: bridge_rioolaansluiting_test.huisaansluiting_hkey
  • Rows out: Avg 636713.8 rows x 4 workers at destination. Max 637336 rows (seg1) with 12299 ms to first row, 27832 ms to end.
6. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..17,585.85 rows=613,495 width=33) (actual rows= loops=)

  • Hash Cond: bridge_rioolaansluiting_test.project_aansl_hkey::text = vmmedw_fl.sat_awis_project.project_hkey::text
  • Rows out: Avg 636713.8 rows x 4 workers. Max 641464 rows (seg1) with 13467 ms to first row, 28022 ms to end.
  • Executor memory: 2341K bytes avg, 2341K bytes max (seg0).
  • Work_mem used: 2341K bytes avg, 2341K bytes max (seg0). Workfile: (0 spilling)
  • (seg1) Hash chain length 1.4 avg, 6 max, using 31436 of 65536 buckets.
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..16,895.34 rows=613,497 width=66) (actual rows= loops=)

  • Hash Cond: bridge_rioolaansluiting_test.project_stop_project_hkey::text = vmmedw_fl.sat_awis_project.project_hkey::text
  • Rows out: Avg 636713.8 rows x 4 workers. Max 641464 rows (seg1) with 13231 ms to first row, 27108 ms to end.
  • Executor memory: 2341K bytes avg, 2341K bytes max (seg0).
  • Work_mem used: 2341K bytes avg, 2341K bytes max (seg0). Workfile: (0 spilling)
  • (seg1) Hash chain length 1.4 avg, 6 max, using 31436 of 65536 buckets.
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..16,121.65 rows=613,499 width=99) (actual rows= loops=)

  • Hash Cond: bridge_rioolaansluiting_test.project_start_project_hkey::text = vmmedw_fl.sat_awis_project.project_hkey::text
  • Rows out: Avg 636713.8 rows x 4 workers. Max 641464 rows (seg1) with 12945 ms to first row, 26125 ms to end.
  • Executor memory: 2341K bytes avg, 2341K bytes max (seg0).
  • Work_mem used: 2341K bytes avg, 2341K bytes max (seg0). Workfile: (0 spilling)
  • (seg1) Hash chain length 1.4 avg, 6 max, using 31436 of 65536 buckets.
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..15,264.77 rows=613,501 width=132) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.streng_hkey::text = bridge_rioolaansluiting_test.streng_hkey::text AND sat_awis_streng.streng_hkey::text = bridge_rioolaansluiting_test.streng_hkey::text
  • Rows out: Avg 636713.8 rows x 4 workers. Max 641464 rows (seg1) with 12738 ms to first row, 25227 ms to end.
  • Executor memory: 15924K bytes avg, 16080K bytes max (seg1).
  • Work_mem used: 15924K bytes avg, 16080K bytes max (seg1). Workfile: (4 spilling)
  • Work_mem wanted: 124359K bytes avg, 125286K bytes max (seg1) to lessen workfile I/O affecting 4 workers.
  • (seg1) Initial batch 0:
  • (seg1) Wrote 102992K bytes to inner workfile.
  • (seg1) Wrote 7024K bytes to outer workfile.
  • (seg1) Initial batches 1..7:
  • (seg1) Read 103041K bytes from inner workfile: 14721K avg x 7 nonempty batches, 15115K max.
  • (seg1) Read 7083K bytes from outer workfile: 1012K avg x 7 nonempty batches, 1031K max.
  • (seg1) Hash chain length 11.5 avg, 327 max, using 55703 of 262144 buckets.
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..10,319.02 rows=95,120 width=66) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.streng_hkey::text = sat_awis_streng.streng_hkey::text
  • Rows out: Avg 98718.8 rows x 4 workers. Max 98923 rows (seg2) with 144 ms to first row, 11493 ms to end.
  • Executor memory: 5394K bytes avg, 5405K bytes max (seg2).
  • Work_mem used: 5394K bytes avg, 5405K bytes max (seg2). Workfile: (0 spilling)
  • (seg2) Hash chain length 1.9 avg, 10 max, using 51101 of 65536 buckets.
11. 0.000 0.000 ↓ 0.0

Redistribute Motion 4:4 (slice18; segments: 4) (cost=0.00..9,726.07 rows=94,860 width=33) (actual rows= loops=)

  • Hash Key: vmmedw_pl_test.bridge_streng_test.streng_hkey
  • Rows out: Avg 98718.8 rows x 4 workers at destination. Max 98923 rows (seg2) with 0.102 ms to first row, 11121 ms to end.
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..9,716.27 rows=94,860 width=33) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.stren_materiaal_hkey::text = sat_awis_stren_materiaal.stren_materiaal_hkey::text
  • Rows out: 394875 rows (seg3) with 981 ms to first row, 12606 ms to end.
  • Executor memory: 2K bytes avg, 2K bytes max (seg0).
  • Work_mem used: 2K bytes avg, 2K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 26 of 65536 buckets.
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..9,253.98 rows=94,860 width=66) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.adres_wijziging_reden_hkey::text = sat_awis_adres_wijziging_reden.adres_wijziging_reden_hkey::text
  • Rows out: 394875 rows (seg3) with 968 ms to first row, 11754 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 8 of 65536 buckets.
14. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..8,778.85 rows=94,860 width=99) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.afgeleid_water_type_hkey::text = sat_awis_afgeleid_water_type.afgeleid_water_type_hkey::text
  • Rows out: 394875 rows (seg3) with 967 ms to first row, 11275 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 8 of 65536 buckets.
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..8,290.86 rows=94,860 width=132) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.water_type_hkey::text = sat_awis_water_type.water_type_hkey::text
  • Rows out: 394875 rows (seg3) with 964 ms to first row, 10471 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 5 of 65536 buckets.
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..7,790.01 rows=94,860 width=165) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.zuiveringsgebied_hkey::text = sat_awis_zuiveringsgebied_lf.zuiveringsgebied_hkey::text
  • Rows out: 394875 rows (seg3) with 964 ms to first row, 9983 ms to end.
  • Executor memory: 24K bytes avg, 24K bytes max (seg0).
  • Work_mem used: 24K bytes avg, 24K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.0 avg, 2 max, using 434 of 65536 buckets.
17. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..7,275.71 rows=94,860 width=198) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.opmetingsproces_hkey::text = sat_awis_opmetingsproces.opmetingsproces_hkey::text
  • Rows out: 394875 rows (seg3) with 956 ms to first row, 9062 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 8 of 65536 buckets.
18. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..6,749.13 rows=94,860 width=231) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.nauwkeurigheid_hkey::text = sat_awis_nauwkeurigheid.nauwkeurigheid_hkey::text
  • Rows out: 394875 rows (seg3) with 955 ms to first row, 8587 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 7 of 65536 buckets.
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..6,209.69 rows=94,860 width=264) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.infr_status_hkey::text = sat_awis_infr_status.infr_status_hkey::text
  • Rows out: 394875 rows (seg3) with 954 ms to first row, 7650 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 8 of 65536 buckets.
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..5,657.38 rows=94,860 width=297) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.afvoer_type_hkey::text = sat_awis_afvoer_type.afvoer_type_hkey::text
  • Rows out: 394875 rows (seg3) with 954 ms to first row, 7126 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 10 of 65536 buckets.
21. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..5,092.21 rows=94,860 width=330) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.stren_functie_hkey::text = sat_awis_stren_functie.stren_functie_hkey::text
  • Rows out: 394875 rows (seg3) with 953 ms to first row, 6473 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 5 of 65536 buckets.
22. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..4,514.19 rows=94,860 width=363) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.stren_type_hkey::text = sat_awis_stren_type.stren_type_hkey::text
  • Rows out: 394875 rows (seg3) with 952 ms to first row, 5982 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 15 of 65536 buckets.
23. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,923.28 rows=94,860 width=396) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.project_stop_project_hkey::text = vmmedw_fl.sat_awis_project.project_hkey::text
  • Rows out: 394875 rows (seg3) with 952 ms to first row, 5187 ms to end.
  • Executor memory: 2341K bytes avg, 2341K bytes max (seg0).
  • Work_mem used: 2341K bytes avg, 2341K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.4 avg, 6 max, using 31436 of 65536 buckets.
24. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..3,262.18 rows=94,860 width=429) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.project_start_project_hkey::text = vmmedw_fl.sat_awis_project.project_hkey::text
  • Rows out: 394875 rows (seg3) with 719 ms to first row, 4333 ms to end.
  • Executor memory: 2341K bytes avg, 2341K bytes max (seg0).
  • Work_mem used: 2341K bytes avg, 2341K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.4 avg, 6 max, using 31436 of 65536 buckets.
25. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..2,588.21 rows=94,860 width=462) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.gemeente_hkey::text = sat_awis_gemeente.gemeente_hkey::text
  • Rows out: 394875 rows (seg3) with 460 ms to first row, 3201 ms to end.
  • Executor memory: 18K bytes avg, 18K bytes max (seg0).
  • Work_mem used: 18K bytes avg, 18K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.0 avg, 2 max, using 316 of 65536 buckets.
26. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,958.30 rows=94,883 width=495) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.installatie_hkey::text = sat_awis_installatie.installatie_hkey::text
  • Rows out: 394875 rows (seg3) with 459 ms to first row, 2704 ms to end.
  • Executor memory: 2K bytes avg, 2K bytes max (seg0).
  • Work_mem used: 2K bytes avg, 2K bytes max (seg0). Workfile: (0 spilling)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 22 of 65536 buckets.
27. 0.000 0.000 ↓ 0.0

Hash Join (cost=0.00..1,313.98 rows=98,719 width=528) (actual rows= loops=)

  • Hash Cond: vmmedw_pl_test.bridge_streng_test.snapshot_date = (max((max(vmmedw_pl_test.bridge_streng_test.snapshot_date))))
  • Rows out: 394875 rows (seg3) with 458 ms to first row, 1801 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)
  • (seg3) Hash chain length 1.0 avg, 1 max, using 1 of 131072 buckets.
28. 0.000 0.000 ↓ 0.0

Table Scan on bridge_streng_test (cost=0.00..491.97 rows=98,719 width=532) (actual rows= loops=)

  • Rows out: 394875 rows (seg3) with 0.127 ms to first row, 871 ms to end.
29. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 1.0 rows x 4 workers. Max 1 rows (seg0) with 452 ms to end, start offset by 794 ms.
30. 0.000 0.000 ↓ 0.0

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

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

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

  • Rows out: 1 rows with 992 ms to end.
32. 0.000 0.000 ↓ 0.0

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

  • Rows out: 4 rows at destination with 15 ms to first row, 992 ms to end.
33. 0.000 0.000 ↓ 0.0

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

  • Rows out: Avg 1.0 rows x 4 workers. Max 1 rows (seg0) with 0.148 ms to first row, 0.149 ms to end.
34. 0.000 0.000 ↓ 0.0

Table Scan on bridge_streng_test (cost=0.00..491.97 rows=98,719 width=4) (actual rows= loops=)

  • Rows out: 394875 rows (seg3) with 0.205 ms to first row, 662 ms to end.
35. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=22 width=33) (actual rows= loops=)

  • Rows in: Avg 22.0 rows x 4 workers. Max 22 rows (seg0) with 0.160 ms to end, start offset by 791 ms.
36. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice3; segments: 4) (cost=0.00..431.01 rows=22 width=33) (actual rows= loops=)

  • Rows out: Avg 22.0 rows x 4 workers at destination. Max 22 rows (seg0) with 0.088 ms to first row, 0.107 ms to end.
37. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_installatie (cost=0.00..431.00 rows=6 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 5.5 rows x 4 workers. Max 11 rows (seg0) with 0.177 ms to first row, 0.184 ms to end.
38. 0.000 0.000 ↓ 0.0

Hash (cost=431.16..431.16 rows=318 width=33) (actual rows= loops=)

  • Rows in: Avg 318.0 rows x 4 workers. Max 318 rows (seg0) with 0.648 ms to end, start offset by 789 ms.
39. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice4; segments: 4) (cost=0.00..431.16 rows=318 width=33) (actual rows= loops=)

  • Rows out: Avg 318.0 rows x 4 workers at destination. Max 318 rows (seg0) with 0.026 ms to first row, 0.215 ms to end.
40. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_gemeente (cost=0.00..431.02 rows=80 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 79.5 rows x 4 workers. Max 90 rows (seg2) with 0.162 ms to first row, 0.222 ms to end.
41. 0.000 0.000 ↓ 0.0

Hash (cost=452.36..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows in: Avg 42801.0 rows x 4 workers. Max 42801 rows (seg0) with 270 ms to end, start offset by 518 ms.
42. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice5; segments: 4) (cost=0.00..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows out: Avg 42801.0 rows x 4 workers at destination. Max 42801 rows (seg0) with 0.036 ms to first row, 236 ms to end.
43. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_project (cost=0.00..433.10 rows=10,601 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 10700.2 rows x 4 workers. Max 10781 rows (seg2) with 0.285 ms to first row, 7.159 ms to end.
44. 0.000 0.000 ↓ 0.0

Hash (cost=452.36..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows in: Avg 42801.0 rows x 4 workers. Max 42801 rows (seg0) with 218 ms to end, start offset by 300 ms.
45. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice6; segments: 4) (cost=0.00..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows out: Avg 42801.0 rows x 4 workers at destination. Max 42801 rows (seg0) with 0.047 ms to first row, 129 ms to end.
46. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_project (cost=0.00..433.10 rows=10,601 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 10700.2 rows x 4 workers. Max 10781 rows (seg2) with 0.219 ms to first row, 6.780 ms to end.
47. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=15 width=33) (actual rows= loops=)

  • Rows in: Avg 15.0 rows x 4 workers. Max 15 rows (seg0) with 0.108 ms to end, start offset by 299 ms.
48. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice7; segments: 4) (cost=0.00..431.01 rows=15 width=33) (actual rows= loops=)

  • Rows out: Avg 15.0 rows x 4 workers at destination. Max 15 rows (seg0) with 0.016 ms to first row, 0.094 ms to end.
49. 0.000 0.000 ↓ 0.0

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

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 3.8 rows x 4 workers. Max 4 rows (seg0) with 0.206 ms to first row, 0.209 ms to end.
50. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=5 width=33) (actual rows= loops=)

  • Rows in: Avg 5.0 rows x 4 workers. Max 5 rows (seg0) with 0.029 ms to end, start offset by 299 ms.
51. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice8; segments: 4) (cost=0.00..431.00 rows=5 width=33) (actual rows= loops=)

  • Rows out: Avg 5.0 rows x 4 workers at destination. Max 5 rows (seg0) with 0.015 ms to first row, 0.021 ms to end.
52. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_stren_functie (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 1.2 rows x 4 workers. Max 2 rows (seg1) with 0.893 ms to first row, 0.896 ms to end.
53. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=10 width=33) (actual rows= loops=)

  • Rows in: Avg 10.0 rows x 4 workers. Max 10 rows (seg0) with 0.036 ms to end, start offset by 298 ms.
54. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice9; segments: 4) (cost=0.00..431.01 rows=10 width=33) (actual rows= loops=)

  • Rows out: Avg 10.0 rows x 4 workers at destination. Max 10 rows (seg0) with 0.017 ms to first row, 0.023 ms to end.
55. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_afvoer_type (cost=0.00..431.00 rows=3 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 3.3 rows x 3 workers. Max 5 rows (seg1) with 0.223 ms to first row, 0.227 ms to end.
56. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 8.0 rows x 4 workers. Max 8 rows (seg0) with 0.036 ms to end, start offset by 297 ms.
57. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice10; segments: 4) (cost=0.00..431.00 rows=8 width=33) (actual rows= loops=)

  • Rows out: Avg 8.0 rows x 4 workers at destination. Max 8 rows (seg0) with 0.018 ms to first row, 0.026 ms to end.
58. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_infr_status (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 2.0 rows x 4 workers. Max 3 rows (seg1) with 0.247 ms to first row, 0.250 ms to end.
59. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=7 width=33) (actual rows= loops=)

  • Rows in: Avg 7.0 rows x 4 workers. Max 7 rows (seg0) with 0.042 ms to end, start offset by 297 ms.
60. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice11; segments: 4) (cost=0.00..431.00 rows=7 width=33) (actual rows= loops=)

  • Rows out: Avg 7.0 rows x 4 workers at destination. Max 7 rows (seg0) with 0.014 ms to first row, 0.024 ms to end.
61. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_nauwkeurigheid (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 2.3 rows x 3 workers. Max 3 rows (seg0) with 0.288 ms to first row, 0.292 ms to end.
62. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 8.0 rows x 4 workers. Max 8 rows (seg0) with 0.037 ms to end, start offset by 296 ms.
63. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice12; segments: 4) (cost=0.00..431.00 rows=8 width=33) (actual rows= loops=)

  • Rows out: Avg 8.0 rows x 4 workers at destination. Max 8 rows (seg0) with 0.020 ms to first row, 0.028 ms to end.
64. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_opmetingsproces (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 2.0 rows x 4 workers. Max 4 rows (seg0) with 0.413 ms to first row, 0.419 ms to end.
65. 0.000 0.000 ↓ 0.0

Hash (cost=431.22..431.22 rows=438 width=33) (actual rows= loops=)

  • Rows in: Avg 438.0 rows x 4 workers. Max 438 rows (seg0) with 0.514 ms to end, start offset by 295 ms.
66. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice13; segments: 4) (cost=0.00..431.22 rows=438 width=33) (actual rows= loops=)

  • Rows out: Avg 438.0 rows x 4 workers at destination. Max 438 rows (seg0) with 0.064 ms to first row, 0.276 ms to end.
67. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_zuiveringsgebied_lf (cost=0.00..431.02 rows=110 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 109.5 rows x 4 workers. Max 118 rows (seg2) with 0.224 ms to first row, 0.349 ms to end.
68. 0.000 0.000 ↓ 0.0

Hash (cost=431.00..431.00 rows=5 width=33) (actual rows= loops=)

  • Rows in: Avg 5.0 rows x 4 workers. Max 5 rows (seg0) with 0.059 ms to end, start offset by 294 ms.
69. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice14; segments: 4) (cost=0.00..431.00 rows=5 width=33) (actual rows= loops=)

  • Rows out: Avg 5.0 rows x 4 workers at destination. Max 5 rows (seg0) with 0.040 ms to first row, 0.048 ms to end.
70. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_water_type (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 1.7 rows x 3 workers. Max 3 rows (seg1) with 0.216 ms to first row, 0.230 ms to end.
71. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 8.0 rows x 4 workers. Max 8 rows (seg0) with 0.049 ms to end, start offset by 293 ms.
72. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice15; segments: 4) (cost=0.00..431.00 rows=8 width=33) (actual rows= loops=)

  • Rows out: Avg 8.0 rows x 4 workers at destination. Max 8 rows (seg0) with 0.016 ms to first row, 0.023 ms to end.
73. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_afgeleid_water_type (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 2.0 rows x 4 workers. Max 3 rows (seg0) with 0.183 ms to first row, 0.188 ms to end.
74. 0.000 0.000 ↓ 0.0

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

  • Rows in: Avg 8.0 rows x 4 workers. Max 8 rows (seg0) with 0.047 ms to end, start offset by 293 ms.
75. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice16; segments: 4) (cost=0.00..431.00 rows=8 width=33) (actual rows= loops=)

  • Rows out: Avg 8.0 rows x 4 workers at destination. Max 8 rows (seg0) with 0.015 ms to first row, 0.023 ms to end.
76. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_adres_wijziging_reden (cost=0.00..431.00 rows=2 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 2.7 rows x 3 workers. Max 4 rows (seg0) with 0.247 ms to first row, 0.251 ms to end.
77. 0.000 0.000 ↓ 0.0

Hash (cost=431.01..431.01 rows=26 width=33) (actual rows= loops=)

  • Rows in: Avg 26.0 rows x 4 workers. Max 26 rows (seg0) with 0.109 ms to end, start offset by 292 ms.
78. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice17; segments: 4) (cost=0.00..431.01 rows=26 width=33) (actual rows= loops=)

  • Rows out: Avg 26.0 rows x 4 workers at destination. Max 26 rows (seg0) with 0.047 ms to first row, 0.072 ms to end.
79. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_stren_materiaal (cost=0.00..431.00 rows=7 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 6.5 rows x 4 workers. Max 11 rows (seg2) with 0.337 ms to first row, 0.344 ms to end.
80. 0.000 0.000 ↓ 0.0

Hash (cost=463.81..463.81 rows=104,551 width=33) (actual rows= loops=)

  • Rows in: Avg 98728.0 rows x 4 workers. Max 98931 rows (seg2) with 143 ms to end, start offset by 13574 ms.
81. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_streng (cost=0.00..463.81 rows=104,551 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 98728.0 rows x 4 workers. Max 98931 rows (seg2) with 0.334 ms to first row, 70 ms to end.
82. 0.000 0.000 ↓ 0.0

Hash (cost=1,260.26..1,260.26 rows=636,714 width=165) (actual rows= loops=)

  • Rows in: Avg 79222.0 rows x 4 workers. Max 80501 rows (seg0) with 12598 ms to end, start offset by 974 ms.
83. 0.000 0.000 ↓ 0.0

Redistribute Motion 4:4 (slice19; segments: 4) (cost=0.00..1,260.26 rows=636,714 width=165) (actual rows= loops=)

  • Hash Key: bridge_rioolaansluiting_test.streng_hkey
  • Rows out: Avg 636713.8 rows x 4 workers at destination. Max 641464 rows (seg1) with 0.060 ms to first row, 11915 ms to end.
84. 0.000 0.000 ↓ 0.0

Table Scan on bridge_rioolaansluiting_test (cost=0.00..736.02 rows=636,714 width=165) (actual rows= loops=)

  • Rows out: 2546855 rows (seg1) with 0.212 ms to first row, 3120 ms to end.
85. 0.000 0.000 ↓ 0.0

Hash (cost=452.36..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows in: Avg 42801.0 rows x 4 workers. Max 42801 rows (seg0) with 184 ms to end, start offset by 790 ms.
86. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice20; segments: 4) (cost=0.00..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows out: Avg 42801.0 rows x 4 workers at destination. Max 42801 rows (seg0) with 0.053 ms to first row, 147 ms to end.
87. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_project (cost=0.00..433.10 rows=10,601 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 10700.2 rows x 4 workers. Max 10781 rows (seg2) with 0.273 ms to first row, 9.227 ms to end.
88. 0.000 0.000 ↓ 0.0

Hash (cost=452.36..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows in: Avg 42801.0 rows x 4 workers. Max 42801 rows (seg0) with 271 ms to end, start offset by 499 ms.
89. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice21; segments: 4) (cost=0.00..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows out: Avg 42801.0 rows x 4 workers at destination. Max 42801 rows (seg0) with 0.079 ms to first row, 234 ms to end.
90. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_project (cost=0.00..433.10 rows=10,601 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 10700.2 rows x 4 workers. Max 10781 rows (seg2) with 0.221 ms to first row, 7.012 ms to end.
91. 0.000 0.000 ↓ 0.0

Hash (cost=452.36..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows in: Avg 42801.0 rows x 4 workers. Max 42801 rows (seg0) with 228 ms to end, start offset by 270 ms.
92. 0.000 0.000 ↓ 0.0

Broadcast Motion 4:4 (slice22; segments: 4) (cost=0.00..452.36 rows=42,402 width=33) (actual rows= loops=)

  • Rows out: Avg 42801.0 rows x 4 workers at destination. Max 42801 rows (seg0) with 0.064 ms to first row, 175 ms to end.
93. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_project (cost=0.00..433.10 rows=10,601 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone
  • Rows out: Avg 10700.2 rows x 4 workers. Max 10781 rows (seg2) with 0.196 ms to first row, 6.862 ms to end.
94. 0.000 0.000 ↓ 0.0

Hash (cost=603.88..603.88 rows=668,195 width=33) (actual rows= loops=)

  • Rows in: Avg 334554.2 rows x 4 workers. Max 334792 rows (seg3) with 1630 ms to end, start offset by 256 ms.
95. 0.000 0.000 ↓ 0.0

Table Scan on sat_awis_huisaansluiting (cost=0.00..603.88 rows=668,195 width=33) (actual rows= loops=)

  • Filter: load_end_date = '2999-12-31 23:59:59'::timestamp without time zone AND delete_flag::text = 'N'::text
  • Rows out: Avg 669416.5 rows x 4 workers. Max 669843 rows (seg1) with 0.303 ms to first row, 622 ms to end.
Total runtime : 30,910.487 ms