explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KJdp

Settings
# exclusive inclusive rows x rows loops node
1. 0.039 27.422 ↑ 1.0 1 1

Nested Loop Left Join (cost=36.51..201.58 rows=1 width=3,740) (actual time=27.315..27.422 rows=1 loops=1)

  • Output: visit0_.id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_.planned_date, visit0_.appointment_id, caseinitgo12_.id, caseinitgo12_.name, visit0_1_.deviation_reason_id, mes14_.id, mes14_.name, mesquality15_.id, visit0_1_.is_continue_editable, visit0_1_.is_continue, employeeto16_.id, visit0_1_.main_diagnosis_id, diagnosis24_.id, diagnosis24_.name, visit0_1_.outcome_clinic_id, careregime22_.id, careregime22_.name, stepresult20_.id, stepresult20_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepcarere21_.id, stepcarere21_.name, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, position30_.id, speciality31_.id, speciality31_.name, medicalpro18_.id, medicalpro18_.name, visit0_.type_id, visitplace17_.id, visitplace17_.name, visit0_.initiator_id, visit0_1_.case_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, medicalcas1_.uid, medicalcas1_.care_level_id, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, medicalcas1_.care_regimen_id, careregime43_.name, careregime43_.code, medicalcas1_.rankin_scale_for_admission_id, rankinscal9_.name, medicalcas1_.patient_id, individual64_.birth_dt, medicalcar49_.id, medicalcar49_.name, medicalcas1_.close_date, clinic2_.id, organizati3_.short_name, organizati3_.full_name, medicalcas1_.state_id, casestate37_.name, medicalcas1_.main_diagnos_id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, socialgrou41_.id, socialgrou41_.name, medicalcas1_.init_goal_id, caseinitgo47_.name, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, repeatcoun53_.name, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, admissionr51_.name, medicalcas1_.admission_state_id, admissions55_.name, medicalcas1_.drunkenness_type_id, drunkennes57_.name, medicalcas1_.time_gone_id, timegone59_.name, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, healthgrou34_.id, healthgrou34_.name, medicalcas1_.create_date, medicalcas1_.open_date, casestep11_.outcome_date, casestep11_.id, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalpay61_.id, medicalpay61_.name, (SubPlan 1), (SubPlan 2), (SubPlan 4), standard67_.id, standard67_.name, careprovid66_.id, careprovid66_.name, clinicalst35_.id, clinicalst35_.name, visittype13_.code, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, (SubPlan 5), (SubPlan 7), visit0_1_.planned_date_closing_case, casestep11_.gestational_age, onkostage68_.id, bedprofile69_.id, bedprofile69_.name
  • Buffers: shared hit=89 read=27
2. 0.003 24.911 ↑ 1.0 1 1

