explain.depesz.com

A tool for finding a real cause for slow queries.

Result: cgZ : EXISTING_P32_V_REPORT

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.019 7,858.776 ↑ 1.0 13 1

Sort (cost=6,336.46..6,336.49 rows=13 width=580) (actual time=7,858.776..7,858.776 rows=13 loops=1)

  • Sort Key: a.month
  • Sort Method: quicksort Memory: 26kB
2. 0.030 7,858.757 ↑ 1.0 13 1

HashAggregate (cost=6,336.09..6,336.22 rows=13 width=580) (actual time=7,858.751..7,858.757 rows=13 loops=1)

3. 0.003 7,858.727 ↑ 1.0 13 1

Append (cost=3,167.93..6,335.47 rows=13 width=580) (actual time=3,939.044..7,858.727 rows=13 loops=1)

4. 0.046 3,939.088 ↑ 1.0 12 1

GroupAggregate (cost=3,167.93..3,168.70 rows=12 width=580) (actual time=3,939.044..3,939.088 rows=12 loops=1)

5. 0.014 3,939.042 ↑ 1.0 12 1

Merge Left Join (cost=3,167.93..3,168.01 rows=12 width=580) (actual time=3,939.033..3,939.042 rows=12 loops=1)

  • Merge Cond: (a.month = b.month)
6. 0.010 0.028 ↑ 1.0 12 1

Sort (cost=1.34..1.37 rows=12 width=4) (actual time=0.027..0.028 rows=12 loops=1)

  • Sort Key: a.month
  • Sort Method: quicksort Memory: 25kB
7. 0.018 0.018 ↑ 1.0 12 1

Seq Scan on ft_sys_tax_weeks a (cost=0.00..1.12 rows=12 width=4) (actual time=0.017..0.018 rows=12 loops=1)

8. 0.011 3,939.000 ↓ 9.0 9 1

Sort (cost=3,166.60..3,166.60 rows=1 width=580) (actual time=3,939.000..3,939.000 rows=9 loops=1)

  • Sort Key: b.month
  • Sort Method: quicksort Memory: 26kB
9. 0.003 3,938.989 ↓ 9.0 9 1

Subquery Scan on b (cost=3,166.57..3,166.59 rows=1 width=580) (actual time=3,938.977..3,938.989 rows=9 loops=1)

10. 313.461 3,938.986 ↓ 9.0 9 1

HashAggregate (cost=3,166.57..3,166.58 rows=1 width=404) (actual time=3,938.976..3,938.986 rows=9 loops=1)

11. 44.961 3,625.525 ↓ 90,018.0 90,018 1

Nested Loop (cost=1,434.94..3,166.51 rows=1 width=404) (actual time=2,291.255..3,625.525 rows=90,018 loops=1)

12. 42.868 3,380.436 ↓ 100,064.0 100,064 1

Hash Join (cost=1,434.94..3,166.18 rows=1 width=412) (actual time=2,291.238..3,380.436 rows=100,064 loops=1)

  • Hash Cond: ((fenvy.process_year)::text = (fer.er_cur_taxyear)::text)
13. 773.807 3,337.542 ↓ 5,614.8 101,066 1

Nested Loop (cost=1,426.66..3,157.83 rows=18 width=417) (actual time=2,289.550..3,337.542 rows=101,066 loops=1)

  • Join Filter: (((fenvy.process_period = fstw.month) AND ((fenvy.ee_pay_freq)::text = 'M'::text)) OR ((fenvy.process_period >= fstw.wk_start) AND (fenvy.process_period <= fstw.wk_end) AND ((fenvy.ee_pay_freq)::text = 'W'::text)) OR ((fenvy.process_period >= fstw.tw_start) AND (fenvy.process_period <= fstw.tw_end) AND ((fenvy.ee_pay_freq)::text = 'N'::text)) OR ((fenvy.process_period >= fstw.fw_start) AND (fenvy.process_period <= fstw.fw_end) AND ((fenvy.ee_pay_freq)::text = 'F'::text)))
14. 0.029 2,289.967 ↓ 5.5 11 1

