explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YSD2

Settings

Optimization(s) for this plan:

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

Gather Motion 25:1 (slice24; segments: 25) (cost=2,208,299.55..2,208,300.68 rows=30 width=336) (actual rows= loops=)

  • Rows out: 24 rows at destination with 35453 ms to first row, 35456 ms to end, start offset by 6178 ms.
  • (slice0) Executor memory: 2511K bytes.
  • (slice1) Executor memory: 8609K bytes avg x 25 workers, 8609K bytes max (seg0).
  • (slice2) Executor memory: 2841K bytes avg x 25 workers, 3028K bytes max (seg4). Work_mem: 44K bytes max.
  • (slice3) Executor memory: 2012K bytes avg x 25 workers, 2029K bytes max (seg18).
  • (slice4) Executor memory: 74745K bytes avg x 25 workers, 82282K bytes max (seg11).
  • (slice5) Executor memory: 1409K bytes avg x 25 workers, 1409K bytes max (seg0).
  • (slice6) Executor memory: 3189K bytes avg x 25 workers, 3189K bytes max (seg0). Work_mem: 44K bytes max.
  • (slice7) Executor memory: 7788K bytes avg x 25 workers, 8618K bytes max (seg4).
  • (slice8) Executor memory: 1468K bytes avg x 25 workers, 1468K bytes max (seg0).
  • (slice9) Executor memory: 2011K bytes avg x 25 workers, 2042K bytes max (seg2).
  • (slice10) Executor memory: 451577K bytes avg x 25 workers, 467306K bytes max (seg12).
  • (slice11) Executor memory: 2961K bytes avg x 25 workers, 2961K bytes max (seg0). Work_mem: 100K bytes max.
  • (slice12) Executor memory: 1425K bytes avg x 25 workers, 1425K bytes max (seg0).
  • (slice13) Executor memory: 3025K bytes avg x 25 workers, 3025K bytes max (seg0). Work_mem: 44K bytes max.
  • (slice14) Executor memory: 451937K bytes avg x 25 workers, 475530K bytes max (seg13).
  • (slice15) Executor memory: 2994K bytes avg x 25 workers, 2994K bytes max (seg0). Work_mem: 100K bytes max.
  • (slice16) Executor memory: 1458K bytes avg x 25 workers, 1458K bytes max (seg0).
  • (slice17) Executor memory: 1670K bytes avg x 25 workers, 1677K bytes max (seg2).
  • (slice18) Executor memory: 12238K bytes avg x 25 workers, 12238K bytes max (seg0). Work_mem: 4590K bytes max.
  • (slice19) Executor memory: 2618K bytes avg x 25 workers, 4539K bytes max (seg13).
  • (slice20) Executor memory: 452713K bytes avg x 25 workers, 476015K bytes max (seg13). Work_mem: 56K bytes max.
  • (slice21) Executor memory: 1498K bytes avg x 25 workers, 1498K bytes max (seg0).
  • (slice22) Executor memory: 3542K bytes avg x 25 workers, 3542K bytes max (seg0). Work_mem: 44K bytes max.
  • (slice23) Executor memory: 2207K bytes avg x 25 workers, 2268K bytes max (seg0).
  • (slice24) Executor memory: 1508K bytes avg x 25 workers, 1540K bytes max (seg0).
  • Memory used: 128000K bytes
2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,208,299.55..2,208,300.68 rows=2 width=336) (actual rows= loops=)

  • Group By: paragone.org_id
  • Rows out: Avg 1.6 rows x 15 workers. Max 3 rows (seg0) with 35441 ms to end, start offset by 6191 ms.
  • Executor memory: 188K bytes avg, 217K bytes max (seg0).
3. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice23; segments: 25) (cost=2,208,297.75..2,208,298.35 rows=2 width=336) (actual rows= loops=)

  • Hash Key: paragone.org_id
  • Rows out: Avg 1.6 rows x 15 workers at destination. Max 3 rows (seg0) with 35438 ms to first row, 35440 ms to end, start offset by 6191 ms.
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,208,297.75..2,208,297.75 rows=2 width=336) (actual rows= loops=)

  • Group By: "?column1?
  • Rows out: Avg 1.6 rows x 15 workers. Max 3 rows (seg0) with 35383 ms to end, start offset by 6246 ms.
  • Executor memory: 188K bytes avg, 217K bytes max (seg0).
5. 0.000 0.000 ↓ 0.0

