explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 37yf

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 3,103.894 ↓ 0.0 0 1

Nested Loop (cost=1.86..2,883.83 rows=1 width=12) (actual time=3,103.894..3,103.894 rows=0 loops=1)

  • Output: pi.death_dt, sr.id
  • Buffers: shared hit=539 read=450
  • I/O Timings: read=3,087.371
2. 0.133 3,103.889 ↓ 0.0 0 1

Nested Loop (cost=1.43..2,875.37 rows=1 width=8) (actual time=3,103.889..3,103.889 rows=0 loops=1)

  • Output: sr.id, sr.customer_id
  • Buffers: shared hit=539 read=450
  • I/O Timings: read=3,087.371
3. 1.450 2,720.032 ↓ 1.2 19 1

Nested Loop (cost=1.00..2,831.32 rows=16 width=12) (actual time=126.425..2,720.032 rows=19 loops=1)

  • Output: sr.id, sr.customer_id, msp.protocol_id
  • Buffers: shared hit=514 read=399
  • I/O Timings: read=2,705.559
4. 1,607.638 1,607.638 ↓ 1.0 233 1

Index Scan using sr_srv_rendered_customer_id_idx on public.sr_srv_rendered sr (cost=0.57..914.90 rows=227 width=8) (actual time=36.727..1,607.638 rows=233 loops=1)

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

Index Scan using idx_sr_srv_ehr_protocol on public.md_srv_protocol msp (cost=0.43..8.43 rows=1 width=8) (actual time=4.768..4.768 rows=0 loops=233)

  • Output: msp.id, msp.srv_rendered_id, msp.protocol_id, msp.aud_who, msp.aud_when, msp.aud_source, msp.aud_who_create, msp.aud_when_create, msp.aud_source_create
  • Index Cond: (msp.srv_rendered_id = sr.id)
  • Buffers: shared hit=512 read=207
  • I/O Timings: read=1,103.515
6. 383.724 383.724 ↓ 0.0 0 19

Index Scan using pk_md_ehr_0 on public.md_ehr_protocol mep (cost=0.43..2.74 rows=1 width=4) (actual time=20.196..20.196 rows=0 loops=19)

  • Output: mep.id, mep.doc_type_id, mep.path, mep.is_aql_saved, mep.is_signed, mep.cda_id, mep.template_path, mep.protocol_uid, mep.report_path, mep.aud_who, mep.aud_when, mep.aud_source, mep.aud_who_create, mep.aud_when_create, mep.aud_source_create, mep.signed_user_id, mep.signed_user_full_name, mep.signed_dt, mep.certificate_info
  • Index Cond: (mep.id = msp.protocol_id)
  • Filter: ((mep.template_path)::text ~~* '%kal svidetelstvo o smerti%'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=25 read=51
  • I/O Timings: read=381.812
7. 0.000 0.000 ↓ 0.0 0

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

  • Output: pi.death_dt, pi.id
  • Index Cond: (pi.id = 1,024,246)
  • Filter: (pi.death_dt IS NOT NULL)
Planning time : 19.225 ms
Execution time : 3,104.283 ms