Hash Join (cost=1,426.66..1,507.01 rows=2 width=393) (actual time=2,289.504..2,289.967 rows=11 loops=1)

  • Hash Cond: (fstw.month = fstw.month)
15. 486.789 2,289.928 ↑ 32.6 11 1

HashAggregate (cost=1,425.47..1,500.86 rows=359 width=357) (actual time=2,289.486..2,289.928 rows=11 loops=1)

16. 55.327 1,803.139 ↓ 253.5 91,020 1

Nested Loop (cost=5.49..1,375.21 rows=359 width=357) (actual time=4.942..1,803.139 rows=91,020 loops=1)

17. 20.767 1,545.676 ↓ 104.1 101,068 1

Nested Loop (cost=5.49..1,066.29 rows=971 width=361) (actual time=4.931..1,545.676 rows=101,068 loops=1)

18. 0.020 0.020 ↑ 1.0 1 1

Index Scan using ft_eropt_p on ft_er_options feo (cost=0.00..8.27 rows=1 width=6) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (er_id = 100)
19. 1,149.295 1,524.889 ↓ 104.1 101,068 1

Nested Loop (cost=5.49..1,048.31 rows=971 width=359) (actual time=4.909..1,524.889 rows=101,068 loops=1)

  • Join Filter: (((fenvy.ee_ssp <= 0::numeric) AND (((fenvy.process_period = fstw.month) AND ((fenvy.ee_pay_freq)::text = 'M'::text)) OR ((fenvy.process_period >= fstw.wk_start) AND (fenvy.process_period <= fstw.wk_end) AND ((fenvy.ee_pay_freq)::text = 'W'::text)) OR ((fenvy.process_period >= fstw.tw_start) AND (fenvy.process_period <= fstw.tw_end) AND ((fenvy.ee_pay_freq)::text = 'N'::text)) OR ((fenvy.process_period >= fstw.fw_start) AND (fenvy.process_period <= fstw.fw_end) AND ((fenvy.ee_pay_freq)::text = 'F'::text)))) OR ((fenvy.ee_ssp > 0::numeric) AND (fenvy.process_date >= fstd.month_start_date) AND (fenvy.process_date <= fstd.month_end_date)))
20. 0.192 2.922 ↓ 144.0 144 1

Nested Loop (cost=5.49..39.78 rows=1 width=364) (actual time=0.153..2.922 rows=144 loops=1)

21. 0.490 2.586 ↓ 144.0 144 1

Nested Loop (cost=5.49..39.50 rows=1 width=336) (actual time=0.135..2.586 rows=144 loops=1)

  • Join Filter: (fst.taxyear_id = spb.spp_bir_taxyear_id)
22. 0.379 1.952 ↓ 144.0 144 1

Nested Loop (cost=5.49..38.25 rows=1 width=276) (actual time=0.127..1.952 rows=144 loops=1)

  • Join Filter: (fst.taxyear_id = spa.spp_adp_taxyear_id)
23. 0.211 1.285 ↓ 144.0 144 1

Nested Loop (cost=5.49..37.00 rows=1 width=216) (actual time=0.120..1.285 rows=144 loops=1)

  • Join Filter: (fstd.month = fstw.month)
24. 0.191 0.930 ↓ 10.3 144 1

Nested Loop (cost=5.49..35.61 rows=14 width=192) (actual time=0.109..0.930 rows=144 loops=1)

  • Join Filter: (ssp.ssp_taxyear_id = fst.taxyear_id)
25. 0.240 0.595 ↓ 10.3 144 1

Nested Loop (cost=5.49..32.16 rows=14 width=154) (actual time=0.100..0.595 rows=144 loops=1)

  • Join Filter: (ssp.ssp_taxyear_id = sap.sap_taxyear_id)
26. 0.075 0.211 ↓ 10.3 144 1

Hash Join (cost=5.49..28.72 rows=14 width=94) (actual time=0.087..0.211 rows=144 loops=1)

  • Hash Cond: (aspb.aspp_bir_taxyear_id = ssp.ssp_taxyear_id)
27. 0.064 0.124 ↑ 1.8 144 1

Hash Join (cost=4.24..26.38 rows=252 width=76) (actual time=0.068..0.124 rows=144 loops=1)

  • Hash Cond: (aspb.aspp_bir_taxyear_id = fstd.taxyear_id)
