Limit (cost=127466.71..127640.73 rows=100 width=4211) Local Node (actual time=185.302..185.319 rows=100 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark, r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Local Node (CPU: ex c/r=61872691441716, ex row=100, ex cyc=6187269144171648, inc cyc=624914183556157056) -> Streaming(type: LOCAL GATHER dop: 1/4) (cost=127466.71..127640.73 rows=100 width=4211) Local Node (actual time=185.300..185.304 rows=100 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark, r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Local Node (Buffers: 0) Local Node (CPU: ex c/r=6187269144119854, ex row=100, ex cyc=618726914411985408, inc cyc=618726914411985408) -> Limit (cost=127466.71..127557.20 rows=100 width=4211) Local Node[worker 0] (actual time=172.806..181.303 rows=100 loops=1) Local Node[worker 1] (actual time=1599.636..1599.636 rows=0 loops=1) Local Node[worker 2] (actual time=1594.928..1594.928 rows=0 loops=1) Local Node[worker 3] (actual time=1609.369..1609.369 rows=0 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark, r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Local Node[worker 0] (CPU: ex c/r=61872691439621, ex row=100, ex cyc=6187269143962112, inc cyc=624914182993271040) Local Node[worker 1] (CPU: ex c/r=0, ex row=0, ex cyc=2758, inc cyc=6187273399372310) Local Node[worker 2] (CPU: ex c/r=0, ex row=0, ex cyc=3294, inc cyc=6187273385145402) Local Node[worker 3] (CPU: ex c/r=0, ex row=0, ex cyc=3806, inc cyc=6187273428636568) -> Hash Join (cost=127466.71..9453464.23 rows=10306183 distinct=[1, 876749] width=4211) Local Node[worker 0] (actual time=172.804..181.272 rows=100 loops=1) Local Node[worker 1] (actual time=1599.634..1599.634 rows=0 loops=1) Local Node[worker 2] (actual time=1594.926..1594.926 rows=0 loops=1) Local Node[worker 3] (actual time=1609.367..1609.367 rows=0 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark, r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Hash Cond: ((r.test_record_id)::text = (t.test_record_id)::text) Local Node[worker 0] (Buffers: shared hit=8501 temp written=7104) Local Node[worker 1] (Buffers: shared hit=8473 temp read=7108 written=7094) Local Node[worker 2] (Buffers: shared hit=8401 temp read=7050 written=7036) Local Node[worker 3] (Buffers: shared hit=8401 temp read=7054 written=7040) Local Node[worker 0] (CPU: ex c/r=-13893484695365, ex row=221332, ex cyc=-3075072754594547712, inc cyc=618726913849308928) Local Node[worker 1] (CPU: ex c/r=-28037249175285, ex row=220901, ex cyc=-6193456380069695488, inc cyc=6187273399369552) Local Node[worker 2] (CPU: ex c/r=-28283334986165, ex row=218979, ex cyc=-6193456411935508480, inc cyc=6187273385142108) Local Node[worker 3] (CPU: ex c/r=-28263458158093, ex row=219133, ex cyc=-6193456376557419520, inc cyc=6187273428632762) -> Streaming(type: BROADCAST dop: 4/4) (cost=0.00..3856495.37 rows=41224732 width=1063) Local Node[worker 0] (actual time=0.094..8.122 rows=596 loops=1) Local Node[worker 1] (actual time=0.052..1348.566 rows=1000 loops=1) Local Node[worker 2] (actual time=0.064..1322.220 rows=1000 loops=1) Local Node[worker 3] (actual time=0.056..1351.518 rows=1000 loops=1) Output: r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Local Node[worker 0] (Buffers: 0) Local Node[worker 1] (Buffers: 0) Local Node[worker 2] (Buffers: 0) Local Node[worker 3] (Buffers: 0) Local Node[worker 0] (CPU: ex c/r=6187269126388020, ex row=596, ex cyc=3687612399327260160, inc cyc=3687612399327260160) Local Node[worker 1] (CPU: ex c/r=6193456384406750, ex row=1000, ex cyc=6193456384406750208, inc cyc=6193456384406750208) Local Node[worker 2] (CPU: ex c/r=6193456416179064, ex row=1000, ex cyc=6193456416179063808, inc cyc=6193456416179063808) Local Node[worker 3] (CPU: ex c/r=6193456380932514, ex row=1000, ex cyc=6193456380932513792, inc cyc=6193456380932513792) -> Seq Scan on mdnov.his_test_result_now r (cost=0.00..85297.21 rows=10306183 width=1063) Local Node[worker 0] (actual time=0.004..292.588 rows=2578048 loops=1) Local Node[worker 1] (actual time=0.004..280.205 rows=2575799 loops=1) Local Node[worker 2] (actual time=0.004..288.269 rows=2578456 loops=1) Local Node[worker 3] (actual time=0.003..292.520 rows=2573880 loops=1) Output: r.id, r.his_code, r.case_no, r.outp_no, r.adm_date, r.test_result_id, r.test_record_id, r.project_code, r.project_no, r.project_name, r.test_result, r.result_unit, r.is_normal, r.refer_scope, r.lis_project_code, r.synonym, r.create_by, r.create_time, r.update_by, r.update_time, r.remark Local Node[worker 0] (Buffers: shared hit=56600) Local Node[worker 1] (Buffers: shared hit=56527) Local Node[worker 2] (Buffers: shared hit=56500) Local Node[worker 3] (Buffers: shared hit=56500) Local Node[worker 0] (CPU: ex c/r=6187273552976724, ex row=2578048, ex cyc=15951088208704536838144, inc cyc=15951088208704536838144) Local Node[worker 1] (CPU: ex c/r=6187273515446786, ex row=2575799, ex cyc=15937172933814316433408, inc cyc=15937172933814316433408) Local Node[worker 2] (CPU: ex c/r=6187273611679487, ex row=2578456, ex cyc=15953612767676642361344, inc cyc=15953612767676642361344) Local Node[worker 3] (CPU: ex c/r=6187273553161473, ex row=2573880, ex cyc=15925299653011251920896, inc cyc=15925299653011251920896) -> Hash (cost=13634.87..13634.87 rows=876749 width=3148) Local Node[worker 0] (actual time=172.083..172.083 rows=220736 loops=1) Local Node[worker 1] (actual time=153.560..153.560 rows=219901 loops=1) Local Node[worker 2] (actual time=180.065..180.065 rows=217979 loops=1) Local Node[worker 3] (actual time=150.665..150.665 rows=218133 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark Local Node Buckets: 65536 Batches: 8 Memory Usage: 8884kB Local Node[worker 0] (Buffers: shared hit=8500 temp written=7096) Local Node[worker 1] (Buffers: shared hit=8472 temp written=7066) Local Node[worker 2] (Buffers: shared hit=8400 temp written=7008) Local Node[worker 3] (Buffers: shared hit=8400 temp written=7012) Local Node[worker 0] (CPU: ex c/r=-6187268859274666, ex row=220736, ex cyc=-1365752978920852684800, inc cyc=6187269116596160) Local Node[worker 1] (CPU: ex c/r=-6187268831286065, ex row=219901, ex cyc=-1360586603268636934144, inc cyc=6187269062315224) Local Node[worker 2] (CPU: ex c/r=-6187268864825285, ex row=217979, ex cyc=-1348694679885750730752, inc cyc=6187269141586886) Local Node[worker 3] (CPU: ex c/r=-6187268827271492, ex row=218133, ex cyc=-1349647511099212300288, inc cyc=6187269053538072) -> Seq Scan on mdnov.his_test_record_now t (cost=0.00..13634.87 rows=876749 width=3148) Local Node[worker 0] (actual time=0.005..44.270 rows=220736 loops=1) Local Node[worker 1] (actual time=0.005..40.457 rows=219901 loops=1) Local Node[worker 2] (actual time=0.005..46.841 rows=217979 loops=1) Local Node[worker 3] (actual time=0.005..39.273 rows=218133 loops=1) Output: t.id, t.his_code, t.test_record_id, t.apply_no, t.patient_id, t.case_no, t.outp_no, t.adm_date, t.test_date, t.test_purpose_code, t.test_purpose, t.clinical_diagnosis, t.sample_type, t.reportor, t.sample_no, t.lis_patient_id, t.is_get_patient_info, t.sample_time, t.collect_time, t.care_area, t.care_area_code, t.test_opt_code, t.test_opt_name, t.dept_code, t.dept_name, t.age, t.gender, t.patient_name, t.visit_flag, t.visit_type_name, t.paadmtype, t.deliver_doctor, t.reportor_code, t.age_unit, t.specimen_no, t.create_by, t.create_time, t.update_by, t.update_time, t.remark Local Node[worker 0] (Buffers: shared hit=8500) Local Node[worker 1] (Buffers: shared hit=8472) Local Node[worker 2] (Buffers: shared hit=8400) Local Node[worker 3] (Buffers: shared hit=8400) Local Node[worker 0] (CPU: ex c/r=6187296889451514, ex row=220736, ex cyc=1365759166189969342464, inc cyc=1365759166189969342464) Local Node[worker 1] (CPU: ex c/r=6187296967897824, ex row=219901, ex cyc=1360592790537699328000, inc cyc=1360592790537699328000) Local Node[worker 2] (CPU: ex c/r=6187297249528130, ex row=217979, ex cyc=1348700867154892292096, inc cyc=1348700867154892292096) Local Node[worker 3] (CPU: ex c/r=6187297191934580, ex row=218133, ex cyc=1349653698368265781248, inc cyc=1349653698368265781248) Total runtime: 1617.483 ms