explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ijje : EMP_PERSONAL_DETAILS_3

Settings
# exclusive inclusive rows x rows loops node
1. 373.492 1,038.873 ↓ 1.0 104,057 1

Hash Join (cost=7,102.81..1,754,942.31 rows=103,944 width=491) (actual time=147.008..1,038.873 rows=104,057 loops=1)

  • Hash Cond: (fee.ee_ni_cat_id = fnc.ni_cat_id)
2. 163.107 457.170 ↑ 1.0 104,057 1

Hash Left Join (cost=7,087.56..25,150.10 rows=104,530 width=196) (actual time=146.817..457.170 rows=104,057 loops=1)

  • Hash Cond: ((fee.ee_er_id = feh.ee_er_id) AND (fee.ee_id = feh.ee_id))
3. 147.383 147.383 ↑ 1.0 104,057 1

Seq Scan on ft_employees fee (cost=0.00..17,278.49 rows=104,530 width=151) (actual time=0.009..147.383 rows=104,057 loops=1)

  • Filter: ((ee_er_id = 3178) AND ((ee_sys_status)::text = 'A'::text))
  • Rows Removed by Filter: 173620
4. 57.563 146.680 ↓ 4,730.0 104,061 1

Hash (cost=7,087.23..7,087.23 rows=22 width=53) (actual time=146.680..146.680 rows=104,061 loops=1)

  • Buckets: 32768 (originally 1024) Batches: 4 (originally 1) Memory Usage: 2934kB
5. 21.391 89.117 ↓ 4,730.0 104,061 1

Gather (cost=1,017.01..7,087.23 rows=22 width=53) (actual time=4.144..89.117 rows=104,061 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 40.480 67.726 ↓ 3,854.1 34,687 3

Hash Join (cost=17.01..6,085.03 rows=9 width=53) (actual time=1.529..67.726 rows=34,687 loops=3)

  • Hash Cond: (feh.ee_hol_schm_id = fehs.hol_schm_id)
7. 27.168 27.168 ↑ 1.3 34,687 3

Parallel Seq Scan on ft_ee_holiday feh (cost=0.00..5,953.37 rows=43,667 width=28) (actual time=1.307..27.168 rows=34,687 loops=3)

  • Filter: (ee_er_id = 3178)
  • Rows Removed by Filter: 57872
8. 0.015 0.078 ↑ 1.0 4 3

Hash (cost=16.96..16.96 rows=4 width=37) (actual time=0.078..0.078 rows=4 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.063 0.063 ↑ 1.0 4 3

Index Scan using ft_erhschm_u1 on ft_er_hol_schemes fehs (cost=0.29..16.96 rows=4 width=37) (actual time=0.056..0.063 rows=4 loops=3)

  • Index Cond: (er_id = 3178)
10. 0.003 0.097 ↑ 1.2 8 1

Hash (cost=15.12..15.12 rows=10 width=16) (actual time=0.097..0.097 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.004 0.094 ↑ 1.2 8 1

Nested Loop (cost=1.53..15.12 rows=10 width=16) (actual time=0.087..0.094 rows=8 loops=1)

12. 0.012 0.012 ↑ 1.0 1 1

Index Scan using ft_er_u1 on ft_employers fer (cost=0.28..8.30 rows=1 width=19) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (er_id = 3178)
  • Filter: ((er_cur_taxyear)::text = '20192020'::text)
13. 0.035 0.078 ↑ 1.2 8 1

Hash Join (cost=1.25..6.72 rows=10 width=40) (actual time=0.074..0.078 rows=8 loops=1)

  • Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
14. 0.034 0.034 ↑ 1.0 187 1

Seq Scan on ft_ni_cat fnc (cost=0.00..4.87 rows=187 width=10) (actual time=0.009..0.034 rows=187 loops=1)

15. 0.003 0.009 ↑ 1.0 1 1

Hash (cost=1.24..1.24 rows=1 width=38) (actual time=0.009..0.009 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
16. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.24 rows=1 width=38) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: ((taxyear)::text = '20192020'::text)
  • Rows Removed by Filter: 18
17.          

SubPlan (forHash Join)

18. 104.057 104.057 ↑ 1.0 1 104,057

Index Scan using ft_erdept_p on ft_er_depts ferd (cost=0.29..8.31 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=104,057)

  • Index Cond: (dept_id = fee.ee_dept_id)
  • Filter: (er_id = fee.ee_er_id)
19. 104.057 104.057 ↑ 1.0 1 104,057

Index Scan using ft_erctr_p on ft_er_ccenter fcc (cost=0.29..8.30 rows=1 width=13) (actual time=0.001..0.001 rows=1 loops=104,057)

  • Index Cond: (ccenter_id = fee.ee_ccenter_id)
  • Filter: (er_id = fee.ee_er_id)
Planning time : 1.123 ms
Execution time : 1,049.110 ms