explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RNCa

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..173,734,245.22 rows=49,635,666 width=18) (actual rows= loops=)

  • Output: headr.astr, headr.code_alt, child.astr, child.code_alt
  • Join Filter: ((child.code_alt)::text ~~ ((headr.code_alt)::text || '_%'::text))
2. 0.000 0.000 ↓ 0.0

Seq Scan on icd_update_2020.icd10dxsmlggen headr (cost=0.00..4,582.35 rows=99,635 width=9) (actual rows= loops=)

  • Output: headr.code, headr.code_alt, headr.astr, headr.descr_sh, headr.descr_med, headr.descr_long, headr.eff_date, headr.del_date, headr.header_descr, headr.not_reportable_ind, headr.male_only_ind, headr.female_only_ind, headr.newborn_ind, headr.pediatric_ind, headr.maternity_ind, headr.adult_ind, headr.manifestation_ind, headr.poa_ind, headr.questionable_admission_ind, headr.unacceptable_principal_ind, headr.hiv_related_ind, headr.external_cause_ind, headr.valid_code_this_year_ind, headr.valid_code_last_year_ind, headr.valid_code_previous_to_last_year_ind
3. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..5,080.53 rows=99,635 width=9) (actual rows= loops=)

  • Output: child.astr, child.code_alt
4. 0.000 0.000 ↓ 0.0

Seq Scan on icd_update_2020.icd10dxsmlggen child (cost=0.00..4,582.35 rows=99,635 width=9) (actual rows= loops=)

  • Output: child.astr, child.code_alt