28. 0.007 0.007 ↑ 29.2 12 1

Seq Scan on ft_sys_aspp_bir aspb (cost=0.00..13.50 rows=350 width=60) (actual time=0.006..0.007 rows=12 loops=1)

29. 0.032 0.053 ↑ 1.0 144 1

Hash (cost=2.44..2.44 rows=144 width=16) (actual time=0.053..0.053 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
30. 0.021 0.021 ↑ 1.0 144 1

Seq Scan on ft_sys_taxyear_details fstd (cost=0.00..2.44 rows=144 width=16) (actual time=0.008..0.021 rows=144 loops=1)

31. 0.004 0.012 ↓ 1.1 12 1

Hash (cost=1.11..1.11 rows=11 width=18) (actual time=0.012..0.012 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
32. 0.008 0.008 ↓ 1.1 12 1

Seq Scan on ft_sys_ssp ssp (cost=0.00..1.11 rows=11 width=18) (actual time=0.007..0.008 rows=12 loops=1)

33. 0.135 0.144 ↓ 1.1 12 144

Materialize (cost=0.00..1.17 rows=11 width=60) (actual time=0.000..0.001 rows=12 loops=144)

34. 0.009 0.009 ↓ 1.1 12 1

Seq Scan on ft_sys_sap sap (cost=0.00..1.11 rows=11 width=60) (actual time=0.008..0.009 rows=12 loops=1)

35. 0.137 0.144 ↓ 1.1 12 144

Materialize (cost=0.00..1.17 rows=11 width=38) (actual time=0.000..0.001 rows=12 loops=144)

36. 0.007 0.007 ↓ 1.1 12 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.11 rows=11 width=38) (actual time=0.006..0.007 rows=12 loops=1)

37. 0.142 0.144 ↓ 12.0 12 144

Materialize (cost=0.00..1.18 rows=1 width=28) (actual time=0.000..0.001 rows=12 loops=144)

38. 0.002 0.002 ↓ 12.0 12 1

Seq Scan on ft_sys_tax_weeks fstw (cost=0.00..1.18 rows=1 width=28) (actual time=0.002..0.002 rows=12 loops=1)

  • Filter: ((month >= 1) AND (month <= 12))
39. 0.288 0.288 ↓ 1.1 12 144

Seq Scan on ft_sys_spp_adp spa (cost=0.00..1.11 rows=11 width=60) (actual time=0.001..0.002 rows=12 loops=144)

40. 0.144 0.144 ↓ 1.1 12 144

Seq Scan on ft_sys_spp_bir spb (cost=0.00..1.11 rows=11 width=60) (actual time=0.001..0.001 rows=12 loops=144)

41. 0.144 0.144 ↑ 1.0 1 144

Index Scan using ft_ssmp_u1 on ft_sys_smp smp (cost=0.00..0.27 rows=1 width=60) (actual time=0.001..0.001 rows=1 loops=144)

  • Index Cond: (smp_taxyear_id = fst.taxyear_id)
42. 372.672 372.672 ↑ 1.3 8,422 144

Index Scan using ft_enetvaly_u2 on ft_ee_net_values_ytd fenvy (cost=0.00..447.03 rows=11,230 width=71) (actual time=0.007..2.588 rows=8,422 loops=144)

  • Index Cond: ((ee_er_id = 100) AND ((process_year)::text = (fst.taxyear)::text))
43. 202.136 202.136 ↑ 1.0 1 101,068

Index Scan using ft_ee_p on ft_employees fee (cost=0.00..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=101,068)

  • Index Cond: (ee_id = fenvy.ee_id)
  • Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 100))
44. 0.002 0.010 ↓ 12.0 12 1

