explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ybZp

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

Limit (cost=62,171.30..62,171.30 rows=1 width=40) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=62,171.30..62,171.30 rows=1 width=40) (actual rows= loops=)

  • Sort Key: (count(*)), imm_department.department_cd
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=59,285.68..62,171.29 rows=1 width=40) (actual rows= loops=)

  • Hash Cond: ((imm_department_inc_ath.department_cd)::text = (imm_department.department_cd)::text)
4. 0.000 0.000 ↓ 0.0

HashAggregate (cost=26,806.14..28,021.13 rows=121,499 width=40) (actual rows= loops=)

  • Group Key: imm_department_inc_ath.department_cd
5. 0.000 0.000 ↓ 0.0

Seq Scan on imm_department_inc_ath (cost=0.00..23,557.35 rows=649,757 width=32) (actual rows= loops=)

  • Filter: (((company_cd)::text = 'G-MAS0001'::text) AND ((department_set_cd)::text = 'G-MAS0001'::text))
6. 0.000 0.000 ↓ 0.0

Hash (cost=32,479.52..32,479.52 rows=1 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Gather (cost=26,172.83..32,479.52 rows=1 width=32) (actual rows= loops=)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Parallel Hash Anti Join (cost=25,172.83..31,479.42 rows=1 width=32) (actual rows= loops=)

  • Hash Cond: ((imm_department.department_cd)::text = (npbg_w_ss_jh_zk_work.soshiki_cd)::text)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on imm_department (cost=0.00..6,055.52 rows=50,215 width=32) (actual rows= loops=)

  • Filter: (((company_cd)::text <> (department_cd)::text) AND ((company_cd)::text = 'G-MAS0001'::text) AND ((department_set_cd)::text = 'G-MAS0001'::text) AND ((locale_id)::text = 'ja'::text) AND (start_date = '1900-01-01'::date))
10. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=24,538.07..24,538.07 rows=50,781 width=32) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on npbg_w_ss_jh_zk_work (cost=0.00..24,538.07 rows=50,781 width=32) (actual rows= loops=)

  • Filter: (((soshiki_joho_teishi_ymd)::text >= '20200213'::text) AND ((del_flg)::text = '0'::text) AND (torikomi_dt = '2020-02-12 20:53:27.847'::timestamp without time zone))