explain.depesz.com

PostgreSQL's explain analyze made readable

Result: au9V : Ee_Payslip_With_Index_Trial_1

Settings
# exclusive inclusive rows x rows loops node
1. 0.309 0.619 ↑ 1.0 1 1

GroupAggregate (cost=27.61..42.77 rows=1 width=2,581) (actual time=0.618..0.619 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.078 0.310 ↑ 1.0 1 1

Sort (cost=27.61..27.61 rows=1 width=395) (actual time=0.309..0.310 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. 0.033 0.232 ↑ 1.0 1 1

Bitmap Heap Scan on ft_ee_net_values_ytd fenvy (cost=8.87..27.60 rows=1 width=395) (actual time=0.231..0.232 rows=1 loops=1)

  • Recheck Cond: ((payslip_id = 787401) OR ((parent_payslip_id IS NOT NULL) AND (parent_payslip_id = 787401)))
  • 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)))
  • Heap Blocks: exact=2
4. 0.000 0.068 ↓ 0.0 0 1

BitmapOr (cost=8.87..8.87 rows=1 width=0) (actual time=0.068..0.068 rows=0 loops=1)

5. 0.036 0.036 ↓ 2.0 2 1

Bitmap Index Scan on ft_enetvaly_p (cost=0.00..4.43 rows=1 width=0) (actual time=0.036..0.036 rows=2 loops=1)

  • Index Cond: (payslip_id = 787401)
6. 0.032 0.032 ↓ 0.0 0 1

Bitmap Index Scan on ft_enetvaly_u1 (cost=0.00..4.43 rows=1 width=0) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: ((parent_payslip_id IS NOT NULL) AND (parent_payslip_id = 787401))
7.          

SubPlan (forBitmap Heap Scan)

8. 0.020 0.020 ↑ 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.020..0.020 rows=1 loops=1)

  • Index Cond: (dept_id = fenvy.ee_dept_id)
  • Filter: (er_id = fenvy.ee_er_id)
9. 0.022 0.111 ↑ 1.0 1 1

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

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

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

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

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

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

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

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