explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f4Du

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 6.444 ↓ 0.0 0 1

Limit (cost=36,891.29..36,891.29 rows=1 width=4,598) (actual time=6.444..6.444 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit, ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create, ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting, pi.id, pi.birth_dt, pi.death_dt, pi.has_citizenship, pi.name, pi.patr_name, pi.surname, pi.gender_id, pi.nationality_id, pi.list_identity_doc, pi.list_oms_doc, pi.list_job_org, pi.list_reg_name, pi.list_snils, pi.list_uid, pi.aud_who, pi.aud_when, pi.aud_source, pi.aud_who_create, pi.aud_when_create, pi.aud_source_create, pi.birth_place, pi.age_year, pi.age_month, pi.age_day, pi.list_main_contact, pi.is_only_birth_year, ma.registration_dt
  • Buffers: shared hit=2574
2. 0.027 6.443 ↓ 0.0 0 1

Sort (cost=36,891.29..36,891.29 rows=1 width=4,598) (actual time=6.443..6.443 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit, ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create, ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting, pi.id, pi.birth_dt, pi.death_dt, pi.has_citizenship, pi.name, pi.patr_name, pi.surname, pi.gender_id, pi.nationality_id, pi.list_identity_doc, pi.list_oms_doc, pi.list_job_org, pi.list_reg_name, pi.list_snils, pi.list_uid, pi.aud_who, pi.aud_when, pi.aud_source, pi.aud_who_create, pi.aud_when_create, pi.aud_source_create, pi.birth_place, pi.age_year, pi.age_month, pi.age_day, pi.list_main_contact, pi.is_only_birth_year, ma.registration_dt
  • Sort Key: ma.registration_dt
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2574
3. 0.000 6.416 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,366.06..36,891.28 rows=1 width=4,598) (actual time=6.416..6.416 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit, ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create, ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting, pi.id, pi.birth_dt, pi.death_dt, pi.has_citizenship, pi.name, pi.patr_name, pi.surname, pi.gender_id, pi.nationality_id, pi.list_identity_doc, pi.list_oms_doc, pi.list_job_org, pi.list_reg_name, pi.list_snils, pi.list_uid, pi.aud_who, pi.aud_when, pi.aud_source, pi.aud_who_create, pi.aud_when_create, pi.aud_source_create, pi.birth_place, pi.age_year, pi.age_month, pi.age_day, pi.list_main_contact, pi.is_only_birth_year, ma.registration_dt
  • Buffers: shared hit=2574
4. 0.001 6.416 ↓ 0.0 0 1

Nested Loop (cost=34,365.64..36,884.40 rows=1 width=3,711) (actual time=6.416..6.416 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit, ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create, ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting
  • Buffers: shared hit=2574
5. 0.001 6.415 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,365.07..36,877.32 rows=1 width=2,981) (actual time=6.415..6.415 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit, ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create
  • Buffers: shared hit=2574
6. 0.000 6.414 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,364.64..36,870.41 rows=1 width=2,896) (actual time=6.414..6.414 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt, mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit
  • Join Filter: (mhc.category_id = mhcc.id)
  • Buffers: shared hit=2574
7. 0.000 6.414 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,364.64..36,869.26 rows=1 width=2,573) (actual time=6.414..6.414 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment, mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt
  • Join Filter: (mhc.result_id = mhcr.id)
  • Buffers: shared hit=2574
8. 0.002 6.414 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,364.64..36,868.10 rows=1 width=2,234) (actual time=6.414..6.414 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id, mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment
  • Buffers: shared hit=2574
9. 0.000 6.412 ↓ 0.0 0 1

Nested Loop (cost=34,364.35..36,861.37 rows=1 width=1,874) (actual time=6.412..6.412 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id
  • Buffers: shared hit=2574
10. 0.000 6.412 ↓ 0.0 0 1

Nested Loop (cost=34,363.91..36,854.46 rows=1 width=1,816) (actual time=6.412..6.412 rows=0 loops=1)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id, strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id
  • Buffers: shared hit=2574
11. 0.026 6.412 ↓ 0.0 0 1

Hash Right Join (cost=34,363.34..36,845.86 rows=1 width=1,135) (actual time=6.412..6.412 rows=0 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code, mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id
  • Hash Cond: (mha.appointment_id = ma.id)
  • Buffers: shared hit=2574
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.md_hcall_assignment mha (cost=0.00..2,154.55 rows=87,455 width=102) (never executed)

  • Output: mha.id, mha.house_call_id, mha.appointment_id, mha.date, mha.reassign_reason_id, mha.comment, mha.aud_who, mha.aud_when, mha.aud_source, mha.aud_who_create, mha.aud_when_create, mha.aud_source_create, mha.department_id
13. 0.001 6.386 ↓ 0.0 0 1

Hash (cost=34,363.33..34,363.33 rows=1 width=1,033) (actual time=6.386..6.386 rows=0 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=2574
14. 0.001 6.385 ↓ 0.0 0 1

Nested Loop (cost=2.42..34,363.33 rows=1 width=1,033) (actual time=6.385..6.385 rows=0 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create, ma.id, ma.srv_rendered_id, ma.executor_id, ma.bdatetime, ma.customer_id, ma.funding_id, ma.state_id, ma.service_id, ma.cancel_reason_id, ma.care_regimen_id, ma.care_level_id, ma.referral_id, ma.source_id, ma.registrator_id, ma.registration_dt, ma.edatetime, ma.is_urgent, ma.notif_contact, ma.price_list_id, ma.message, ma.queue_state_id, ma.queue_change_dt, ma.ticket_number, ma.price, ma.init_goal_id, ma.organization_id, ma.is_house_call, ma.comment, ma.aud_who, ma.aud_when, ma.aud_source, ma.aud_who_create, ma.aud_when_create, ma.aud_source_create, ma.reject_comment, ma.reject_reason_id, ma.way_id, ma.is_cito, ma.event_id, ma.is_send_message, ma.comment_send_message, ma.cancel_dt, ma.answer_portal_code
  • Join Filter: (((COALESCE(ss.bdatetime, ma.bdatetime))::date >= '2020-01-31'::date) AND ((COALESCE(ss.bdatetime, ma.bdatetime))::date <= '2020-01-31'::date))
  • Buffers: shared hit=2574
15. 0.000 6.384 ↓ 0.0 0 1

Nested Loop (cost=1.85..34,278.71 rows=12 width=302) (actual time=6.384..6.384 rows=0 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter, sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create
  • Buffers: shared hit=2574
16. 0.004 6.384 ↓ 0.0 0 1

Nested Loop (cost=1.42..34,132.27 rows=20 width=240) (actual time=6.384..6.384 rows=0 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create, ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter
  • Buffers: shared hit=2574
17. 0.195 0.689 ↑ 1.7 271 1

Nested Loop (cost=0.85..507.64 rows=462 width=148) (actual time=0.045..0.689 rows=271 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create, ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create
  • Buffers: shared hit=184
18. 0.059 0.059 ↑ 1.7 15 1

Index Scan using idx_sr_timetable_res_group on public.sr_timetable_res_group strg (cost=0.42..75.39 rows=26 width=60) (actual time=0.025..0.059 rows=15 loops=1)

  • Output: strg.id, strg.res_group_id, strg.aud_who, strg.aud_when, strg.aud_source, strg.aud_who_create, strg.aud_when_create, strg.aud_source_create
  • Index Cond: (strg.res_group_id = 58580925)
  • Buffers: shared hit=16
19. 0.435 0.435 ↑ 1.3 18 15

Index Scan using sr_shift_timetable_id_idx on public.sr_shift ss1 (cost=0.43..16.38 rows=24 width=88) (actual time=0.010..0.029 rows=18 loops=15)

  • Output: ss1.id, ss1.bdatetime, ss1.edatetime, ss1.schedule_id, ss1.time_type_id, ss1.timetable_id, ss1.schedule_kind_id, ss1.aud_who, ss1.aud_when, ss1.aud_source, ss1.aud_who_create, ss1.aud_when_create, ss1.aud_source_create
  • Index Cond: (ss1.timetable_id = strg.id)
  • Buffers: shared hit=168
20. 5.691 5.691 ↓ 0.0 0 271

Index Scan using sr_session_shift_id_idx on public.sr_session ss (cost=0.56..72.77 rows=1 width=92) (actual time=0.021..0.021 rows=0 loops=271)

  • Output: ss.id, ss.bdatetime, ss.edatetime, ss.time_type_id, ss.shift_id, ss.is_house_call, ss.aud_who, ss.aud_when, ss.aud_source, ss.aud_who_create, ss.aud_when_create, ss.aud_source_create, ss.eboard_prohibited, ss.session_number, ss.ticket_counter
  • Index Cond: (ss.shift_id = ss1.id)
  • Filter: ss.is_house_call
  • Rows Removed by Filter: 18
  • Buffers: shared hit=2390
21. 0.000 0.000 ↓ 0.0 0

Index Scan using sr_session_ticket_session_id_idx on public.sr_session_ticket sst (cost=0.44..7.30 rows=2 width=62) (never executed)

  • Output: sst.session_id, sst.ticket_id, sst.aud_who, sst.aud_when, sst.aud_source, sst.aud_who_create, sst.aud_when_create, sst.aud_source_create
  • Index Cond: (sst.session_id = ss.id)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using md_appointment_pk on public.md_appointment ma (cost=0.56..7.03 rows=1 width=731) (never executed)

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

Index Scan using sr_res_group_responsible_id_id_ix on public.sr_res_group srg (cost=0.57..8.59 rows=1 width=681) (never executed)

  • Output: srg.id, srg.bdate, srg.edate, srg.is_system, srg.name, srg.department_id, srg.org_id, srg.responsible_id, srg.is_available_in_electronic_queue, srg.label_id, srg.ignore_regclinic_check, srg.note, srg.blocked, srg.block_comment, srg.template_res_group_id, srg.aud_who, srg.aud_when, srg.aud_source, srg.aud_who_create, srg.aud_when_create, srg.aud_source_create, srg.emergency, srg.ignore_districts, srg.service_template_id
  • Index Cond: ((srg.responsible_id = 73230) AND (srg.id = 58580925))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using sr_ticket_pk on public.sr_ticket st (cost=0.44..6.90 rows=1 width=58) (never executed)

  • Output: st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create
  • Index Cond: (st.id = sst.ticket_id)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using md_house_call_pk on public.md_house_call mhc (cost=0.29..6.72 rows=1 width=360) (never executed)

  • Output: mhc.id, mhc.address_id, mhc.entryphone, mhc.district_id, mhc.category_id, mhc.call_reason_id, mhc.temperature, mhc.complaints, mhc.contact, mhc.is_executor_assigned, mhc.result_id, mhc.deviation_reason_id, mhc.name, mhc.patr_name, mhc.surname, mhc.address_text, mhc.aud_who, mhc.aud_when, mhc.aud_source, mhc.aud_who_create, mhc.aud_when_create, mhc.aud_source_create, mhc.house_call_number, mhc.emergency, mhc.actual_appointment_id, mhc.actual_assignment_id, mhc.date, mhc.organization_id, mhc.patient_id, mhc.executor_assign_date, mhc.source_id, mhc.call_reason_text, mhc.age, mhc.age_measure_id, mhc.gender_id, mhc.result_comment
  • Index Cond: (mhc.id = mha.house_call_id)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.md_house_call_result mhcr (cost=0.00..1.07 rows=7 width=339) (never executed)

  • Output: mhcr.id, mhcr.name, mhcr.code, mhcr.e_code, mhcr.aud_who, mhcr.aud_when, mhcr.aud_source, mhcr.aud_who_create, mhcr.aud_when_create, mhcr.aud_source_create, mhcr.from_dt, mhcr.to_dt
27. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.md_house_call_category mhcc (cost=0.00..1.07 rows=7 width=323) (never executed)

  • Output: mhcc.id, mhcc.name, mhcc.code, mhcc.e_code, mhcc.aud_who, mhcc.aud_when, mhcc.aud_source, mhcc.aud_who_create, mhcc.aud_when_create, mhcc.aud_source_create, mhcc.from_dt, mhcc.to_dt, mhcc.close_without_visit
28. 0.000 0.000 ↓ 0.0 0

Index Scan using address_element_pkey on public.address_element ae (cost=0.43..6.89 rows=1 width=85) (never executed)

  • Output: ae.id, ae.name, ae.display_format_id, ae.level_id, ae.parent_id, ae.type_id, ae.temp, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create
  • Index Cond: (mhc.address_id = ae.id)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using sr_srv_rendered_pk on public.sr_srv_rendered ssr (cost=0.57..7.07 rows=1 width=730) (never executed)

  • Output: ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting
  • Index Cond: (ssr.id = ma.srv_rendered_id)
  • Filter: (NOT ssr.is_rendered)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using pim_individual_pk on public.pim_individual pi (cost=0.43..6.87 rows=1 width=887) (never executed)

  • Output: pi.id, pi.birth_dt, pi.death_dt, pi.has_citizenship, pi.name, pi.patr_name, pi.surname, pi.gender_id, pi.nationality_id, pi.list_identity_doc, pi.list_oms_doc, pi.list_job_org, pi.list_reg_name, pi.list_snils, pi.list_uid, pi.aud_who, pi.aud_when, pi.aud_source, pi.aud_who_create, pi.aud_when_create, pi.aud_source_create, pi.birth_place, pi.age_year, pi.age_month, pi.age_day, pi.list_main_contact, pi.is_only_birth_year
  • Index Cond: (ma.customer_id = pi.id)
Planning time : 25.988 ms
Execution time : 8.446 ms