explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3yYq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,442.488 ↑ 1.0 1 1

Limit (cost=5.57..157,382.23 rows=1 width=12) (actual time=1,442.488..1,442.488 rows=1 loops=1)

  • Output: ssr.id, ((SubPlan 4)), ((pv.dental_formula_id IS NOT NULL)), (NULL::unknown)
  • Buffers: shared hit=124,979 read=19
  • I/O Timings: read=1.279
2. 0.032 1,442.486 ↑ 12.0 1 1

Nested Loop Left Join (cost=5.57..1,888,525.43 rows=12 width=12) (actual time=1,442.486..1,442.486 rows=1 loops=1)

  • Output: ssr.id, (SubPlan 4), (pv.dental_formula_id IS NOT NULL), NULL::unknown
  • Buffers: shared hit=124,979 read=19
  • I/O Timings: read=1.279
3. 0.000 0.121 ↑ 12.0 1 1

Nested Loop Left Join (cost=5.13..53.05 rows=12 width=12) (actual time=0.121..0.121 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, ms.id
  • Buffers: shared hit=47
4. 0.003 0.116 ↑ 12.0 1 1

Nested Loop Left Join (cost=4.71..47.30 rows=12 width=16) (actual time=0.116..0.116 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, pp.id, ms.id
  • Join Filter: (ssr.id = msr.id)
  • Buffers: shared hit=44
5. 0.004 0.096 ↑ 12.0 1 1

Nested Loop Left Join (cost=3.58..29.94 rows=12 width=12) (actual time=0.096..0.096 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, pp.id
  • Buffers: shared hit=34
6. 0.002 0.079 ↑ 3.0 1 1

Nested Loop Left Join (cost=3.15..28.07 rows=3 width=12) (actual time=0.079..0.079 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, pp.id
  • Buffers: shared hit=29
7. 0.001 0.065 ↑ 2.0 1 1

Nested Loop Left Join (cost=2.72..27.07 rows=2 width=16) (actual time=0.065..0.065 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, ppadr.id, pp.id
  • Buffers: shared hit=24
8. 0.002 0.059 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.29..26.45 rows=1 width=16) (actual time=0.059..0.059 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, ppa.id, pp.id
  • Buffers: shared hit=20
9. 0.002 0.045 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.86..25.97 rows=1 width=16) (actual time=0.045..0.045 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, pi.id, ppa.id
  • Buffers: shared hit=16
10. 0.002 0.027 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.43..25.50 rows=1 width=12) (actual time=0.027..0.027 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, pi.id
  • Buffers: shared hit=12
11. 0.001 0.019 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.00..17.05 rows=1 width=12) (actual time=0.019..0.019 rows=1 loops=1)

  • Output: ssr.id, ssr.service_id, ssr.customer_id
  • Join Filter: (ssr.id = a.srv_rendered_id)
  • Buffers: shared hit=8
12. 0.012 0.012 ↑ 1.0 1 1

Index Scan using sr_srv_rendered_id_res_group_id_idx on public.sr_srv_rendered ssr (cost=0.57..8.59 rows=1 width=12) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: ssr.id, ssr.bdate, ssr.comment, ssr.cost, ssr.duration, ssr.edate, ssr.is_rendered, ssr.quantity, ssr.total_cost, ssr.contract_id, ssr.customer_id, ssr.funding_id, ssr.res_group_id, ssr.service_id, ssr.duration_measure_unit_id, ssr.begin_time, ssr.prototype_id, ssr.org_id, ssr.price_list_id, ssr.cul, ssr.parent_id, ssr.payment_status_id, ssr.root_service_id, ssr.is_wholly_rendered, ssr.planned_date, ssr.planned_time, ssr.tooth_number, ssr.is_refused, ssr.aud_who, ssr.aud_when, ssr.aud_source, ssr.aud_who_create, ssr.aud_when_create, ssr.aud_source_create, ssr.is_amalgam_filling, ssr.is_mobile_medical_teams, ssr._responsible_id, ssr._department_id, ssr._created_by_dep_id, ssr.entity_type, ssr.md_is_urgent, ssr.md_is_use_cryogenic, ssr.md_is_use_endoscopic, ssr.md_is_use_laser, ssr.md_anesthesia_type_id, ssr.md_step_id, ssr.md_complication_type_id, ssr.md_diagnosis_id, ssr.md_case_id, ssr.md_referral_id, ssr.md_result_category_id, ssr.md_patient_prescription_id, ssr.md_health_group_id, ssr.md_vmp_type_id, ssr.md_vmp_method_id, ssr.md_anatomic_zone_id, ssr.md_prescription_id, ssr.entity_sync_num, ssr.entity_type_aware, ssr.cancel_reason, ssr.is_vmp, ssr.close_date, ssr.complex_srv_id, ssr.for_upload, ssr.uid, ssr.is_need_consulting, ssr.main_complex, ssr.expert_verified
  • Index Cond: (ssr.id = 76,296,617)
  • Buffers: shared hit=5
13. 0.006 0.006 ↓ 0.0 0 1

Index Only Scan using md_appointment_srv_rendered_id_idx on public.md_appointment a (cost=0.43..8.45 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Output: a.srv_rendered_id
  • Index Cond: (a.srv_rendered_id = 76,296,617)
  • Heap Fetches: 0
  • Buffers: shared hit=3
14. 0.006 0.006 ↑ 1.0 1 1

Index Scan using pim_individual_pk on public.pim_individual pi (cost=0.43..8.45 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: pi.id, pi.gender_id
  • Index Cond: (ssr.customer_id = pi.id)
  • Buffers: shared hit=4
15. 0.016 0.016 ↑ 1.0 1 1

Index Only Scan using pim_party_pk on public.pim_party ppa (cost=0.43..0.46 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=1)

  • Output: ppa.id
  • Index Cond: (ppa.id = pi.id)
  • Heap Fetches: 0
  • Buffers: shared hit=4
16. 0.012 0.012 ↑ 1.0 1 1

Index Only Scan using pci_patient_pk on public.pci_patient pp (cost=0.43..0.47 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: pp.id
  • Index Cond: (pp.id = pi.id)
  • Heap Fetches: 0
  • Buffers: shared hit=4
17. 0.005 0.005 ↑ 2.0 1 1

Index Scan using pim_party_address_party_id_idx on public.pim_party_address ppadr (cost=0.43..0.60 rows=2 width=8) (actual time=0.005..0.005 rows=1 loops=1)

  • Output: ppadr.id, ppadr.from_date, ppadr.note, ppadr.text_addr, ppadr.to_date, ppadr.is_valid, ppadr.addr_id, ppadr.party_id, ppadr.register_type_id, ppadr.aud_who, ppadr.aud_when, ppadr.aud_source, ppadr.aud_who_create, ppadr.aud_when_create, ppadr.aud_source_create
  • Index Cond: (ppa.id = ppadr.party_id)
  • Buffers: shared hit=4
18. 0.012 0.012 ↑ 2.0 1 1

Index Only Scan using pim_party_addr_to_addr_type_party_address_id_idx on public.pim_party_addr_to_addr_type ppatat (cost=0.43..0.48 rows=2 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Output: ppatat.party_address_id
  • Index Cond: (ppatat.party_address_id = ppadr.id)
  • Heap Fetches: 1
  • Buffers: shared hit=5
19. 0.013 0.013 ↑ 5.0 1 1

Index Only Scan using pci_patient_reg_patient_id_idx on public.pci_patient_reg ppr (cost=0.43..0.57 rows=5 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Output: ppr.patient_id
  • Index Cond: (ppr.patient_id = pp.id)
  • Heap Fetches: 1
  • Buffers: shared hit=5
20. 0.003 0.017 ↑ 1.0 1 1

Materialize (cost=1.13..17.18 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=1)

  • Output: msr.id, ms.id
  • Buffers: shared hit=10
21. 0.001 0.014 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.13..17.18 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=1)

  • Output: msr.id, ms.id
  • Buffers: shared hit=10
22. 0.007 0.007 ↑ 1.0 1 1

Index Scan using md_srv_rendered_pk on public.md_srv_rendered msr (cost=0.57..8.59 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Output: msr.id, msr.is_urgent, msr.is_use_cryogenic, msr.is_use_endoscopic, msr.is_use_laser, msr.anesthesia_type_id, msr.step_id, msr.complication_type_id, msr.diagnosis_id, msr.case_id, msr.referral_id, msr.result_category_id, msr.patient_prescription_id, msr.health_group_id, msr.vmp_type_id, msr.vmp_method_id, msr.anatomic_zone_id, msr.aud_who, msr.aud_when, msr.aud_source, msr.aud_who_create, msr.aud_when_create, msr.aud_source_create, msr.prescription_id, msr.entity_sync_num, msr.complicated_value, msr.by_standard, msr.vmp_profile_id
  • Index Cond: (msr.id = 76,296,617)
  • Buffers: shared hit=5
23. 0.006 0.006 ↑ 1.0 1 1

Index Scan using mc_step_pk on public.mc_step ms (cost=0.56..8.58 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=1)

  • Output: ms.id, ms.admission_date, ms.admission_time, ms.death_date, ms.death_time, ms.outcome_date, ms.outcome_time, ms.death_employee_id, ms.main_diagnosis_id, ms.case_id, ms.outcome_id, ms.outcome_clinic_id, ms.outcome_regimen_id, ms.regimen_id, ms.res_group_id, ms.result_id, ms.reason_id, ms.profile_id, ms.mes_id, ms.mes_quality_criterion_id, ms.is_continue, ms.is_continue_editable, ms.standard_id, ms.csg_id, ms.vmp_type_id, ms.vmp_method_id, ms.deviation_reason_id, ms.aud_who, ms.aud_when, ms.aud_source, ms.aud_who_create, ms.aud_when_create, ms.aud_source_create, ms._clinic_id, ms._patient_id, ms._case_mode_id, ms._is_last, ms._responsible_id, ms._department_id, ms.hsp_bed_days_amount, ms.hsp_bed_profile_id, ms.hsp_complexity_level_id, ms.hsp_days_comp_algo_id, ms.hsp_department_id, ms.hsp_funding_id, ms.hsp_is_admission_day_counts, ms.hsp_is_diag_not_eq, ms.hsp_is_set_diagnosis, ms.hsp_issue_planned_date, ms.hsp_mes_id, ms.hsp_missed_days_amount, ms.hsp_plan_department_id, ms.hsp_previous_id, ms.hsp_refusal_employee_id, ms.plc_goal_id, ms.plc_initiator_id, ms.plc_is_needed, ms.plc_is_sanitized, ms.plc_is_viewed, ms.plc_place_id, ms.plc_type_id, ms.plc_appointment_id, ms.plc_planned_date, ms.is_autopsy, ms.planned_date_closing_case, ms.gestational_age, ms.onko_stage, ms.is_first_step
  • Index Cond: (msr.step_id = ms.id)
  • Buffers: shared hit=5
24. 0.005 0.005 ↓ 0.0 0 1

Index Scan using pci_patient_job_patient_id_idx on public.pci_patient_job ppj (cost=0.42..0.47 rows=1 width=12) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: ppj.id, ppj.from_dt, ppj.job_name, ppj.is_main_job, ppj.to_dt, ppj.organization_id, ppj.organization_type_id, ppj.patient_id, ppj.sphere_id, ppj.employee_id, ppj.profession_working_id, ppj.study_group, ppj.aud_who, ppj.aud_when, ppj.aud_source, ppj.aud_who_create, ppj.aud_when_create, ppj.aud_source_create, ppj.is_empl_fired, ppj.department_id, ppj.pci_rb_econom_act_type_id, ppj.okved_id
  • Index Cond: (pp.id = ppj.patient_id)
  • Buffers: shared hit=3
25. 0.395 0.395 ↑ 1.0 1 1

Index Scan using plc_visit_pk on public.plc_visit pv (cost=0.44..0.51 rows=1 width=8) (actual time=0.395..0.395 rows=1 loops=1)

  • Output: pv.id, pv.duration, pv.goal_id, pv.initiator_id, pv.place_id, pv.type_id, pv.is_viewed, pv.is_needed, pv.is_sanitized, pv.aud_who, pv.aud_when, pv.aud_source, pv.aud_who_create, pv.aud_when_create, pv.aud_source_create, pv.planned_date, pv.appointment_id, pv.dental_formula_id
  • Index Cond: (ms.id = pv.id)
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.387
26.          

SubPlan (for Nested Loop Left Join)

27. 0.029 1,441.938 ↑ 1.0 1 1

Result (cost=157,372.17..157,372.18 rows=1 width=0) (actual time=1,441.938..1,441.938 rows=1 loops=1)

  • Output: CASE WHEN (NOT $3) THEN ssr.service_id ELSE $6 END
  • Buffers: shared hit=124,930 read=17
  • I/O Timings: read=0.892
28.          

CTE services_pairs

29. 0.065 0.065 ↑ 1.0 1 1

Index Scan using sr_service_pk on public.sr_service (cost=0.43..8.59 rows=1 width=130) (actual time=0.021..0.065 rows=1 loops=1)

  • Output: CASE WHEN ("position"((sr_service.name)::text, 'овторн'::text) <> 0) THEN sr_service.code WHEN ((sr_service.code)::text ~ '^(?:[a-zA-Zа-яА-Я]?[0-9]+[.]{1}[0-9]+[.]{1}[0-9]+)$'::text) THEN (concat(split_part((sr_service.code)::text, '.'::text, 1), '.', split_part((sr_service.code)::text, '.'::text, 2), '.', lpad(((((split_part((sr_service.code)::text, '.'::text, 3))::bigint + 1))::character varying)::text, length(split_part((sr_service.code)::text, '.'::text, 3)), '0'::text)))::character varying WHEN (((sr_service.code)::text ~ '^(?:[a-zA-Zа-яА-Я]?[0-9]+)$'::text) AND (length((concat(regexp_replace((sr_service.code)::text, '[^a-zA-Zа-яА-Я]'::text, ''::text, 'g'::text), ((regexp_replace((sr_service.code)::text, '[^0-9]'::text, ''::text, 'g'::text))::bigint + 1)))::text) = length((sr_service.code)::text))) THEN (concat(regexp_replace((sr_service.code)::text, '[^a-zA-Zа-яА-Я]'::text, ''::text, 'g'::text), ((regexp_replace((sr_service.code)::text, '[^0-9]'::text, ''::text, 'g'::text))::bigint + 1)))::character varying WHEN (((sr_service.code)::text ~ '^(?:[a-zA-Zа-яА-Я]?[0-9]+)$'::text) AND (length((concat(regexp_replace((sr_service.code)::text, '[^a-zA-Zа-яА-Я]'::text, ''::text, 'g'::text), ((regexp_replace((sr_service.code)::text, '[^0-9]'::text, ''::text, 'g'::text))::bigint + 1)))::text) <> length((sr_service.code)::text))) THEN (concat(regexp_replace((sr_service.code)::text, '[^a-zA-Zа-яА-Я]'::text, ''::text, 'g'::text), lpad(((((regexp_replace((sr_service.code)::text, '[^0-9]'::text, ''::text, 'g'::text))::bigint + 1))::character varying)::text, (length((sr_service.code)::text) - length(regexp_replace((sr_service.code)::text, '[^a-zA-Zа-яА-Я]'::text, ''::text, 'g'::text))), '0'::text)))::character varying ELSE NULL::character varying END, CASE WHEN ("position"((sr_service.name)::text, 'ервичн'::text) <> 0) THEN regexp_replace((sr_service.name)::text, 'ервичн'::text, 'овторн'::text) ELSE NULL::text END
  • Index Cond: (sr_service.id = ssr.service_id)
  • Buffers: shared hit=4
30.          

Initplan (for Result)

31. 0.138 1,435.011 ↑ 1,371.0 1 1

Hash Join (cost=146,782.09..292,717.08 rows=1,371 width=0) (actual time=1,435.011..1,435.011 rows=1 loops=1)

  • Hash Cond: (sr.srv_type_id = s.id)
  • Buffers: shared hit=108,522 read=17
  • I/O Timings: read=0.892
32. 2.469 9.548 ↑ 342.8 4 1

Nested Loop (cost=1.00..145,917.14 rows=1,371 width=4) (actual time=9.509..9.548 rows=4 loops=1)

  • Output: sr.srv_type_id
  • Buffers: shared hit=16,375 read=17
  • I/O Timings: read=0.892
33. 1.636 1.636 ↑ 3.3 5,443 1

Index Only Scan using sr_res_group_responsible_id_id_ix on public.sr_res_group rg (cost=0.57..930.46 rows=17,969 width=4) (actual time=0.346..1.636 rows=5,443 loops=1)

  • Output: rg.responsible_id, rg.id
  • Index Cond: (rg.responsible_id = 11,951)
  • Heap Fetches: 1
  • Buffers: shared hit=10 read=17
  • I/O Timings: read=0.892
34. 5.443 5.443 ↓ 0.0 0 5,443

Index Scan using sr_res_group_service_group_id_idx on public.sr_res_group_service sr (cost=0.43..7.88 rows=19 width=8) (actual time=0.001..0.001 rows=0 loops=5,443)

  • Output: sr.id, sr.bdatetime, sr.edatetime, sr.power, sr.group_id, sr.srv_type_id, sr.moderation_required, sr.patient_multiple_appointment_per_day, sr.referral_required, sr.default_service, sr.aud_who, sr.aud_when, sr.aud_source, sr.aud_who_create, sr.aud_when_create, sr.aud_source_create
  • Index Cond: (sr.group_id = rg.id)
  • Buffers: shared hit=16,365
35. 0.212 1,425.325 ↑ 141.7 107 1

Hash (cost=146,591.53..146,591.53 rows=15,165 width=4) (actual time=1,425.325..1,425.325 rows=107 loops=1)

  • Output: s.id
  • Buckets: 16,384 Batches: 1 Memory Usage: 132kB
  • Buffers: shared hit=92,147
36. 0.011 1,425.113 ↑ 141.7 107 1

Subquery Scan on s (cost=146,401.97..146,591.53 rows=15,165 width=4) (actual time=1,425.081..1,425.113 rows=107 loops=1)

  • Output: s.id
  • Buffers: shared hit=92,147
37. 0.219 1,425.102 ↑ 141.7 107 1

Sort (cost=146,401.97..146,439.88 rows=15,165 width=4) (actual time=1,425.080..1,425.102 rows=107 loops=1)

  • Output: s_1.id, (NULL::character varying(255)), (NULL::character varying(500))
  • Sort Key: s_1.id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=92,147
38. 1,271.396 1,424.883 ↑ 141.7 107 1

Nested Loop (cost=0.00..145,348.88 rows=15,165 width=4) (actual time=13.808..1,424.883 rows=107 loops=1)

  • Output: s_1.id, NULL::character varying(255), NULL::character varying(500)
  • Join Filter: ((btrim((s_1.code)::text) = btrim((sp.second_service_code)::text)) OR (btrim((s_1.name)::text) = btrim(sp.second_service_name)))
  • Rows Removed by Join Filter: 1,520,162
  • Buffers: shared hit=92,144
39. 0.068 0.068 ↑ 1.0 1 1

CTE Scan on services_pairs sp (cost=0.00..0.02 rows=1 width=64) (actual time=0.023..0.068 rows=1 loops=1)

  • Output: sp.second_service_code, sp.second_service_name
  • Buffers: shared hit=4
40. 153.419 153.419 ↓ 1.0 1,520,269 1

Seq Scan on public.sr_service s_1 (cost=0.00..107,342.53 rows=1,520,253 width=134) (actual time=0.004..153.419 rows=1,520,269 loops=1)

  • Output: s_1.id, s_1.code, s_1.cul, s_1.is_death, s_1.duration, s_1.is_fictitious, s_1.is_independent, s_1.is_multuplicity, s_1.name, s_1.terms, s_1.org_id, s_1.category_id, s_1.duration_unit_id, s_1.prototype_id, s_1.type_id, s_1.from_dt, s_1.to_dt, s_1.is_repeated, s_1.is_inherit_protocol, s_1.is_expendable_materials, s_1.is_actual_cul, s_1.is_paraclinical, s_1.is_complex, s_1.accounting_id, s_1.is_autocopy_diagnoses, s_1.is_stomat, s_1.srg_dif_type_id, s_1.srg_opr_kind_id, s_1.is_need_anatomic_zone, s_1.aud_who, s_1.aud_when, s_1.aud_source, s_1.aud_who_create, s_1.aud_when_create, s_1.aud_source_create, s_1.is_filling, s_1.is_extraction, s_1.short_name, s_1.is_need_close_date, s_1.is_vmp, s_1.is_blocked_for_waitlist
  • Buffers: shared hit=92,140
41. 0.017 6.898 ↑ 1.0 1 1

Limit (cost=1.43..10,475.04 rows=1 width=4) (actual time=6.898..6.898 rows=1 loops=1)

  • Output: s_2.id
  • Buffers: shared hit=16,408
42. 0.064 6.881 ↑ 14.0 1 1

Nested Loop (cost=1.43..146,632.01 rows=14 width=4) (actual time=6.881..6.881 rows=1 loops=1)

  • Output: s_2.id
  • Join Filter: ((btrim((s_2.code)::text) = btrim((sp_1.second_service_code)::text)) OR (btrim((s_2.name)::text) = btrim(sp_1.second_service_name)))
  • Rows Removed by Join Filter: 3
  • Buffers: shared hit=16,408
43. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on services_pairs sp_1 (cost=0.00..0.02 rows=1 width=64) (actual time=0.001..0.001 rows=1 loops=1)

  • Output: sp_1.second_service_code, sp_1.second_service_name
44. 0.031 6.816 ↑ 342.8 4 1

Nested Loop (cost=1.43..146,597.72 rows=1,371 width=134) (actual time=6.800..6.816 rows=4 loops=1)

  • Output: s_2.id, s_2.code, s_2.name
  • Buffers: shared hit=16,408
45. 0.794 6.761 ↑ 342.8 4 1

Nested Loop (cost=1.00..145,917.14 rows=1,371 width=4) (actual time=6.759..6.761 rows=4 loops=1)

  • Output: sr_1.srv_type_id
  • Buffers: shared hit=16,392
46. 0.524 0.524 ↑ 3.3 5,443 1

Index Only Scan using sr_res_group_responsible_id_id_ix on public.sr_res_group rg_1 (cost=0.57..930.46 rows=17,969 width=4) (actual time=0.046..0.524 rows=5,443 loops=1)

  • Output: rg_1.responsible_id, rg_1.id
  • Index Cond: (rg_1.responsible_id = 11,951)
  • Heap Fetches: 1
  • Buffers: shared hit=27
47. 5.443 5.443 ↓ 0.0 0 5,443

Index Scan using sr_res_group_service_group_id_idx on public.sr_res_group_service sr_1 (cost=0.43..7.88 rows=19 width=8) (actual time=0.001..0.001 rows=0 loops=5,443)

  • Output: sr_1.id, sr_1.bdatetime, sr_1.edatetime, sr_1.power, sr_1.group_id, sr_1.srv_type_id, sr_1.moderation_required, sr_1.patient_multiple_appointment_per_day, sr_1.referral_required, sr_1.default_service, sr_1.aud_who, sr_1.aud_when, sr_1.aud_source, sr_1.aud_who_create, sr_1.aud_when_create, sr_1.aud_source_create
  • Index Cond: (sr_1.group_id = rg_1.id)
  • Buffers: shared hit=16,365
48. 0.024 0.024 ↑ 1.0 1 4

Index Scan using sr_service_pk on public.sr_service s_2 (cost=0.43..0.49 rows=1 width=134) (actual time=0.006..0.006 rows=1 loops=4)

  • Output: s_2.id, s_2.code, s_2.cul, s_2.is_death, s_2.duration, s_2.is_fictitious, s_2.is_independent, s_2.is_multuplicity, s_2.name, s_2.terms, s_2.org_id, s_2.category_id, s_2.duration_unit_id, s_2.prototype_id, s_2.type_id, s_2.from_dt, s_2.to_dt, s_2.is_repeated, s_2.is_inherit_protocol, s_2.is_expendable_materials, s_2.is_actual_cul, s_2.is_paraclinical, s_2.is_complex, s_2.accounting_id, s_2.is_autocopy_diagnoses, s_2.is_stomat, s_2.srg_dif_type_id, s_2.srg_opr_kind_id, s_2.is_need_anatomic_zone, s_2.aud_who, s_2.aud_when, s_2.aud_source, s_2.aud_who_create, s_2.aud_when_create, s_2.aud_source_create, s_2.is_filling, s_2.is_extraction, s_2.short_name, s_2.is_need_close_date, s_2.is_vmp, s_2.is_blocked_for_waitlist
  • Index Cond: (s_2.id = sr_1.srv_type_id)
  • Buffers: shared hit=16
Planning time : 13.511 ms
Execution time : 1,443.413 ms