explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0hxT0 : Optimization for: plan #Jx5W

Settings

Optimization path:

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

Nested Loop (cost=384.94..820.26 rows=1 width=116) (actual rows= loops=)

  • Join Filter: (c.drug_tier_type_id = t.drug_tier_type_id)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=384.94..793.76 rows=1 width=78) (actual rows= loops=)

  • Hash Cond: (c.frmulry_drg_tr_raw_id = b.frmulry_drg_tr_raw_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=83.50..490.32 rows=2 width=62) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=28.50..357.01 rows=2 width=25) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on t_hlth_plan_raw r (cost=0.00..257.00 rows=3 width=20) (actual rows= loops=)

  • Filter: ((plan_id)::text = '90296MD0610013'::text)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_t_carr_formul_raw on t_carr_formul_raw d (cost=28.50..32.84 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (carr_formul_raw_id = r.carr_formul_raw_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using ix_t_frmulry_drg_tr_raw_carr_frmlry_id on t_frmulry_drg_tr_raw c (cost=55.00..66.15 rows=1 width=47) (actual rows= loops=)

  • Index Cond: (carr_frmlry_id = d.carr_formul_raw_id)
  • Filter: (shop_year = '2020'::numeric)
8. 0.000 0.000 ↓ 0.0

Hash (cost=289.44..289.44 rows=12 width=21) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=141.00..289.44 rows=12 width=21) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using t_drug_stg_rxcui_drug_stg_id on t_drug_stg a (cost=57.50..74.51 rows=2 width=21) (actual rows= loops=)

  • Index Cond: (rxcui = '1046771'::numeric)
11. 0.000 0.000 ↓ 0.0

Index Scan using t_frmulry_drg_tr_raw_drug_asoc_drug_stg_id on t_frmulry_drg_tr_raw_drug_asoc b (cost=83.50..104.46 rows=6 width=10) (actual rows= loops=)

  • Index Cond: (drug_stg_id = a.drug_stg_id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on t_drug_tier_type t (cost=0.00..9.50 rows=17 width=48) (actual rows= loops=)