Append (cost=31,962.27..2,208,296.55 rows=2 width=60) (actual rows= loops=)

  • Rows out: Avg 4.9 rows x 15 workers. Max 11 rows (seg0) with 1665 ms to first row, 35382 ms to end, start offset by 6246 ms.
6. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 1" (cost=31,962.27..31,962.30 rows=1 width=56) (actual rows= loops=)

  • Rows out: Avg 1.7 rows x 12 workers. Max 3 rows (seg0) with 1665 ms to end, start offset by 6246 ms.
7. 0.000 0.000 ↓ 0.0

HashAggregate (cost=31,962.27..31,962.29 rows=1 width=56) (actual rows= loops=)

  • Group By: rsccallplan.org_id
  • Rows out: Avg 1.7 rows x 12 workers. Max 3 rows (seg0) with 1665 ms to end, start offset by 6246 ms.
  • Executor memory: 307K bytes avg, 345K bytes max (seg0).
8. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice3; segments: 25) (cost=31,962.24..31,962.26 rows=1 width=16) (actual rows= loops=)

  • Hash Key: rsccallplan.org_id
  • Rows out: Avg 3.4 rows x 12 workers at destination. Max 7 rows (seg0) with 1657 ms to first row, 1665 ms to end, start offset by 6247 ms.
9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=31,962.24..31,962.24 rows=1 width=16) (actual rows= loops=)

  • Group By: rsccallplan.org_id
  • Rows out: Avg 1.8 rows x 23 workers. Max 5 rows (seg7) with 1229 ms to end, start offset by 6363 ms.
  • Executor memory: 595K bytes avg, 601K bytes max (seg0).
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9,412.09..31,962.20 rows=1 width=16) (actual rows= loops=)

  • Join Filter: employee.position_id = "position".id
  • Rows out: Avg 63.0 rows x 23 workers. Max 437 rows (seg4) with 1048 ms to first row, 1662 ms to end, start offset by 6243 ms.
11. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice2; segments: 25) (cost=9,165.44..25,597.99 rows=59 width=20) (actual rows= loops=)

  • Rows out: Avg 2444.0 rows x 25 workers at destination. Max 2444 rows (seg0) with 838 ms to first row, 1658 ms to end, start offset by 6240 ms.
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=9,165.44..25,582.88 rows=3 width=20) (actual rows= loops=)

  • Hash Cond: rsccallplan.creator_id = employee.id
  • Rows out: Avg 97.8 rows x 25 workers. Max 269 rows (seg4) with 131 ms to first row, 1661 ms to end, start offset by 6237 ms.
  • Executor memory: 42K bytes avg, 44K bytes max (seg7).
  • Work_mem used: 42K bytes avg, 44K bytes max (seg7). Workfile: (0 spilling, 0 reused)
  • (seg4) Hash chain length 1.0 avg, 2 max, using 1023 of 16417 buckets.
13. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice1; segments: 25) (cost=0.00..16,416.57 rows=3 width=24) (actual rows= loops=)

  • Hash Key: rsccallplan.creator_id
  • Rows out: Avg 97.8 rows x 25 workers at destination. Max 269 rows (seg4) with 75 ms to first row, 1605 ms to end, start offset by 6292 ms.
14. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_callplan rsccallplan (cost=0.00..16,415.41 rows=3 width=24) (actual rows= loops=)

  • Filter: deleteflag = 0 AND substr(calltime::text, 1, 8) = '20190813'::text AND status = 0
  • Rows out: Avg 97.8 rows x 25 workers. Max 121 rows (seg3) with 391 ms to first row, 415 ms to end, start offset by 6190 ms.
15. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.53..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows in: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 58 ms to end, start offset by 6353 ms.
16. 0.000 0.000 ↓ 0.0

