explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OkCl

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

WindowAgg (cost=93,991.64..100,640.39 rows=139,984 width=90) (actual time=0.012..0.012 rows=0 loops=1)

  • +-Merge Left Join (cost=93991.64..98540.63 rows=139984 width=62) (actual time=0.012..0.012 rows=0 loops=1) Merge Cond: (((CASE WHEN ((sire_hz.duns_no IS NULL) OR ((sire_hz.duns_no)::text = ''::text)) THEN sire_hz.duns_no_dummy ELSE sire_hz.duns_no END))::text = (m_sup.duns_no)::text) Join Filter: ((m_sup.year)::text = (kikan.ks_y)::text)
  • +-Sort (cost=91168.66..91518.62 rows=139984 width=184) (actual time=0.011..0.011 rows=0 loops=1) Sort Key: (CASE WHEN ((sire_hz.duns_no IS NULL) OR ((sire_hz.duns_no)::text = ''::text)) THEN sire_hz.duns_no_dummy ELSE sire_hz.duns_no END), js_sum.kk_y Sort Method: quicksort Memory: 25kB
  • | +-Hash Left Join (cost=384.15..66761.09 rows=139984 width=184) (actual time=0.009..0.009 rows=0 loops=1) Hash Cond: ((js_sum.sire_cd)::text = (sire_hz.sire_cd)::text)
  • | +-Nested Loop (cost=0.00..65659.37 rows=139984 width=25) (actual time=0.009..0.009 rows=0 loops=1) Join Filter: (((js_sum.kk_ym)::text >= (kikan.start_y_m)::text) AND ((js_sum.kk_ym)::text <= (kikan.end_y_m)::text))
  • | | +-Seq Scan on ghg_m_ks_kk_rate_set kikan (cost=0.00..1.04 rows=1 width=19) (actual time=0.008..0.008 rows=0 loops=1) Filter: (((jisi_flag)::text = '0'::text) AND ((ks_y)::text = '2019'::text)) Rows Removed by Filter: 3
  • | +-Seq Scan on gha_m_dn_sire_hz sire_hz (cost=0.00..259.07 rows=10006 width=31) (never executed) Filter: ((del_flg)::text = '0'::text)
  • +-Sort (cost=2822.98..2847.99 rows=10006 width=37) (never executed) Sort Key: m_sup.duns_no
2. 0.000 0.000 ↓ 0.0 0

| | +-Seq Scan on gha_m_kk_th_js_sum js_sum (cost=0.00..46,760.53 rows=1,259,853 width=27) (never executed)

3. 0.000 0.000 ↓ 0.0 0

| +-Hash (cost=259.07..259.07 rows=10,006 width=31) (never executed)

  • +-Seq Scan on gha_m_supplier m_sup (cost=0.00..2158.15 rows=10006 width=37) (never executed) Filter: (((year)::text = '2019'::text) AND ((del_flg)::text = '0'::text))
Planning time : 0.337 ms
Execution time : 0.046 ms