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) AND ((ko_soshiki.oya_soshiki_cd)::text = (oya_soshiki.soshiki_cd)::text))
4. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on npbg_w_ss_jh_zk_work ko_soshiki (cost=0.00..18,385.33 rows=50,672 width=114) (actual rows= loops=)

  • Filter: (('20200207'::text <= (soshiki_joho_teishi_ymd)::text) AND (torikomi_dt = '2020-02-07 17:03:54.577'::timestamp without time zone))
5. 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(cost=0.00..18385.33 rows=50672 width=40)
  • Filter: (('20200207'::text <= (soshiki_joho_teishi_ymd)::text) AND (torikomi_dt = '2020-02-07 17:03:54.577'::timestamp without time zone))