explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Md8v

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 7.479 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,450.93..37,271.26 rows=12 width=4,598) (actual time=7.479..7.479 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
  • Buffers: shared hit=2579
2. 0.001 7.477 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,450.50..37,188.72 rows=12 width=3,711) (actual time=7.477..7.477 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=2579
3. 0.000 7.476 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,449.93..37,103.77 rows=12 width=2,981) (actual time=7.476..7.476 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=2579
4. 0.002 7.476 ↓ 0.0 0 1

Hash Left Join (cost=34,449.51..37,020.93 rows=12 width=2,896) (actual time=7.476..7.476 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
  • Hash Cond: (mhc.category_id = mhcc.id)
  • Buffers: shared hit=2579
5. 0.000 7.474 ↓ 0.0 0 1

Hash Left Join (cost=34,448.35..37,019.62 rows=12 width=2,573) (actual time=7.474..7.474 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
  • Hash Cond: (mhc.result_id = mhcr.id)
  • Buffers: shared hit=2579
6. 0.000 7.474 ↓ 0.0 0 1

Nested Loop Left Join (cost=34,447.19..37,018.29 rows=12 width=2,234) (actual time=7.474..7.474 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=2579
7. 0.006 7.474 ↓ 0.0 0 1

Nested Loop (cost=34,446.90..36,937.55 rows=12 width=1,874) (actual time=7.474..7.474 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=2579
8. 0.043 0.043 ↑ 1.0 1 1

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) (actual time=0.042..0.043 rows=1 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
  • Index Cond: ((srg.responsible_id = 73230) AND (srg.id = 58580925))
  • Buffers: shared hit=5
9. 0.013 7.425 ↓ 0.0 0 1

Hash Right Join (cost=34,446.33..36,928.85 rows=12 width=1,193) (actual time=7.425..7.425 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, 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
  • Hash Cond: (mha.appointment_id = ma.id)
  • Buffers: shared hit=2574
10. 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
11. 0.000 7.412 ↓ 0.0 0 1

Hash (cost=34,446.18..34,446.18 rows=12 width=1,091) (actual time=7.412..7.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, 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
  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=2574
12. 0.000 7.412 ↓ 0.0 0 1

Nested Loop (cost=2.85..34,446.18 rows=12 width=1,091) (actual time=7.412..7.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, 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
  • Buffers: shared hit=2574
13. 0.002 7.412 ↓ 0.0 0 1

Nested Loop (cost=2.29..34,361.68 rows=12 width=360) (actual time=7.412..7.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, st.id, st.aud_who, st.aud_when, st.aud_source, st.aud_who_create, st.aud_when_create, st.aud_source_create
  • Buffers: shared hit=2574
14. 0.000 7.410 ↓ 0.0 0 1

Nested Loop (cost=1.85..34,278.71 rows=12 width=302) (actual time=7.410..7.410 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
15. 0.287 7.410 ↓ 0.0 0 1

Nested Loop (cost=1.42..34,132.27 rows=20 width=240) (actual time=7.410..7.410 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
16. 0.192 1.161 ↑ 1.7 271 1

Nested Loop (cost=0.85..507.64 rows=462 width=148) (actual time=0.040..1.161 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
17. 0.069 0.069 ↑ 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.021..0.069 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
18. 0.900 0.900 ↑ 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.017..0.060 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
19. 5.962 5.962 ↓ 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.022..0.022 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
20. 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)
21. 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)
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 = st.id)
23. 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)
24. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.07..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
25. 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
26. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.07..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
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: (ma.srv_rendered_id = ssr.id)
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 : 12.201 ms
Execution time : 8.701 ms