Seq Scan on portal_employee employee (cost=0.00..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows out: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 0.097 ms to first row, 57 ms to end, start offset by 6353 ms.
17. 0.000 0.000 ↓ 0.0

Materialize (cost=246.65..248.52 rows=8 width=8) (actual rows= loops=)

  • Rows out: Avg 17987.8 rows x 25 workers. Max 31772 rows (seg7) with 0.410 ms to first row, 3.614 ms to end of 2444 scans, start offset by 7591 ms.
18. 0.000 0.000 ↓ 0.0

Seq Scan on portal_position "position" (cost=0.00..246.46 rows=8 width=8) (actual rows= loops=)

  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 7.4 rows x 25 workers. Max 13 rows (seg7) with 0.201 ms to first row, 0.413 ms to end, start offset by 6763 ms.
19. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 2" (cost=399,215.85..399,215.87 rows=1 width=60) (actual rows= loops=)

  • Rows out: Avg 1.6 rows x 13 workers. Max 3 rows (seg0) with 8085 ms to end, start offset by 7912 ms.
20. 0.000 0.000 ↓ 0.0

HashAggregate (cost=399,215.85..399,215.86 rows=1 width=60) (actual rows= loops=)

  • Group By: rscintention.org_id
  • Rows out: Avg 1.6 rows x 13 workers. Max 3 rows (seg0) with 8085 ms to end, start offset by 7912 ms.
  • Executor memory: 310K bytes avg, 345K bytes max (seg0).
21. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice6; segments: 25) (cost=399,215.81..399,215.83 rows=1 width=24) (actual rows= loops=)

  • Hash Key: rscintention.org_id
  • Rows out: Avg 11.5 rows x 13 workers at destination. Max 30 rows (seg1) with 8080 ms to first row, 8085 ms to end, start offset by 7912 ms.
22. 0.000 0.000 ↓ 0.0

HashAggregate (cost=399,215.81..399,215.81 rows=1 width=24) (actual rows= loops=)

  • Group By: rscintention.org_id
  • Rows out: Avg 6.0 rows x 25 workers. Max 11 rows (seg18) with 9496 ms to first row, 9500 ms to end, start offset by 6442 ms.
  • Executor memory: 345K bytes avg, 345K bytes max (seg0).
23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9,465.27..399,215.35 rows=3 width=20) (actual rows= loops=)

  • Join Filter: employee.position_id = "position".id
  • Rows out: Avg 153.0 rows x 25 workers. Max 273 rows (seg17) with 5337 ms to first row, 9293 ms to end, start offset by 6645 ms.
24. 0.000 0.000 ↓ 0.0

Hash Join (cost=9,165.44..68,020.56 rows=126 width=24) (actual rows= loops=)

  • Hash Cond: rscintention.creator_id = employee.id
  • Rows out: Avg 171.4 rows x 25 workers. Max 299 rows (seg17) with 5116 ms to first row, 9053 ms to end, start offset by 6867 ms.
  • Executor memory: 42K bytes avg, 44K bytes max (seg7).
  • Work_mem used: 42K bytes avg, 44K bytes max (seg7). Workfile: (0 spilling, 0 reused)
  • (seg17) Hash chain length 1.0 avg, 2 max, using 1056 of 16417 buckets.
25. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice4; segments: 25) (cost=0.00..58,807.99 rows=126 width=28) (actual rows= loops=)

  • Hash Key: rscintention.creator_id
  • Rows out: Avg 175.3 rows x 25 workers at destination. Max 345 rows (seg9) with 5094 ms to first row, 9038 ms to end, start offset by 6627 ms.
26. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_intention rscintention (cost=0.00..58,745.15 rows=126 width=28) (actual rows= loops=)

  • Filter: deleteflag = 0 AND track_status = 0
  • Rows out: Avg 175.3 rows x 25 workers. Max 204 rows (seg10) with 610 ms to first row, 5793 ms to end, start offset by 5995 ms.
27. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.53..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows in: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 35 ms to end, start offset by 6603 ms.
28. 0.000 0.000 ↓ 0.0

