explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zIU0

Settings
# exclusive inclusive rows x rows loops node
1. 1,282,738.300 1,858,990.753 ↑ 143.7 249,808 1

Nested Loop (cost=0.00..125,687,439.37 rows=35,907,956 width=18) (actual time=0.016..1,858,990.753 rows=249,808 loops=1)

  • Output: headr.astr, headr.code_alt, child.astr, child.code_alt
  • Join Filter: ((child.code_alt)::text ~~ ((headr.code_alt)::text || '_%'::text))
  • Rows Removed by Join Filter: 7221693532
2. 162.883 162.883 ↑ 1.0 99,635 1

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

  • 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. 576,071.693 576,089.570 ↓ 1.0 72,484 99,635

Materialize (cost=0.00..5,191.83 rows=72,079 width=9) (actual time=0.000..5.782 rows=72,484 loops=99,635)

  • Output: child.astr, child.code_alt
4. 17.877 17.877 ↓ 1.0 72,484 1

Seq Scan on icd_update_2020.icd10dxsmlggen child (cost=0.00..4,831.44 rows=72,079 width=9) (actual time=0.004..17.877 rows=72,484 loops=1)

  • Output: child.astr, child.code_alt
  • Filter: (child.astr <> '*'::bpchar)
  • Rows Removed by Filter: 27151
Planning time : 0.064 ms
Execution time : 1,859,023.571 ms