Hash (cost=1.18..1.18 rows=1 width=28) (actual time=0.010..0.010 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
45. 0.008 0.008 ↓ 12.0 12 1

Seq Scan on ft_sys_tax_weeks fstw (cost=0.00..1.18 rows=1 width=28) (actual time=0.004..0.008 rows=12 loops=1)

  • Filter: ((month >= 1) AND (month <= 12))
46. 273.768 273.768 ↓ 7.3 82,054 11

Index Scan using ft_enetvaly_u2 on ft_ee_net_values_ytd fenvy (cost=0.00..376.21 rows=11,230 width=58) (actual time=0.033..24.888 rows=82,054 loops=11)

  • Index Cond: ((ee_er_id = 100) AND ((process_year)::text = (fenvy.process_year)::text))
47. 0.006 0.026 ↑ 1.0 1 1

Hash (cost=8.27..8.27 rows=1 width=13) (actual time=0.026..0.026 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
48. 0.020 0.020 ↑ 1.0 1 1

Index Scan using ft_er_u1 on ft_employers fer (cost=0.00..8.27 rows=1 width=13) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (er_id = 100)
49. 200.128 200.128 ↑ 1.0 1 100,064

Index Scan using ft_ee_p on ft_employees fee (cost=0.00..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=100,064)

  • Index Cond: (ee_id = fenvy.ee_id)
  • Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 100))
50. 0.050 3,919.636 ↑ 1.0 1 1

Aggregate (cost=3,166.63..3,166.64 rows=1 width=576) (actual time=3,919.636..3,919.636 rows=1 loops=1)

51. 313.059 3,919.586 ↓ 9.0 9 1

HashAggregate (cost=3,166.57..3,166.58 rows=1 width=404) (actual time=3,919.577..3,919.586 rows=9 loops=1)

52. 46.499 3,606.527 ↓ 90,018.0 90,018 1

Nested Loop (cost=1,434.94..3,166.51 rows=1 width=404) (actual time=2,274.668..3,606.527 rows=90,018 loops=1)

53. 40.792 3,359.900 ↓ 100,064.0 100,064 1

Hash Join (cost=1,434.94..3,166.18 rows=1 width=412) (actual time=2,274.652..3,359.900 rows=100,064 loops=1)

  • Hash Cond: ((fenvy.process_year)::text = (fer.er_cur_taxyear)::text)
54. 772.446 3,319.091 ↓ 5,614.8 101,066 1

Nested Loop (cost=1,426.66..3,157.83 rows=18 width=417) (actual time=2,272.961..3,319.091 rows=101,066 loops=1)

  • Join Filter: (((fenvy.process_period = fstw.month) AND ((fenvy.ee_pay_freq)::text = 'M'::text)) OR ((fenvy.process_period >= fstw.wk_start) AND (fenvy.process_period <= fstw.wk_end) AND ((fenvy.ee_pay_freq)::text = 'W'::text)) OR ((fenvy.process_period >= fstw.tw_start) AND (fenvy.process_period <= fstw.tw_end) AND ((fenvy.ee_pay_freq)::text = 'N'::text)) OR ((fenvy.process_period >= fstw.fw_start) AND (fenvy.process_period <= fstw.fw_end) AND ((fenvy.ee_pay_freq)::text = 'F'::text)))
55. 0.034 2,273.383 ↓ 5.5 11 1

Hash Join (cost=1,426.66..1,507.01 rows=2 width=393) (actual time=2,272.915..2,273.383 rows=11 loops=1)

  • Hash Cond: (fstw.month = fstw.month)
56. 481.325 2,273.334 ↑ 32.6 11 1

HashAggregate (cost=1,425.47..1,500.86 rows=359 width=357) (actual time=2,272.890..2,273.334 rows=11 loops=1)

57. 50.665 1,792.009 ↓ 253.5 91,020 1

Nested Loop (cost=5.49..1,375.21 rows=359 width=357) (actual time=4.804..1,792.009 rows=91,020 loops=1)

58. 20.486 1,539.208 ↓ 104.1 101,068 1

Nested Loop (cost=5.49..1,066.29 rows=971 width=361) (actual time=4.797..1,539.208 rows=101,068 loops=1)

59. 0.009 0.009 ↑ 1.0 1 1

Index Scan using ft_eropt_p on ft_er_options feo (cost=0.00..8.27 rows=1 width=6) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (er_id = 100)
60. 1,147.597 1,518.713 ↓ 104.1 101,068 1