Seq Scan on portal_employee employee (cost=0.00..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows out: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 0.070 ms to first row, 35 ms to end, start offset by 6603 ms.
29. 0.000 0.000 ↓ 0.0

Materialize (cost=299.82..346.63 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 31546.0 rows x 25 workers. Max 55017 rows (seg17) with 221 ms to first row, 227 ms to end of 300 scans, start offset by 15938 ms.
30. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice5; segments: 25) (cost=0.00..295.14 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 184.0 rows x 25 workers at destination. Max 184 rows (seg0) with 0.031 ms to first row, 686 ms to end, start offset by 6233 ms.
31. 0.000 0.000 ↓ 0.0

Seq Scan on portal_position "position" (cost=0.00..246.46 rows=8 width=8) (actual rows= loops=)

  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 7.4 rows x 25 workers. Max 13 rows (seg7) with 0.337 ms to first row, 0.491 ms to end, start offset by 5886 ms.
32. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 3" (cost=219,470.33..219,470.35 rows=1 width=52) (actual rows= loops=)

  • Rows out: Avg 1.1 rows x 8 workers. Max 2 rows (seg0) with 0.201 ms to first row, 0.262 ms to end, start offset by 15997 ms.
33. 0.000 0.000 ↓ 0.0

HashAggregate (cost=219,470.33..219,470.34 rows=1 width=52) (actual rows= loops=)

  • Group By: rscsatisfy.org_id
  • Rows out: Avg 1.1 rows x 8 workers. Max 2 rows (seg0) with 0.190 ms to first row, 0.249 ms to end, start offset by 15997 ms.
  • Executor memory: 296K bytes avg, 345K bytes max (seg0).
34. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice9; segments: 25) (cost=219,470.29..219,470.31 rows=1 width=12) (actual rows= loops=)

  • Hash Key: rscsatisfy.org_id
  • Rows out: Avg 1.2 rows x 8 workers at destination. Max 3 rows (seg0) with 0.016 ms to first row, 0.038 ms to end, start offset by 15997 ms.
35. 0.000 0.000 ↓ 0.0

HashAggregate (cost=219,470.29..219,470.29 rows=1 width=12) (actual rows= loops=)

  • Group By: rscsatisfy.org_id
  • Rows out: Avg 1.2 rows x 8 workers. Max 2 rows (seg7) with 911 ms to end, start offset by 6371 ms.
  • Executor memory: 552K bytes avg, 601K bytes max (seg2).
36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..219,470.25 rows=1 width=8) (actual rows= loops=)

  • Rows out: Avg 2.5 rows x 8 workers. Max 8 rows (seg7) with 908 ms to first row, 910 ms to end, start offset by 6371 ms.
37. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice8; segments: 25) (cost=0.00..218,499.87 rows=39 width=12) (actual rows= loops=)

  • Rows out: Avg 20.0 rows x 25 workers at destination. Max 20 rows (seg0) with 1365 ms to first row, 1366 ms to end, start offset by 6231 ms.
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..218,489.98 rows=2 width=12) (actual rows= loops=)

  • Rows out: Avg 1.3 rows x 15 workers. Max 3 rows (seg15) with 2.791 ms to first row, 909 ms to end, start offset by 6632 ms.
39. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice7; segments: 25) (cost=0.00..30,122.17 rows=39 width=12) (actual rows= loops=)

  • Rows out: Avg 20.0 rows x 25 workers at destination. Max 20 rows (seg0) with 110 ms to first row, 1349 ms to end, start offset by 6244 ms.
40. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_satisfy_survey rscsatisfy (cost=0.00..30,112.28 rows=2 width=12) (actual rows= loops=)

  • Filter: deleteflag = 0 AND input_time::text >= '20190801000000'::text AND input_time::text <= '20190813235959'::text AND visit_status = 1
  • Rows out: Avg 1.4 rows x 14 workers. Max 3 rows (seg14) with 209 ms to first row, 334 ms to end, start offset by 6195 ms.
41. 0.000 0.000 ↓ 0.0

Index Scan using portal_employee_pkey on portal_employee employee (cost=0.00..197.95 rows=1 width=12) (actual rows= loops=)

  • Index Cond: rscsatisfy.creator_id = employee.id
  • Rows out: Avg 1.3 rows x 15 workers. Max 3 rows (seg15) with 0.062 ms to first row, 3.388 ms to end of 20 scans, start offset by 7542 ms.
42. 0.000 0.000 ↓ 0.0

Index Scan using portal_position_pkey on portal_position "position" (cost=0.00..1.01 rows=1 width=8) (actual rows= loops=)

  • Index Cond: employee.position_id = "position".id
  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 2.5 rows x 8 workers. Max 8 rows (seg7) with 0.137 ms to first row, 0.245 ms to end of 20 scans, start offset by 7279 ms.
43. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 4" (cost=309,963.25..309,963.52 rows=1 width=68) (actual rows= loops=)

  • Rows out: 0 rows (seg0) with 25634 ms to end, start offset by 15753 ms.
44. 0.000 0.000 ↓ 0.0

HashAggregate (cost=309,963.25..309,963.43 rows=1 width=68) (actual rows= loops=)

  • Group By: rsccustomer.org_id
  • Rows out: 0 rows (seg0) with 25634 ms to end, start offset by 15753 ms.
  • Executor memory: 145K bytes avg, 145K bytes max (seg0).
45. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice13; segments: 25) (cost=309,962.78..309,963.05 rows=1 width=40) (actual rows= loops=)

  • Hash Key: rsccustomer.org_id
  • Rows out: 0 rows at destination (seg0) with 25634 ms to end, start offset by 15753 ms.
46. 0.000 0.000 ↓ 0.0

HashAggregate (cost=309,962.78..309,962.87 rows=1 width=40) (actual rows= loops=)

  • Group By: rsccustomer.org_id
  • Rows out: 0 rows (seg0) with 35397 ms to end, start offset by 6230 ms.
  • Executor memory: 145K bytes avg, 145K bytes max (seg0).
47. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,282.14..309,962.66 rows=1 width=20) (actual rows= loops=)

  • Join Filter: employee.position_id = "position".id
  • Rows out: 0 rows (seg0) with 35397 ms to end, start offset by 6230 ms.
48. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,982.31..259,008.96 rows=20 width=24) (actual rows= loops=)

  • Hash Cond: rsccustomer.creator_id = employee.id
  • Rows out: 0 rows (seg0) with 34716 ms to end, start offset by 6671 ms.
  • Executor memory: 42K bytes avg, 44K bytes max (seg7).
  • Work_mem used: 42K bytes avg, 44K bytes max (seg7). Workfile: (0 spilling, 0 reused)
49. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice11; segments: 25) (cost=3,816.87..249,836.30 rows=20 width=28) (actual rows= loops=)

  • Hash Key: rsccustomer.creator_id
  • Rows out: 0 rows at destination (seg0) with 34697 ms to end, start offset by 6616 ms.
50. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,816.87..249,826.68 rows=20 width=28) (actual rows= loops=)

  • Hash Cond: rscejob.customer_id = rsccustomer.customer_id
  • Rows out: 0 rows (seg0) with 35420 ms to end, start offset by 6206 ms.
  • Executor memory: 98K bytes avg, 100K bytes max (seg24).
  • Work_mem used: 98K bytes avg, 100K bytes max (seg24). Workfile: (0 spilling, 0 reused)
51. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice10; segments: 25) (cost=0.00..245,893.83 rows=1,298 width=20) (actual rows= loops=)

  • Rows out: 0 rows at destination (seg0) with 35394 ms to end, start offset by 5989 ms.
52. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_ejob rscejob (cost=0.00..245,556.40 rows=52 width=20) (actual rows= loops=)

  • Filter: deleteflag = 0 AND status = 0
  • Rows out: 0 rows (seg0) with 35138 ms to end, start offset by 6427 ms.
53. 0.000 0.000 ↓ 0.0

Hash (cost=3,263.80..3,263.80 rows=1,770 width=24) (actual rows= loops=)

  • Rows in: Avg 1775.2 rows x 25 workers. Max 1823 rows (seg24) with 48 ms to end, start offset by 6456 ms.
54. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_customer rsccustomer (cost=0.00..3,263.80 rows=1,770 width=24) (actual rows= loops=)

  • Filter: valid_status = 1 AND service_version = 1
  • Rows out: Avg 1775.2 rows x 25 workers. Max 1823 rows (seg24) with 15 ms to first row, 47 ms to end, start offset by 6456 ms.
55. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.53..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows in: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 37 ms to end, start offset by 6601 ms.
56. 0.000 0.000 ↓ 0.0