Nested Loop Left Join (cost=36.24..122.23 rows=1 width=3,642) (actual time=24.805..24.911 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, position30_.id, speciality31_.id, speciality31_.name, clinicalst35_.id, clinicalst35_.name, standard67_.id, standard67_.name
  • Buffers: shared hit=73 read=24
3. 0.004 24.907 ↑ 1.0 1 1

Nested Loop Left Join (cost=35.96..113.93 rows=1 width=3,515) (actual time=24.802..24.907 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, position30_.id, speciality31_.id, speciality31_.name, clinicalst35_.id, clinicalst35_.name
  • Buffers: shared hit=73 read=24
4. 0.007 24.901 ↑ 1.0 1 1

Nested Loop Left Join (cost=35.68..105.62 rows=1 width=3,406) (actual time=24.796..24.901 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, position30_.id, speciality31_.id, speciality31_.name
  • Buffers: shared hit=73 read=24
5. 0.007 24.881 ↑ 1.0 1 1

Nested Loop Left Join (cost=35.41..105.32 rows=1 width=3,366) (actual time=24.778..24.881 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, position30_.id, position30_.speciality_id
  • Buffers: shared hit=70 read=24
6. 0.006 16.226 ↑ 1.0 1 1

Nested Loop Left Join (cost=35.12..104.88 rows=1 width=3,362) (actual time=16.124..16.226 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, employeeto29_.id, employeeto29_.position_id
  • Buffers: shared hit=69 read=22
7. 0.006 13.911 ↑ 1.0 1 1

Nested Loop Left Join (cost=34.83..104.56 rows=1 width=3,358) (actual time=13.811..13.911 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name, resourcegr28_.id, resourcegr28_.is_system, resourcegr28_.template_res_group_id, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.name, resourcegr28_.responsible_id
  • Buffers: shared hit=67 read=21
8. 0.009 13.847 ↑ 1.0 1 1

Nested Loop Left Join (cost=34.27..95.97 rows=1 width=3,282) (actual time=13.748..13.847 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, diagnosis24_.id, diagnosis24_.name
  • Buffers: shared hit=63 read=20
9. 0.004 12.441 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.98..95.65 rows=1 width=3,165) (actual time=12.344..12.441 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name, casediagno23_.diagnos_id
  • Buffers: shared hit=61 read=19
10. 0.036 11.293 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.42..87.06 rows=1 width=3,161) (actual time=11.198..11.293 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name, careregime22_.id, careregime22_.name
  • Join Filter: (visit0_1_.outcome_regimen_id = careregime22_.id)
  • Rows Removed by Join Filter: 42
  • Buffers: shared hit=57 read=18
11. 0.044 11.213 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.42..83.12 rows=1 width=3,042) (actual time=11.119..11.213 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult19_.id, stepresult19_.name, stepresult19_.is_closed, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name
  • Join Filter: (visit0_1_.result_id = stepresult19_.id)
  • Rows Removed by Join Filter: 95
  • Buffers: shared hit=55 read=17
12. 0.015 9.865 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.42..74.98 rows=1 width=2,889) (actual time=9.772..9.865 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.result_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult20_.id, stepresult20_.name, stepcarere21_.id, stepcarere21_.name
  • Join Filter: (visit0_1_.outcome_id = stepcarere21_.id)
  • Rows Removed by Join Filter: 17
  • Buffers: shared hit=51 read=15
13. 0.020 9.842 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.42..73.60 rows=1 width=2,869) (actual time=9.749..9.842 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.result_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name, stepresult20_.id, stepresult20_.name
  • Join Filter: (visit0_1_.reason_id = stepresult20_.id)
  • Rows Removed by Join Filter: 23
  • Buffers: shared hit=50 read=15
14. 0.005 9.812 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.42..72.08 rows=1 width=2,824) (actual time=9.719..9.812 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name, medicalpro18_.id, medicalpro18_.name
  • Buffers: shared hit=49 read=15
15. 0.018 9.795 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.27..63.91 rows=1 width=2,759) (actual time=9.705..9.795 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id, visitplace17_.id, visitplace17_.name
  • Join Filter: (visit0_.place_id = visitplace17_.id)
  • Rows Removed by Join Filter: 8
  • Buffers: shared hit=47 read=15
16. 0.011 9.770 ↑ 1.0 1 1

Nested Loop Left Join (cost=33.27..62.70 rows=1 width=2,699) (actual time=9.687..9.770 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id, employeeto16_.id
  • Buffers: shared hit=46 read=15
17. 0.019 9.758 ↑ 1.0 1 1

Nested Loop Left Join (cost=32.98..54.39 rows=1 width=2,699) (actual time=9.676..9.758 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name, mesquality15_.id
  • Buffers: shared hit=46 read=15
18. 0.003 9.738 ↑ 1.0 1 1

Nested Loop Left Join (cost=32.84..46.22 rows=1 width=2,699) (actual time=9.656..9.738 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code, mes14_.id, mes14_.name
  • Buffers: shared hit=46 read=15
19. 0.002 9.734 ↑ 1.0 1 1

Nested Loop Left Join (cost=32.56..37.91 rows=1 width=2,631) (actual time=9.653..9.734 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, visittype13_.code
  • Buffers: shared hit=46 read=15
20. 0.018 9.725 ↑ 1.0 1 1

Nested Loop Left Join (cost=32.43..37.56 rows=1 width=2,633) (actual time=9.646..9.725 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, careprovid66_.id, careprovid66_.name, caseinitgo12_.id, caseinitgo12_.name, caseinitgo12_.visit_type_id
  • Buffers: shared hit=44 read=15
21. 0.007 9.707 ↑ 1.0 1 1

Nested Loop Left Join (cost=32.30..37.41 rows=1 width=2,614) (actual time=9.642..9.707 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, individual64_.birth_dt, caseinitgo12_.id, caseinitgo12_.name, caseinitgo12_.visit_type_id
  • Buffers: shared hit=44 read=15
22. 0.132 9.656 ↑ 1.0 1 1

Hash Right Join (cost=31.86..36.77 rows=1 width=2,614) (actual time=9.593..9.656 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, patient63_.id, caseinitgo12_.id, caseinitgo12_.name, caseinitgo12_.visit_type_id
  • Hash Cond: (caseinitgo12_.id = visit0_.goal_id)
  • Buffers: shared hit=41 read=14
23. 0.120 0.120 ↑ 1.0 65 1

Seq Scan on public.mc_case_init_goal caseinitgo12_ (cost=0.00..4.65 rows=65 width=137) (actual time=0.028..0.120 rows=65 loops=1)

  • Output: caseinitgo12_.id, caseinitgo12_.code, caseinitgo12_.name, caseinitgo12_.visit_type_id, caseinitgo12_.e_code, caseinitgo12_.aud_who, caseinitgo12_.aud_when, caseinitgo12_.aud_source, caseinitgo12_.from_dt, caseinitgo12_.to_dt, caseinitgo12_.aud_who_create, caseinitgo12_.aud_when_create, caseinitgo12_.aud_source_create, caseinitgo12_.billing_code
  • Buffers: shared hit=3 read=1
24. 0.032 9.404 ↑ 1.0 1 1

Hash (cost=31.85..31.85 rows=1 width=2,481) (actual time=9.404..9.404 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, patient63_.id
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=35 read=13
25. 0.013 9.372 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.74..31.85 rows=1 width=2,481) (actual time=9.341..9.372 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name, patient63_.id
  • Buffers: shared hit=35 read=13
26. 0.002 9.292 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.30..31.38 rows=1 width=2,477) (actual time=9.263..9.292 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name, medicalpay61_.id, medicalpay61_.name
  • Buffers: shared hit=31 read=13
27. 0.003 9.289 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.16..31.22 rows=1 width=2,351) (actual time=9.260..9.289 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name, timegone59_.name
  • Buffers: shared hit=31 read=13
28. 0.002 9.286 ↑ 1.0 1 1

Nested Loop Left Join (cost=6.03..31.06 rows=1 width=2,321) (actual time=9.258..9.286 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name, drunkennes57_.name
  • Buffers: shared hit=31 read=13
29. 0.003 9.283 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.91..30.90 rows=1 width=2,296) (actual time=9.255..9.283 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name, admissions55_.name
  • Buffers: shared hit=31 read=13
30. 0.004 9.280 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.78..30.75 rows=1 width=2,274) (actual time=9.252..9.280 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name, repeatcoun53_.name
  • Buffers: shared hit=31 read=13
31. 0.003 9.275 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.65..30.59 rows=1 width=2,257) (actual time=9.248..9.275 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name, admissionr51_.name
  • Buffers: shared hit=31 read=13
32. 0.002 9.272 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.52..30.43 rows=1 width=2,191) (actual time=9.246..9.272 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name, medicalcar49_.id, medicalcar49_.name
  • Buffers: shared hit=31 read=13
33. 0.003 9.269 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.38..30.27 rows=1 width=2,166) (actual time=9.243..9.269 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code, caseinitgo47_.name
  • Buffers: shared hit=31 read=13
34. 0.004 9.257 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.24..30.10 rows=1 width=2,037) (actual time=9.233..9.257 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code, carelevel45_.name, carelevel45_.code, carelevel45_.icon_code
  • Buffers: shared hit=29 read=13
35. 0.004 9.242 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.11..29.94 rows=1 width=1,915) (actual time=9.219..9.242 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name, careregime43_.name, careregime43_.code
  • Buffers: shared hit=27 read=13
36. 0.002 9.227 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.97..29.77 rows=1 width=1,792) (actual time=9.206..9.227 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code, socialgrou41_.id, socialgrou41_.name
  • Buffers: shared hit=25 read=13
37. 0.003 9.225 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.83..29.61 rows=1 width=1,740) (actual time=9.204..9.225 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name, fundingsou39_.id, fundingsou39_.name, fundingsou39_.code
  • Buffers: shared hit=25 read=13
38. 0.004 9.222 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.70..29.45 rows=1 width=1,705) (actual time=9.201..9.222 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name, casestate37_.name
  • Buffers: shared hit=25 read=13
39. 0.003 9.209 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.56..29.29 rows=1 width=1,665) (actual time=9.189..9.209 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, healthgrou34_.id, healthgrou34_.name
  • Buffers: shared hit=23 read=13
40. 0.005 9.205 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.43..29.13 rows=1 width=1,662) (actual time=9.186..9.205 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code, medicalcas33_.health_group_id
  • Buffers: shared hit=23 read=13
41. 0.006 9.199 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.00..28.67 rows=1 width=1,658) (actual time=9.181..9.199 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, diagnosis27_.id, diagnosis27_.name, diagnosis27_.code
  • Buffers: shared hit=23 read=13
42. 0.005 7.972 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.72..28.35 rows=1 width=1,536) (actual time=7.955..7.972 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id, casediagno26_.diagnos_id
  • Buffers: shared hit=22 read=11
43. 0.014 6.449 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.15..27.57 rows=1 width=1,532) (actual time=6.434..6.449 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, onkostage68_.id
  • Buffers: shared hit=18 read=10
44. 0.005 6.433 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.01..27.41 rows=1 width=1,532) (actual time=6.418..6.433 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name, casestep11_.outcome_date, casestep11_.id, casestep11_.gestational_age, casestep11_.onko_stage
  • Buffers: shared hit=18 read=10
45. 0.003 5.412 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.58..26.82 rows=1 width=1,520) (actual time=5.399..5.412 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name, rankinscal9_.name
  • Buffers: shared hit=16 read=8
46. 0.003 5.409 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.44..26.66 rows=1 width=1,294) (actual time=5.397..5.409 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id, rankinscal7_.id, rankinscal7_.name
  • Buffers: shared hit=16 read=8
47. 0.006 5.405 ↑ 1.0 1 1

Nested Loop (cost=2.31..26.50 rows=1 width=1,068) (actual time=5.394..5.405 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, casetype5_.id, casetype5_.name, casetype5_.case_mode_id
  • Buffers: shared hit=16 read=8
48. 0.010 5.388 ↑ 1.0 1 1

Nested Loop (cost=2.18..26.34 rows=1 width=1,016) (actual time=5.378..5.388 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.case_type_id, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name
  • Buffers: shared hit=14 read=8
49. 0.005 3.595 ↑ 1.0 1 1

Nested Loop (cost=1.75..25.88 rows=1 width=1,024) (actual time=3.586..3.595 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.clinic_id, medicalcas1_.case_type_id, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id, organizati3_.short_name, organizati3_.full_name, organizati3_.id
  • Buffers: shared hit=11 read=7
50. 0.015 3.540 ↑ 1.0 1 1

Nested Loop (cost=1.46..25.56 rows=1 width=923) (actual time=3.534..3.540 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.clinic_id, medicalcas1_.case_type_id, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id, clinic2_.id
  • Buffers: shared hit=9 read=6
51. 0.038 3.429 ↑ 1.0 1 1

Nested Loop (cost=1.31..25.39 rows=1 width=919) (actual time=3.425..3.429 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.uid, medicalcas1_.care_level_id, medicalcas1_.care_regimen_id, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.patient_id, medicalcas1_.close_date, medicalcas1_.state_id, medicalcas1_.main_diagnos_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.repeat_count_id, medicalcas1_.referral_id, medicalcas1_.referral_resulting_id, medicalcas1_.admission_type_id, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.drunkenness_type_id, medicalcas1_.time_gone_id, medicalcas1_.emergency_team_code, medicalcas1_.transporting_type_id, medicalcas1_.note, medicalcas1_.result_id, medicalcas1_.create_date, medicalcas1_.open_date, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.clinic_id, medicalcas1_.case_type_id, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.closing_step_id, medicalcas1_.funding_id, medicalcas1_.soc_group_id, medicalcas1_.provision_condition_id, medicalcas1_.payment_method_id, medicalcas1_.care_providing_form_id
  • Buffers: shared hit=7 read=5
52. 0.009 2.272 ↑ 1.0 1 1

Nested Loop (cost=0.88..16.92 rows=1 width=141) (actual time=2.270..2.272 rows=1 loops=1)

  • Output: visit0_.id, visit0_.planned_date, visit0_.appointment_id, visit0_.type_id, visit0_.initiator_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.goal_id, visit0_.place_id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.deviation_reason_id, visit0_1_.is_continue_editable, visit0_1_.is_continue, visit0_1_.main_diagnosis_id, visit0_1_.outcome_clinic_id, visit0_1_.regimen_id, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.case_id, visit0_1_.planned_date_closing_case, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.death_employee_id, visit0_1_.profile_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.outcome_id, visit0_1_.outcome_regimen_id, visit0_1_.res_group_id, visit0_1_.csg_id, visit0_1_.standard_id, visit0_1_.hsp_bed_profile_id
  • Buffers: shared hit=4 read=4
53. 1.224 1.224 ↑ 1.0 1 1

Index Scan using plc_visit_pkey on public.plc_visit visit0_ (cost=0.44..8.46 rows=1 width=31) (actual time=1.223..1.224 rows=1 loops=1)

  • Output: visit0_.duration, visit0_.id, visit0_.goal_id, visit0_.initiator_id, visit0_.place_id, visit0_.type_id, visit0_.is_viewed, visit0_.is_needed, visit0_.is_sanitized, visit0_.aud_who, visit0_.aud_when, visit0_.aud_source, visit0_.aud_who_create, visit0_.aud_when_create, visit0_.aud_source_create, visit0_.dental_formula_id, visit0_.appointment_id, visit0_.planned_date
  • Index Cond: (visit0_.id = 474)
  • Buffers: shared hit=1 read=3
54. 1.039 1.039 ↑ 1.0 1 1

Index Scan using mc_step_pkey on public.mc_step visit0_1_ (cost=0.44..8.46 rows=1 width=114) (actual time=1.038..1.039 rows=1 loops=1)

  • Output: visit0_1_.id, visit0_1_.admission_date, visit0_1_.admission_time, visit0_1_.death_date, visit0_1_.death_time, visit0_1_.outcome_date, visit0_1_.outcome_time, visit0_1_.death_employee_id, visit0_1_.main_diagnosis_id, visit0_1_.case_id, visit0_1_.outcome_id, visit0_1_.outcome_clinic_id, visit0_1_.outcome_regimen_id, visit0_1_.regimen_id, visit0_1_.res_group_id, visit0_1_.result_id, visit0_1_.reason_id, visit0_1_.profile_id, visit0_1_.mes_id, visit0_1_.mes_quality_criterion_id, visit0_1_.is_continue, visit0_1_.is_continue_editable, visit0_1_.standard_id, visit0_1_.csg_id, visit0_1_.vmp_type_id, visit0_1_.vmp_method_id, visit0_1_.deviation_reason_id, visit0_1_.aud_who, visit0_1_.aud_when, visit0_1_.aud_source, visit0_1_.aud_who_create, visit0_1_.aud_when_create, visit0_1_.aud_source_create, visit0_1_._clinic_id, visit0_1_._patient_id, visit0_1_.planned_date_closing_case, visit0_1_.gestational_age, visit0_1_.onko_stage, visit0_1_.hsp_bed_profile_id, visit0_1_.is_first_step
  • Index Cond: (visit0_1_.id = 474)
  • Buffers: shared hit=3 read=1
55. 1.119 1.119 ↑ 1.0 1 1

Index Scan using mc_case_pkey on public.mc_case medicalcas1_ (cost=0.44..8.46 rows=1 width=782) (actual time=1.118..1.119 rows=1 loops=1)

  • Output: medicalcas1_.id, medicalcas1_.care_full_years, medicalcas1_.create_date, medicalcas1_.death_reason, medicalcas1_.emergency_team_code, medicalcas1_.note, medicalcas1_.plan_case_duration, medicalcas1_.plan_hosp_date, medicalcas1_.sicklist_close_dt, medicalcas1_.sicklist_open_dt, medicalcas1_.uid, medicalcas1_.who_delivered, medicalcas1_.who_delivered_code, medicalcas1_.who_delivered_team_number, medicalcas1_.admission_reason_id, medicalcas1_.admission_state_id, medicalcas1_.admission_type_id, medicalcas1_.care_gender_id, medicalcas1_.care_level_id, medicalcas1_.case_type_id, medicalcas1_.clinic_id, medicalcas1_.main_contract_id, medicalcas1_.death_reason_diagnosis_id, medicalcas1_.drunkenness_type_id, medicalcas1_.funding_id, medicalcas1_.init_goal_id, medicalcas1_.init_type_id, medicalcas1_.main_diagnos_id, medicalcas1_.result_id, medicalcas1_.patient_id, medicalcas1_.prehospital_stage_defect_id, medicalcas1_.referral_id, medicalcas1_.care_regimen_id, medicalcas1_.repeat_count_id, medicalcas1_.soc_group_id, medicalcas1_.state_id, medicalcas1_.time_gone_id, medicalcas1_.transporting_type_id, medicalcas1_.repeat_count, medicalcas1_.referral_resulting_id, medicalcas1_.payment_method_id, medicalcas1_.complexity_level_id, medicalcas1_.deviation_reason_id, medicalcas1_.open_date, medicalcas1_.closing_step_id, medicalcas1_.provision_condition_id, medicalcas1_.care_providing_form_id, medicalcas1_.injury_type_id, medicalcas1_.aud_who, medicalcas1_.aud_when, medicalcas1_.aud_source, medicalcas1_.hsp_canal_id, medicalcas1_.open_time, medicalcas1_.close_date, medicalcas1_.aud_who_create, medicalcas1_.aud_when_create, medicalcas1_.aud_source_create, medicalcas1_.rankin_scale_for_admission_id, medicalcas1_.rankin_scale_on_disposal_id, medicalcas1_.notes_to_work, medicalcas1_.mark, medicalcas1_.is_need_sicklist, medicalcas1_.narcotic_substance, medicalcas1_.where_from_delivered, medicalcas1_.is_social_significant, medicalcas1_.is_finance_type_control, medicalcas1_.is_control_case_init_goal, medicalcas1_.ticket_vmp, medicalcas1_.ticket_vmp_date, medicalcas1_.planned_hospitalization_date, medicalcas1_.severity_level_id, medicalcas1_.external_reason_mkb_id, medicalcas1_.additional_data
  • Index Cond: (medicalcas1_.id = visit0_1_.case_id)
  • Buffers: shared hit=3 read=1
56. 0.096 0.096 ↑ 1.0 1 1

Index Only Scan using md_clinic_pkey on public.md_clinic clinic2_ (cost=0.15..0.17 rows=1 width=4) (actual time=0.094..0.096 rows=1 loops=1)

  • Output: clinic2_.id
  • Index Cond: (clinic2_.id = medicalcas1_.clinic_id)
  • Heap Fetches: 1
  • Buffers: shared hit=2 read=1
57. 0.050 0.050 ↑ 1.0 1 1

Index Scan using pim_organization_pkey on public.pim_organization organizati3_ (cost=0.29..0.31 rows=1 width=101) (actual time=0.049..0.050 rows=1 loops=1)

  • Output: organizati3_.short_name, organizati3_.full_name, organizati3_.id
  • Index Cond: (organizati3_.id = medicalcas1_.clinic_id)
  • Buffers: shared hit=2 read=1
58. 1.783 1.783 ↑ 1.0 1 1

Index Only Scan using pim_party_pkey on public.pim_party organizati3_1_ (cost=0.43..0.45 rows=1 width=4) (actual time=1.782..1.783 rows=1 loops=1)

  • Output: organizati3_1_.id
  • Index Cond: (organizati3_1_.id = medicalcas1_.clinic_id)
  • Heap Fetches: 0
  • Buffers: shared hit=3 read=1
59. 0.011 0.011 ↑ 1.0 1 1

Index Scan using mc_case_type_pkey on public.mc_case_type casetype5_ (cost=0.13..0.15 rows=1 width=56) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: casetype5_.id, casetype5_.case_mode_id, casetype5_.code, casetype5_.name, casetype5_.default_regimen_id, casetype5_.e_code, casetype5_.aud_who, casetype5_.aud_when, casetype5_.aud_source, casetype5_.from_dt, casetype5_.to_dt, casetype5_.aud_who_create, casetype5_.aud_when_create, casetype5_.aud_source_create, casetype5_.billing_code
  • Index Cond: (casetype5_.id = medicalcas1_.case_type_id)
  • Buffers: shared hit=2
60. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_rankin_scale_pkey on public.mc_rankin_scale rankinscal7_ (cost=0.13..0.15 rows=1 width=230) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: rankinscal7_.id, rankinscal7_.code, rankinscal7_.name, rankinscal7_.from_dt, rankinscal7_.to_dt, rankinscal7_.e_code, rankinscal7_.aud_who, rankinscal7_.aud_when, rankinscal7_.aud_source, rankinscal7_.aud_who_create, rankinscal7_.aud_when_create, rankinscal7_.aud_source_create
  • Index Cond: (medicalcas1_.rankin_scale_on_disposal_id = rankinscal7_.id)
61. 0.000 0.000 ↓ 0.0 0 1

Index Scan using mc_rankin_scale_pkey on public.mc_rankin_scale rankinscal9_ (cost=0.13..0.15 rows=1 width=230) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: rankinscal9_.id, rankinscal9_.code, rankinscal9_.name, rankinscal9_.from_dt, rankinscal9_.to_dt, rankinscal9_.e_code, rankinscal9_.aud_who, rankinscal9_.aud_when, rankinscal9_.aud_source, rankinscal9_.aud_who_create, rankinscal9_.aud_when_create, rankinscal9_.aud_source_create
  • Index Cond: (medicalcas1_.rankin_scale_for_admission_id = rankinscal9_.id)
62. 1.016 1.016 ↑ 1.0 1 1

Index Scan using mc_step_pkey on public.mc_step casestep11_ (cost=0.44..0.58 rows=1 width=16) (actual time=1.014..1.016 rows=1 loops=1)

  • Output: casestep11_.id, casestep11_.admission_date, casestep11_.admission_time, casestep11_.death_date, casestep11_.death_time, casestep11_.outcome_date, casestep11_.outcome_time, casestep11_.death_employee_id, casestep11_.main_diagnosis_id, casestep11_.case_id, casestep11_.outcome_id, casestep11_.outcome_clinic_id, casestep11_.outcome_regimen_id, casestep11_.regimen_id, casestep11_.res_group_id, casestep11_.result_id, casestep11_.reason_id, casestep11_.profile_id, casestep11_.mes_id, casestep11_.mes_quality_criterion_id, casestep11_.is_continue, casestep11_.is_continue_editable, casestep11_.standard_id, casestep11_.csg_id, casestep11_.vmp_type_id, casestep11_.vmp_method_id, casestep11_.deviation_reason_id, casestep11_.aud_who, casestep11_.aud_when, casestep11_.aud_source, casestep11_.aud_who_create, casestep11_.aud_when_create, casestep11_.aud_source_create, casestep11_._clinic_id, casestep11_._patient_id, casestep11_.planned_date_closing_case, casestep11_.gestational_age, casestep11_.onko_stage, casestep11_.hsp_bed_profile_id, casestep11_.is_first_step
  • Index Cond: (medicalcas1_.closing_step_id = casestep11_.id)
  • Buffers: shared hit=2 read=2
63. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using onko_stage_pkey on refbook.onko_stage onkostage68_ (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: onkostage68_.id
  • Index Cond: (onkostage68_.id = casestep11_.onko_stage)
  • Heap Fetches: 0
64. 1.518 1.518 ↑ 1.0 1 1

Index Scan using mc_diagnosis_pkey on public.mc_diagnosis casediagno26_ (cost=0.56..0.77 rows=1 width=8) (actual time=1.517..1.518 rows=1 loops=1)

  • Output: casediagno26_.id, casediagno26_.diagnos_id
  • Index Cond: (medicalcas1_.main_diagnos_id = casediagno26_.id)
  • Buffers: shared hit=4 read=1
65. 1.221 1.221 ↑ 1.0 1 1

Index Scan using md_diagnosis_pkey on public.md_diagnosis diagnosis27_ (cost=0.29..0.30 rows=1 width=126) (actual time=1.220..1.221 rows=1 loops=1)

  • Output: diagnosis27_.id, diagnosis27_.code, diagnosis27_.name, diagnosis27_.parent_id, diagnosis27_.is_injury, diagnosis27_.level, diagnosis27_.is_leaf, diagnosis27_.e_code, diagnosis27_.oms, diagnosis27_.stomat, diagnosis27_.aud_who, diagnosis27_.aud_when, diagnosis27_.aud_source, diagnosis27_.from_dt, diagnosis27_.to_dt, diagnosis27_.aud_who_create, diagnosis27_.aud_when_create, diagnosis27_.aud_source_create
  • Index Cond: (casediagno26_.diagnos_id = diagnosis27_.id)
  • Buffers: shared hit=1 read=2
66. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_med_case_result_pkey on public.mc_med_case_result medicalcas33_ (cost=0.43..0.45 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: medicalcas33_.id, medicalcas33_.outcome_regimen_id, medicalcas33_.outcome_clinic_id, medicalcas33_.md_diagnosis, medicalcas33_.health_group_id, medicalcas33_.care_full_years, medicalcas33_.is_for_care, medicalcas33_.care_gender_id, medicalcas33_.death_reason_diagnosis_id, medicalcas33_.prehospital_stage_defect_id, medicalcas33_.dispensary_group_id, medicalcas33_.csg_id, medicalcas33_.aud_who, medicalcas33_.aud_when, medicalcas33_.aud_source, medicalcas33_.aud_who_create, medicalcas33_.aud_when_create, medicalcas33_.aud_source_create, medicalcas33_.gestational_age, medicalcas33_.onko_stage
  • Index Cond: (medicalcas1_.result_id = medicalcas33_.id)
67. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_health_group_pkey on public.mc_health_group healthgrou34_ (cost=0.13..0.15 rows=1 width=7) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: healthgrou34_.id, healthgrou34_.code, healthgrou34_.name, healthgrou34_.e_code, healthgrou34_.aud_who, healthgrou34_.aud_when, healthgrou34_.aud_source, healthgrou34_.from_dt, healthgrou34_.to_dt, healthgrou34_.aud_who_create, healthgrou34_.aud_when_create, healthgrou34_.aud_source_create, healthgrou34_.billing_code
  • Index Cond: (medicalcas33_.health_group_id = healthgrou34_.id)
68. 0.009 0.009 ↑ 1.0 1 1

Index Scan using mc_case_state_pkey on public.mc_case_state casestate37_ (cost=0.13..0.15 rows=1 width=44) (actual time=0.009..0.009 rows=1 loops=1)

  • Output: casestate37_.id, casestate37_.case_mode_id, casestate37_.is_case_editable, casestate37_.is_outcome_set, casestate37_.is_show_department, casestate37_.name, casestate37_.text_color, casestate37_.pim_department_type_id, casestate37_.code, casestate37_.e_code, casestate37_.aud_who, casestate37_.aud_when, casestate37_.aud_source, casestate37_.from_dt, casestate37_.to_dt, casestate37_.aud_who_create, casestate37_.aud_when_create, casestate37_.aud_source_create
  • Index Cond: (medicalcas1_.state_id = casestate37_.id)
  • Buffers: shared hit=2
69. 0.000 0.000 ↓ 0.0 0 1

Index Scan using fin_funding_source_type_pkey on public.fin_funding_source_type fundingsou39_ (cost=0.13..0.15 rows=1 width=39) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: fundingsou39_.id, fundingsou39_.bdate, fundingsou39_.code, fundingsou39_.edate, fundingsou39_.name, fundingsou39_.ordern, fundingsou39_.parent_id, fundingsou39_.has_exception, fundingsou39_.e_code, fundingsou39_.is_contract_required, fundingsou39_.is_citizen, fundingsou39_.is_payer_smo, fundingsou39_.is_payer_foms, fundingsou39_.is_default, fundingsou39_.is_privileged, fundingsou39_.aud_who, fundingsou39_.aud_when, fundingsou39_.aud_source, fundingsou39_.from_dt, fundingsou39_.to_dt, fundingsou39_.aud_who_create, fundingsou39_.aud_when_create, fundingsou39_.aud_source_create, fundingsou39_.is_vmp, fundingsou39_.billing_code
  • Index Cond: (medicalcas1_.funding_id = fundingsou39_.id)
70. 0.000 0.000 ↓ 0.0 0 1

Index Scan using md_soc_group_pkey on public.md_soc_group socialgrou41_ (cost=0.14..0.16 rows=1 width=56) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: socialgrou41_.id, socialgrou41_.code, socialgrou41_.from_age, socialgrou41_.from_dt, socialgrou41_.name, socialgrou41_.to_age, socialgrou41_.to_dt, socialgrou41_.e_code, socialgrou41_.aud_who, socialgrou41_.aud_when, socialgrou41_.aud_source, socialgrou41_.aud_who_create, socialgrou41_.aud_when_create, socialgrou41_.aud_source_create, socialgrou41_.parent_id, socialgrou41_.billing_code
  • Index Cond: (medicalcas1_.soc_group_id = socialgrou41_.id)
71. 0.011 0.011 ↑ 1.0 1 1

Index Scan using mc_care_regimen_pkey on public.mc_care_regimen careregime43_ (cost=0.14..0.16 rows=1 width=127) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: careregime43_.id, careregime43_.bdate, careregime43_.is_bed_required, careregime43_.case_mode_id, careregime43_.med_cert_name, careregime43_.code, careregime43_.edate, careregime43_.name, careregime43_.e_code, careregime43_.aud_who, careregime43_.aud_when, careregime43_.aud_source, careregime43_.from_dt, careregime43_.to_dt, careregime43_.aud_who_create, careregime43_.aud_when_create, careregime43_.aud_source_create, careregime43_.is_not_admission, careregime43_.billing_code
  • Index Cond: (medicalcas1_.care_regimen_id = careregime43_.id)
  • Buffers: shared hit=2
72. 0.011 0.011 ↑ 1.0 1 1

Index Scan using mc_care_level_pkey on public.mc_care_level carelevel45_ (cost=0.14..0.15 rows=1 width=126) (actual time=0.010..0.011 rows=1 loops=1)

  • Output: carelevel45_.id, carelevel45_.bdate, carelevel45_.code, carelevel45_.edate, carelevel45_.name, carelevel45_.e_code, carelevel45_.vmp_flag, carelevel45_.icon_code, carelevel45_.aud_who, carelevel45_.aud_when, carelevel45_.aud_source, carelevel45_.from_dt, carelevel45_.to_dt, carelevel45_.aud_who_create, carelevel45_.aud_when_create, carelevel45_.aud_source_create, carelevel45_.parent_id, carelevel45_.billing_code
  • Index Cond: (medicalcas1_.care_level_id = carelevel45_.id)
  • Buffers: shared hit=2
73. 0.009 0.009 ↑ 1.0 1 1

Index Scan using mc_case_init_goal_pkey on public.mc_case_init_goal caseinitgo47_ (cost=0.14..0.16 rows=1 width=133) (actual time=0.008..0.009 rows=1 loops=1)

  • Output: caseinitgo47_.id, caseinitgo47_.code, caseinitgo47_.name, caseinitgo47_.visit_type_id, caseinitgo47_.e_code, caseinitgo47_.aud_who, caseinitgo47_.aud_when, caseinitgo47_.aud_source, caseinitgo47_.from_dt, caseinitgo47_.to_dt, caseinitgo47_.aud_who_create, caseinitgo47_.aud_when_create, caseinitgo47_.aud_source_create, caseinitgo47_.billing_code
  • Index Cond: (medicalcas1_.init_goal_id = caseinitgo47_.id)
  • Buffers: shared hit=2
74. 0.001 0.001 ↓ 0.0 0 1

Index Scan using md_care_provision_condition_pk on public.md_care_provision_condition medicalcar49_ (cost=0.13..0.15 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: medicalcar49_.id, medicalcar49_.code, medicalcar49_.name, medicalcar49_.begin_date, medicalcar49_.end_date, medicalcar49_.e_code, medicalcar49_.aud_who, medicalcar49_.aud_when, medicalcar49_.aud_source, medicalcar49_.from_dt, medicalcar49_.to_dt, medicalcar49_.aud_who_create, medicalcar49_.aud_when_create, medicalcar49_.aud_source_create
  • Index Cond: (medicalcas1_.provision_condition_id = medicalcar49_.id)
75. 0.000 0.000 ↓ 0.0 0 1

Index Scan using mc_admission_reason_pkey on public.mc_admission_reason admissionr51_ (cost=0.14..0.15 rows=1 width=70) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: admissionr51_.id, admissionr51_.code, admissionr51_.name, admissionr51_.e_code, admissionr51_.is_injury, admissionr51_.aud_who, admissionr51_.aud_when, admissionr51_.aud_source, admissionr51_.from_dt, admissionr51_.to_dt, admissionr51_.aud_who_create, admissionr51_.aud_when_create, admissionr51_.aud_source_create, admissionr51_.external_reason_input_is_allowed
  • Index Cond: (medicalcas1_.admission_reason_id = admissionr51_.id)
76. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_repeat_count_pkey on public.mc_repeat_count repeatcoun53_ (cost=0.13..0.15 rows=1 width=21) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: repeatcoun53_.id, repeatcoun53_.code, repeatcoun53_.name, repeatcoun53_.e_code, repeatcoun53_.aud_who, repeatcoun53_.aud_when, repeatcoun53_.aud_source, repeatcoun53_.from_dt, repeatcoun53_.to_dt, repeatcoun53_.aud_who_create, repeatcoun53_.aud_when_create, repeatcoun53_.aud_source_create
  • Index Cond: (medicalcas1_.repeat_count_id = repeatcoun53_.id)
77. 0.000 0.000 ↓ 0.0 0 1

Index Scan using mc_admission_state_pkey on public.mc_admission_state admissions55_ (cost=0.13..0.15 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: admissions55_.id, admissions55_.code, admissions55_.name, admissions55_.e_code, admissions55_.aud_who, admissions55_.aud_when, admissions55_.aud_source, admissions55_.from_dt, admissions55_.to_dt, admissions55_.aud_who_create, admissions55_.aud_when_create, admissions55_.aud_source_create
  • Index Cond: (medicalcas1_.admission_state_id = admissions55_.id)
78. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_drunkenness_type_pkey on public.mc_drunkenness_type drunkennes57_ (cost=0.13..0.15 rows=1 width=29) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: drunkennes57_.id, drunkennes57_.code, drunkennes57_.name, drunkennes57_.e_code, drunkennes57_.aud_who, drunkennes57_.aud_when, drunkennes57_.aud_source, drunkennes57_.from_dt, drunkennes57_.to_dt, drunkennes57_.aud_who_create, drunkennes57_.aud_when_create, drunkennes57_.aud_source_create
  • Index Cond: (medicalcas1_.drunkenness_type_id = drunkennes57_.id)
79. 0.000 0.000 ↓ 0.0 0 1

Index Scan using mc_time_gone_pkey on public.mc_time_gone timegone59_ (cost=0.13..0.15 rows=1 width=34) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: timegone59_.id, timegone59_.code, timegone59_.name, timegone59_.e_code, timegone59_.aud_who, timegone59_.aud_when, timegone59_.aud_source, timegone59_.from_dt, timegone59_.to_dt, timegone59_.aud_who_create, timegone59_.aud_when_create, timegone59_.aud_source_create
  • Index Cond: (medicalcas1_.time_gone_id = timegone59_.id)
80. 0.001 0.001 ↓ 0.0 0 1

Index Scan using mc_payment_method_pk on public.mc_payment_method medicalpay61_ (cost=0.14..0.16 rows=1 width=130) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: medicalpay61_.id, medicalpay61_.code, medicalpay61_.name, medicalpay61_.e_code, medicalpay61_.aud_who, medicalpay61_.aud_when, medicalpay61_.aud_source, medicalpay61_.from_dt, medicalpay61_.to_dt, medicalpay61_.aud_who_create, medicalpay61_.aud_when_create, medicalpay61_.aud_source_create, medicalpay61_.billing_code
  • Index Cond: (medicalcas1_.payment_method_id = medicalpay61_.id)
81. 0.067 0.067 ↑ 1.0 1 1

Index Only Scan using pci_patient_pkey on public.pci_patient patient63_ (cost=0.43..0.46 rows=1 width=4) (actual time=0.066..0.067 rows=1 loops=1)

  • Output: patient63_.id
  • Index Cond: (patient63_.id = medicalcas1_.patient_id)
  • Heap Fetches: 0
  • Buffers: shared hit=4
82. 0.044 0.044 ↑ 1.0 1 1

Index Scan using pim_individual_pkey on public.pim_individual individual64_ (cost=0.43..0.63 rows=1 width=8) (actual time=0.043..0.044 rows=1 loops=1)

  • Output: individual64_.birth_dt, individual64_.death_dt, individual64_.has_citizenship, individual64_.name, individual64_.patr_name, individual64_.surname, individual64_.id, individual64_.gender_id, individual64_.nationality_id, individual64_.list_identity_doc, individual64_.list_oms_doc, individual64_.list_job_org, individual64_.list_reg_name, individual64_.list_snils, individual64_.list_uid, individual64_.aud_who, individual64_.aud_when, individual64_.aud_source, individual64_.aud_who_create, individual64_.aud_when_create, individual64_.aud_source_create, individual64_.birth_place, individual64_.list_main_contact, individual64_.age_year, individual64_.age_month, individual64_.age_day
  • Index Cond: (patient63_.id = individual64_.id)
  • Buffers: shared hit=3 read=1
83. 0.000 0.000 ↓ 0.0 0 1

Index Scan using md_care_providing_form_pk on public.md_care_providing_form careprovid66_ (cost=0.13..0.15 rows=1 width=23) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: careprovid66_.id, careprovid66_.code, careprovid66_.name, careprovid66_.e_code, careprovid66_.aud_who, careprovid66_.aud_when, careprovid66_.aud_source, careprovid66_.from_dt, careprovid66_.to_dt, careprovid66_.aud_who_create, careprovid66_.aud_when_create, careprovid66_.aud_source_create, careprovid66_.billing_code
  • Index Cond: (medicalcas1_.care_providing_form_id = careprovid66_.id)
84. 0.007 0.007 ↑ 1.0 1 1

Index Scan using plc_visit_type_pkey on public.plc_visit_type visittype13_ (cost=0.13..0.33 rows=1 width=6) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: visittype13_.id, visittype13_.code, visittype13_.name, visittype13_.e_code, visittype13_.aud_who, visittype13_.aud_when, visittype13_.aud_source, visittype13_.from_dt, visittype13_.to_dt, visittype13_.aud_who_create, visittype13_.aud_when_create, visittype13_.aud_source_create
  • Index Cond: (caseinitgo12_.visit_type_id = visittype13_.id)
  • Buffers: shared hit=2
85. 0.001 0.001 ↓ 0.0 0 1

Index Scan using md_mes_pkey on public.md_mes mes14_ (cost=0.29..8.30 rows=1 width=72) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: mes14_.id, mes14_.code, mes14_.from_document, mes14_.from_dt, mes14_.name, mes14_.to_document, mes14_.to_dt, mes14_.age_group_id, mes14_.group_classifier_id, mes14_.med_profile_id, mes14_.bed_profile_id, mes14_.complexity_level_id, mes14_.case_type_id, mes14_.input_intensities, mes14_.clinic_id, mes14_.e_code, mes14_.aud_who, mes14_.aud_when, mes14_.aud_source, mes14_.aud_who_create, mes14_.aud_when_create, mes14_.aud_source_create
  • Index Cond: (visit0_1_.mes_id = mes14_.id)
86. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using md_mes_quality_criterion_pk on public.mc_mes_quality_criterion mesquality15_ (cost=0.14..8.16 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: mesquality15_.id
  • Index Cond: (mesquality15_.id = visit0_1_.mes_quality_criterion_id)
  • Heap Fetches: 0
87. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using pim_employee_position_pkey on public.pim_employee_position employeeto16_ (cost=0.29..8.31 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: employeeto16_.id
  • Index Cond: (employeeto16_.id = visit0_1_.death_employee_id)
  • Heap Fetches: 0
88. 0.007 0.007 ↑ 1.0 9 1

Seq Scan on public.plc_visit_place visitplace17_ (cost=0.00..1.09 rows=9 width=64) (actual time=0.004..0.007 rows=9 loops=1)

  • Output: visitplace17_.id, visitplace17_.code, visitplace17_.name, visitplace17_.e_code, visitplace17_.aud_who, visitplace17_.aud_when, visitplace17_.aud_source, visitplace17_.from_dt, visitplace17_.to_dt, visitplace17_.aud_who_create, visitplace17_.aud_when_create, visitplace17_.aud_source_create, visitplace17_.billing_code
  • Buffers: shared hit=1
89. 0.012 0.012 ↑ 1.0 1 1

Index Scan using md_profile_pkey on public.md_profile medicalpro18_ (cost=0.14..8.16 rows=1 width=69) (actual time=0.011..0.012 rows=1 loops=1)

  • Output: medicalpro18_.id, medicalpro18_.code, medicalpro18_.name, medicalpro18_.genitive_name, medicalpro18_.e_code, medicalpro18_.aud_who, medicalpro18_.aud_when, medicalpro18_.aud_source, medicalpro18_.from_dt, medicalpro18_.to_dt, medicalpro18_.aud_who_create, medicalpro18_.aud_when_create, medicalpro18_.aud_source_create, medicalpro18_.billing_code
  • Index Cond: (visit0_1_.profile_id = medicalpro18_.id)
  • Buffers: shared hit=2
90. 0.010 0.010 ↑ 1.0 23 1

Seq Scan on public.mc_step_result_reason stepresult20_ (cost=0.00..1.23 rows=23 width=49) (actual time=0.004..0.010 rows=23 loops=1)

  • Output: stepresult20_.id, stepresult20_.code, stepresult20_.name, stepresult20_.is_planning_allowed, stepresult20_.is_refused, stepresult20_.is_transfer_allowed, stepresult20_.initiator_id, stepresult20_.step_result_id, stepresult20_.e_code, stepresult20_.aud_who, stepresult20_.aud_when, stepresult20_.aud_source, stepresult20_.from_dt, stepresult20_.to_dt, stepresult20_.aud_who_create, stepresult20_.aud_when_create, stepresult20_.aud_source_create, stepresult20_.is_transfer, stepresult20_.billing_code
  • Buffers: shared hit=1
91. 0.008 0.008 ↑ 1.0 17 1

Seq Scan on public.mc_step_care_result stepcarere21_ (cost=0.00..1.17 rows=17 width=24) (actual time=0.003..0.008 rows=17 loops=1)

  • Output: stepcarere21_.id, stepcarere21_.code, stepcarere21_.name, stepcarere21_.e_code, stepcarere21_.aud_who, stepcarere21_.aud_when, stepcarere21_.aud_source, stepcarere21_.from_dt, stepcarere21_.to_dt, stepcarere21_.aud_who_create, stepcarere21_.aud_when_create, stepcarere21_.aud_source_create, stepcarere21_.billing_code
  • Buffers: shared hit=1
92. 1.304 1.304 ↑ 1.0 95 1

Seq Scan on public.mc_step_result stepresult19_ (cost=0.00..6.95 rows=95 width=157) (actual time=0.030..1.304 rows=95 loops=1)

  • Output: stepresult19_.id, stepresult19_.is_closed, stepresult19_.code, stepresult19_.is_death, stepresult19_.is_future, stepresult19_.name, stepresult19_.is_planning, stepresult19_.is_reason, stepresult19_.is_refusal, stepresult19_.is_transfer_permitted, stepresult19_.clinic_id, stepresult19_.e_code, stepresult19_.aud_who, stepresult19_.aud_when, stepresult19_.aud_source, stepresult19_.from_dt, stepresult19_.to_dt, stepresult19_.aud_who_create, stepresult19_.aud_when_create, stepresult19_.aud_source_create, stepresult19_.billing_code
  • Buffers: shared hit=4 read=2
93. 0.044 0.044 ↑ 1.0 42 1

Seq Scan on public.mc_care_regimen careregime22_ (cost=0.00..3.42 rows=42 width=123) (actual time=0.024..0.044 rows=42 loops=1)

  • Output: careregime22_.id, careregime22_.bdate, careregime22_.is_bed_required, careregime22_.case_mode_id, careregime22_.med_cert_name, careregime22_.code, careregime22_.edate, careregime22_.name, careregime22_.e_code, careregime22_.aud_who, careregime22_.aud_when, careregime22_.aud_source, careregime22_.from_dt, careregime22_.to_dt, careregime22_.aud_who_create, careregime22_.aud_when_create, careregime22_.aud_source_create, careregime22_.is_not_admission, careregime22_.billing_code
  • Buffers: shared hit=2 read=1
94. 1.144 1.144 ↑ 1.0 1 1

Index Scan using mc_diagnosis_pkey on public.mc_diagnosis casediagno23_ (cost=0.56..8.58 rows=1 width=8) (actual time=1.142..1.144 rows=1 loops=1)

  • Output: casediagno23_.id, casediagno23_.diagnos_id
  • Index Cond: (visit0_1_.main_diagnosis_id = casediagno23_.id)
  • Buffers: shared hit=4 read=1
95. 1.397 1.397 ↑ 1.0 1 1

Index Scan using md_diagnosis_pkey on public.md_diagnosis diagnosis24_ (cost=0.29..0.30 rows=1 width=121) (actual time=1.395..1.397 rows=1 loops=1)

  • Output: diagnosis24_.id, diagnosis24_.code, diagnosis24_.name, diagnosis24_.parent_id, diagnosis24_.is_injury, diagnosis24_.level, diagnosis24_.is_leaf, diagnosis24_.e_code, diagnosis24_.oms, diagnosis24_.stomat, diagnosis24_.aud_who, diagnosis24_.aud_when, diagnosis24_.aud_source, diagnosis24_.from_dt, diagnosis24_.to_dt, diagnosis24_.aud_who_create, diagnosis24_.aud_when_create, diagnosis24_.aud_source_create
  • Index Cond: (casediagno23_.diagnos_id = diagnosis24_.id)
  • Buffers: shared hit=2 read=1
96. 0.058 0.058 ↑ 1.0 1 1

Index Scan using sr_res_group_pkey on public.sr_res_group resourcegr28_ (cost=0.57..8.59 rows=1 width=80) (actual time=0.057..0.058 rows=1 loops=1)

  • Output: resourcegr28_.id, resourcegr28_.bdate, resourcegr28_.edate, resourcegr28_.is_system, resourcegr28_.name, resourcegr28_.org_id, resourcegr28_.department_id, resourcegr28_.responsible_id, resourcegr28_.is_available_in_electronic_queue, resourcegr28_.label_id, resourcegr28_.ignore_regclinic_check, resourcegr28_.note, resourcegr28_.blocked, resourcegr28_.block_comment, resourcegr28_.template_res_group_id, resourcegr28_.aud_who, resourcegr28_.aud_when, resourcegr28_.aud_source, resourcegr28_.aud_who_create, resourcegr28_.aud_when_create, resourcegr28_.aud_source_create, resourcegr28_.emergency, resourcegr28_.ignore_districts, resourcegr28_.service_template_id
  • Index Cond: (visit0_1_.res_group_id = resourcegr28_.id)
  • Buffers: shared hit=4 read=1
97. 2.309 2.309 ↑ 1.0 1 1

Index Scan using pim_employee_position_pkey on public.pim_employee_position employeeto29_ (cost=0.29..0.31 rows=1 width=8) (actual time=2.308..2.309 rows=1 loops=1)

  • Output: employeeto29_.id, employeeto29_.dismissal_order_code, employeeto29_.start_date, employeeto29_.hiring_order_code, employeeto29_.rate, employeeto29_.end_date, employeeto29_.dismissal_reason_id, employeeto29_.employee_id, employeeto29_.employment_type_id, employeeto29_.hiring_type_id, employeeto29_.position_id, employeeto29_.position_type_id, employeeto29_.unit_id, employeeto29_.code, employeeto29_.aud_who, employeeto29_.aud_when, employeeto29_.aud_source, employeeto29_.aud_who_create, employeeto29_.aud_when_create, employeeto29_.aud_source_create, employeeto29_.pref_prescription, employeeto29_.extra_payment, employeeto29_.target_training, employeeto29_.leaving_reason_id
  • Index Cond: (resourcegr28_.responsible_id = employeeto29_.id)
  • Buffers: shared hit=2 read=1
98. 8.648 8.648 ↑ 1.0 1 1

Index Scan using pim_position_pkey on public.pim_position position30_ (cost=0.29..0.44 rows=1 width=8) (actual time=8.648..8.648 rows=1 loops=1)

  • Output: position30_.id, position30_.code, position30_.start_date, position30_.name, position30_.end_date, position30_.department_id, position30_.organization_id, position30_.role_id, position30_.speciality_id, position30_.rate, position30_.e_code, position30_.aud_who, position30_.aud_when, position30_.aud_source, position30_.from_dt, position30_.to_dt, position30_.aud_who_create, position30_.aud_when_create, position30_.aud_source_create, position30_.pref_prescription, position30_.payment_fond, position30_.staff_event1, position30_.staff_event2, position30_.note, position30_.fact_employment, position30_.external_rate, position30_.billing_code
  • Index Cond: (employeeto29_.position_id = position30_.id)
  • Buffers: shared hit=1 read=2
99. 0.013 0.013 ↑ 1.0 1 1

Index Scan using pim_speciality_pkey on public.pim_speciality speciality31_ (cost=0.27..0.29 rows=1 width=44) (actual time=0.012..0.013 rows=1 loops=1)

  • Output: speciality31_.id, speciality31_.code, speciality31_.code_regional, speciality31_.name, speciality31_.sphere_id, speciality31_.parent_id, speciality31_.education_type_id, speciality31_.e_code, speciality31_.aud_who, speciality31_.aud_when, speciality31_.aud_source, speciality31_.from_dt, speciality31_.to_dt, speciality31_.aud_who_create, speciality31_.aud_when_create, speciality31_.aud_source_create, speciality31_.billing_code
  • Index Cond: (position30_.speciality_id = speciality31_.id)
  • Buffers: shared hit=3
100. 0.002 0.002 ↓ 0.0 0 1

Index Scan using md_clinical_statistical_group_pk on public.md_clinical_statistical_group clinicalst35_ (cost=0.28..8.30 rows=1 width=113) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: clinicalst35_.id, clinicalst35_.type_id, clinicalst35_.group_id, clinicalst35_.code, clinicalst35_.name, clinicalst35_.coefficient, clinicalst35_.age_group_id, clinicalst35_.bed_profile_id, clinicalst35_.gender_id, clinicalst35_.profile_id, clinicalst35_.from_dt, clinicalst35_.to_dt, clinicalst35_.aud_who, clinicalst35_.aud_when, clinicalst35_.aud_source, clinicalst35_.aud_who_create, clinicalst35_.aud_when_create, clinicalst35_.aud_source_create
  • Index Cond: (visit0_1_.csg_id = clinicalst35_.id)
101. 0.001 0.001 ↓ 0.0 0 1

Index Scan using md_standard_pk on public.md_standard standard67_ (cost=0.28..8.29 rows=1 width=131) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: standard67_.id, standard67_.clinic_id, standard67_.name, standard67_.description, standard67_.service_stages_id, standard67_.gender_restriction_id, standard67_.code, standard67_.treatment_duration, standard67_.care_level_id, standard67_.complication_id, standard67_.phase_id, standard67_.stage_id, standard67_.class_id, standard67_.care_providing_form_id, standard67_.care_regimen_id, standard67_.norm_document_id, standard67_.aud_who, standard67_.aud_when, standard67_.aud_source, standard67_.aud_who_create, standard67_.aud_when_create, standard67_.aud_source_create
  • Index Cond: (visit0_1_.standard_id = standard67_.id)
102. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pk_md_bed_profile on public.md_bed_profile bedprofile69_ (cost=0.27..8.29 rows=1 width=102) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: bedprofile69_.id, bedprofile69_.code, bedprofile69_.name, bedprofile69_.e_code, bedprofile69_.parent_id, bedprofile69_.aud_who, bedprofile69_.aud_when, bedprofile69_.aud_source, bedprofile69_.from_dt, bedprofile69_.to_dt, bedprofile69_.aud_who_create, bedprofile69_.aud_when_create, bedprofile69_.aud_source_create, bedprofile69_.billing_code
  • Index Cond: (visit0_1_.hsp_bed_profile_id = bedprofile69_.id)
103.          

SubPlan (for Nested Loop Left Join)

104. 0.007 2.368 ↑ 1.0 1 1

Aggregate (cost=9.21..9.22 rows=1 width=4) (actual time=2.368..2.368 rows=1 loops=1)

  • Output: max(sicklist101_.id)
  • Buffers: shared read=3
105. 2.361 2.361 ↓ 0.0 0 1

Index Scan using md_sicklist_case_id_idx on public.md_sicklist sicklist101_ (cost=0.42..9.20 rows=4 width=4) (actual time=2.361..2.361 rows=0 loops=1)

  • Output: sicklist101_.id, sicklist101_.code, sicklist101_.disability_from_dt, sicklist101_.is_disability_group_changed, sicklist101_.disability_to_dt, sicklist101_.is_early_pregnancy_register, sicklist101_.mse_examination_dt, sicklist101_.family_member_1_age, sicklist101_.family_member_1_age_month, sicklist101_.family_member_1_name, sicklist101_.family_member_2_age, sicklist101_.family_member_2_age_month, sicklist101_.family_member_2_name, sicklist101_.hospital_from_dt, sicklist101_.hospital_to_dt, sicklist101_.issue_dt, sicklist101_.ready_to_work_dt, sicklist101_.ready_to_work_other_dt, sicklist101_.mse_referral_dt, sicklist101_.regimen_violation_dt, sicklist101_.mse_register_dt, sicklist101_.sanatorium_ogrn_code, sicklist101_.voucher_code, sicklist101_.clinic_id, sicklist101_.disability_reason_id, sicklist101_.disability_reason_edited_id, sicklist101_.disability_reason_ext_id, sicklist101_.family_member_1_relation_id, sicklist101_.family_member_2_relation_id, sicklist101_.case_id, sicklist101_.parent_id, sicklist101_.patient_id, sicklist101_.ready_to_work_other_id, sicklist101_.regimen_violation_id, sicklist101_.regimen_violation_doctor_id, sicklist101_.state_id, sicklist101_.type_id, sicklist101_.workplace_id, sicklist101_.workplace_type_id, sicklist101_.transfer_to_o_clinic, sicklist101_.mse_org_id, sicklist101_.on_placement_service, sicklist101_.name, sicklist101_.patr_name, sicklist101_.surname, sicklist101_.workplace_print, sicklist101_.initial_diagnosis_id, sicklist101_.final_diagnosis_id, sicklist101_.aud_who, sicklist101_.aud_when, sicklist101_.aud_source, sicklist101_.aud_who_create, sicklist101_.aud_when_create, sicklist101_.aud_source_create, sicklist101_.parent_manual_code, sicklist101_.transfer_from_clinic, sicklist101_.parent_print
  • Index Cond: (sicklist101_.case_id = visit0_1_.case_id)
  • Buffers: shared read=3
106. 0.015 0.041 ↑ 1.0 1 1

Aggregate (cost=9.42..9.43 rows=1 width=4) (actual time=0.040..0.041 rows=1 loops=1)

  • Output: max(casestep102_.admission_date)
  • Buffers: shared hit=5
107. 0.026 0.026 ↓ 2.2 9 1

Index Scan using mc_step_case_ix on public.mc_step casestep102_ (cost=0.44..9.41 rows=4 width=4) (actual time=0.018..0.026 rows=9 loops=1)

  • Output: casestep102_.id, casestep102_.admission_date, casestep102_.admission_time, casestep102_.death_date, casestep102_.death_time, casestep102_.outcome_date, casestep102_.outcome_time, casestep102_.death_employee_id, casestep102_.main_diagnosis_id, casestep102_.case_id, casestep102_.outcome_id, casestep102_.outcome_clinic_id, casestep102_.outcome_regimen_id, casestep102_.regimen_id, casestep102_.res_group_id, casestep102_.result_id, casestep102_.reason_id, casestep102_.profile_id, casestep102_.mes_id, casestep102_.mes_quality_criterion_id, casestep102_.is_continue, casestep102_.is_continue_editable, casestep102_.standard_id, casestep102_.csg_id, casestep102_.vmp_type_id, casestep102_.vmp_method_id, casestep102_.deviation_reason_id, casestep102_.aud_who, casestep102_.aud_when, casestep102_.aud_source, casestep102_.aud_who_create, casestep102_.aud_when_create, casestep102_.aud_source_create, casestep102_._clinic_id, casestep102_._patient_id, casestep102_.planned_date_closing_case, casestep102_.gestational_age, casestep102_.onko_stage, casestep102_.hsp_bed_profile_id, casestep102_.is_first_step
  • Index Cond: (casestep102_.case_id = visit0_1_.case_id)
  • Buffers: shared hit=5
108. 0.000 0.055 ↑ 1.0 1 1

Aggregate (cost=18.85..18.86 rows=1 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Output: COALESCE(max(casestep103_.admission_time), '00:00:00'::time without time zone)
  • Buffers: shared hit=10
109.          

Initplan (for Aggregate)

110. 0.008 0.020 ↑ 1.0 1 1

Aggregate (cost=9.42..9.43 rows=1 width=4) (actual time=0.019..0.020 rows=1 loops=1)

  • Output: max(casestep104_.admission_date)
  • Buffers: shared hit=5
111. 0.012 0.012 ↓ 2.2 9 1

Index Scan using mc_step_case_ix on public.mc_step casestep104_ (cost=0.44..9.41 rows=4 width=4) (actual time=0.007..0.012 rows=9 loops=1)

  • Output: casestep104_.id, casestep104_.admission_date, casestep104_.admission_time, casestep104_.death_date, casestep104_.death_time, casestep104_.outcome_date, casestep104_.outcome_time, casestep104_.death_employee_id, casestep104_.main_diagnosis_id, casestep104_.case_id, casestep104_.outcome_id, casestep104_.outcome_clinic_id, casestep104_.outcome_regimen_id, casestep104_.regimen_id, casestep104_.res_group_id, casestep104_.result_id, casestep104_.reason_id, casestep104_.profile_id, casestep104_.mes_id, casestep104_.mes_quality_criterion_id, casestep104_.is_continue, casestep104_.is_continue_editable, casestep104_.standard_id, casestep104_.csg_id, casestep104_.vmp_type_id, casestep104_.vmp_method_id, casestep104_.deviation_reason_id, casestep104_.aud_who, casestep104_.aud_when, casestep104_.aud_source, casestep104_.aud_who_create, casestep104_.aud_when_create, casestep104_.aud_source_create, casestep104_._clinic_id, casestep104_._patient_id, casestep104_.planned_date_closing_case, casestep104_.gestational_age, casestep104_.onko_stage, casestep104_.hsp_bed_profile_id, casestep104_.is_first_step
  • Index Cond: (casestep104_.case_id = visit0_1_.case_id)
  • Buffers: shared hit=5
112. 0.052 0.052 ↑ 1.0 1 1

Index Scan using mc_step_case_ix on public.mc_step casestep103_ (cost=0.44..9.42 rows=1 width=8) (actual time=0.052..0.052 rows=1 loops=1)

  • Output: casestep103_.id, casestep103_.admission_date, casestep103_.admission_time, casestep103_.death_date, casestep103_.death_time, casestep103_.outcome_date, casestep103_.outcome_time, casestep103_.death_employee_id, casestep103_.main_diagnosis_id, casestep103_.case_id, casestep103_.outcome_id, casestep103_.outcome_clinic_id, casestep103_.outcome_regimen_id, casestep103_.regimen_id, casestep103_.res_group_id, casestep103_.result_id, casestep103_.reason_id, casestep103_.profile_id, casestep103_.mes_id, casestep103_.mes_quality_criterion_id, casestep103_.is_continue, casestep103_.is_continue_editable, casestep103_.standard_id, casestep103_.csg_id, casestep103_.vmp_type_id, casestep103_.vmp_method_id, casestep103_.deviation_reason_id, casestep103_.aud_who, casestep103_.aud_when, casestep103_.aud_source, casestep103_.aud_who_create, casestep103_.aud_when_create, casestep103_.aud_source_create, casestep103_._clinic_id, casestep103_._patient_id, casestep103_.planned_date_closing_case, casestep103_.gestational_age, casestep103_.onko_stage, casestep103_.hsp_bed_profile_id, casestep103_.is_first_step
  • Index Cond: (casestep103_.case_id = visit0_1_.case_id)
  • Filter: (casestep103_.admission_date = $3)
  • Rows Removed by Filter: 8
  • Buffers: shared hit=10
113. 0.005 0.005 ↓ 0.0 0 1

Index Scan using md_profile_category_profile_id_idx on public.md_profile_category medicalpro105_ (cost=0.14..8.16 rows=1 width=418) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: medicalpro105_.code
  • Index Cond: (medicalpro105_.profile_id = medicalpro18_.id)
  • Buffers: shared hit=1
114. 0.001 0.002 ↓ 0.0 0 1

Nested Loop (cost=0.88..25.39 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: (SubPlan 6)
115. 0.001 0.001 ↓ 0.0 0 1

Index Scan using md_appointment_pk on public.md_appointment appointmen106_ (cost=0.44..8.46 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: appointmen106_.id, appointmen106_.srv_rendered_id, appointmen106_.executor_id, appointmen106_.bdatetime, appointmen106_.customer_id, appointmen106_.funding_id, appointmen106_.state_id, appointmen106_.service_id, appointmen106_.cancel_reason_id, appointmen106_.care_regimen_id, appointmen106_.care_level_id, appointmen106_.referral_id, appointmen106_.source_id, appointmen106_.registrator_id, appointmen106_.registration_dt, appointmen106_.edatetime, appointmen106_.is_urgent, appointmen106_.notif_contact, appointmen106_.price_list_id, appointmen106_.message, appointmen106_.queue_state_id, appointmen106_.queue_change_dt, appointmen106_.ticket_number, appointmen106_.price, appointmen106_.init_goal_id, appointmen106_.organization_id, appointmen106_.is_house_call, appointmen106_.comment, appointmen106_.aud_who, appointmen106_.aud_when, appointmen106_.aud_source, appointmen106_.aud_who_create, appointmen106_.aud_when_create, appointmen106_.aud_source_create, appointmen106_.reject_comment, appointmen106_.reject_reason_id, appointmen106_.way_id, appointmen106_.is_cito, appointmen106_.event_id, appointmen106_.is_send_message, appointmen106_.comment_send_message, appointmen106_.cancel_dt, appointmen106_.answer_portal_code
  • Index Cond: (appointmen106_.id = visit0_.appointment_id)
116. 0.000 0.000 ↓ 0.0 0

Index Only Scan using sr_ticket_pk on public.sr_ticket appointmen106_1_ (cost=0.44..8.46 rows=1 width=4) (never executed)

  • Output: appointmen106_1_.id
  • Index Cond: (appointmen106_1_.id = visit0_.appointment_id)
  • Heap Fetches: 0
117.          

SubPlan (for Nested Loop)

118. 0.000 0.000 ↓ 0.0 0

Index Scan using md_appointment_pk on public.md_appointment a (cost=0.44..8.47 rows=1 width=12) (never executed)

  • Output: CASE WHEN ((a.bdatetime < ('now'::cstring)::date) AND (a.state_id = ANY ('{0,2,5}'::integer[]))) THEN 6 ELSE appointmen106_.state_id END
  • Index Cond: (a.id = appointmen106_.id)
Planning time : 2,291.915 ms
Execution time : 35.038 ms