explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iHkJ : Ee_Payslip

Settings
# exclusive inclusive rows x rows loops node
1. 0.143 391.275 ↑ 1.0 1 1

GroupAggregate (cost=100,392.43..100,407.59 rows=1 width=2,581) (actual time=391.275..391.275 rows=1 loops=1)

  • Group Key: fenvy.ee_id, fenvy.ee_er_id, fenvy.ee_tcode, fenvy.ee_w1m1, fenvy.ee_scot_ind, fenvy.ee_ni_cat_id, ((SubPlan 2)), fenvy.ee_pay_freq, fenvy.ee_pay_method, fenvy.ee_designation, fenvy.ee_payslip_msg,
2. 0.065 391.132 ↑ 1.0 1 1

Sort (cost=100,392.43..100,392.43 rows=1 width=395) (actual time=391.132..391.132 rows=1 loops=1)

  • Sort Key: fenvy.ee_id, fenvy.ee_er_id, fenvy.ee_tcode, fenvy.ee_w1m1, fenvy.ee_scot_ind, fenvy.ee_ni_cat_id, ((SubPlan 2)), fenvy.ee_pay_freq, fenvy.ee_pay_method, fenvy.ee_designation, fenvy.ee_payslip
  • Sort Method: quicksort Memory: 25kB
3. 390.942 391.067 ↑ 1.0 1 1

Seq Scan on ft_ee_net_values_ytd fenvy (cost=0.00..100,392.42 rows=1 width=395) (actual time=391.043..391.067 rows=1 loops=1)

  • Filter: (((payslip_id = 787401) AND (parent_payslip_id IS NULL)) OR ((parent_payslip_id IS NOT NULL) AND (parent_payslip_id = 787401) AND (ee_er_id = 30)))
  • Rows Removed by Filter: 740910
4.          

SubPlan (forSeq Scan)

5. 0.019 0.019 ↑ 1.0 1 1

Index Scan using ft_erdept_p on ft_er_depts ferd (cost=0.28..8.30 rows=1 width=14) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (dept_id = fenvy.ee_dept_id)
  • Filter: (er_id = fenvy.ee_er_id)
6. 0.053 0.106 ↑ 1.0 1 1

Hash Join (cost=1.22..6.41 rows=1 width=2) (actual time=0.104..0.106 rows=1 loops=1)

  • Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
7. 0.037 0.037 ↓ 1.6 18 1

Seq Scan on ft_ni_cat fnc (cost=0.00..5.14 rows=11 width=6) (actual time=0.014..0.037 rows=18 loops=1)

  • Filter: (ni_cat_id = fenvy.ee_ni_cat_id)
  • Rows Removed by Filter: 161
8. 0.005 0.016 ↑ 1.0 1 1

Hash (cost=1.21..1.21 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=1)

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

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.21 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: ((taxyear)::text = (fenvy.process_year)::text)
  • Rows Removed by Filter: 17