appeals.main_profile
Y
Normal
N
1000
100
-
2024/11/11 16:52:36.340
-
2024/11/11 16:52:36.340
Table input appel-doc
Merge join
Y
Table input person-reg
Merge join
Y
Merge join
Memory group by
Y
Table input appel-doc
TableInput
Y
1
none
postgres.appeal-document-service
N
0
SELECT
recruit_id
FROM public.appeal_document
N
480
160
Table output
TableOutput
Y
1
none
1000
N
N
N
N
Y
N
N
N
Y
N
Y
1104
160
Memory group by
MemoryGroupBy
Y
1
none
N
800
160
Sort rows
SortRows
Y
1
none
N
${java.io.tmpdir}
out
1000000
N
960
160
Table input person-reg
TableInput
Y
1
none
ervu_person_registry
N
0
SELECT
recruit_id
FROM public.recruits r
JOIN public.recruits_info ri
ON ri.recruit_id = r.id
WHERE r.current_recruitment_id IS NOT NULL
AND r.target_recruitment_id IS NOT NULL
N
480
288
Merge join
MergeJoin
Y
1
none
LEFT OUTER
recruit_id
recruit_id
Table input appel-doc
Table input person-reg
640
160