Seq Scan on portal_employee employee (cost=0.00..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows out: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 0.102 ms to first row, 36 ms to end, start offset by 6601 ms.
57. 0.000 0.000 ↓ 0.0

Materialize (cost=299.82..346.63 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 1.0 rows x 25 workers. Max 1 rows (seg0) with 685 ms to end, start offset by 6230 ms.
58. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice12; segments: 25) (cost=0.00..295.14 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 184.0 rows x 25 workers at destination. Max 184 rows (seg0) with 0.024 ms to first row, 685 ms to end, start offset by 6230 ms.
59. 0.000 0.000 ↓ 0.0

Seq Scan on portal_position "position" (cost=0.00..246.46 rows=8 width=8) (actual rows= loops=)

  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 7.4 rows x 25 workers. Max 13 rows (seg7) with 0.183 ms to first row, 0.280 ms to end, start offset by 6100 ms.
60. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 5" (cost=398,327.07..398,327.46 rows=1 width=56) (actual rows= loops=)

  • Rows out: 0 rows (seg0) with 0.343 ms to end, start offset by 41570 ms.
61. 0.000 0.000 ↓ 0.0

HashAggregate (cost=398,327.07..398,327.29 rows=1 width=56) (actual rows= loops=)

  • Group By: rsccustomer.org_id
  • Rows out: 0 rows (seg0) with 0.342 ms to end, start offset by 41570 ms.
  • Executor memory: 273K bytes avg, 273K bytes max (seg0).
62. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice18; segments: 25) (cost=398,326.48..398,326.82 rows=1 width=16) (actual rows= loops=)

  • Hash Key: rsccustomer.org_id
  • Rows out: 0 rows at destination (seg0) with 0.059 ms to end, start offset by 41387 ms.
63. 0.000 0.000 ↓ 0.0

HashAggregate (cost=398,326.48..398,326.48 rows=1 width=16) (actual rows= loops=)

  • Group By: rsccustomer.org_id
  • Rows out: 0 rows (seg0) with 35314 ms to end, start offset by 6241 ms.
  • Executor memory: 529K bytes avg, 529K bytes max (seg0).
64. 0.000 0.000 ↓ 0.0

Hash Left Anti Semi Join (Not-In) (cost=101,645.67..398,326.39 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: rscejob.id = "NotIn_SUBQUERY".rsc_ejob_id
  • Rows out: 0 rows (seg0) with 35311 ms to end, start offset by 6243 ms.
  • Executor memory: 4590K bytes avg, 4590K bytes max (seg0).
  • Work_mem used: 4590K bytes avg, 4590K bytes max (seg0). Workfile: (0 spilling, 0 reused)
65. 0.000 0.000 ↓ 0.0

Nested Loop (cost=13,282.14..309,962.66 rows=1 width=16) (actual rows= loops=)

  • Join Filter: employee.position_id = "position".id
  • Rows out: 0 rows (seg0) with 34544 ms to end, start offset by 6758 ms.
66. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,982.31..259,008.96 rows=20 width=20) (actual rows= loops=)

  • Hash Cond: rsccustomer.creator_id = employee.id
  • Rows out: 0 rows (seg0) with 34543 ms to end, start offset by 6759 ms.
  • Executor memory: 42K bytes avg, 44K bytes max (seg7).
  • Work_mem used: 42K bytes avg, 44K bytes max (seg7). Workfile: (0 spilling, 0 reused)
67. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice15; segments: 25) (cost=3,816.87..249,836.30 rows=20 width=24) (actual rows= loops=)

  • Hash Key: rsccustomer.creator_id
  • Rows out: 0 rows at destination (seg0) with 34521 ms to end, start offset by 6707 ms.
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,816.87..249,826.68 rows=20 width=24) (actual rows= loops=)

  • Hash Cond: rscejob.customer_id = rsccustomer.customer_id
  • Rows out: 0 rows (seg0) with 35309 ms to end, start offset by 6230 ms.
  • Executor memory: 98K bytes avg, 100K bytes max (seg24).
  • Work_mem used: 98K bytes avg, 100K bytes max (seg24). Workfile: (0 spilling, 0 reused)
69. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice14; segments: 25) (cost=0.00..245,893.83 rows=1,298 width=16) (actual rows= loops=)

  • Rows out: 0 rows at destination (seg0) with 35292 ms to end, start offset by 6191 ms.
70. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_ejob rscejob (cost=0.00..245,556.40 rows=52 width=16) (actual rows= loops=)

  • Filter: deleteflag = 0 AND id IS NOT NULL AND status = 0
  • Rows out: 0 rows (seg0) with 35047 ms to end, start offset by 6434 ms.
71. 0.000 0.000 ↓ 0.0

Hash (cost=3,263.80..3,263.80 rows=1,770 width=24) (actual rows= loops=)

  • Rows in: Avg 1775.2 rows x 25 workers. Max 1823 rows (seg24) with 38 ms to end, start offset by 6453 ms.
72. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_customer rsccustomer (cost=0.00..3,263.80 rows=1,770 width=24) (actual rows= loops=)

  • Filter: valid_status = 1 AND service_version = 1
  • Rows out: Avg 1775.2 rows x 25 workers. Max 1823 rows (seg24) with 10 ms to first row, 37 ms to end, start offset by 6453 ms.
73. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.53..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows in: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 66 ms to end, start offset by 6688 ms.
74. 0.000 0.000 ↓ 0.0

