explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9pY

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

Update on discharge d (cost=16,815,241.30..17,643,175.22 rows=1 width=218) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Merge Join (cost=16,815,241.30..17,643,175.22 rows=1 width=218) (actual rows= loops=)

  • Merge Cond: ((t.cd_co_dep = d.adm_co_dep) AND ((t.cd_state_code)::text = (d.d_state_code)::text) AND ((t.cd_provider_id)::text = (d.d_adm_provider_id)::text) AND ((t.cd_client_id)::text = (d.d_adm_client_id)::text) AND ((t.cd_client_trans_typ)::text = (d.d_adm_client_trans_typ)::text) AND (t.cd_date_admission = d.adm_admission_date) AND (t.cd_services = d.adm_services))
3. 0.000 0.000 ↓ 0.0

Sort (cost=7,352,113.44..7,445,808.11 rows=37,477,868 width=41) (actual rows= loops=)

  • Sort Key: t.cd_co_dep, t.cd_state_code, t.cd_provider_id, t.cd_client_id, t.cd_client_trans_typ, t.cd_date_admission, t.cd_services
4. 0.000 0.000 ↓ 0.0

Seq Scan on treatment t (cost=0.00..1,484,598.68 rows=37,477,868 width=41) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=9,453,233.70..9,629,493.11 rows=35,251,882 width=200) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=9,453,233.70..9,541,363.41 rows=35,251,882 width=200) (actual rows= loops=)

  • Sort Key: d.adm_co_dep, d.d_state_code, d.d_adm_provider_id, d.d_adm_client_id, d.d_adm_client_trans_typ, d.adm_admission_date, d.adm_services
7. 0.000 0.000 ↓ 0.0

Seq Scan on discharge d (cost=0.00..1,660,482.82 rows=35,251,882 width=200) (actual rows= loops=)