explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qjgq

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 2,476.615 ↓ 0.0 0 1

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

  • Output: pi.death_dt, sr.id
  • Buffers: shared hit=607 read=382
  • I/O Timings: read=2,453.214
2. 0.214 2,476.609 ↓ 0.0 0 1

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

  • Output: sr.id, sr.customer_id
  • Buffers: shared hit=607 read=382
  • I/O Timings: read=2,453.214
3. 2.158 2,231.371 ↓ 1.2 19 1

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

  • Output: sr.id, sr.customer_id, msp.protocol_id
  • Buffers: shared hit=568 read=345
  • I/O Timings: read=2,210.883
4. 1,408.354 1,408.354 ↓ 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=35.618..1,408.354 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,400.925
5. 820.859 820.859 ↓ 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=3.523..3.523 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=566 read=153
  • I/O Timings: read=809.958
6. 245.024 245.024 ↓ 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=12.896..12.896 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=39 read=37
  • I/O Timings: read=242.331
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 : 20.180 ms
Execution time : 2,477.050 ms