Seq Scan on portal_employee employee (cost=0.00..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows out: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 0.084 ms to first row, 65 ms to end, start offset by 6688 ms.
75. 0.000 0.000 ↓ 0.0

Materialize (cost=299.82..346.63 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 1.0 rows x 25 workers. Max 1 rows (seg0) with 0.276 ms to end, start offset by 7003 ms.
76. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice16; segments: 25) (cost=0.00..295.14 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 184.0 rows x 25 workers at destination. Max 184 rows (seg0) with 0.007 ms to first row, 0.083 ms to end, start offset by 7003 ms.
77. 0.000 0.000 ↓ 0.0

Seq Scan on portal_position "position" (cost=0.00..246.46 rows=8 width=8) (actual rows= loops=)

  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 7.4 rows x 25 workers. Max 13 rows (seg7) with 1.336 ms to first row, 1.433 ms to end, start offset by 6124 ms.
78. 0.000 0.000 ↓ 0.0

Hash (cost=42,285.72..42,285.72 rows=147,449 width=8) (actual rows= loops=)

  • Rows in: Avg 146862.0 rows x 25 workers. Max 146862 rows (seg0) with 756 ms to end, start offset by 6247 ms.
79. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice17; segments: 25) (cost=0.00..42,285.72 rows=147,449 width=8) (actual rows= loops=)

  • Rows out: Avg 146862.0 rows x 25 workers at destination. Max 146862 rows (seg0) with 0.162 ms to first row, 694 ms to end, start offset by 6247 ms.
80. 0.000 0.000 ↓ 0.0

Subquery Scan "NotIn_SUBQUERY" (cost=0.00..3,948.98 rows=5,898 width=8) (actual rows= loops=)

  • Rows out: Avg 5874.5 rows x 25 workers. Max 5896 rows (seg24) with 0.205 ms to first row, 9.507 ms to end, start offset by 6449 ms.
81. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_ejob_label ejoblabel (cost=0.00..2,474.49 rows=5,898 width=8) (actual rows= loops=)

  • Rows out: Avg 5874.5 rows x 25 workers. Max 5896 rows (seg24) with 0.202 ms to first row, 7.725 ms to end, start offset by 6449 ms.
82. 0.000 0.000 ↓ 0.0

Subquery Scan "*SELECT* 6" (cost=849,357.04..849,357.06 rows=1 width=56) (actual rows= loops=)

  • Rows out: Avg 1.6 rows x 15 workers. Max 3 rows (seg0) with 0.203 ms to first row, 0.237 ms to end, start offset by 41629 ms.
83. 0.000 0.000 ↓ 0.0

HashAggregate (cost=849,357.04..849,357.05 rows=1 width=56) (actual rows= loops=)

  • Group By: ejobcandidate.org_id
  • Rows out: Avg 1.6 rows x 15 workers. Max 3 rows (seg0) with 0.200 ms to first row, 0.231 ms to end, start offset by 41629 ms.
  • Executor memory: 316K bytes avg, 345K bytes max (seg0).
84. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice22; segments: 25) (cost=849,357.00..849,357.02 rows=1 width=16) (actual rows= loops=)

  • Hash Key: ejobcandidate.org_id
  • Rows out: Avg 8.7 rows x 15 workers at destination. Max 22 rows (seg1) with 0.008 ms to first row, 0.042 ms to end, start offset by 41629 ms.
85. 0.000 0.000 ↓ 0.0

HashAggregate (cost=849,357.00..849,357.00 rows=1 width=16) (actual rows= loops=)

  • Group By: ejobcandidate.org_id
  • Rows out: Avg 5.2 rows x 25 workers. Max 10 rows (seg15) with 34992 ms to end, start offset by 6436 ms.
  • Executor memory: 601K bytes avg, 601K bytes max (seg0).
86. 0.000 0.000 ↓ 0.0

Nested Loop (cost=109,664.24..849,356.53 rows=4 width=16) (actual rows= loops=)

  • Join Filter: employee.position_id = "position".id
  • Rows out: Avg 149.8 rows x 25 workers. Max 792 rows (seg15) with 20561 ms to first row, 34991 ms to end, start offset by 6436 ms.
87. 0.000 0.000 ↓ 0.0

Hash Join (cost=109,364.41..344,723.67 rows=192 width=20) (actual rows= loops=)

  • Hash Cond: ejobcandidate.creator_id = employee.id
  • Rows out: Avg 157.4 rows x 25 workers. Max 792 rows (seg15) with 20115 ms to first row, 34501 ms to end, start offset by 6882 ms.
  • Executor memory: 42K bytes avg, 44K bytes max (seg7).
  • Work_mem used: 42K bytes avg, 44K bytes max (seg7). Workfile: (0 spilling, 0 reused)
  • (seg15) Hash chain length 1.0 avg, 2 max, using 1055 of 16417 buckets.
88. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice20; segments: 25) (cost=100,198.97..335,486.40 rows=192 width=24) (actual rows= loops=)

  • Hash Key: ejobcandidate.creator_id
  • Rows out: Avg 157.4 rows x 25 workers at destination. Max 792 rows (seg15) with 20070 ms to first row, 34453 ms to end, start offset by 6927 ms.
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=100,198.97..335,390.62 rows=192 width=24) (actual rows= loops=)

  • Hash Cond: rscejob.id = ejobcandidate.rsc_ejob_id
  • Rows out: Avg 157.4 rows x 25 workers. Max 302 rows (seg11) with 18289 ms to first row, 23133 ms to end, start offset by 6438 ms.
  • Executor memory: 39K bytes avg, 56K bytes max (seg11).
  • Work_mem used: 39K bytes avg, 56K bytes max (seg11). Workfile: (0 spilling, 0 reused)
  • (seg11) Hash chain length 5.9 avg, 190 max, using 172 of 16417 buckets.
  • (seg13) Hash chain length 4.8 avg, 70 max, using 164 of 16417 buckets.
90. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_ejob rscejob (cost=0.00..231,272.37 rows=61,751 width=8) (actual rows= loops=)

  • Filter: kind = ANY ('{1,8,9}'::integer[])
  • Rows out: Avg 62231.0 rows x 25 workers. Max 62652 rows (seg19) with 6.761 ms to first row, 32071 ms to end, start offset by 7146 ms.
91. 0.000 0.000 ↓ 0.0

Hash (cost=99,755.89..99,755.89 rows=1,418 width=32) (actual rows= loops=)

  • Rows in: Avg 709.8 rows x 25 workers. Max 1015 rows (seg11) with 515 ms to end, start offset by 6438 ms.
92. 0.000 0.000 ↓ 0.0

Redistribute Motion 25:25 (slice19; segments: 25) (cost=0.00..99,755.89 rows=1,418 width=32) (actual rows= loops=)

  • Hash Key: ejobcandidate.rsc_ejob_id
  • Rows out: Avg 709.8 rows x 25 workers at destination. Max 1015 rows (seg11) with 0.031 ms to first row, 515 ms to end, start offset by 6438 ms.
93. 0.000 0.000 ↓ 0.0

Seq Scan on rsc_ejob_candidate ejobcandidate (cost=0.00..99,046.95 rows=1,418 width=32) (actual rows= loops=)

  • Filter: deleteflag = 0 AND createtime::text >= '20190715000000'::text AND createtime::text <= '20190813235959'::text
  • Rows out: Avg 709.8 rows x 25 workers. Max 772 rows (seg13) with 185 ms to first row, 355 ms to end, start offset by 6193 ms.
94. 0.000 0.000 ↓ 0.0

Hash (cost=8,843.53..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows in: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 55 ms to end, start offset by 6619 ms.
95. 0.000 0.000 ↓ 0.0

Seq Scan on portal_employee employee (cost=0.00..8,843.53 rows=1,031 width=12) (actual rows= loops=)

  • Rows out: Avg 1067.2 rows x 25 workers. Max 1104 rows (seg7) with 0.070 ms to first row, 54 ms to end, start offset by 6619 ms.
96. 0.000 0.000 ↓ 0.0

Materialize (cost=299.82..346.63 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 28955.2 rows x 25 workers. Max 145729 rows (seg15) with 446 ms to first row, 460 ms to end of 793 scans, start offset by 41426 ms.
97. 0.000 0.000 ↓ 0.0

Broadcast Motion 25:25 (slice21; segments: 25) (cost=0.00..295.14 rows=188 width=8) (actual rows= loops=)

  • Rows out: Avg 184.0 rows x 25 workers at destination. Max 184 rows (seg0) with 0.024 ms to first row, 697 ms to end, start offset by 6237 ms.
98. 0.000 0.000 ↓ 0.0

Seq Scan on portal_position "position" (cost=0.00..246.46 rows=8 width=8) (actual rows= loops=)

  • Filter: position_channel::text = 'A0000603'::text
  • Rows out: Avg 7.4 rows x 25 workers. Max 13 rows (seg7) with 1.268 ms to first row, 1.465 ms to end, start offset by 5940 ms.