explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d2Cm : Ee_Payslip_With_Index

Settings
# exclusive inclusive rows x rows loops node
1. 0.122 52.407 ↑ 1.0 1 1

GroupAggregate (cost=23,545.03..23,560.20 rows=1 width=2,581) (actual time=52.407..52.407 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.024 52.285 ↑ 1.0 1 1

Sort (cost=23,545.03..23,545.04 rows=1 width=395) (actual time=52.285..52.285 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.059 52.261 ↑ 1.0 1 1

Bitmap Heap Scan on ft_ee_net_values_ytd fenvy (cost=23,526.30..23,545.02 rows=1 width=395) (actual time=52.261..52.261 rows=1 loops=1)

  • Recheck Cond: ((payslip_id = 787401) OR ((ee_er_id = 30) AND (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.001 52.113 ↓ 0.0 0 1

BitmapOr (cost=23,526.30..23,526.30 rows=1 width=0) (actual time=52.113..52.113 rows=0 loops=1)

5. 0.218 0.218 ↓ 2.0 2 1

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

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

Bitmap Index Scan on ft_enetvaly_u1 (cost=0.00..23,521.86 rows=1 width=0) (actual time=51.894..51.894 rows=0 loops=1)

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

SubPlan (forBitmap Heap Scan)

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

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

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

  • Hash Cond: (fnc.ni_taxyear_id = fst.taxyear_id)
10. 0.038 0.038 ↓ 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.038 rows=18 loops=1)

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

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

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

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

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