explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LXRZ : EMP_PERSONAL_DETAILS_2

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

Nested Loop (cost=18.97..1,854,134.41 rows=103,944 width=498) (actual rows= loops=)

  • Join Filter: (fnc.ni_cat_id = fee.ee_ni_cat_id)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=17.43..110,110.90 rows=104,530 width=196) (actual rows= loops=)

  • Join Filter: ((feh.ee_er_id = fee.ee_er_id) AND (feh.ee_id = fee.ee_id))
3. 0.000 0.000 ↓ 0.0

Index Scan using ft_ee_i1 on ft_employees fee (cost=0.42..61,592.13 rows=104,530 width=151) (actual rows= loops=)

  • Filter: ((ee_er_id = 3178) AND ((ee_sys_status)::text = 'A'::text))
4. 0.000 0.000 ↓ 0.0

Materialize (cost=17.01..8,274.77 rows=22 width=53) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=17.01..8,274.66 rows=22 width=53) (actual rows= loops=)

  • Hash Cond: (feh.ee_hol_schm_id = fehs.hol_schm_id)
6. 0.000 0.000 ↓ 0.0

Seq Scan on ft_ee_holiday feh (cost=0.00..7,982.49 rows=104,800 width=28) (actual rows= loops=)

  • Filter: (ee_er_id = 3178)
7. 0.000 0.000 ↓ 0.0

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (er_id = 3178)
9. 0.000 0.000 ↓ 0.0

Materialize (cost=1.53..15.17 rows=10 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.53..15.12 rows=10 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (er_id = 3178)
  • Filter: ((er_cur_taxyear)::text = '20192020'::text)
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.25..6.72 rows=10 width=40) (actual rows= loops=)

  • Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 0.000 0.000 ↓ 0.0

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

  • Filter: ((taxyear)::text = '20192020'::text)
16.          

SubPlan (for Nested Loop)

17. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (dept_id = fee.ee_dept_id)
  • Filter: (er_id = fee.ee_er_id)
18. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (ccenter_id = fee.ee_ccenter_id)
  • Filter: (er_id = fee.ee_er_id)