Nested Loop (cost=5.49..1,048.31 rows=971 width=359) (actual time=4.783..1,518.713 rows=101,068 loops=1)

  • Join Filter: (((fenvy.ee_ssp <= 0::numeric) AND (((fenvy.process_period = fstw.month) AND ((fenvy.ee_pay_freq)::text = 'M'::text)) OR ((fenvy.process_period >= fstw.wk_start) AND (fenvy.process_period <= fstw.wk_end) AND ((fenvy.ee_pay_freq)::text = 'W'::text)) OR ((fenvy.process_period >= fstw.tw_start) AND (fenvy.process_period <= fstw.tw_end) AND ((fenvy.ee_pay_freq)::text = 'N'::text)) OR ((fenvy.process_period >= fstw.fw_start) AND (fenvy.process_period <= fstw.fw_end) AND ((fenvy.ee_pay_freq)::text = 'F'::text)))) OR ((fenvy.ee_ssp > 0::numeric) AND (fenvy.process_date >= fstd.month_start_date) AND (fenvy.process_date <= fstd.month_end_date)))
61. 0.187 2.908 ↓ 144.0 144 1

Nested Loop (cost=5.49..39.78 rows=1 width=364) (actual time=0.146..2.908 rows=144 loops=1)

62. 0.492 2.577 ↓ 144.0 144 1

Nested Loop (cost=5.49..39.50 rows=1 width=336) (actual time=0.134..2.577 rows=144 loops=1)

  • Join Filter: (fst.taxyear_id = spb.spp_bir_taxyear_id)
63. 0.513 1.941 ↓ 144.0 144 1

Nested Loop (cost=5.49..38.25 rows=1 width=276) (actual time=0.129..1.941 rows=144 loops=1)

  • Join Filter: (fst.taxyear_id = spa.spp_adp_taxyear_id)
64. 0.203 1.284 ↓ 144.0 144 1

Nested Loop (cost=5.49..37.00 rows=1 width=216) (actual time=0.122..1.284 rows=144 loops=1)

  • Join Filter: (fstd.month = fstw.month)
65. 0.200 0.937 ↓ 10.3 144 1

Nested Loop (cost=5.49..35.61 rows=14 width=192) (actual time=0.111..0.937 rows=144 loops=1)

  • Join Filter: (ssp.ssp_taxyear_id = fst.taxyear_id)
66. 0.243 0.593 ↓ 10.3 144 1

Nested Loop (cost=5.49..32.16 rows=14 width=154) (actual time=0.102..0.593 rows=144 loops=1)

  • Join Filter: (ssp.ssp_taxyear_id = sap.sap_taxyear_id)
67. 0.082 0.206 ↓ 10.3 144 1

Hash Join (cost=5.49..28.72 rows=14 width=94) (actual time=0.092..0.206 rows=144 loops=1)

  • Hash Cond: (aspb.aspp_bir_taxyear_id = ssp.ssp_taxyear_id)
68. 0.061 0.113 ↑ 1.8 144 1

Hash Join (cost=4.24..26.38 rows=252 width=76) (actual time=0.070..0.113 rows=144 loops=1)

  • Hash Cond: (aspb.aspp_bir_taxyear_id = fstd.taxyear_id)
69. 0.004 0.004 ↑ 29.2 12 1

Seq Scan on ft_sys_aspp_bir aspb (cost=0.00..13.50 rows=350 width=60) (actual time=0.004..0.004 rows=12 loops=1)

70. 0.024 0.048 ↑ 1.0 144 1

