explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iH0R

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

Sort (cost=38,910.89..38,910.90 rows=1 width=106) (actual rows= loops=)

  • Sort Key: ko_soshiki.seq
2. 0.000 0.000 ↓ 0.0

Gather (cost=20,145.41..38,910.88 rows=1 width=106) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Parallel Hash Anti Join (cost=19,145.41..37,910.78 rows=1 width=106) (actual rows= loops=)

  • Hash Cond: ((ko_soshiki.torikomi_dt = oya_soshiki.torikomi_dt) AN
  • -> Parallel Seq Scan on npbg_w_ss_jh_zk_work ko_soshiki (cost=0
  • Filter: (('20200207'::text <= (soshiki_joho_teishi_ymd)::te
4. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=18,385.33..18,385.33 rows=50,672 width=40) (actual rows= loops=)

  • -> Parallel Seq Scan on npbg_w_ss_jh_zk_work oya_soshiki
  • Filter: (('20200207'::text <= (soshiki_joho_teishi_ym