explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zetZ

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

Limit (cost=57,127.28..57,130.70 rows=1,368 width=58) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=57,127.28..57,130.70 rows=1,368 width=58) (actual rows= loops=)

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

Hash Right Join (cost=54,440.80..57,056.02 rows=1,368 width=58) (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=27,395.54..28,491.51 rows=109,597 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..24,343.15 rows=610,477 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=27,028.16..27,028.16 rows=1,368 width=50) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Gather (cost=20,293.22..27,028.16 rows=1,368 width=50) (actual rows= loops=)

  • Workers Planned: 2
8. 0.000 0.000 ↓ 0.0

Parallel Hash Anti Join (cost=19,293.22..25,891.36 rows=570 width=50) (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,340.87 rows=50,585 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=18,656.14..18,656.14 rows=50,966 width=50) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on npbg_w_ss_jh_zk_work (cost=0.00..18,656.14 rows=50,966 width=50) (actual rows= loops=)

  • Filter: (((soshiki_joho_teishi_ymd)::text >= '20200213'::text) AND ((del_flg)::text = '0'::text) AND (torikomi_dt = '2020-02-13 17:21:12.192'::timestamp without time zone))