Hash (cost=2.44..2.44 rows=144 width=16) (actual time=0.048..0.048 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
71. 0.024 0.024 ↑ 1.0 144 1

Seq Scan on ft_sys_taxyear_details fstd (cost=0.00..2.44 rows=144 width=16) (actual time=0.007..0.024 rows=144 loops=1)

72. 0.003 0.011 ↓ 1.1 12 1

Hash (cost=1.11..1.11 rows=11 width=18) (actual time=0.011..0.011 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
73. 0.008 0.008 ↓ 1.1 12 1

Seq Scan on ft_sys_ssp ssp (cost=0.00..1.11 rows=11 width=18) (actual time=0.006..0.008 rows=12 loops=1)

74. 0.137 0.144 ↓ 1.1 12 144

Materialize (cost=0.00..1.17 rows=11 width=60) (actual time=0.000..0.001 rows=12 loops=144)

75. 0.007 0.007 ↓ 1.1 12 1

Seq Scan on ft_sys_sap sap (cost=0.00..1.11 rows=11 width=60) (actual time=0.006..0.007 rows=12 loops=1)

76. 0.137 0.144 ↓ 1.1 12 144

Materialize (cost=0.00..1.17 rows=11 width=38) (actual time=0.000..0.001 rows=12 loops=144)

77. 0.007 0.007 ↓ 1.1 12 1

Seq Scan on ft_sys_taxyear fst (cost=0.00..1.11 rows=11 width=38) (actual time=0.005..0.007 rows=12 loops=1)

78. 0.139 0.144 ↓ 12.0 12 144

Materialize (cost=0.00..1.18 rows=1 width=28) (actual time=0.000..0.001 rows=12 loops=144)

79. 0.005 0.005 ↓ 12.0 12 1

Seq Scan on ft_sys_tax_weeks fstw (cost=0.00..1.18 rows=1 width=28) (actual time=0.003..0.005 rows=12 loops=1)

  • Filter: ((month >= 1) AND (month <= 12))
80. 0.144 0.144 ↓ 1.1 12 144

Seq Scan on ft_sys_spp_adp spa (cost=0.00..1.11 rows=11 width=60) (actual time=0.001..0.001 rows=12 loops=144)

81. 0.144 0.144 ↓ 1.1 12 144

Seq Scan on ft_sys_spp_bir spb (cost=0.00..1.11 rows=11 width=60) (actual time=0.000..0.001 rows=12 loops=144)

82. 0.144 0.144 ↑ 1.0 1 144

Index Scan using ft_ssmp_u1 on ft_sys_smp smp (cost=0.00..0.27 rows=1 width=60) (actual time=0.001..0.001 rows=1 loops=144)

  • Index Cond: (smp_taxyear_id = fst.taxyear_id)
83. 368.208 368.208 ↑ 1.3 8,422 144

Index Scan using ft_enetvaly_u2 on ft_ee_net_values_ytd fenvy (cost=0.00..447.03 rows=11,230 width=71) (actual time=0.007..2.557 rows=8,422 loops=144)

  • Index Cond: ((ee_er_id = 100) AND ((process_year)::text = (fst.taxyear)::text))
84. 202.136 202.136 ↑ 1.0 1 101,068

Index Scan using ft_ee_p on ft_employees fee (cost=0.00..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=101,068)

  • Index Cond: (ee_id = fenvy.ee_id)
  • Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 100))
85. 0.003 0.015 ↓ 12.0 12 1

Hash (cost=1.18..1.18 rows=1 width=28) (actual time=0.015..0.015 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
86. 0.012 0.012 ↓ 12.0 12 1

Seq Scan on ft_sys_tax_weeks fstw (cost=0.00..1.18 rows=1 width=28) (actual time=0.008..0.012 rows=12 loops=1)

  • Filter: ((month >= 1) AND (month <= 12))
87. 273.262 273.262 ↓ 7.3 82,054 11

Index Scan using ft_enetvaly_u2 on ft_ee_net_values_ytd fenvy (cost=0.00..376.21 rows=11,230 width=58) (actual time=0.034..24.842 rows=82,054 loops=11)

  • Index Cond: ((ee_er_id = 100) AND ((process_year)::text = (fenvy.process_year)::text))
88. 0.002 0.017 ↑ 1.0 1 1

Hash (cost=8.27..8.27 rows=1 width=13) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
89. 0.015 0.015 ↑ 1.0 1 1

Index Scan using ft_er_u1 on ft_employers fer (cost=0.00..8.27 rows=1 width=13) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: (er_id = 100)
90. 200.128 200.128 ↑ 1.0 1 100,064

Index Scan using ft_ee_p on ft_employees fee (cost=0.00..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=100,064)

  • Index Cond: (ee_id = fenvy.ee_id)
  • Filter: (((ee_sys_status)::text <> 'D'::text) AND (ee_er_id = 100))