explain.depesz.com

PostgreSQL's explain analyze made readable

Result: E6QH

Settings
# exclusive inclusive rows x rows loops node
1. 0.350 1,019.393 ↑ 1.0 1 1

Limit (cost=46.30..1,337,802.32 rows=1 width=5,673) (actual time=1,018.926..1,019.393 rows=1 loops=1)

  • Output: cal.id, cal.control, (('№ '::text || (cal.call_number)::text)), cal.call_mark, ((SubPlan 1)), ((SubPlan 2)), cal.call_kind_id, cal.call_type_id, pep.id, ((((((((((pi.surname)::text || ' '::text) || "left"(initcap((pi.name)::text), 1)) || '. '::text) || "left"(initcap((pi.patr_name)::text), 1)) || '.'::text) || '('::text) || (CASE WHEN ((pep.code IS NOT NULL) AND ((pep.code)::text <> ''::text)) THEN pep.code ELSE (pep.id)::character varying(10) END)::text) || ')'::text)), srg.id, srg.name, srtjr.id, ((((((((((((respep.id)::text || ': '::text) || (respi.surname)::text) || ' '::text) || "left"(initcap((respi.name)::text), 1)) || '. '::text) || "left"(initcap((respi.patr_name)::text), 1)) || '.'::text) || '('::text) || (resppos.name)::text) || ')'::text)), ts.id, ts.name, cal.from_time, (to_char(cal.from_time, 'hh24:mi'::text)), (CASE WHEN ((SubPlan 3) IS NOT NULL) THEN (SubPlan 4) ELSE NULL::text END), (CASE WHEN ((SubPlan 5) IS NOT NULL) THEN (SubPlan 6) ELSE NULL::text END), (CASE WHEN ((SubPlan 7) IS NOT NULL) THEN (SubPlan 8) ELSE NULL::text END), (CASE WHEN ((SubPlan 9) IS NOT NULL) THEN (SubPlan 10) ELSE NULL::text END), (CASE WHEN ((SubPlan 11) IS NOT NULL) THEN (SubPlan 12) ELSE NULL::text END), (CASE WHEN ((SubPlan 13) IS NOT NULL) THEN (SubPlan 14) ELSE NULL::text END), (CASE WHEN ((SubPlan 15) IS NOT NULL) THEN to_char(((SubPlan 16) - cal.from_time), 'hh24:mi'::text) ELSE NULL::text END), (CASE WHEN ((SubPlan 17) IS NOT NULL) THEN to_char(((SubPlan 18) - (SubPlan 19)), 'hh24:mi'::text) ELSE NULL::text END), (CASE WHEN ((SubPlan 20) IS NOT NULL) THEN to_char((cal.to_time - (SubPlan 21)), 'hh24:mi'::text) ELSE NULL::text END), (to_char(cal.to_time, 'hh24:mi'::text)), (CASE WHEN ((SubPlan 22) IS NOT NULL) THEN (SubPlan 23) ELSE NULL::text END), step.death_date, (CASE WHEN (step.death_time IS NOT NULL) THEN to_char((step.death_time)::interval, 'hh24:mi'::text) ELSE NULL::text END), deathdiag.id, deathpep.id, ((((((((((deathpi.surname)::text || ' '::text) || "left"(initcap((deathpi.name)::text), 1)) || '. '::text) || "left"(initcap((deathpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (deathppos.name)::text) || ')'::text)), (to_char((cal.to_time - cal.from_time), 'hh24:mi'::text)), cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, pip.id, pip.id, pip.id, ((((((pip.surname)::text || ' '::text) || (pip.name)::text) || ' '::text) || (pip.patr_name)::text)), pip.surname, pip.name, pip.patr_name, (CASE WHEN (get_age(pip.birth_dt, (now())::date) = '-1'::integer) THEN ''::character varying ELSE (get_age(pip.birth_dt, (now())::date))::character varying(3) END), pip.birth_dt, (CASE WHEN ((((SubPlan 24))::text ~~ 'пациент скорой%'::text) AND ((SubPlan 25) = $26)) THEN true ELSE false END), pg.id, pg.id, (lower("left"(initcap((pg.name)::text), 1))), cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, (CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%year%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END), (CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%month%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END), (CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%day%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END), pic.id, pic.code, pic.indiv_id, idoc.type_id, idoc.series, idoc.number, (COALESCE(cr.citizenship_type_id, (SubPlan 29))), (COALESCE(cr.soc_group_id, (SubPlan 30))), masterdiag.id, masterd.note, ((((masterdiag.code)::text || ' '::text) || (masterdiag.name)::text)), mdist.id, accompdiag.id, accompd.note, accompdist.id, step.result_id, ((SubPlan 31)), ((SubPlan 32)), step.outcome_id, crea.id, cal.reason_note, dia.id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cas.time_gone_id, ((cr.nsdatatime)::date), (to_char(cr.nsdatatime, 'HH24:mi'::text)), po.id, (COALESCE(po.short_name, po.full_name)), ppa.addr_id, stael.search_name, cal.route_id, pd.id, pd.name, substaed.id, substaed.search_name, routepep.id, delres.id, ((SubPlan 33)), (CASE WHEN (cr.need_exit_through IS NOT NULL) THEN 1 ELSE CASE WHEN (cr.activ_visit_clinic_id IS NOT NULL) THEN 2 ELSE 3 END END), cr.need_exit_through, poliorg.id, (COALESCE(poliorg.full_name, poliorg.short_name)), cr.other_recommendations, cal.to_org_id, cal.to_department_id, cal.to_address_id, toaed.search_name, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, step.outcome_date, (to_char((step.outcome_time)::interval, 'HH24:MI'::text)), (CASE WHEN (alternatives: SubPlan 34 or hashed SubPlan 35) THEN to_char((step.outcome_time)::interval, 'HH24:MI'::text) ELSE NULL::text END), clinddiag.id, cas.transporting_type_id, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, step.outcome_date, (to_char((step.outcome_time)::interval, 'HH24:mi'::text)), cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, ((((cal.description)::text || ','::text) || (cal.note)::text)), mash.id, (to_char(mash.date_time, 'dd.mm.yyyy hh24:mi:ss'::text)), ($39), ($40), (((((((((((amb.search_call_note(cal.id) || ' Заполнил карту вызова: '::text) || (kvpi.surname)::text) || ' '::text) || "left"(initcap((kvpi.name)::text), 1)) || '. '::text) || "left"(initcap((kvpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (kvppos.name)::text) || ')'::text)), ((cr.milage)::character varying(5)), ((SubPlan 38)), cr.complications_result_measure_id, cal.note, cas.note, cas.death_reason, ((((((((((kvpi.surname)::text || ' '::text) || "left"(initcap((kvpi.name)::text), 1)) || '. '::text) || "left"(initcap((kvpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (kvppos.name)::text) || ')'::text)), (CASE WHEN ((SubPlan 39) IS NOT NULL) THEN true ELSE false END), ssr.id, (CASE WHEN ((SubPlan 40) > 0) THEN true ELSE false END), cr.receive_brg, mac.id, ((cal.from_time)::date), (CASE WHEN (alternatives: SubPlan 41 or hashed SubPlan 42) THEN true ELSE false END), (CASE WHEN (alternatives: SubPlan 43 or hashed SubPlan 44) THEN (SubPlan 45) ELSE NULL::integer END), cr.take_birth_id, ($52)
  • Buffers: shared hit=3,959 read=283 dirtied=1
  • I/O Timings: read=828.408
2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.pci_part_case_internal (cost=0.00..1.07 rows=1 width=4) (never executed)

  • Output: pci_part_case_internal.id
  • Filter: ((pci_part_case_internal.code)::text = '8'::text)
4. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state (cost=0.00..1.19 rows=1 width=4) (actual time=0.011..0.013 rows=1 loops=1)

  • Output: md_ambulance_call_state.id
  • Filter: ((md_ambulance_call_state.code)::text = '4'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
5. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state md_ambulance_call_state_1 (cost=0.00..1.19 rows=1 width=36) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: md_ambulance_call_state_1.name
  • Filter: ((md_ambulance_call_state_1.code)::text = '4'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
6. 0.066 0.066 ↑ 1.0 1 1

Seq Scan on public.pim_party_role (cost=0.00..1.46 rows=1 width=4) (actual time=0.041..0.066 rows=1 loops=1)

  • Output: pim_party_role.id
  • Filter: (btrim(upper((pim_party_role.code)::text)) = 'CLINIC_ORGANIZATION'::text)
  • Rows Removed by Filter: 25
  • Buffers: shared hit=1
7. 0.025 0.025 ↑ 1.0 1 1

Seq Scan on public.pim_code_type (cost=0.00..1.36 rows=1 width=4) (actual time=0.020..0.025 rows=1 loops=1)

  • Output: pim_code_type.id
  • Filter: ((pim_code_type.code)::text = 'ENP'::text)
  • Rows Removed by Filter: 30
  • Buffers: shared hit=1
8. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state md_ambulance_call_state_2 (cost=0.00..1.19 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Output: md_ambulance_call_state_2.id
  • Filter: ((md_ambulance_call_state_2.code)::text = '4'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
9. 388.037 1,018.924 ↑ 88.0 1 1

Nested Loop Left Join (cost=38.84..117,722,568.73 rows=88 width=5,673) (actual time=1,018.924..1,018.924 rows=1 loops=1)

  • Output: cal.id, cal.control, ('№ '::text || (cal.call_number)::text), cal.call_mark, (SubPlan 1), (SubPlan 2), cal.call_kind_id, cal.call_type_id, pep.id, (((((((((pi.surname)::text || ' '::text) || "left"(initcap((pi.name)::text), 1)) || '. '::text) || "left"(initcap((pi.patr_name)::text), 1)) || '.'::text) || '('::text) || (CASE WHEN ((pep.code IS NOT NULL) AND ((pep.code)::text <> ''::text)) THEN pep.code ELSE (pep.id)::character varying(10) END)::text) || ')'::text), srg.id, srg.name, srtjr.id, (((((((((((respep.id)::text || ': '::text) || (respi.surname)::text) || ' '::text) || "left"(initcap((respi.name)::text), 1)) || '. '::text) || "left"(initcap((respi.patr_name)::text), 1)) || '.'::text) || '('::text) || (resppos.name)::text) || ')'::text), ts.id, ts.name, cal.from_time, to_char(cal.from_time, 'hh24:mi'::text), CASE WHEN ((SubPlan 3) IS NOT NULL) THEN (SubPlan 4) ELSE NULL::text END, CASE WHEN ((SubPlan 5) IS NOT NULL) THEN (SubPlan 6) ELSE NULL::text END, CASE WHEN ((SubPlan 7) IS NOT NULL) THEN (SubPlan 8) ELSE NULL::text END, CASE WHEN ((SubPlan 9) IS NOT NULL) THEN (SubPlan 10) ELSE NULL::text END, CASE WHEN ((SubPlan 11) IS NOT NULL) THEN (SubPlan 12) ELSE NULL::text END, CASE WHEN ((SubPlan 13) IS NOT NULL) THEN (SubPlan 14) ELSE NULL::text END, CASE WHEN ((SubPlan 15) IS NOT NULL) THEN to_char(((SubPlan 16) - cal.from_time), 'hh24:mi'::text) ELSE NULL::text END, CASE WHEN ((SubPlan 17) IS NOT NULL) THEN to_char(((SubPlan 18) - (SubPlan 19)), 'hh24:mi'::text) ELSE NULL::text END, CASE WHEN ((SubPlan 20) IS NOT NULL) THEN to_char((cal.to_time - (SubPlan 21)), 'hh24:mi'::text) ELSE NULL::text END, to_char(cal.to_time, 'hh24:mi'::text), CASE WHEN ((SubPlan 22) IS NOT NULL) THEN (SubPlan 23) ELSE NULL::text END, step.death_date, CASE WHEN (step.death_time IS NOT NULL) THEN to_char((step.death_time)::interval, 'hh24:mi'::text) ELSE NULL::text END, deathdiag.id, deathpep.id, (((((((((deathpi.surname)::text || ' '::text) || "left"(initcap((deathpi.name)::text), 1)) || '. '::text) || "left"(initcap((deathpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (deathppos.name)::text) || ')'::text), to_char((cal.to_time - cal.from_time), 'hh24:mi'::text), cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, pip.id, pip.id, pip.id, (((((pip.surname)::text || ' '::text) || (pip.name)::text) || ' '::text) || (pip.patr_name)::text), pip.surname, pip.name, pip.patr_name, CASE WHEN (get_age(pip.birth_dt, (now())::date) = '-1'::integer) THEN ''::character varying ELSE (get_age(pip.birth_dt, (now())::date))::character varying(3) END, pip.birth_dt, CASE WHEN ((((SubPlan 24))::text ~~ 'пациент скорой%'::text) AND ((SubPlan 25) = $26)) THEN true ELSE false END, pg.id, pg.id, lower("left"(initcap((pg.name)::text), 1)), cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%year%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END, CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%month%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END, CASE WHEN ((amb.get_age_full(pip.birth_dt, (now())::date) <> '00:00:00'::interval) AND (((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text ~~ '%day%'::text)) THEN (split_part(((amb.get_age_full(pip.birth_dt, (now())::date))::character varying(9))::text, ' '::text, 1))::integer ELSE NULL::integer END, pic.id, pic.code, pic.indiv_id, idoc.type_id, idoc.series, idoc.number, COALESCE(cr.citizenship_type_id, (SubPlan 29)), COALESCE(cr.soc_group_id, (SubPlan 30)), masterdiag.id, masterd.note, (((masterdiag.code)::text || ' '::text) || (masterdiag.name)::text), mdist.id, accompdiag.id, accompd.note, accompdist.id, step.result_id, (SubPlan 31), (SubPlan 32), step.outcome_id, crea.id, cal.reason_note, dia.id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cas.time_gone_id, (cr.nsdatatime)::date, to_char(cr.nsdatatime, 'HH24:mi'::text), po.id, COALESCE(po.short_name, po.full_name), ppa.addr_id, stael.search_name, cal.route_id, pd.id, pd.name, substaed.id, substaed.search_name, routepep.id, delres.id, (SubPlan 33), CASE WHEN (cr.need_exit_through IS NOT NULL) THEN 1 ELSE CASE WHEN (cr.activ_visit_clinic_id IS NOT NULL) THEN 2 ELSE 3 END END, cr.need_exit_through, poliorg.id, COALESCE(poliorg.full_name, poliorg.short_name), cr.other_recommendations, cal.to_org_id, cal.to_department_id, cal.to_address_id, toaed.search_name, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, step.outcome_date, to_char((step.outcome_time)::interval, 'HH24:MI'::text), CASE WHEN (alternatives: SubPlan 34 or hashed SubPlan 35) THEN to_char((step.outcome_time)::interval, 'HH24:MI'::text) ELSE NULL::text END, clinddiag.id, cas.transporting_type_id, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, step.outcome_date, to_char((step.outcome_time)::interval, 'HH24:mi'::text), cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, (((cal.description)::text || ','::text) || (cal.note)::text), mash.id, to_char(mash.date_time, 'dd.mm.yyyy hh24:mi:ss'::text), $39, $40, ((((((((((amb.search_call_note(cal.id) || ' Заполнил карту вызова: '::text) || (kvpi.surname)::text) || ' '::text) || "left"(initcap((kvpi.name)::text), 1)) || '. '::text) || "left"(initcap((kvpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (kvppos.name)::text) || ')'::text), (cr.milage)::character varying(5), (SubPlan 38), cr.complications_result_measure_id, cal.note, cas.note, cas.death_reason, (((((((((kvpi.surname)::text || ' '::text) || "left"(initcap((kvpi.name)::text), 1)) || '. '::text) || "left"(initcap((kvpi.patr_name)::text), 1)) || '.'::text) || '('::text) || (kvppos.name)::text) || ')'::text), CASE WHEN ((SubPlan 39) IS NOT NULL) THEN true ELSE false END, ssr.id, CASE WHEN ((SubPlan 40) > 0) THEN true ELSE false END, cr.receive_brg, mac.id, (cal.from_time)::date, CASE WHEN (alternatives: SubPlan 41 or hashed SubPlan 42) THEN true ELSE false END, CASE WHEN (alternatives: SubPlan 43 or hashed SubPlan 44) THEN (SubPlan 45) ELSE NULL::integer END, cr.take_birth_id, $52
  • Join Filter: (macc.call_id = cal.id)
  • Rows Removed by Join Filter: 234
  • Buffers: shared hit=3,959 read=283 dirtied=1
  • I/O Timings: read=828.408
10. 1.142 493.527 ↑ 88.0 1 1

Nested Loop (cost=38.84..117,689,933.51 rows=88 width=3,604) (actual time=493.526..493.527 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name, ssr.id, kvpi.surname, kvpi.name, kvpi.patr_name, kvppos.name
  • Join Filter: (kvpep.position_id = kvppos.id)
  • Rows Removed by Join Filter: 7,076
  • Buffers: shared hit=3,052 read=176
  • I/O Timings: read=322.907
11. 0.083 486.517 ↑ 88.0 1 1

Nested Loop (cost=38.84..117,680,034.28 rows=88 width=3,554) (actual time=486.517..486.517 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name, ssr.id, kvpep.position_id, kvpi.surname, kvpi.name, kvpi.patr_name
  • Buffers: shared hit=2,914 read=176
  • I/O Timings: read=322.907
12. 2.240 485.483 ↑ 88.0 1 1

Nested Loop (cost=38.42..117,679,382.60 rows=88 width=3,509) (actual time=485.483..485.483 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name, ssr.id, kvpep.position_id, kvpe.individual_id
  • Join Filter: (kvpep.employee_id = kvpe.id)
  • Rows Removed by Join Filter: 13,576
  • Buffers: shared hit=2,912 read=174
  • I/O Timings: read=322.011
13. 3.639 474.629 ↑ 88.0 1 1

Nested Loop (cost=38.42..117,660,387.03 rows=88 width=3,509) (actual time=474.629..474.629 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name, ssr.id, kvpep.employee_id, kvpep.position_id
  • Join Filter: (cr.registrator_id = kvpep.id)
  • Rows Removed by Join Filter: 22,731
  • Buffers: shared hit=2,739 read=174
  • I/O Timings: read=322.011
14. 0.009 453.240 ↑ 88.0 1 1

Nested Loop Left Join (cost=38.42..117,628,673.32 rows=88 width=3,505) (actual time=453.240..453.240 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name, ssr.id
  • Buffers: shared hit=2,414 read=174
  • I/O Timings: read=322.011
15. 1.155 453.142 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.85..117,628,314.22 rows=88 width=3,505) (actual time=453.142..453.142 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpi.surname, deathpi.name, deathpi.patr_name, deathppos.name
  • Join Filter: (deathppos.id = deathpep.position_id)
  • Rows Removed by Join Filter: 7,321
  • Buffers: shared hit=2,408 read=174
  • I/O Timings: read=322.011
16. 0.008 427.175 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.85..117,618,414.99 rows=88 width=3,455) (actual time=427.174..427.175 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpep.position_id, deathpi.surname, deathpi.name, deathpi.patr_name
  • Buffers: shared hit=2,310 read=128
  • I/O Timings: read=305.335
17. 2.115 427.164 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.43..117,617,763.31 rows=88 width=3,410) (actual time=427.164..427.164 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpep.position_id, deathpe.individual_id
  • Join Filter: (deathpe.id = deathpep.employee_id)
  • Rows Removed by Join Filter: 14,121
  • Buffers: shared hit=2,310 read=128
  • I/O Timings: read=305.335
18. 3.574 404.452 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.43..117,598,767.74 rows=88 width=3,410) (actual time=404.452..404.452 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id, deathpep.id, deathpep.employee_id, deathpep.position_id
  • Join Filter: (deathpep.id = step.death_employee_id)
  • Rows Removed by Join Filter: 23,548
  • Buffers: shared hit=2,158 read=98
  • I/O Timings: read=296.606
19. 0.001 380.920 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.43..117,567,054.03 rows=88 width=3,402) (actual time=380.920..380.920 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id, deathdiag.id
  • Buffers: shared hit=1,818 read=98
  • I/O Timings: read=296.606
20. 0.007 380.918 ↑ 88.0 1 1

Nested Loop Left Join (cost=37.14..117,566,737.45 rows=88 width=3,402) (actual time=380.917..380.918 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clinddiag.id
  • Buffers: shared hit=1,818 read=98
  • I/O Timings: read=296.606
21. 0.003 380.911 ↑ 88.0 1 1

Nested Loop Left Join (cost=36.86..117,566,420.86 rows=88 width=3,402) (actual time=380.911..380.911 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name, clind.diagnos_id
  • Buffers: shared hit=1,818 read=98
  • I/O Timings: read=296.606
22. 0.007 380.906 ↑ 88.0 1 1

Nested Loop Left Join (cost=36.42..117,565,793.47 rows=88 width=3,402) (actual time=380.906..380.906 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name, toaed.search_name
  • Buffers: shared hit=1,818 read=98
  • I/O Timings: read=296.606
23. 2.985 380.895 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.99..117,565,174.20 rows=88 width=3,201) (actual time=380.895..380.895 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, poliorg.id, poliorg.full_name, poliorg.short_name
  • Join Filter: (poliorg.id = policl.id)
  • Rows Removed by Join Filter: 19,766
  • Buffers: shared hit=1,818 read=98
  • I/O Timings: read=296.606
24. 0.021 353.285 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.99..117,538,076.33 rows=88 width=2,983) (actual time=353.285..353.285 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id, policl.id
  • Join Filter: (policl.id = cr.activ_visit_clinic_id)
  • Rows Removed by Join Filter: 77
  • Buffers: shared hit=1,053 read=98
  • I/O Timings: read=296.606
25. 0.003 353.196 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.99..117,537,963.73 rows=88 width=2,979) (actual time=353.196..353.196 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id, delres.id
  • Join Filter: (delres.id = cr.out_delay_reason_id)
  • Buffers: shared hit=1,043 read=98
  • I/O Timings: read=296.606
26. 0.437 353.180 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.99..117,537,956.07 rows=88 width=2,979) (actual time=353.180..353.180 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, routepep.id
  • Join Filter: (routepep.id = mash.registrator_id)
  • Rows Removed by Join Filter: 2,694
  • Buffers: shared hit=1,042 read=98
  • I/O Timings: read=296.606
27. 0.004 350.387 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.99..117,506,242.35 rows=88 width=2,979) (actual time=350.386..350.387 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name, mash.id, mash.date_time, mash.registrator_id
  • Buffers: shared hit=1,005 read=98
  • I/O Timings: read=296.606
28. 0.007 330.150 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.56..117,505,596.86 rows=88 width=2,963) (actual time=330.149..330.150 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, substaed.id, substaed.search_name
  • Buffers: shared hit=1,000 read=96
  • I/O Timings: read=276.434
29. 0.033 330.140 ↑ 88.0 1 1

Nested Loop Left Join (cost=35.13..117,504,855.24 rows=88 width=2,762) (actual time=330.140..330.140 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name, pda.addr_id
  • Join Filter: (pda.dep_id = pd.id)
  • Rows Removed by Join Filter: 147
  • Buffers: shared hit=1,000 read=96
  • I/O Timings: read=276.434
30. 0.016 328.478 ↑ 88.0 1 1

Nested Loop (cost=35.13..117,504,617.65 rows=88 width=2,758) (actual time=328.477..328.478 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, stael.search_name, pd.id, pd.name
  • Join Filter: (cal.station_id = mc.id)
  • Rows Removed by Join Filter: 73
  • Buffers: shared hit=983 read=88
  • I/O Timings: read=275.331
31. 0.028 328.368 ↑ 87.0 1 1

Nested Loop (cost=35.13..117,504,506.20 rows=87 width=2,762) (actual time=328.368..328.368 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, ppa.party_id, stael.search_name, pd.id, pd.name
  • Join Filter: (cal.substation_id = pd.id)
  • Rows Removed by Join Filter: 146
  • Buffers: shared hit=974 read=88
  • I/O Timings: read=275.331
32. 3.272 328.075 ↑ 87.0 1 1

Nested Loop (cost=35.13..117,501,340.49 rows=87 width=2,692) (actual time=328.074..328.075 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, po.id, po.short_name, po.full_name, ppa.addr_id, ppa.party_id, stael.search_name
  • Join Filter: (cal.station_id = po.id)
  • Rows Removed by Join Filter: 18,201
  • Buffers: shared hit=970 read=88
  • I/O Timings: read=275.331
33. 0.021 283.777 ↑ 87.0 1 1

Nested Loop Left Join (cost=35.13..117,474,539.06 rows=87 width=2,470) (actual time=283.777..283.777 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, dia.id, ppa.addr_id, ppa.party_id, stael.search_name
  • Buffers: shared hit=239 read=88
  • I/O Timings: read=275.331
34. 0.033 283.755 ↑ 87.0 1 1

Nested Loop (cost=34.85..117,474,226.07 rows=87 width=2,470) (actual time=283.755..283.755 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id, ppa.addr_id, ppa.party_id, stael.search_name
  • Join Filter: (ppa.party_id = cal.station_id)
  • Rows Removed by Join Filter: 26
  • Buffers: shared hit=239 read=88
  • I/O Timings: read=275.331
35. 0.008 87.755 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=33.57..116,554,924.34 rows=1,424,046 width=2,261) (actual time=87.754..87.755 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id, crea.id
  • Buffers: shared hit=52 read=29
  • I/O Timings: read=84.755
36. 0.008 86.641 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=33.42..113,457,619.16 rows=1,424,046 width=2,261) (actual time=86.641..86.641 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompdiag.id, accompdist.id
  • Join Filter: (accompdist.id = accompd.disease_type_id)
  • Rows Removed by Join Filter: 9
  • Buffers: shared hit=51 read=28
  • I/O Timings: read=83.728
37. 0.017 86.610 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=33.42..113,265,371.84 rows=1,424,046 width=2,261) (actual time=86.610..86.610 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompd.disease_type_id, accompdiag.id
  • Buffers: shared hit=50 read=28
  • I/O Timings: read=83.728
38. 0.006 86.591 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=33.13..108,142,312.87 rows=1,424,046 width=2,261) (actual time=86.591..86.591 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id, accompd.note, accompd.diagnos_id, accompd.disease_type_id
  • Buffers: shared hit=50 read=28
  • I/O Timings: read=83.728
39. 0.002 39.872 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=32.70..97,356,853.81 rows=1,424,046 width=2,250) (actual time=39.872..39.872 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterdiag.id, masterdiag.code, masterdiag.name, mdist.id
  • Join Filter: (mdist.id = masterd.disease_type_id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=47 read=20
  • I/O Timings: read=37.330
40. 0.004 39.850 ↑ 1,424,046.0 1 1

Nested Loop Left Join (cost=32.70..97,164,606.49 rows=1,424,046 width=2,250) (actual time=39.849..39.850 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, idoc.type_id, idoc.series, idoc.number, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterd.disease_type_id, masterdiag.id, masterdiag.code, masterdiag.name
  • Buffers: shared hit=46 read=20
  • I/O Timings: read=37.330
41. 0.005 37.654 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=30.33..84,445,191.92 rows=551,252 width=2,233) (actual time=37.654..37.654 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterd.disease_type_id, masterdiag.id, masterdiag.code, masterdiag.name
  • Buffers: shared hit=43 read=18
  • I/O Timings: read=35.237
42. 0.003 37.623 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=30.04..80,652,717.95 rows=551,252 width=2,154) (actual time=37.623..37.623 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pg.id, pg.name, pic.id, pic.code, pic.indiv_id, masterd.note, masterd.diagnos_id, masterd.disease_type_id
  • Buffers: shared hit=40 read=18
  • I/O Timings: read=35.237
43. 0.093 30.267 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=29.61..76,762,130.92 rows=551,252 width=2,143) (actual time=30.267..30.267 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pg.id, pg.name, pic.id, pic.code, pic.indiv_id
  • Buffers: shared hit=38 read=16
  • I/O Timings: read=27.928
44. 0.002 26.680 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=29.18..69,578,920.96 rows=551,252 width=2,124) (actual time=26.680..26.680 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pg.id, pg.name
  • Join Filter: (pg.id = pip.gender_id)
  • Buffers: shared hit=35 read=13
  • I/O Timings: read=24.689
45. 0.002 26.668 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=29.18..69,554,113.58 rows=551,252 width=2,104) (actual time=26.668..26.668 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name, pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pip.gender_id
  • Buffers: shared hit=34 read=13
  • I/O Timings: read=24.689
46. 0.011 24.553 ↑ 551,252.0 1 1

Nested Loop (cost=28.75..65,676,888.15 rows=551,252 width=2,043) (actual time=24.552..24.553 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name, ts.id, ts.name
  • Join Filter: (cr.transmit_state_id = ts.id)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=32 read=11
  • I/O Timings: read=22.603
47. 0.003 24.440 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=28.75..65,635,543.19 rows=551,252 width=2,014) (actual time=24.440..24.440 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respi.surname, respi.name, respi.patr_name, resppos.name
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
48. 0.001 24.437 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=28.47..61,853,293.06 rows=551,252 width=1,964) (actual time=24.437..24.437 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respep.position_id, respi.surname, respi.name, respi.patr_name
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
49. 0.002 24.435 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=28.04..57,771,051.31 rows=551,252 width=1,919) (actual time=24.435..24.435 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respep.position_id, respe.individual_id
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
50. 0.001 24.433 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=27.76..54,018,327.81 rows=551,252 width=1,919) (actual time=24.433..24.433 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respep.id, respep.employee_id, respep.position_id
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
51. 0.003 24.431 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=27.47..50,223,154.57 rows=551,252 width=1,911) (actual time=24.431..24.431 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, respepr.employee_position_id
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
52. 0.001 24.428 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=27.19..46,508,164.27 rows=551,252 width=1,911) (actual time=24.428..24.428 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, sr.id
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
53. 0.004 24.427 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=26.90..42,762,362.00 rows=551,252 width=1,911) (actual time=24.426..24.427 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name, srtjr.id, srtjr.resource_id
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
54. 0.004 24.423 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=26.61..38,971,673.66 rows=551,252 width=1,907) (actual time=24.423..24.423 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, srg.id, srg.name
  • Buffers: shared hit=31 read=11
  • I/O Timings: read=22.603
55. 0.002 24.215 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=26.04..35,003,165.14 rows=551,252 width=1,847) (actual time=24.215..24.215 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name, ssren.res_group_id
  • Buffers: shared hit=26 read=11
  • I/O Timings: read=22.603
56. 0.000 17.570 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=25.48..30,969,284.33 rows=551,252 width=1,843) (actual time=17.570..17.570 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pi.surname, pi.name, pi.patr_name
  • Buffers: shared hit=22 read=10
  • I/O Timings: read=16.285
57. 0.090 15.403 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=25.05..26,887,042.57 rows=551,252 width=1,798) (actual time=15.402..15.403 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pe.individual_id
  • Buffers: shared hit=20 read=8
  • I/O Timings: read=14.331
58. 0.003 15.286 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=24.77..23,134,319.08 rows=551,252 width=1,798) (actual time=15.286..15.286 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id, pep.id, pep.code, pep.employee_id
  • Buffers: shared hit=17 read=8
  • I/O Timings: read=14.331
59. 1.910 15.153 ↑ 551,252.0 1 1

Nested Loop (cost=24.48..19,341,160.74 rows=551,252 width=1,793) (actual time=15.153..15.153 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.emp_id, cal.registrator_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id, mac.id
  • Buffers: shared hit=14 read=8
  • I/O Timings: read=14.331
60. 0.003 4.597 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=7.57..7,876,846.78 rows=551,252 width=1,793) (actual time=4.597..4.597 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.brg_id, cal.emp_id, cal.registrator_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.death_reason_diagnosis_id, step.death_date, step.death_time, step.result_id, step.outcome_id, step.outcome_date, step.outcome_time, step.main_diagnosis_id, step.death_employee_id
  • Buffers: shared hit=14 read=2
  • I/O Timings: read=4.198
61. 0.003 0.159 ↑ 551,252.0 1 1

Nested Loop Left Join (cost=7.13..3,987,983.01 rows=551,252 width=1,757) (actual time=0.159..0.159 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.brg_id, cal.emp_id, cal.registrator_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id, cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.closing_step_id, cas.death_reason_diagnosis_id
  • Buffers: shared hit=12
62. 0.005 0.034 ↑ 551,252.0 1 1

Merge Join (cost=6.70..77,284.96 rows=551,252 width=1,114) (actual time=0.034..0.034 rows=1 loops=1)

  • Output: cal.id, cal.control, cal.call_number, cal.call_mark, cal.call_dt, cal.station_id, cal.substation_id, cal.call_kind_id, cal.call_type_id, cal.from_time, cal.to_time, cal.call_place_id, cal.call_place_note, cal.place_org_id, cal.place_department_id, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.caller_id, cal.employee_id, cal.caller_note, cal.is_chronic, cal.age_years, cal.age_months, cal.age_days, cal.reason_note, cal.route_id, cal.to_org_id, cal.to_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.is_group_sufferer, cal.sum_sufferer, cal.phone_caller, cal.note, cal.brg_id, cal.emp_id, cal.registrator_id, cal.patient_id, cal.caller_reason_id, cal.reason_diag, cr.citizenship_type_id, cr.soc_group_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.nsdatatime, cr.id, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_emp_id, cr.receive_emp, cr.list_note, cr.receive_brg, cr.milage, cr.complications_result_measure_id, cr.take_birth_id, cr.case_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.receive_mkb_id, cr.registrator_id
  • Merge Cond: (cal.id = cr.id)
  • Buffers: shared hit=8
63. 0.018 0.018 ↑ 555,655.0 1 1

Index Scan using md_ambulance_call_pkey on amb.md_ambulance_call cal (cost=0.42..36,849.60 rows=555,655 width=253) (actual time=0.017..0.018 rows=1 loops=1)

  • Output: cal.id, cal.call_number, cal.call_place_id, cal.call_type_id, cal.priority_id, cal.from_time, cal.to_time, cal.address_id, cal.house, cal.housing, cal.apartment, cal.porch, cal.floor, cal.door_code, cal.description, cal.phone_caller, cal.caller_note, cal.registrator_id, cal.call_kind_id, cal.reason_note, cal.caller_reason_id, cal.call_place_note, cal.place_org_id, cal.caller_id, cal.place_department_id, cal.to_address_id, cal.to_house, cal.to_housing, cal.to_apartment, cal.to_porch, cal.to_description, cal.patient_id, cal.is_group_sufferer, cal.sum_sufferer, cal.station_id, cal.reason_diag, cal.is_chronic, cal.employee_id, cal.priority, cal.route_id, cal.call_dt, cal.brg_id, cal.note, cal.substation_id, cal.to_org_id, cal.to_department_id, cal.control, cal.emp_id, cal.age_years, cal.age_months, cal.age_days, cal.call_mark, cal.aud_who, cal.aud_when, cal.aud_source, cal.aud_who_create, cal.aud_when_create, cal.aud_source_create, cal.desk_id
  • Buffers: shared hit=4
64. 0.011 0.011 ↑ 551,252.0 1 1

Index Scan using md_ambulance_call_result_pkey on amb.md_ambulance_call_result cr (cost=0.42..32,173.13 rows=551,252 width=861) (actual time=0.011..0.011 rows=1 loops=1)

  • Output: cr.id, cr.case_id, cr.srv_rendered_id, cr.transmit_state_id, cr.out_delay_reason_id, cr.call_reason_id, cr.reason_accident_id, cr.condition_ns, cr.citizenship_type_id, cr.nsdatatime, cr.milage, cr.need_exit_through, cr.activ_visit_clinic_id, cr.other_recommendations, cr.receive_mkb_id, cr.receive_emp_id, cr.receive_emp, cr.receive_brg, cr.list_note, cr.has_list, cr.return_ticket, cr.registrator_id, cr.create_dt, cr.take_birth_id, cr.aud_who, cr.aud_when, cr.aud_source, cr.aud_who_create, cr.aud_when_create, cr.aud_source_create, cr.complications_result_measure_id, cr.soc_group_id, cr.diagnosis_is_not_confirmed
  • Buffers: shared hit=4
65. 0.122 0.122 ↑ 1.0 1 1

Index Scan using mc_case_pk on public.mc_case cas (cost=0.43..7.08 rows=1 width=647) (actual time=0.121..0.122 rows=1 loops=1)

  • Output: cas.time_gone_id, cas.transporting_type_id, cas.note, cas.death_reason, cas.id, cas.closing_step_id, cas.death_reason_diagnosis_id
  • Index Cond: (cas.id = cr.case_id)
  • Buffers: shared hit=4
66. 4.435 4.435 ↑ 1.0 1 1

Index Scan using mc_step_pk on public.mc_step step (cost=0.44..7.04 rows=1 width=44) (actual time=4.435..4.435 rows=1 loops=1)

  • Output: step.id, step.admission_date, step.admission_time, step.death_date, step.death_time, step.outcome_date, step.outcome_time, step.death_employee_id, step.main_diagnosis_id, step.case_id, step.outcome_id, step.outcome_clinic_id, step.outcome_regimen_id, step.regimen_id, step.res_group_id, step.result_id, step.reason_id, step.profile_id, step.mes_id, step.mes_quality_criterion_id, step.is_continue, step.is_continue_editable, step.standard_id, step.csg_id, step.vmp_type_id, step.vmp_method_id, step.deviation_reason_id, step.aud_who, step.aud_when, step.aud_source, step.aud_who_create, step.aud_when_create, step.aud_source_create, step._clinic_id, step._patient_id, step._case_mode_id, step._is_last, step._responsible_id, step._department_id, step.hsp_bed_days_amount, step.hsp_bed_profile_id, step.hsp_complexity_level_id, step.hsp_days_comp_algo_id, step.hsp_department_id, step.hsp_funding_id, step.hsp_is_admission_day_counts, step.hsp_is_diag_not_eq, step.hsp_is_set_diagnosis, step.hsp_issue_planned_date, step.hsp_mes_id, step.hsp_missed_days_amount, step.hsp_plan_department_id, step.hsp_previous_id, step.hsp_refusal_employee_id, step.plc_goal_id, step.plc_initiator_id, step.plc_is_needed, step.plc_is_sanitized, step.plc_is_viewed, step.plc_place_id, step.plc_type_id, step.plc_appointment_id, step.plc_planned_date, step.is_autopsy, step.action_allowed_result_id, step.planned_date_closing_case, step.gestational_age, step.onko_stage, step.is_first_step, step.t
  • Index Cond: (step.id = cas.closing_step_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=4.198
67. 6.837 8.646 ↑ 1.0 1 1

Index Only Scan using md_ambulance_change_pkey on amb.md_ambulance_change mac (cost=16.91..20.79 rows=1 width=4) (actual time=8.645..8.646 rows=1 loops=1)

  • Output: mac.id
  • Index Cond: (mac.id = COALESCE((SubPlan 47), (SubPlan 48)))
  • Heap Fetches: 0
  • Buffers: shared read=3
  • I/O Timings: read=8.450
68.          

SubPlan (for Index Only Scan)

69. 1.809 1.809 ↑ 1.0 1 1

Index Scan using sr_res_team_job_pkey on amb.sr_res_team_job (cost=0.29..8.31 rows=1 width=4) (actual time=1.807..1.809 rows=1 loops=1)

  • Output: sr_res_team_job.change_id
  • Index Cond: (sr_res_team_job.id = cal.brg_id)
  • Buffers: shared read=3
  • I/O Timings: read=1.683
70. 0.000 0.000 ↓ 0.0 0

Index Scan using sr_res_team_job_resourse_pkey on amb.sr_res_team_job_resourse (cost=0.29..8.31 rows=1 width=4) (never executed)

  • Output: sr_res_team_job_resourse.change_id
  • Index Cond: (sr_res_team_job_resourse.id = cal.emp_id)
71. 0.130 0.130 ↑ 1.0 1 1

Index Scan using pim_employee_position_pk on public.pim_employee_position pep (cost=0.29..6.87 rows=1 width=13) (actual time=0.130..0.130 rows=1 loops=1)

  • Output: pep.id, pep.dismissal_order_code, pep.start_date, pep.hiring_order_code, pep.rate, pep.end_date, pep.dismissal_reason_id, pep.employee_id, pep.employment_type_id, pep.hiring_type_id, pep.position_id, pep.position_type_id, pep.unit_id, pep.code, pep.aud_who, pep.aud_when, pep.aud_source, pep.aud_who_create, pep.aud_when_create, pep.aud_source_create, pep.target_training, pep.leaving_reason_id, pep.pref_prescription, pep.extra_payment
  • Index Cond: (pep.id = cal.registrator_id)
  • Buffers: shared hit=3
72. 0.027 0.027 ↑ 1.0 1 1

Index Scan using pim_employee_pk on public.pim_employee pe (cost=0.29..6.80 rows=1 width=8) (actual time=0.027..0.027 rows=1 loops=1)

  • Output: pe.id, pe.note, pe.number, pe.photo, pe.callup_subject_id, pe.individual_id, pe.organization_id, pe.is_dismissed, pe.employment_dt, pe.dismissal_dt, pe.aud_who, pe.aud_when, pe.aud_source, pe.aud_who_create, pe.aud_when_create, pe.aud_source_create, pe.accreditation_id
  • Index Cond: (pe.id = pep.employee_id)
  • Buffers: shared hit=3
73. 2.167 2.167 ↑ 1.0 1 1

Index Scan using pim_individual_pk on public.pim_individual pi (cost=0.42..7.40 rows=1 width=53) (actual time=2.166..2.167 rows=1 loops=1)

  • Output: pi.surname, pi.name, pi.patr_name, pi.id
  • Index Cond: (pi.id = pe.individual_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=1.954
74. 6.643 6.643 ↑ 1.0 1 1

Index Scan using sr_srv_rendered_pk on public.sr_srv_rendered ssren (cost=0.56..7.31 rows=1 width=8) (actual time=6.642..6.643 rows=1 loops=1)

  • Output: ssren.id, ssren.res_group_id
  • Index Cond: (ssren.id = cr.srv_rendered_id)
  • Buffers: shared hit=4 read=1
  • I/O Timings: read=6.318
75. 0.204 0.204 ↑ 1.0 1 1

Index Scan using sr_res_group_pk on public.sr_res_group srg (cost=0.56..7.19 rows=1 width=64) (actual time=0.204..0.204 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.id = ssren.res_group_id)
  • Buffers: shared hit=5
76. 0.000 0.000 ↓ 0.0 0 1

Index Scan using sr_res_team_job_resourse_pkey on amb.sr_res_team_job_resourse srtjr (cost=0.29..6.87 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: srtjr.id, srtjr.change_id, srtjr.team_job_id, srtjr.job_kind_id, srtjr.is_head, srtjr.planned_bdate, srtjr.planned_edate, srtjr.bdate, srtjr.edate, srtjr.deviation_id, srtjr.replacement_id, srtjr.registrator_id, srtjr.deviation_registrator_id, srtjr.workplace, srtjr.resource_id, srtjr.role_id, srtjr.aud_who, srtjr.aud_when, srtjr.aud_source, srtjr.aud_who_create, srtjr.aud_when_create, srtjr.aud_source_create, srtjr.desk_id
  • Index Cond: (srtjr.id = cal.emp_id)
77. 0.000 0.000 ↓ 0.0 0 1

Index Scan using sr_resource_pk on public.sr_resource sr (cost=0.29..6.79 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: sr.id, sr.power, sr.res_kind_id, sr.code, sr.role_id, sr.aud_who, sr.aud_when, sr.aud_source, sr.aud_who_create, sr.aud_when_create, sr.aud_source_create
  • Index Cond: (sr.id = srtjr.resource_id)
78. 0.000 0.000 ↓ 0.0 0 1

Index Scan using pim_employee_position_resource_pk on public.pim_employee_position_resource respepr (cost=0.29..6.73 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: respepr.id, respepr.employee_position_id, respepr.aud_who, respepr.aud_when, respepr.aud_source, respepr.aud_who_create, respepr.aud_when_create, respepr.aud_source_create
  • Index Cond: (respepr.id = sr.id)
79. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pim_employee_position_pk on public.pim_employee_position respep (cost=0.29..6.87 rows=1 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: respep.id, respep.dismissal_order_code, respep.start_date, respep.hiring_order_code, respep.rate, respep.end_date, respep.dismissal_reason_id, respep.employee_id, respep.employment_type_id, respep.hiring_type_id, respep.position_id, respep.position_type_id, respep.unit_id, respep.code, respep.aud_who, respep.aud_when, respep.aud_source, respep.aud_who_create, respep.aud_when_create, respep.aud_source_create, respep.target_training, respep.leaving_reason_id, respep.pref_prescription, respep.extra_payment
  • Index Cond: (respep.id = respepr.employee_position_id)
80. 0.000 0.000 ↓ 0.0 0 1

Index Scan using pim_employee_pk on public.pim_employee respe (cost=0.29..6.80 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: respe.id, respe.note, respe.number, respe.photo, respe.callup_subject_id, respe.individual_id, respe.organization_id, respe.is_dismissed, respe.employment_dt, respe.dismissal_dt, respe.aud_who, respe.aud_when, respe.aud_source, respe.aud_who_create, respe.aud_when_create, respe.aud_source_create, respe.accreditation_id
  • Index Cond: (respe.id = respep.employee_id)
81. 0.001 0.001 ↓ 0.0 0 1

Index Scan using pim_individual_pk on public.pim_individual respi (cost=0.42..7.40 rows=1 width=53) (actual time=0.000..0.001 rows=0 loops=1)

  • Output: respi.surname, respi.name, respi.patr_name, respi.id
  • Index Cond: (respi.id = respe.individual_id)
82. 0.000 0.000 ↓ 0.0 0 1

Index Scan using pim_position_pk on public.pim_position resppos (cost=0.28..6.85 rows=1 width=58) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: resppos.name, resppos.id
  • Index Cond: (resppos.id = respep.position_id)
83. 0.009 0.102 ↑ 2.5 2 1

Materialize (cost=0.00..1.07 rows=5 width=33) (actual time=0.101..0.102 rows=2 loops=1)

  • Output: ts.id, ts.name
  • Buffers: shared hit=1
84. 0.093 0.093 ↑ 2.5 2 1

Seq Scan on amb.md_ambulance_transmit_state ts (cost=0.00..1.05 rows=5 width=33) (actual time=0.093..0.093 rows=2 loops=1)

  • Output: ts.id, ts.name
  • Buffers: shared hit=1
85. 2.113 2.113 ↑ 1.0 1 1

Index Scan using pim_individual_pk on public.pim_individual pip (cost=0.42..7.02 rows=1 width=61) (actual time=2.113..2.113 rows=1 loops=1)

  • Output: pip.id, pip.surname, pip.name, pip.patr_name, pip.birth_dt, pip.gender_id
  • Index Cond: (pip.id = cal.patient_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=2.086
86. 0.005 0.010 ↑ 3.0 1 1

Materialize (cost=0.00..1.04 rows=3 width=24) (actual time=0.010..0.010 rows=1 loops=1)

  • Output: pg.id, pg.name
  • Buffers: shared hit=1
87. 0.005 0.005 ↑ 3.0 1 1

Seq Scan on public.pim_gender pg (cost=0.00..1.03 rows=3 width=24) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: pg.id, pg.name
  • Buffers: shared hit=1
88. 3.494 3.494 ↑ 1.0 1 1

Index Scan using pim_indiv_code_indiv_id_idx on public.pim_indiv_code pic (cost=0.43..13.02 rows=1 width=23) (actual time=3.494..3.494 rows=1 loops=1)

  • Output: pic.id, pic.code, pic.issue_dt, pic.type_id, pic.indiv_id, pic.sha256, pic.aud_who, pic.aud_when, pic.aud_source, pic.aud_who_create, pic.aud_when_create, pic.aud_source_create
  • Index Cond: (pic.indiv_id = cal.patient_id)
  • Filter: (pic.type_id = $55)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=3 read=3
  • I/O Timings: read=3.239
89. 7.353 7.353 ↑ 1.0 1 1

Index Scan using mc_diagnosis_pk on public.mc_diagnosis masterd (cost=0.44..7.05 rows=1 width=19) (actual time=7.353..7.353 rows=1 loops=1)

  • Output: masterd.note, masterd.id, masterd.diagnos_id, masterd.disease_type_id
  • Index Cond: (masterd.id = step.main_diagnosis_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=7.309
90. 0.026 0.026 ↑ 1.0 1 1

Index Scan using md_diagnosis_pk on public.md_diagnosis masterdiag (cost=0.29..6.87 rows=1 width=83) (actual time=0.025..0.026 rows=1 loops=1)

  • Output: masterdiag.id, masterdiag.code, masterdiag.name, masterdiag.parent_id, masterdiag.is_injury, masterdiag.level, masterdiag.is_leaf, masterdiag.e_code, masterdiag.from_dt, masterdiag.to_dt, masterdiag.oms, masterdiag.stomat, masterdiag.aud_who, masterdiag.aud_when, masterdiag.aud_source, masterdiag.aud_who_create, masterdiag.aud_when_create, masterdiag.aud_source_create, masterdiag.gender_id
  • Index Cond: (masterdiag.id = masterd.diagnos_id)
  • Buffers: shared hit=3
91. 0.032 2.192 ↑ 3.0 1 1

Hash Semi Join (cost=2.37..25.41 rows=3 width=21) (actual time=2.192..2.192 rows=1 loops=1)

  • Output: idoc.type_id, idoc.series, idoc.number, idoc.indiv_id
  • Hash Cond: (idoc.type_id = pim_doc_type_category.type_id)
  • Buffers: shared hit=3 read=2
  • I/O Timings: read=2.093
92. 2.124 2.124 ↑ 3.0 1 1

Index Scan using pim_individual_doc_indiv_id_idx on public.pim_individual_doc idoc (cost=0.43..23.43 rows=3 width=21) (actual time=2.123..2.124 rows=1 loops=1)

  • Output: idoc.id, idoc.type_id, idoc.series, idoc.number, idoc.sha256, idoc.code_id, idoc.indiv_id, idoc.is_active, idoc.expire_dt, idoc.issue_dt, idoc.issuer_text, idoc.note, idoc.birth_dt, idoc.contract_number, idoc.name, idoc.patr_name, idoc.surname, idoc.issuer_id, idoc.verific_dt, idoc.birth_place, idoc.check_dt, idoc.check_status_id, idoc.aud_who, idoc.aud_when, idoc.aud_source, idoc.aud_who_create, idoc.aud_when_create, idoc.aud_source_create
  • Index Cond: (idoc.indiv_id = pip.id)
  • Filter: (idoc.is_active IS TRUE)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=2.093
93. 0.013 0.036 ↑ 1.0 26 1

Hash (cost=1.61..1.61 rows=26 width=4) (actual time=0.036..0.036 rows=26 loops=1)

  • Output: pim_doc_type_category.type_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
94. 0.023 0.023 ↑ 1.0 26 1

Seq Scan on public.pim_doc_type_category (cost=0.00..1.61 rows=26 width=4) (actual time=0.012..0.023 rows=26 loops=1)

  • Output: pim_doc_type_category.type_id
  • Filter: (pim_doc_type_category.category_id = 1)
  • Rows Removed by Filter: 26
  • Buffers: shared hit=1
95. 0.013 0.020 ↑ 1.3 7 1

Materialize (cost=0.00..1.14 rows=9 width=4) (actual time=0.014..0.020 rows=7 loops=1)

  • Output: mdist.id
  • Buffers: shared hit=1
96. 0.007 0.007 ↑ 1.3 7 1

Seq Scan on public.mc_disease_type mdist (cost=0.00..1.09 rows=9 width=4) (actual time=0.005..0.007 rows=7 loops=1)

  • Output: mdist.id
  • Buffers: shared hit=1
97. 46.713 46.713 ↓ 0.0 0 1

Index Scan using mc_diagnosis_case_id_idx on public.mc_diagnosis accompd (cost=0.44..7.56 rows=1 width=19) (actual time=46.713..46.713 rows=0 loops=1)

  • Output: accompd.note, accompd.case_id, accompd.diagnos_id, accompd.disease_type_id
  • Index Cond: (accompd.case_id = cas.id)
  • Filter: (accompd.is_main IS FALSE)
  • Rows Removed by Filter: 8
  • Buffers: shared hit=3 read=8
  • I/O Timings: read=46.398
98. 0.002 0.002 ↓ 0.0 0 1

Index Only Scan using md_diagnosis_pk on public.md_diagnosis accompdiag (cost=0.29..3.59 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Output: accompdiag.id
  • Index Cond: (accompdiag.id = accompd.diagnos_id)
  • Heap Fetches: 0
99. 0.008 0.023 ↑ 1.0 9 1

Materialize (cost=0.00..1.14 rows=9 width=4) (actual time=0.017..0.023 rows=9 loops=1)

  • Output: accompdist.id
  • Buffers: shared hit=1
100. 0.015 0.015 ↑ 1.0 9 1

Seq Scan on public.mc_disease_type accompdist (cost=0.00..1.09 rows=9 width=4) (actual time=0.012..0.015 rows=9 loops=1)

  • Output: accompdist.id
  • Buffers: shared hit=1
101. 1.106 1.106 ↑ 1.0 1 1

Index Only Scan using md_ambulance_caller_reason_pkey on amb.md_ambulance_caller_reason crea (cost=0.15..2.17 rows=1 width=4) (actual time=1.106..1.106 rows=1 loops=1)

  • Output: crea.id
  • Index Cond: (crea.id = cal.caller_reason_id)
  • Heap Fetches: 0
  • Buffers: shared hit=1 read=1
  • I/O Timings: read=1.027
102. 0.072 195.967 ↑ 1.6 27 1

Materialize (cost=1.28..792.17 rows=43 width=209) (actual time=21.654..195.967 rows=27 loops=1)

  • Output: ppa.addr_id, ppa.party_id, stael.search_name
  • Buffers: shared hit=187 read=59
  • I/O Timings: read=190.576
103. 0.084 195.895 ↑ 1.6 27 1

Nested Loop (cost=1.28..791.95 rows=43 width=209) (actual time=21.645..195.895 rows=27 loops=1)

  • Output: ppa.addr_id, ppa.party_id, stael.search_name
  • Buffers: shared hit=187 read=59
  • I/O Timings: read=190.576
104. 0.087 107.818 ↑ 1.6 27 1

Nested Loop (cost=0.85..489.51 rows=43 width=8) (actual time=21.599..107.818 rows=27 loops=1)

  • Output: ppa.addr_id, ppa.party_id
  • Buffers: shared hit=105 read=33
  • I/O Timings: read=105.926
105. 26.785 26.785 ↑ 1.6 27 1

Index Scan using pim_party_addr_to_addr_type_address_type_id_idx on public.pim_party_addr_to_addr_type ppatat (cost=0.43..126.05 rows=43 width=4) (actual time=18.059..26.785 rows=27 loops=1)

  • Output: ppatat.id, ppatat.address_type_id, ppatat.party_address_id, ppatat.aud_who, ppatat.aud_when, ppatat.aud_source, ppatat.aud_who_create, ppatat.aud_when_create, ppatat.aud_source_create
  • Index Cond: (ppatat.address_type_id = 6)
  • Buffers: shared hit=22 read=8
  • I/O Timings: read=26.164
106. 80.946 80.946 ↑ 1.0 1 27

Index Scan using pim_party_address_pk on public.pim_party_address ppa (cost=0.42..8.44 rows=1 width=12) (actual time=2.998..2.998 rows=1 loops=27)

  • Output: ppa.id, ppa.from_date, ppa.note, ppa.text_addr, ppa.to_date, ppa.is_valid, ppa.addr_id, ppa.party_id, ppa.register_type_id, ppa.aud_who, ppa.aud_when, ppa.aud_source, ppa.aud_who_create, ppa.aud_when_create, ppa.aud_source_create
  • Index Cond: (ppa.id = ppatat.party_address_id)
  • Buffers: shared hit=83 read=25
  • I/O Timings: read=79.762
107. 87.993 87.993 ↑ 1.0 1 27

Index Scan using address_element_data_pkey on public.address_element_data stael (cost=0.43..7.02 rows=1 width=205) (actual time=3.259..3.259 rows=1 loops=27)

  • Output: stael.id, stael.search_name, stael.path, stael.is_city, stael.aud_who, stael.aud_when, stael.aud_source, stael.aud_who_create, stael.aud_when_create, stael.aud_source_create
  • Index Cond: (stael.id = ppa.addr_id)
  • Buffers: shared hit=82 read=26
  • I/O Timings: read=84.650
108. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using md_diagnosis_pk on public.md_diagnosis dia (cost=0.29..3.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: dia.id
  • Index Cond: (dia.id = cal.reason_diag)
  • Heap Fetches: 0
109. 22.683 41.026 ↑ 1.1 18,202 1

Materialize (cost=0.00..1,061.43 rows=19,762 width=222) (actual time=0.024..41.026 rows=18,202 loops=1)

  • Output: po.id, po.short_name, po.full_name
  • Buffers: shared hit=731
110. 18.343 18.343 ↑ 1.1 18,202 1

Seq Scan on public.pim_organization po (cost=0.00..962.62 rows=19,762 width=222) (actual time=0.020..18.343 rows=18,202 loops=1)

  • Output: po.id, po.short_name, po.full_name
  • Buffers: shared hit=731
111. 0.077 0.265 ↑ 16.0 147 1

Materialize (cost=0.00..98.33 rows=2,355 width=70) (actual time=0.024..0.265 rows=147 loops=1)

  • Output: pd.id, pd.name
  • Buffers: shared hit=4
112. 0.188 0.188 ↑ 16.0 147 1

Seq Scan on public.pim_department pd (cost=0.00..86.55 rows=2,355 width=70) (actual time=0.023..0.188 rows=147 loops=1)

  • Output: pd.id, pd.name
  • Buffers: shared hit=4
113. 0.025 0.094 ↑ 1.0 74 1

Materialize (cost=0.00..11.15 rows=77 width=4) (actual time=0.014..0.094 rows=74 loops=1)

  • Output: mc.id
  • Buffers: shared hit=9
114. 0.069 0.069 ↑ 1.0 74 1

Seq Scan on public.md_clinic mc (cost=0.00..10.77 rows=77 width=4) (actual time=0.014..0.069 rows=74 loops=1)

  • Output: mc.id
  • Buffers: shared hit=9
115. 0.050 1.629 ↓ 1.0 147 1

Materialize (cost=0.00..45.23 rows=146 width=8) (actual time=0.013..1.629 rows=147 loops=1)

  • Output: pda.dep_id, pda.addr_id
  • Buffers: shared hit=17 read=8
  • I/O Timings: read=1.103
116. 1.579 1.579 ↓ 1.0 147 1

Seq Scan on public.md_department_address pda (cost=0.00..44.50 rows=146 width=8) (actual time=0.012..1.579 rows=147 loops=1)

  • Output: pda.dep_id, pda.addr_id
  • Filter: pda.is_display
  • Rows Removed by Filter: 1,805
  • Buffers: shared hit=17 read=8
  • I/O Timings: read=1.103
117. 0.003 0.003 ↓ 0.0 0 1

Index Scan using address_element_data_pkey on public.address_element_data substaed (cost=0.43..8.42 rows=1 width=205) (actual time=0.003..0.003 rows=0 loops=1)

  • Output: substaed.id, substaed.search_name, substaed.path, substaed.is_city, substaed.aud_who, substaed.aud_when, substaed.aud_source, substaed.aud_who_create, substaed.aud_when_create, substaed.aud_source_create
  • Index Cond: (substaed.id = pda.addr_id)
118. 20.233 20.233 ↑ 1.0 1 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash (cost=0.43..7.33 rows=1 width=20) (actual time=20.233..20.233 rows=1 loops=1)

  • Output: mash.id, mash.call_id, mash.date_time, mash.state_id, mash.transmit_id, mash.registrator_id, mash.aud_who, mash.aud_when, mash.aud_source, mash.aud_who_create, mash.aud_when_create, mash.aud_source_create
  • Index Cond: (mash.call_id = cal.id)
  • Filter: (mash.state_id = $56)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=5 read=2
  • I/O Timings: read=20.172
119. 1.016 2.356 ↑ 8.7 2,695 1

Materialize (cost=0.00..693.18 rows=23,545 width=12) (actual time=0.016..2.356 rows=2,695 loops=1)

  • Output: routepep.id, routepep.employee_id, routepep.position_id
  • Buffers: shared hit=37
120. 1.340 1.340 ↑ 8.7 2,695 1

Seq Scan on public.pim_employee_position routepep (cost=0.00..575.45 rows=23,545 width=12) (actual time=0.008..1.340 rows=2,695 loops=1)

  • Output: routepep.id, routepep.employee_id, routepep.position_id
  • Buffers: shared hit=37
121. 0.001 0.013 ↑ 5.0 1 1

Materialize (cost=0.00..1.07 rows=5 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Output: delres.id
  • Buffers: shared hit=1
122. 0.012 0.012 ↑ 5.0 1 1

Seq Scan on amb.md_ambulance_out_delay_reason delres (cost=0.00..1.05 rows=5 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: delres.id
  • Buffers: shared hit=1
123. 0.036 0.068 ↑ 1.0 77 1

Materialize (cost=0.00..11.15 rows=77 width=4) (actual time=0.004..0.068 rows=77 loops=1)

  • Output: policl.id
  • Buffers: shared hit=10
124. 0.032 0.032 ↑ 1.0 77 1

Seq Scan on public.md_clinic policl (cost=0.00..10.77 rows=77 width=4) (actual time=0.003..0.032 rows=77 loops=1)

  • Output: policl.id
  • Buffers: shared hit=10
125. 16.968 24.625 ↓ 1.0 19,766 1

Materialize (cost=0.00..1,061.43 rows=19,762 width=222) (actual time=0.007..24.625 rows=19,766 loops=1)

  • Output: poliorg.id, poliorg.full_name, poliorg.short_name
  • Buffers: shared hit=765
126. 7.657 7.657 ↓ 1.0 19,766 1

Seq Scan on public.pim_organization poliorg (cost=0.00..962.62 rows=19,762 width=222) (actual time=0.005..7.657 rows=19,766 loops=1)

  • Output: poliorg.id, poliorg.full_name, poliorg.short_name
  • Buffers: shared hit=765
127. 0.004 0.004 ↓ 0.0 0 1

Index Scan using address_element_data_pkey on public.address_element_data toaed (cost=0.43..7.03 rows=1 width=205) (actual time=0.003..0.004 rows=0 loops=1)

  • Output: toaed.id, toaed.search_name, toaed.path, toaed.is_city, toaed.aud_who, toaed.aud_when, toaed.aud_source, toaed.aud_who_create, toaed.aud_when_create, toaed.aud_source_create
  • Index Cond: (toaed.id = cal.to_address_id)
128. 0.002 0.002 ↓ 0.0 0 1

Index Scan using mc_diagnosis_pk on public.mc_diagnosis clind (cost=0.44..7.12 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)

  • Output: clind.id, clind.diagnos_id
  • Index Cond: (clind.id = cr.receive_mkb_id)
  • Filter: (clind.stage_id = 2)
129. 0.000 0.000 ↓ 0.0 0 1

Index Only Scan using md_diagnosis_pk on public.md_diagnosis clinddiag (cost=0.29..3.59 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: clinddiag.id
  • Index Cond: (clinddiag.id = clind.diagnos_id)
  • Heap Fetches: 0
130. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using md_diagnosis_pk on public.md_diagnosis deathdiag (cost=0.29..3.59 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=1)

  • Output: deathdiag.id
  • Index Cond: (deathdiag.id = cas.death_reason_diagnosis_id)
  • Heap Fetches: 0
131. 8.793 19.958 ↓ 1.0 23,548 1

Materialize (cost=0.00..693.18 rows=23,545 width=12) (actual time=0.010..19.958 rows=23,548 loops=1)

  • Output: deathpep.id, deathpep.employee_id, deathpep.position_id
  • Buffers: shared hit=340
132. 11.165 11.165 ↓ 1.0 23,548 1

Seq Scan on public.pim_employee_position deathpep (cost=0.00..575.45 rows=23,545 width=12) (actual time=0.009..11.165 rows=23,548 loops=1)

  • Output: deathpep.id, deathpep.employee_id, deathpep.position_id
  • Buffers: shared hit=340
133. 4.954 20.597 ↓ 1.0 14,121 1

Materialize (cost=0.00..393.78 rows=14,119 width=8) (actual time=0.014..20.597 rows=14,121 loops=1)

  • Output: deathpe.id, deathpe.individual_id
  • Buffers: shared hit=152 read=30
  • I/O Timings: read=8.729
134. 15.643 15.643 ↓ 1.0 14,121 1

Seq Scan on public.pim_employee deathpe (cost=0.00..323.19 rows=14,119 width=8) (actual time=0.012..15.643 rows=14,121 loops=1)

  • Output: deathpe.id, deathpe.individual_id
  • Buffers: shared hit=152 read=30
  • I/O Timings: read=8.729
135. 0.003 0.003 ↓ 0.0 0 1

Index Scan using pim_individual_pk on public.pim_individual deathpi (cost=0.42..7.40 rows=1 width=53) (actual time=0.002..0.003 rows=0 loops=1)

  • Output: deathpi.surname, deathpi.name, deathpi.patr_name, deathpi.id
  • Index Cond: (deathpi.id = deathpe.individual_id)
136. 4.246 24.812 ↑ 1.0 7,321 1

Materialize (cost=0.00..253.81 rows=7,321 width=58) (actual time=0.013..24.812 rows=7,321 loops=1)

  • Output: deathppos.name, deathppos.id
  • Buffers: shared hit=98 read=46
  • I/O Timings: read=16.676
137. 20.566 20.566 ↑ 1.0 7,321 1

Seq Scan on public.pim_position deathppos (cost=0.00..217.21 rows=7,321 width=58) (actual time=0.008..20.566 rows=7,321 loops=1)

  • Output: deathppos.name, deathppos.id
  • Buffers: shared hit=98 read=46
  • I/O Timings: read=16.676
138. 0.089 0.089 ↑ 1.0 1 1

Index Only Scan using sr_srv_rendered_pk on public.sr_srv_rendered ssr (cost=0.56..4.07 rows=1 width=4) (actual time=0.089..0.089 rows=1 loops=1)

  • Output: ssr.id
  • Index Cond: (ssr.id = cr.srv_rendered_id)
  • Heap Fetches: 1
  • Buffers: shared hit=6
139. 9.434 17.750 ↑ 1.0 22,732 1

Materialize (cost=0.00..693.18 rows=23,545 width=12) (actual time=0.010..17.750 rows=22,732 loops=1)

  • Output: kvpep.id, kvpep.employee_id, kvpep.position_id
  • Buffers: shared hit=325
140. 8.316 8.316 ↑ 1.0 22,732 1

Seq Scan on public.pim_employee_position kvpep (cost=0.00..575.45 rows=23,545 width=12) (actual time=0.008..8.316 rows=22,732 loops=1)

  • Output: kvpep.id, kvpep.employee_id, kvpep.position_id
  • Buffers: shared hit=325
141. 4.587 8.614 ↑ 1.0 13,577 1

Materialize (cost=0.00..393.78 rows=14,119 width=8) (actual time=0.011..8.614 rows=13,577 loops=1)

  • Output: kvpe.id, kvpe.individual_id
  • Buffers: shared hit=173
142. 4.027 4.027 ↑ 1.0 13,577 1

Seq Scan on public.pim_employee kvpe (cost=0.00..323.19 rows=14,119 width=8) (actual time=0.007..4.027 rows=13,577 loops=1)

  • Output: kvpe.id, kvpe.individual_id
  • Buffers: shared hit=173
143. 0.951 0.951 ↑ 1.0 1 1

Index Scan using pim_individual_pk on public.pim_individual kvpi (cost=0.42..7.40 rows=1 width=53) (actual time=0.951..0.951 rows=1 loops=1)

  • Output: kvpi.surname, kvpi.name, kvpi.patr_name, kvpi.id
  • Index Cond: (kvpi.id = kvpe.individual_id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.896
144. 3.884 5.868 ↑ 1.0 7,077 1

Materialize (cost=0.00..253.81 rows=7,321 width=58) (actual time=0.019..5.868 rows=7,077 loops=1)

  • Output: kvppos.name, kvppos.id
  • Buffers: shared hit=138
145. 1.984 1.984 ↑ 1.0 7,077 1

Seq Scan on public.pim_position kvppos (cost=0.00..217.21 rows=7,321 width=58) (actual time=0.007..1.984 rows=7,077 loops=1)

  • Output: kvppos.name, kvppos.id
  • Buffers: shared hit=138
146. 0.086 0.161 ↑ 1.0 234 1

Materialize (cost=0.00..6.51 rows=234 width=4) (actual time=0.014..0.161 rows=234 loops=1)

  • Output: macc.call_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.018
147. 0.075 0.075 ↑ 1.0 234 1

Seq Scan on amb.md_ambulance_call_complication macc (cost=0.00..5.34 rows=234 width=4) (actual time=0.006..0.075 rows=234 loops=1)

  • Output: macc.call_id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=0.018
148.          

SubPlan (for Nested Loop Left Join)

149. 5.023 5.023 ↑ 1.0 1 1

Index Scan using md_ambulance_change_pkey on amb.md_ambulance_change (cost=0.29..8.31 rows=1 width=4) (actual time=5.021..5.023 rows=1 loops=1)

  • Output: md_ambulance_change.from_data
  • Index Cond: (md_ambulance_change.id = cal.call_dt)
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=5.006
150. 0.003 6.781 ↑ 1.0 1 1

Limit (cost=1.42..1.42 rows=1 width=36) (actual time=6.779..6.781 rows=1 loops=1)

  • Output: (to_char((macs.change_begin)::interval, 'HH24:mi'::text)), macs.department_id
  • Buffers: shared read=1
  • I/O Timings: read=6.436
151. 0.036 6.778 ↑ 1.0 1 1

Sort (cost=1.42..1.42 rows=1 width=36) (actual time=6.777..6.778 rows=1 loops=1)

  • Output: (to_char((macs.change_begin)::interval, 'HH24:mi'::text)), macs.department_id
  • Sort Key: macs.department_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared read=1
  • I/O Timings: read=6.436
152. 6.742 6.742 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_change_setting macs (cost=0.00..1.41 rows=1 width=36) (actual time=6.740..6.742 rows=1 loops=1)

  • Output: to_char((macs.change_begin)::interval, 'HH24:mi'::text), macs.department_id
  • Filter: (((macs.department_id IS NULL) OR (macs.department_id = cal.substation_id)) AND (macs.clinic_id = cal.station_id))
  • Rows Removed by Filter: 26
  • Buffers: shared read=1
  • I/O Timings: read=6.436
153. 0.002 0.118 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.116..0.118 rows=1 loops=1)

  • Output: (to_char(mash_1.date_time, 'hh24:mi'::text)), mash_1.date_time
  • Buffers: shared hit=10
154. 0.072 0.116 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.115..0.116 rows=1 loops=1)

  • Output: (to_char(mash_1.date_time, 'hh24:mi'::text)), mash_1.date_time
  • Sort Key: mash_1.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10
155. 0.010 0.044 ↓ 2.0 2 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.039..0.044 rows=2 loops=1)

  • Output: to_char(mash_1.date_time, 'hh24:mi'::text), mash_1.date_time
  • Join Filter: (mash_1.state_id = macs_1.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=7
156. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_1 (cost=0.00..1.19 rows=1 width=4) (actual time=0.009..0.011 rows=1 loops=1)

  • Output: macs_1.id, macs_1.name, macs_1.code, macs_1.e_code, macs_1.aud_who, macs_1.aud_when, macs_1.aud_source, macs_1.aud_who_create, macs_1.aud_when_create, macs_1.aud_source_create
  • Filter: ((macs_1.code)::text = '5'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
157. 0.023 0.023 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_1 (cost=0.43..8.73 rows=12 width=12) (actual time=0.014..0.023 rows=8 loops=1)

  • Output: mash_1.id, mash_1.call_id, mash_1.date_time, mash_1.state_id, mash_1.transmit_id, mash_1.registrator_id, mash_1.aud_who, mash_1.aud_when, mash_1.aud_source, mash_1.aud_who_create, mash_1.aud_when_create, mash_1.aud_source_create
  • Index Cond: (mash_1.call_id = cal.id)
  • Buffers: shared hit=6
158. 0.003 0.122 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.120..0.122 rows=1 loops=1)

  • Output: (to_char(mash_2.date_time, 'hh24:mi'::text)), mash_2.date_time
  • Buffers: shared hit=7
159. 0.011 0.119 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.119..0.119 rows=1 loops=1)

  • Output: (to_char(mash_2.date_time, 'hh24:mi'::text)), mash_2.date_time
  • Sort Key: mash_2.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
160. 0.013 0.108 ↓ 2.0 2 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.102..0.108 rows=2 loops=1)

  • Output: to_char(mash_2.date_time, 'hh24:mi'::text), mash_2.date_time
  • Join Filter: (mash_2.state_id = macs_2.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=7
161. 0.086 0.086 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_2 (cost=0.00..1.19 rows=1 width=4) (actual time=0.084..0.086 rows=1 loops=1)

  • Output: macs_2.id, macs_2.name, macs_2.code, macs_2.e_code, macs_2.aud_who, macs_2.aud_when, macs_2.aud_source, macs_2.aud_who_create, macs_2.aud_when_create, macs_2.aud_source_create
  • Filter: ((macs_2.code)::text = '5'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
162. 0.009 0.009 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_2 (cost=0.43..8.73 rows=12 width=12) (actual time=0.005..0.009 rows=8 loops=1)

  • Output: mash_2.id, mash_2.call_id, mash_2.date_time, mash_2.state_id, mash_2.transmit_id, mash_2.registrator_id, mash_2.aud_who, mash_2.aud_when, mash_2.aud_source, mash_2.aud_who_create, mash_2.aud_when_create, mash_2.aud_source_create
  • Index Cond: (mash_2.call_id = cal.id)
  • Buffers: shared hit=6
163. 0.002 0.038 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.037..0.038 rows=1 loops=1)

  • Output: (to_char(mash_3.date_time, 'hh24:mi'::text)), mash_3.date_time
  • Buffers: shared hit=7
164. 0.014 0.036 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.036..0.036 rows=1 loops=1)

  • Output: (to_char(mash_3.date_time, 'hh24:mi'::text)), mash_3.date_time
  • Sort Key: mash_3.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
165. 0.013 0.022 ↓ 2.0 2 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.017..0.022 rows=2 loops=1)

  • Output: to_char(mash_3.date_time, 'hh24:mi'::text), mash_3.date_time
  • Join Filter: (mash_3.state_id = macs_3.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=7
166. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_3 (cost=0.00..1.19 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: macs_3.id, macs_3.name, macs_3.code, macs_3.e_code, macs_3.aud_who, macs_3.aud_when, macs_3.aud_source, macs_3.aud_who_create, macs_3.aud_when_create, macs_3.aud_source_create
  • Filter: ((macs_3.code)::text = '5'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
167. 0.005 0.005 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_3 (cost=0.43..8.73 rows=12 width=12) (actual time=0.003..0.005 rows=8 loops=1)

  • Output: mash_3.id, mash_3.call_id, mash_3.date_time, mash_3.state_id, mash_3.transmit_id, mash_3.registrator_id, mash_3.aud_who, mash_3.aud_when, mash_3.aud_source, mash_3.aud_who_create, mash_3.aud_when_create, mash_3.aud_source_create
  • Index Cond: (mash_3.call_id = cal.id)
  • Buffers: shared hit=6
168. 0.004 0.134 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.131..0.134 rows=1 loops=1)

  • Output: (to_char(mash_4.date_time, 'hh24:mi'::text)), mash_4.date_time
  • Buffers: shared hit=7
169. 0.106 0.130 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.130..0.130 rows=1 loops=1)

  • Output: (to_char(mash_4.date_time, 'hh24:mi'::text)), mash_4.date_time
  • Sort Key: mash_4.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
170. 0.011 0.024 ↓ 2.0 2 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.019..0.024 rows=2 loops=1)

  • Output: to_char(mash_4.date_time, 'hh24:mi'::text), mash_4.date_time
  • Join Filter: (mash_4.state_id = macs_4.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=7
171. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_4 (cost=0.00..1.19 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)

  • Output: macs_4.id, macs_4.name, macs_4.code, macs_4.e_code, macs_4.aud_who, macs_4.aud_when, macs_4.aud_source, macs_4.aud_who_create, macs_4.aud_when_create, macs_4.aud_source_create
  • Filter: ((macs_4.code)::text = '5'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
172. 0.006 0.006 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_4 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.006 rows=8 loops=1)

  • Output: mash_4.id, mash_4.call_id, mash_4.date_time, mash_4.state_id, mash_4.transmit_id, mash_4.registrator_id, mash_4.aud_who, mash_4.aud_when, mash_4.aud_source, mash_4.aud_who_create, mash_4.aud_when_create, mash_4.aud_source_create
  • Index Cond: (mash_4.call_id = cal.id)
  • Buffers: shared hit=6
173. 0.002 0.054 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.053..0.054 rows=1 loops=1)

  • Output: (to_char(mash_5.date_time, 'hh24:mi'::text)), mash_5.date_time
  • Buffers: shared hit=7
174. 0.026 0.052 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.052..0.052 rows=1 loops=1)

  • Output: (to_char(mash_5.date_time, 'hh24:mi'::text)), mash_5.date_time
  • Sort Key: mash_5.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
175. 0.009 0.026 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.018..0.026 rows=1 loops=1)

  • Output: to_char(mash_5.date_time, 'hh24:mi'::text), mash_5.date_time
  • Join Filter: (mash_5.state_id = macs_5.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
176. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_5 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.007 rows=1 loops=1)

  • Output: macs_5.id, macs_5.name, macs_5.code, macs_5.e_code, macs_5.aud_who, macs_5.aud_when, macs_5.aud_source, macs_5.aud_who_create, macs_5.aud_when_create, macs_5.aud_source_create
  • Filter: ((macs_5.code)::text = '6'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
177. 0.010 0.010 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_5 (cost=0.43..8.73 rows=12 width=12) (actual time=0.006..0.010 rows=8 loops=1)

  • Output: mash_5.id, mash_5.call_id, mash_5.date_time, mash_5.state_id, mash_5.transmit_id, mash_5.registrator_id, mash_5.aud_who, mash_5.aud_when, mash_5.aud_source, mash_5.aud_who_create, mash_5.aud_when_create, mash_5.aud_source_create
  • Index Cond: (mash_5.call_id = cal.id)
  • Buffers: shared hit=6
178. 0.081 0.121 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.119..0.121 rows=1 loops=1)

  • Output: (to_char(mash_6.date_time, 'hh24:mi'::text)), mash_6.date_time
  • Buffers: shared hit=7
179. 0.012 0.040 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.040..0.040 rows=1 loops=1)

  • Output: (to_char(mash_6.date_time, 'hh24:mi'::text)), mash_6.date_time
  • Sort Key: mash_6.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
180. 0.009 0.028 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.021..0.028 rows=1 loops=1)

  • Output: to_char(mash_6.date_time, 'hh24:mi'::text), mash_6.date_time
  • Join Filter: (mash_6.state_id = macs_6.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
181. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_6 (cost=0.00..1.19 rows=1 width=4) (actual time=0.009..0.011 rows=1 loops=1)

  • Output: macs_6.id, macs_6.name, macs_6.code, macs_6.e_code, macs_6.aud_who, macs_6.aud_when, macs_6.aud_source, macs_6.aud_who_create, macs_6.aud_when_create, macs_6.aud_source_create
  • Filter: ((macs_6.code)::text = '6'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
182. 0.008 0.008 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_6 (cost=0.43..8.73 rows=12 width=12) (actual time=0.005..0.008 rows=8 loops=1)

  • Output: mash_6.id, mash_6.call_id, mash_6.date_time, mash_6.state_id, mash_6.transmit_id, mash_6.registrator_id, mash_6.aud_who, mash_6.aud_when, mash_6.aud_source, mash_6.aud_who_create, mash_6.aud_when_create, mash_6.aud_source_create
  • Index Cond: (mash_6.call_id = cal.id)
  • Buffers: shared hit=6
183. 0.002 0.039 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.038..0.039 rows=1 loops=1)

  • Output: (to_char(mash_7.date_time, 'hh24:mi'::text)), mash_7.date_time
  • Buffers: shared hit=7
184. 0.017 0.037 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.036..0.037 rows=1 loops=1)

  • Output: (to_char(mash_7.date_time, 'hh24:mi'::text)), mash_7.date_time
  • Sort Key: mash_7.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
185. 0.008 0.020 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.015..0.020 rows=1 loops=1)

  • Output: to_char(mash_7.date_time, 'hh24:mi'::text), mash_7.date_time
  • Join Filter: (mash_7.state_id = macs_7.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
186. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_7 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Output: macs_7.id, macs_7.name, macs_7.code, macs_7.e_code, macs_7.aud_who, macs_7.aud_when, macs_7.aud_source, macs_7.aud_who_create, macs_7.aud_when_create, macs_7.aud_source_create
  • Filter: ((macs_7.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
187. 0.007 0.007 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_7 (cost=0.43..8.73 rows=12 width=12) (actual time=0.003..0.007 rows=8 loops=1)

  • Output: mash_7.id, mash_7.call_id, mash_7.date_time, mash_7.state_id, mash_7.transmit_id, mash_7.registrator_id, mash_7.aud_who, mash_7.aud_when, mash_7.aud_source, mash_7.aud_who_create, mash_7.aud_when_create, mash_7.aud_source_create
  • Index Cond: (mash_7.call_id = cal.id)
  • Buffers: shared hit=6
188. 0.002 0.116 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.115..0.116 rows=1 loops=1)

  • Output: (to_char(mash_8.date_time, 'hh24:mi'::text)), mash_8.date_time
  • Buffers: shared hit=7
189. 0.013 0.114 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.114..0.114 rows=1 loops=1)

  • Output: (to_char(mash_8.date_time, 'hh24:mi'::text)), mash_8.date_time
  • Sort Key: mash_8.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
190. 0.087 0.101 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.095..0.101 rows=1 loops=1)

  • Output: to_char(mash_8.date_time, 'hh24:mi'::text), mash_8.date_time
  • Join Filter: (mash_8.state_id = macs_8.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
191. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_8 (cost=0.00..1.19 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=1)

  • Output: macs_8.id, macs_8.name, macs_8.code, macs_8.e_code, macs_8.aud_who, macs_8.aud_when, macs_8.aud_source, macs_8.aud_who_create, macs_8.aud_when_create, macs_8.aud_source_create
  • Filter: ((macs_8.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
192. 0.010 0.010 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_8 (cost=0.43..8.73 rows=12 width=12) (actual time=0.006..0.010 rows=8 loops=1)

  • Output: mash_8.id, mash_8.call_id, mash_8.date_time, mash_8.state_id, mash_8.transmit_id, mash_8.registrator_id, mash_8.aud_who, mash_8.aud_when, mash_8.aud_source, mash_8.aud_who_create, mash_8.aud_when_create, mash_8.aud_source_create
  • Index Cond: (mash_8.call_id = cal.id)
  • Buffers: shared hit=6
193. 0.000 0.101 ↓ 0.0 0 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.101..0.101 rows=0 loops=1)

  • Output: (to_char(mash_9.date_time, 'hh24:mi'::text)), mash_9.date_time
  • Buffers: shared hit=7
194. 0.083 0.101 ↓ 0.0 0 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.101..0.101 rows=0 loops=1)

  • Output: (to_char(mash_9.date_time, 'hh24:mi'::text)), mash_9.date_time
  • Sort Key: mash_9.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
195. 0.007 0.018 ↓ 0.0 0 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.017..0.018 rows=0 loops=1)

  • Output: to_char(mash_9.date_time, 'hh24:mi'::text), mash_9.date_time
  • Join Filter: (mash_9.state_id = macs_9.id)
  • Rows Removed by Join Filter: 8
  • Buffers: shared hit=7
196. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_9 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Output: macs_9.id, macs_9.name, macs_9.code, macs_9.e_code, macs_9.aud_who, macs_9.aud_when, macs_9.aud_source, macs_9.aud_who_create, macs_9.aud_when_create, macs_9.aud_source_create
  • Filter: ((macs_9.code)::text = '8'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
197. 0.006 0.006 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_9 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.006 rows=8 loops=1)

  • Output: mash_9.id, mash_9.call_id, mash_9.date_time, mash_9.state_id, mash_9.transmit_id, mash_9.registrator_id, mash_9.aud_who, mash_9.aud_when, mash_9.aud_source, mash_9.aud_who_create, mash_9.aud_when_create, mash_9.aud_source_create
  • Index Cond: (mash_9.call_id = cal.id)
  • Buffers: shared hit=6
198. 0.000 0.000 ↓ 0.0 0

Limit (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_10.date_time, 'hh24:mi'::text)), mash_10.date_time
199. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_10.date_time, 'hh24:mi'::text)), mash_10.date_time
  • Sort Key: mash_10.date_time DESC
200. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..10.07 rows=1 width=40) (never executed)

  • Output: to_char(mash_10.date_time, 'hh24:mi'::text), mash_10.date_time
  • Join Filter: (mash_10.state_id = macs_10.id)
201. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_state macs_10 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: macs_10.id, macs_10.name, macs_10.code, macs_10.e_code, macs_10.aud_who, macs_10.aud_when, macs_10.aud_source, macs_10.aud_who_create, macs_10.aud_when_create, macs_10.aud_source_create
  • Filter: ((macs_10.code)::text = '8'::text)
202. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_10 (cost=0.43..8.73 rows=12 width=12) (never executed)

  • Output: mash_10.id, mash_10.call_id, mash_10.date_time, mash_10.state_id, mash_10.transmit_id, mash_10.registrator_id, mash_10.aud_who, mash_10.aud_when, mash_10.aud_source, mash_10.aud_who_create, mash_10.aud_when_create, mash_10.aud_source_create
  • Index Cond: (mash_10.call_id = cal.id)
203. 0.001 0.031 ↓ 0.0 0 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.031..0.031 rows=0 loops=1)

  • Output: (to_char(mash_11.date_time, 'hh24:mi'::text)), mash_11.date_time
  • Buffers: shared hit=7
204. 0.015 0.030 ↓ 0.0 0 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.030..0.030 rows=0 loops=1)

  • Output: (to_char(mash_11.date_time, 'hh24:mi'::text)), mash_11.date_time
  • Sort Key: mash_11.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
205. 0.004 0.015 ↓ 0.0 0 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.015..0.015 rows=0 loops=1)

  • Output: to_char(mash_11.date_time, 'hh24:mi'::text), mash_11.date_time
  • Join Filter: (mash_11.state_id = macs_11.id)
  • Rows Removed by Join Filter: 8
  • Buffers: shared hit=7
206. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_11 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Output: macs_11.id, macs_11.name, macs_11.code, macs_11.e_code, macs_11.aud_who, macs_11.aud_when, macs_11.aud_source, macs_11.aud_who_create, macs_11.aud_when_create, macs_11.aud_source_create
  • Filter: ((macs_11.code)::text = '9'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
207. 0.006 0.006 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_11 (cost=0.43..8.73 rows=12 width=12) (actual time=0.003..0.006 rows=8 loops=1)

  • Output: mash_11.id, mash_11.call_id, mash_11.date_time, mash_11.state_id, mash_11.transmit_id, mash_11.registrator_id, mash_11.aud_who, mash_11.aud_when, mash_11.aud_source, mash_11.aud_who_create, mash_11.aud_when_create, mash_11.aud_source_create
  • Index Cond: (mash_11.call_id = cal.id)
  • Buffers: shared hit=6
208. 0.000 0.000 ↓ 0.0 0

Limit (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_12.date_time, 'hh24:mi'::text)), mash_12.date_time
209. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_12.date_time, 'hh24:mi'::text)), mash_12.date_time
  • Sort Key: mash_12.date_time DESC
210. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..10.07 rows=1 width=40) (never executed)

  • Output: to_char(mash_12.date_time, 'hh24:mi'::text), mash_12.date_time
  • Join Filter: (mash_12.state_id = macs_12.id)
211. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_state macs_12 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: macs_12.id, macs_12.name, macs_12.code, macs_12.e_code, macs_12.aud_who, macs_12.aud_when, macs_12.aud_source, macs_12.aud_who_create, macs_12.aud_when_create, macs_12.aud_source_create
  • Filter: ((macs_12.code)::text = '9'::text)
212. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_12 (cost=0.43..8.73 rows=12 width=12) (never executed)

  • Output: mash_12.id, mash_12.call_id, mash_12.date_time, mash_12.state_id, mash_12.transmit_id, mash_12.registrator_id, mash_12.aud_who, mash_12.aud_when, mash_12.aud_source, mash_12.aud_who_create, mash_12.aud_when_create, mash_12.aud_source_create
  • Index Cond: (mash_12.call_id = cal.id)
213. 0.004 0.117 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.115..0.117 rows=1 loops=1)

  • Output: (to_char(mash_13.date_time, 'hh24:mi'::text)), mash_13.date_time
  • Buffers: shared hit=7
214. 0.014 0.113 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.113..0.113 rows=1 loops=1)

  • Output: (to_char(mash_13.date_time, 'hh24:mi'::text)), mash_13.date_time
  • Sort Key: mash_13.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
215. 0.088 0.099 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.093..0.099 rows=1 loops=1)

  • Output: to_char(mash_13.date_time, 'hh24:mi'::text), mash_13.date_time
  • Join Filter: (mash_13.state_id = macs_13.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
216. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_13 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: macs_13.id, macs_13.name, macs_13.code, macs_13.e_code, macs_13.aud_who, macs_13.aud_when, macs_13.aud_source, macs_13.aud_who_create, macs_13.aud_when_create, macs_13.aud_source_create
  • Filter: ((macs_13.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
217. 0.005 0.005 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_13 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.005 rows=8 loops=1)

  • Output: mash_13.id, mash_13.call_id, mash_13.date_time, mash_13.state_id, mash_13.transmit_id, mash_13.registrator_id, mash_13.aud_who, mash_13.aud_when, mash_13.aud_source, mash_13.aud_who_create, mash_13.aud_when_create, mash_13.aud_source_create
  • Index Cond: (mash_13.call_id = cal.id)
  • Buffers: shared hit=6
218. 0.002 0.117 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=16) (actual time=0.116..0.117 rows=1 loops=1)

  • Output: mash_14.date_time, mash_14.date_time
  • Buffers: shared hit=7
219. 0.090 0.115 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=16) (actual time=0.115..0.115 rows=1 loops=1)

  • Output: mash_14.date_time, mash_14.date_time
  • Sort Key: mash_14.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
220. 0.005 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=16) (actual time=0.018..0.025 rows=1 loops=1)

  • Output: mash_14.date_time, mash_14.date_time
  • Join Filter: (mash_14.state_id = macs_14.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
221. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_14 (cost=0.00..1.19 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=1)

  • Output: macs_14.id, macs_14.name, macs_14.code, macs_14.e_code, macs_14.aud_who, macs_14.aud_when, macs_14.aud_source, macs_14.aud_who_create, macs_14.aud_when_create, macs_14.aud_source_create
  • Filter: ((macs_14.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
222. 0.012 0.012 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_14 (cost=0.43..8.73 rows=12 width=12) (actual time=0.008..0.012 rows=8 loops=1)

  • Output: mash_14.id, mash_14.call_id, mash_14.date_time, mash_14.state_id, mash_14.transmit_id, mash_14.registrator_id, mash_14.aud_who, mash_14.aud_when, mash_14.aud_source, mash_14.aud_who_create, mash_14.aud_when_create, mash_14.aud_source_create
  • Index Cond: (mash_14.call_id = cal.id)
  • Buffers: shared hit=6
223. 0.002 0.038 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.037..0.038 rows=1 loops=1)

  • Output: (to_char(mash_15.date_time, 'hh24:mi'::text)), mash_15.date_time
  • Buffers: shared hit=7
224. 0.011 0.036 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.036..0.036 rows=1 loops=1)

  • Output: (to_char(mash_15.date_time, 'hh24:mi'::text)), mash_15.date_time
  • Sort Key: mash_15.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
225. 0.012 0.025 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.020..0.025 rows=1 loops=1)

  • Output: to_char(mash_15.date_time, 'hh24:mi'::text), mash_15.date_time
  • Join Filter: (mash_15.state_id = macs_15.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
226. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_15 (cost=0.00..1.19 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=1)

  • Output: macs_15.id, macs_15.name, macs_15.code, macs_15.e_code, macs_15.aud_who, macs_15.aud_when, macs_15.aud_source, macs_15.aud_who_create, macs_15.aud_when_create, macs_15.aud_source_create
  • Filter: ((macs_15.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
227. 0.006 0.006 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_15 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.006 rows=8 loops=1)

  • Output: mash_15.id, mash_15.call_id, mash_15.date_time, mash_15.state_id, mash_15.transmit_id, mash_15.registrator_id, mash_15.aud_who, mash_15.aud_when, mash_15.aud_source, mash_15.aud_who_create, mash_15.aud_when_create, mash_15.aud_source_create
  • Index Cond: (mash_15.call_id = cal.id)
  • Buffers: shared hit=6
228. 0.001 0.031 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=16) (actual time=0.030..0.031 rows=1 loops=1)

  • Output: mash_16.date_time, mash_16.date_time
  • Buffers: shared hit=7
229. 0.013 0.030 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=16) (actual time=0.029..0.030 rows=1 loops=1)

  • Output: mash_16.date_time, mash_16.date_time
  • Sort Key: mash_16.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
230. 0.007 0.017 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=16) (actual time=0.011..0.017 rows=1 loops=1)

  • Output: mash_16.date_time, mash_16.date_time
  • Join Filter: (mash_16.state_id = macs_16.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
231. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_16 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Output: macs_16.id, macs_16.name, macs_16.code, macs_16.e_code, macs_16.aud_who, macs_16.aud_when, macs_16.aud_source, macs_16.aud_who_create, macs_16.aud_when_create, macs_16.aud_source_create
  • Filter: ((macs_16.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
232. 0.005 0.005 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_16 (cost=0.43..8.73 rows=12 width=12) (actual time=0.003..0.005 rows=8 loops=1)

  • Output: mash_16.id, mash_16.call_id, mash_16.date_time, mash_16.state_id, mash_16.transmit_id, mash_16.registrator_id, mash_16.aud_who, mash_16.aud_when, mash_16.aud_source, mash_16.aud_who_create, mash_16.aud_when_create, mash_16.aud_source_create
  • Index Cond: (mash_16.call_id = cal.id)
  • Buffers: shared hit=6
233. 0.003 0.116 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=16) (actual time=0.115..0.116 rows=1 loops=1)

  • Output: mash_17.date_time, mash_17.date_time
  • Buffers: shared hit=7
234. 0.011 0.113 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=16) (actual time=0.113..0.113 rows=1 loops=1)

  • Output: mash_17.date_time, mash_17.date_time
  • Sort Key: mash_17.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
235. 0.086 0.102 ↓ 2.0 2 1

Nested Loop (cost=0.43..10.07 rows=1 width=16) (actual time=0.097..0.102 rows=2 loops=1)

  • Output: mash_17.date_time, mash_17.date_time
  • Join Filter: (mash_17.state_id = macs_17.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=7
236. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_17 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: macs_17.id, macs_17.name, macs_17.code, macs_17.e_code, macs_17.aud_who, macs_17.aud_when, macs_17.aud_source, macs_17.aud_who_create, macs_17.aud_when_create, macs_17.aud_source_create
  • Filter: ((macs_17.code)::text = '5'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
237. 0.010 0.010 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_17 (cost=0.43..8.73 rows=12 width=12) (actual time=0.005..0.010 rows=8 loops=1)

  • Output: mash_17.id, mash_17.call_id, mash_17.date_time, mash_17.state_id, mash_17.transmit_id, mash_17.registrator_id, mash_17.aud_who, mash_17.aud_when, mash_17.aud_source, mash_17.aud_who_create, mash_17.aud_when_create, mash_17.aud_source_create
  • Index Cond: (mash_17.call_id = cal.id)
  • Buffers: shared hit=6
238. 0.002 0.051 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.050..0.051 rows=1 loops=1)

  • Output: (to_char(mash_18.date_time, 'hh24:mi'::text)), mash_18.date_time
  • Buffers: shared hit=7
239. 0.022 0.049 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.049..0.049 rows=1 loops=1)

  • Output: (to_char(mash_18.date_time, 'hh24:mi'::text)), mash_18.date_time
  • Sort Key: mash_18.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
240. 0.016 0.027 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.019..0.027 rows=1 loops=1)

  • Output: to_char(mash_18.date_time, 'hh24:mi'::text), mash_18.date_time
  • Join Filter: (mash_18.state_id = macs_18.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
241. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_18 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: macs_18.id, macs_18.name, macs_18.code, macs_18.e_code, macs_18.aud_who, macs_18.aud_when, macs_18.aud_source, macs_18.aud_who_create, macs_18.aud_when_create, macs_18.aud_source_create
  • Filter: ((macs_18.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
242. 0.005 0.005 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_18 (cost=0.43..8.73 rows=12 width=12) (actual time=0.003..0.005 rows=8 loops=1)

  • Output: mash_18.id, mash_18.call_id, mash_18.date_time, mash_18.state_id, mash_18.transmit_id, mash_18.registrator_id, mash_18.aud_who, mash_18.aud_when, mash_18.aud_source, mash_18.aud_who_create, mash_18.aud_when_create, mash_18.aud_source_create
  • Index Cond: (mash_18.call_id = cal.id)
  • Buffers: shared hit=6
243. 0.001 0.114 ↑ 1.0 1 1

Limit (cost=10.08..10.08 rows=1 width=16) (actual time=0.113..0.114 rows=1 loops=1)

  • Output: mash_19.date_time, mash_19.date_time
  • Buffers: shared hit=7
244. 0.019 0.113 ↑ 1.0 1 1

Sort (cost=10.08..10.08 rows=1 width=16) (actual time=0.112..0.113 rows=1 loops=1)

  • Output: mash_19.date_time, mash_19.date_time
  • Sort Key: mash_19.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
245. 0.079 0.094 ↑ 1.0 1 1

Nested Loop (cost=0.43..10.07 rows=1 width=16) (actual time=0.089..0.094 rows=1 loops=1)

  • Output: mash_19.date_time, mash_19.date_time
  • Join Filter: (mash_19.state_id = macs_19.id)
  • Rows Removed by Join Filter: 7
  • Buffers: shared hit=7
246. 0.005 0.005 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_19 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=1)

  • Output: macs_19.id, macs_19.name, macs_19.code, macs_19.e_code, macs_19.aud_who, macs_19.aud_when, macs_19.aud_source, macs_19.aud_who_create, macs_19.aud_when_create, macs_19.aud_source_create
  • Filter: ((macs_19.code)::text = '7'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
247. 0.010 0.010 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_19 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.010 rows=8 loops=1)

  • Output: mash_19.id, mash_19.call_id, mash_19.date_time, mash_19.state_id, mash_19.transmit_id, mash_19.registrator_id, mash_19.aud_who, mash_19.aud_when, mash_19.aud_source, mash_19.aud_who_create, mash_19.aud_when_create, mash_19.aud_source_create
  • Index Cond: (mash_19.call_id = cal.id)
  • Buffers: shared hit=6
248. 0.001 0.108 ↓ 0.0 0 1

Limit (cost=10.08..10.08 rows=1 width=40) (actual time=0.108..0.108 rows=0 loops=1)

  • Output: (to_char(mash_20.date_time, 'hh24:mi'::text)), mash_20.date_time
  • Buffers: shared hit=7
249. 0.014 0.107 ↓ 0.0 0 1

Sort (cost=10.08..10.08 rows=1 width=40) (actual time=0.107..0.107 rows=0 loops=1)

  • Output: (to_char(mash_20.date_time, 'hh24:mi'::text)), mash_20.date_time
  • Sort Key: mash_20.date_time DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7
250. 0.079 0.093 ↓ 0.0 0 1

Nested Loop (cost=0.43..10.07 rows=1 width=40) (actual time=0.093..0.093 rows=0 loops=1)

  • Output: to_char(mash_20.date_time, 'hh24:mi'::text), mash_20.date_time
  • Join Filter: (mash_20.state_id = macs_20.id)
  • Rows Removed by Join Filter: 8
  • Buffers: shared hit=7
251. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on amb.md_ambulance_call_state macs_20 (cost=0.00..1.19 rows=1 width=4) (actual time=0.004..0.006 rows=1 loops=1)

  • Output: macs_20.id, macs_20.name, macs_20.code, macs_20.e_code, macs_20.aud_who, macs_20.aud_when, macs_20.aud_source, macs_20.aud_who_create, macs_20.aud_when_create, macs_20.aud_source_create
  • Filter: ((macs_20.code)::text = '11'::text)
  • Rows Removed by Filter: 14
  • Buffers: shared hit=1
252. 0.008 0.008 ↑ 1.5 8 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_20 (cost=0.43..8.73 rows=12 width=12) (actual time=0.004..0.008 rows=8 loops=1)

  • Output: mash_20.id, mash_20.call_id, mash_20.date_time, mash_20.state_id, mash_20.transmit_id, mash_20.registrator_id, mash_20.aud_who, mash_20.aud_when, mash_20.aud_source, mash_20.aud_who_create, mash_20.aud_when_create, mash_20.aud_source_create
  • Index Cond: (mash_20.call_id = cal.id)
  • Buffers: shared hit=6
253. 0.000 0.000 ↓ 0.0 0

Limit (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_21.date_time, 'hh24:mi'::text)), mash_21.date_time
254. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.08..10.08 rows=1 width=40) (never executed)

  • Output: (to_char(mash_21.date_time, 'hh24:mi'::text)), mash_21.date_time
  • Sort Key: mash_21.date_time DESC
255. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..10.07 rows=1 width=40) (never executed)

  • Output: to_char(mash_21.date_time, 'hh24:mi'::text), mash_21.date_time
  • Join Filter: (mash_21.state_id = macs_21.id)
256. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_state macs_21 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: macs_21.id, macs_21.name, macs_21.code, macs_21.e_code, macs_21.aud_who, macs_21.aud_when, macs_21.aud_source, macs_21.aud_who_create, macs_21.aud_when_create, macs_21.aud_source_create
  • Filter: ((macs_21.code)::text = '11'::text)
257. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history mash_21 (cost=0.43..8.73 rows=12 width=12) (never executed)

  • Output: mash_21.id, mash_21.call_id, mash_21.date_time, mash_21.state_id, mash_21.transmit_id, mash_21.registrator_id, mash_21.aud_who, mash_21.aud_when, mash_21.aud_source, mash_21.aud_who_create, mash_21.aud_when_create, mash_21.aud_source_create
  • Index Cond: (mash_21.call_id = cal.id)
258. 5.195 5.195 ↑ 1.0 1 1

Index Scan using pci_patient_id__modified_dt_ix on public.pci_patient (cost=0.42..8.44 rows=1 width=8) (actual time=5.193..5.195 rows=1 loops=1)

  • Output: pci_patient.note
  • Index Cond: (pci_patient.id = pip.id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=5.133
259. 0.000 0.000 ↓ 0.0 0

Limit (cost=8.32..8.32 rows=1 width=8) (never executed)

  • Output: pci_patient_part_case.part_case_id, pci_patient_part_case.from_dt
260. 0.000 0.000 ↓ 0.0 0

Sort (cost=8.32..8.32 rows=1 width=8) (never executed)

  • Output: pci_patient_part_case.part_case_id, pci_patient_part_case.from_dt
  • Sort Key: pci_patient_part_case.from_dt DESC
261. 0.000 0.000 ↓ 0.0 0

Index Scan using pci_patient_part_case_patient_id_idx on public.pci_patient_part_case (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Output: pci_patient_part_case.part_case_id, pci_patient_part_case.from_dt
  • Index Cond: (pci_patient_part_case.patient_id = pip.id)
262. 0.000 0.000 ↓ 0.0 0

Limit (cost=31.80..31.80 rows=1 width=8) (never executed)

  • Output: (CASE WHEN (ae.is_city IS TRUE) THEN $27 ELSE $28 END), ppa_1.id
263.          

Initplan (for Limit)

264. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.pim_citizenship_type (cost=0.00..1.05 rows=1 width=4) (never executed)

  • Output: pim_citizenship_type.id
  • Filter: ((pim_citizenship_type.e_code)::text = '1'::text)
265. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.pim_citizenship_type pim_citizenship_type_1 (cost=0.00..1.05 rows=1 width=4) (never executed)

  • Output: pim_citizenship_type_1.id
  • Filter: ((pim_citizenship_type_1.e_code)::text = '2'::text)
266. 0.000 0.000 ↓ 0.0 0

Sort (cost=29.70..29.70 rows=1 width=8) (never executed)

  • Output: (CASE WHEN (ae.is_city IS TRUE) THEN $27 ELSE $28 END), ppa_1.id
  • Sort Key: ppa_1.id
267. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.41..29.69 rows=1 width=8) (never executed)

  • Output: CASE WHEN (ae.is_city IS TRUE) THEN $27 ELSE $28 END, ppa_1.id
268. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.99..21.23 rows=1 width=8) (never executed)

  • Output: ppa_1.id, ppa_1.addr_id
269. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..20.89 rows=2 width=12) (never executed)

  • Output: ppa_1.id, ppa_1.addr_id, ppatat_1.address_type_id
270. 0.000 0.000 ↓ 0.0 0

Index Scan using pim_party_address_party_id_idx on public.pim_party_address ppa_1 (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Output: ppa_1.id, ppa_1.from_date, ppa_1.note, ppa_1.text_addr, ppa_1.to_date, ppa_1.is_valid, ppa_1.addr_id, ppa_1.party_id, ppa_1.register_type_id, ppa_1.aud_who, ppa_1.aud_when, ppa_1.aud_source, ppa_1.aud_who_create, ppa_1.aud_when_create, ppa_1.aud_source_create
  • Index Cond: (ppa_1.party_id = pip.id)
  • Filter: (ppa_1.is_valid IS TRUE)
271. 0.000 0.000 ↓ 0.0 0

Index Scan using pim_party_addr_to_addr_type_party_address_id_idx on public.pim_party_addr_to_addr_type ppatat_1 (cost=0.43..12.43 rows=2 width=8) (never executed)

  • Output: ppatat_1.id, ppatat_1.address_type_id, ppatat_1.party_address_id, ppatat_1.aud_who, ppatat_1.aud_when, ppatat_1.aud_source, ppatat_1.aud_who_create, ppatat_1.aud_when_create, ppatat_1.aud_source_create
  • Index Cond: (ppatat_1.party_address_id = ppa_1.id)
272. 0.000 0.000 ↓ 0.0 0

Index Scan using pim_address_type_pk on public.pim_address_type padt (cost=0.13..0.16 rows=1 width=4) (never executed)

  • Output: padt.id, padt.code, padt.name, padt.note, padt.party_type_id, padt.e_code, padt.from_dt, padt.to_dt, padt.aud_who, padt.aud_when, padt.aud_source, padt.aud_who_create, padt.aud_when_create, padt.aud_source_create, padt.is_unique, padt.is_singular
  • Index Cond: (padt.id = ppatat_1.address_type_id)
  • Filter: ((padt.party_type_id = 1) AND (upper(btrim((padt.code)::text)) = 'REGISTER'::text))
273. 0.000 0.000 ↓ 0.0 0

Index Scan using address_element_data_pkey on public.address_element_data ae (cost=0.43..8.45 rows=1 width=5) (never executed)

  • Output: ae.id, ae.search_name, ae.path, ae.is_city, ae.aud_who, ae.aud_when, ae.aud_source, ae.aud_who_create, ae.aud_when_create, ae.aud_source_create
  • Index Cond: (ae.id = ppa_1.addr_id)
274. 0.002 4.942 ↓ 0.0 0 1

Limit (cost=13.74..13.74 rows=1 width=8) (actual time=4.942..4.942 rows=0 loops=1)

  • Output: ppsg.social_group_id, ppsg.id
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=4.806
275. 0.009 4.940 ↓ 0.0 0 1

Sort (cost=13.74..13.74 rows=1 width=8) (actual time=4.940..4.940 rows=0 loops=1)

  • Output: ppsg.social_group_id, ppsg.id
  • Sort Key: ppsg.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=4.806
276. 0.098 4.931 ↓ 0.0 0 1

Nested Loop (cost=0.42..13.73 rows=1 width=8) (actual time=4.931..4.931 rows=0 loops=1)

  • Output: ppsg.social_group_id, ppsg.id
  • Join Filter: (ppsg.social_group_id = msg.id)
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=4.806
277. 4.833 4.833 ↓ 0.0 0 1

Index Scan using pci_patient_social_group_patient_id_ix on public.pci_patient_social_group ppsg (cost=0.42..12.41 rows=1 width=8) (actual time=4.833..4.833 rows=0 loops=1)

  • Output: ppsg.id, ppsg.patient_id, ppsg.social_group_id, ppsg.from_dt, ppsg.to_dt, ppsg.aud_who, ppsg.aud_when, ppsg.aud_source, ppsg.aud_who_create, ppsg.aud_when_create, ppsg.aud_source_create
  • Index Cond: (ppsg.patient_id = pip.id)
  • Filter: ((ppsg.to_dt IS NULL) OR (ppsg.to_dt > (now())::date))
  • Buffers: shared hit=2 read=1
  • I/O Timings: read=4.806
278. 0.000 0.000 ↓ 0.0 0

Seq Scan on public.md_soc_group msg (cost=0.00..1.14 rows=14 width=4) (never executed)

  • Output: msg.id, msg.code, msg.from_age, msg.from_dt, msg.name, msg.to_age, msg.to_dt, msg.e_code, msg.parent_id, msg.aud_who, msg.aud_when, msg.aud_source, msg.aud_who_create, msg.aud_when_create, msg.aud_source_create, msg.snmp_code
279. 0.028 0.028 ↑ 1.0 1 1

Index Scan using mc_step_result_pk on public.mc_step_result (cost=0.14..8.16 rows=1 width=104) (actual time=0.028..0.028 rows=1 loops=1)

  • Output: mc_step_result.name
  • Index Cond: (mc_step_result.id = step.result_id)
  • Buffers: shared hit=2
280. 0.005 0.005 ↑ 1.0 1 1

Index Scan using mc_step_result_pk on public.mc_step_result mc_step_result_1 (cost=0.14..8.16 rows=1 width=3) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: mc_step_result_1.e_code
  • Index Cond: (mc_step_result_1.id = step.result_id)
  • Buffers: shared hit=2
281. 4.318 4.318 ↓ 0.0 0 1

Seq Scan on supp.ambcall_delay_reason (cost=0.00..1.93 rows=1 width=33) (actual time=4.318..4.318 rows=0 loops=1)

  • Output: ambcall_delay_reason.delay_text
  • Filter: (ambcall_delay_reason.call_id = cr.id)
  • Rows Removed by Filter: 74
  • Buffers: shared read=1
  • I/O Timings: read=4.293
282. 0.015 0.015 ↓ 0.0 0 1

Index Scan using md_ambcall_state_history_call_idx on amb.md_ambcall_state_history (cost=0.43..8.76 rows=1 width=0) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (md_ambcall_state_history.call_id = cal.id)
  • Filter: (md_ambcall_state_history.state_id = 9)
  • Rows Removed by Filter: 8
  • Buffers: shared hit=6
283. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on amb.md_ambcall_state_history md_ambcall_state_history_1 (cost=1,281.29..55,802.02 rows=64,627 width=4) (never executed)

  • Output: md_ambcall_state_history_1.call_id
  • Recheck Cond: (md_ambcall_state_history_1.state_id = 9)
284. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on md_ambcall_state_history_state_idx (cost=0.00..1,265.13 rows=64,627 width=0) (never executed)

  • Index Cond: (md_ambcall_state_history_1.state_id = 9)
285. 0.010 0.066 ↑ 1.0 1 1

Aggregate (cost=7.22..7.23 rows=1 width=32) (actual time=0.064..0.066 rows=1 loops=1)

  • Output: array_to_json(array_agg(row_to_json(ROW(ac.id))))
  • Buffers: shared hit=4
286. 0.012 0.056 ↓ 0.0 0 1

Hash Join (cost=5.94..7.21 rows=1 width=4) (actual time=0.055..0.056 rows=0 loops=1)

  • Output: ac.id
  • Hash Cond: (ac.id = r.complication_id)
  • Buffers: shared hit=4
287. 0.007 0.007 ↑ 19.0 1 1

Seq Scan on amb.md_ambulance_complications ac (cost=0.00..1.19 rows=19 width=4) (actual time=0.007..0.007 rows=1 loops=1)

  • Output: ac.id, ac.code, ac.name, ac.e_code, ac.aud_who, ac.aud_when, ac.aud_source, ac.aud_who_create, ac.aud_when_create, ac.aud_source_create
  • Buffers: shared hit=1
288. 0.000 0.037 ↓ 0.0 0 1

Hash (cost=5.93..5.93 rows=1 width=4) (actual time=0.037..0.037 rows=0 loops=1)

  • Output: r.complication_id
  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
  • Buffers: shared hit=3
289. 0.037 0.037 ↓ 0.0 0 1

Seq Scan on amb.md_ambulance_call_complication r (cost=0.00..5.93 rows=1 width=4) (actual time=0.037..0.037 rows=0 loops=1)

  • Output: r.complication_id
  • Filter: (r.call_id = cal.id)
  • Rows Removed by Filter: 234
  • Buffers: shared hit=3
290. 0.020 0.020 ↓ 0.0 0 1

Index Scan using md_ambulance_call_notes_call_idx on amb.md_ambulance_call_note (cost=0.42..8.44 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: md_ambulance_call_note.id
  • Index Cond: (md_ambulance_call_note.call_id = cal.id)
  • Filter: ((md_ambulance_call_note.note_active IS TRUE) AND (md_ambulance_call_note.note_type IS TRUE) AND (md_ambulance_call_note.note_id = 21))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=9
291. 0.002 0.012 ↑ 1.0 1 1

Aggregate (cost=8.44..8.45 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: count(*)
  • Buffers: shared hit=9
292. 0.010 0.010 ↓ 0.0 0 1

Index Scan using md_ambulance_call_notes_call_idx on amb.md_ambulance_call_note md_ambulance_call_note_1 (cost=0.42..8.44 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: md_ambulance_call_note_1.id, md_ambulance_call_note_1.call_id, md_ambulance_call_note_1.note_dt, md_ambulance_call_note_1.note_id, md_ambulance_call_note_1.registrator_id, md_ambulance_call_note_1.note_reason_id, md_ambulance_call_note_1.note_description, md_ambulance_call_note_1.note_active, md_ambulance_call_note_1.note_type, md_ambulance_call_note_1.aud_who, md_ambulance_call_note_1.aud_when, md_ambulance_call_note_1.aud_source, md_ambulance_call_note_1.aud_who_create, md_ambulance_call_note_1.aud_when_create, md_ambulance_call_note_1.aud_source_create
  • Index Cond: (md_ambulance_call_note_1.call_id = cal.id)
  • Filter: (md_ambulance_call_note_1.note_type AND md_ambulance_call_note_1.note_active AND (md_ambulance_call_note_1.note_id = 15))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=9
293. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..9.64 rows=1 width=0) (never executed)

294. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_on_base cob (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: cob.id, cob.call_on_base_id, cob.aud_who, cob.aud_when, cob.aud_source, cob.aud_who_create, cob.aud_when_create, cob.aud_source_create
  • Filter: (cob.call_on_base_id = cal.id)
295. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambulance_call_pkey on amb.md_ambulance_call child (cost=0.42..8.45 rows=1 width=4) (never executed)

  • Output: child.id, child.call_number, child.call_place_id, child.call_type_id, child.priority_id, child.from_time, child.to_time, child.address_id, child.house, child.housing, child.apartment, child.porch, child.floor, child.door_code, child.description, child.phone_caller, child.caller_note, child.registrator_id, child.call_kind_id, child.reason_note, child.caller_reason_id, child.call_place_note, child.place_org_id, child.caller_id, child.place_department_id, child.to_address_id, child.to_house, child.to_housing, child.to_apartment, child.to_porch, child.to_description, child.patient_id, child.is_group_sufferer, child.sum_sufferer, child.station_id, child.reason_diag, child.is_chronic, child.employee_id, child.priority, child.route_id, child.call_dt, child.brg_id, child.note, child.substation_id, child.to_org_id, child.to_department_id, child.control, child.emp_id, child.age_years, child.age_months, child.age_days, child.call_mark, child.aud_who, child.aud_when, child.aud_source, child.aud_who_create, child.aud_when_create, child.aud_source_create, child.desk_id
  • Index Cond: (child.id = cob.id)
  • Filter: (child.call_kind_id = 5)
296. 0.058 109.108 ↓ 5.0 5 1

Hash Join (cost=1.76..59.96 rows=1 width=4) (actual time=21.943..109.108 rows=5 loops=1)

  • Output: cob_1.call_on_base_id
  • Hash Cond: (child_1.id = cob_1.id)
  • Buffers: shared hit=2 read=31
  • I/O Timings: read=108.560
297. 109.032 109.032 ↓ 1.4 106 1

Index Scan using md_ambulance_call_kind_idx on amb.md_ambulance_call child_1 (cost=0.42..58.33 rows=74 width=4) (actual time=21.912..109.032 rows=106 loops=1)

  • Output: child_1.id, child_1.call_number, child_1.call_place_id, child_1.call_type_id, child_1.priority_id, child_1.from_time, child_1.to_time, child_1.address_id, child_1.house, child_1.housing, child_1.apartment, child_1.porch, child_1.floor, child_1.door_code, child_1.description, child_1.phone_caller, child_1.caller_note, child_1.registrator_id, child_1.call_kind_id, child_1.reason_note, child_1.caller_reason_id, child_1.call_place_note, child_1.place_org_id, child_1.caller_id, child_1.place_department_id, child_1.to_address_id, child_1.to_house, child_1.to_housing, child_1.to_apartment, child_1.to_porch, child_1.to_description, child_1.patient_id, child_1.is_group_sufferer, child_1.sum_sufferer, child_1.station_id, child_1.reason_diag, child_1.is_chronic, child_1.employee_id, child_1.priority, child_1.route_id, child_1.call_dt, child_1.brg_id, child_1.note, child_1.substation_id, child_1.to_org_id, child_1.to_department_id, child_1.control, child_1.emp_id, child_1.age_years, child_1.age_months, child_1.age_days, child_1.call_mark, child_1.aud_who, child_1.aud_when, child_1.aud_source, child_1.aud_who_create, child_1.aud_when_create, child_1.aud_source_create, child_1.desk_id
  • Index Cond: (child_1.call_kind_id = 5)
  • Buffers: shared hit=1 read=31
  • I/O Timings: read=108.560
298. 0.008 0.018 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=8) (actual time=0.018..0.018 rows=15 loops=1)

  • Output: cob_1.call_on_base_id, cob_1.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
299. 0.010 0.010 ↑ 1.0 15 1

Seq Scan on amb.md_ambulance_call_on_base cob_1 (cost=0.00..1.15 rows=15 width=8) (actual time=0.007..0.010 rows=15 loops=1)

  • Output: cob_1.call_on_base_id, cob_1.id
  • Buffers: shared hit=1
300. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..9.64 rows=1 width=0) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_on_base cob_2 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: cob_2.id, cob_2.call_on_base_id, cob_2.aud_who, cob_2.aud_when, cob_2.aud_source, cob_2.aud_who_create, cob_2.aud_when_create, cob_2.aud_source_create
  • Filter: (cob_2.call_on_base_id = cal.id)
302. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambulance_call_pkey on amb.md_ambulance_call child_2 (cost=0.42..8.45 rows=1 width=4) (never executed)

  • Output: child_2.id, child_2.call_number, child_2.call_place_id, child_2.call_type_id, child_2.priority_id, child_2.from_time, child_2.to_time, child_2.address_id, child_2.house, child_2.housing, child_2.apartment, child_2.porch, child_2.floor, child_2.door_code, child_2.description, child_2.phone_caller, child_2.caller_note, child_2.registrator_id, child_2.call_kind_id, child_2.reason_note, child_2.caller_reason_id, child_2.call_place_note, child_2.place_org_id, child_2.caller_id, child_2.place_department_id, child_2.to_address_id, child_2.to_house, child_2.to_housing, child_2.to_apartment, child_2.to_porch, child_2.to_description, child_2.patient_id, child_2.is_group_sufferer, child_2.sum_sufferer, child_2.station_id, child_2.reason_diag, child_2.is_chronic, child_2.employee_id, child_2.priority, child_2.route_id, child_2.call_dt, child_2.brg_id, child_2.note, child_2.substation_id, child_2.to_org_id, child_2.to_department_id, child_2.control, child_2.emp_id, child_2.age_years, child_2.age_months, child_2.age_days, child_2.call_mark, child_2.aud_who, child_2.aud_when, child_2.aud_source, child_2.aud_who_create, child_2.aud_when_create, child_2.aud_source_create, child_2.desk_id
  • Index Cond: (child_2.id = cob_2.id)
  • Filter: (child_2.call_kind_id = 5)
303. 0.033 0.120 ↓ 5.0 5 1

Hash Join (cost=1.76..59.96 rows=1 width=4) (actual time=0.049..0.120 rows=5 loops=1)

  • Output: cob_3.call_on_base_id
  • Hash Cond: (child_3.id = cob_3.id)
  • Buffers: shared hit=33
304. 0.070 0.070 ↓ 1.4 106 1

Index Scan using md_ambulance_call_kind_idx on amb.md_ambulance_call child_3 (cost=0.42..58.33 rows=74 width=4) (actual time=0.018..0.070 rows=106 loops=1)

  • Output: child_3.id, child_3.call_number, child_3.call_place_id, child_3.call_type_id, child_3.priority_id, child_3.from_time, child_3.to_time, child_3.address_id, child_3.house, child_3.housing, child_3.apartment, child_3.porch, child_3.floor, child_3.door_code, child_3.description, child_3.phone_caller, child_3.caller_note, child_3.registrator_id, child_3.call_kind_id, child_3.reason_note, child_3.caller_reason_id, child_3.call_place_note, child_3.place_org_id, child_3.caller_id, child_3.place_department_id, child_3.to_address_id, child_3.to_house, child_3.to_housing, child_3.to_apartment, child_3.to_porch, child_3.to_description, child_3.patient_id, child_3.is_group_sufferer, child_3.sum_sufferer, child_3.station_id, child_3.reason_diag, child_3.is_chronic, child_3.employee_id, child_3.priority, child_3.route_id, child_3.call_dt, child_3.brg_id, child_3.note, child_3.substation_id, child_3.to_org_id, child_3.to_department_id, child_3.control, child_3.emp_id, child_3.age_years, child_3.age_months, child_3.age_days, child_3.call_mark, child_3.aud_who, child_3.aud_when, child_3.aud_source, child_3.aud_who_create, child_3.aud_when_create, child_3.aud_source_create, child_3.desk_id
  • Index Cond: (child_3.call_kind_id = 5)
  • Buffers: shared hit=32
305. 0.003 0.017 ↑ 1.0 15 1

Hash (cost=1.15..1.15 rows=15 width=8) (actual time=0.017..0.017 rows=15 loops=1)

  • Output: cob_3.call_on_base_id, cob_3.id
  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
306. 0.014 0.014 ↑ 1.0 15 1

Seq Scan on amb.md_ambulance_call_on_base cob_3 (cost=0.00..1.15 rows=15 width=8) (actual time=0.007..0.014 rows=15 loops=1)

  • Output: cob_3.call_on_base_id, cob_3.id
  • Buffers: shared hit=1
307. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..9.64 rows=1 width=4) (never executed)

  • Output: child_4.reason_diag
308. 0.000 0.000 ↓ 0.0 0

Seq Scan on amb.md_ambulance_call_on_base cob_4 (cost=0.00..1.19 rows=1 width=4) (never executed)

  • Output: cob_4.id, cob_4.call_on_base_id, cob_4.aud_who, cob_4.aud_when, cob_4.aud_source, cob_4.aud_who_create, cob_4.aud_when_create, cob_4.aud_source_create
  • Filter: (cob_4.call_on_base_id = cal.id)
309. 0.000 0.000 ↓ 0.0 0

Index Scan using md_ambulance_call_pkey on amb.md_ambulance_call child_4 (cost=0.42..8.45 rows=1 width=8) (never executed)

  • Output: child_4.id, child_4.call_number, child_4.call_place_id, child_4.call_type_id, child_4.priority_id, child_4.from_time, child_4.to_time, child_4.address_id, child_4.house, child_4.housing, child_4.apartment, child_4.porch, child_4.floor, child_4.door_code, child_4.description, child_4.phone_caller, child_4.caller_note, child_4.registrator_id, child_4.call_kind_id, child_4.reason_note, child_4.caller_reason_id, child_4.call_place_note, child_4.place_org_id, child_4.caller_id, child_4.place_department_id, child_4.to_address_id, child_4.to_house, child_4.to_housing, child_4.to_apartment, child_4.to_porch, child_4.to_description, child_4.patient_id, child_4.is_group_sufferer, child_4.sum_sufferer, child_4.station_id, child_4.reason_diag, child_4.is_chronic, child_4.employee_id, child_4.priority, child_4.route_id, child_4.call_dt, child_4.brg_id, child_4.note, child_4.substation_id, child_4.to_org_id, child_4.to_department_id, child_4.control, child_4.emp_id, child_4.age_years, child_4.age_months, child_4.age_days, child_4.call_mark, child_4.aud_who, child_4.aud_when, child_4.aud_source, child_4.aud_who_create, child_4.aud_when_create, child_4.aud_source_create, child_4.desk_id
  • Index Cond: (child_4.id = cob_4.id)
  • Filter: (child_4.call_kind_id = 5)
Planning time : 3,025.156 ms
Execution time : 1,037.972 ms