explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S9BG

Settings
# exclusive inclusive rows x rows loops node
1. 0.060 43,887.660 ↑ 1.0 1 1

Nested Loop Left Join (cost=25.09..1,866.27 rows=1 width=30) (actual time=34,058.566..43,887.660 rows=1 loops=1)

2. 0.088 43,887.574 ↑ 1.0 1 1

Nested Loop (cost=24.55..1,857.70 rows=1 width=40) (actual time=34,058.481..43,887.574 rows=1 loops=1)

3. 0.256 43,887.438 ↑ 1.0 1 1

Nested Loop Left Join (cost=24.02..1,849.13 rows=1 width=51) (actual time=34,058.346..43,887.438 rows=1 loops=1)

  • Join Filter: (((tblvc_17.vpd_key)::text = (chr_val_desc_table_6.vpd_key)::text) AND ((tblvc_17.oid)::text = (chr_val_desc_table_6.oid)::text))
  • Rows Removed by Join Filter: 843
4. 4.097 43,844.893 ↑ 1.0 1 1

Nested Loop (cost=22.85..1,754.94 rows=1 width=82) (actual time=34,018.211..43,844.893 rows=1 loops=1)

  • Join Filter: ((employeepo0_.termination_reason_oid)::text = (tblvc_17.oid)::text)
  • Rows Removed by Join Filter: 85
5. 12.702 12.702 ↓ 86.0 86 1

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_17 (cost=0.79..51.90 rows=1 width=31) (actual time=0.273..12.702 rows=86 loops=1)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_REASON_PL'::character varying))::text, ','::text))))
6. 3.612 43,828.094 ↑ 1.0 1 86

Nested Loop (cost=22.06..1,703.02 rows=1 width=65) (actual time=473.444..509.629 rows=1 loops=86)

7. 4.988 43,813.388 ↑ 1.0 1 86

Nested Loop (cost=21.14..1,609.63 rows=1 width=79) (actual time=473.274..509.458 rows=1 loops=86)

8. 19.178 43,794.210 ↑ 1.0 1 86

Nested Loop Left Join (cost=20.22..1,516.23 rows=1 width=93) (actual time=473.052..509.235 rows=1 loops=86)

  • Join Filter: (((tblvc_14.vpd_key)::text = (chr_val_desc_table_5.vpd_key)::text) AND ((tblvc_14.oid)::text = (chr_val_desc_table_5.oid)::text))
  • Rows Removed by Join Filter: 843
9. 3.956 39,921.974 ↑ 1.0 1 86

Nested Loop (cost=19.05..1,422.04 rows=1 width=123) (actual time=431.253..464.209 rows=1 loops=86)

  • Join Filter: ((employeepo0_.benefits_elig_class_oid)::text = (tblvc_14.oid)::text)
10. 11.696 11.696 ↑ 1.0 1 86

Index Scan using pk_bn_eligibility_class_pl on bn_eligibility_class_pl tblvc_14 (cost=0.65..14.33 rows=1 width=30) (actual time=0.134..0.136 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('BN_ELIGIBILITY_CLASS_PL'::character varying))::text, ','::text))))
11. 3.784 39,906.322 ↑ 1.0 1 86

Nested Loop (cost=18.40..1,407.69 rows=1 width=107) (actual time=431.073..464.027 rows=1 loops=86)

12. 4.730 39,889.294 ↑ 1.0 1 86

Nested Loop (cost=17.48..1,314.30 rows=1 width=118) (actual time=430.878..463.829 rows=1 loops=86)

13. 22.102 39,856.012 ↑ 1.0 1 86

Nested Loop Left Join (cost=16.56..1,220.90 rows=1 width=131) (actual time=430.492..463.442 rows=1 loops=86)

  • Join Filter: (((tblvc_11.vpd_key)::text = (chr_val_desc_table_4.vpd_key)::text) AND ((tblvc_11.oid)::text = (chr_val_desc_table_4.oid)::text))
  • Rows Removed by Join Filter: 843
14. 8.342 36,051.888 ↑ 1.0 1 86

Nested Loop (cost=15.39..1,126.71 rows=1 width=163) (actual time=389.581..419.208 rows=1 loops=86)

  • Join Filter: ((employeepo0_.business_unit_oid)::text = (tblvc_11.oid)::text)
15. 10.664 10.664 ↑ 1.0 1 86

Index Scan using pk_chr_business_unit_pl on chr_business_unit_pl tblvc_11 (cost=0.77..27.59 rows=1 width=32) (actual time=0.123..0.124 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_BUSINESS_UNIT_PL'::character varying))::text, ','::text))))
16. 4.042 36,032.882 ↑ 1.0 1 86

Nested Loop Left Join (cost=14.61..1,099.11 rows=1 width=145) (actual time=389.363..418.987 rows=1 loops=86)

  • Join Filter: (((employeepo0_.currency_code)::text = (tblvc_10.currency_code)::text) AND ((employeepo0_.chr_pay_grade_oid)::text = (tblvc_10.oid)::text))
  • Rows Removed by Join Filter: 2
17. 4.472 24,321.918 ↑ 1.0 1 86

Nested Loop (cost=12.67..977.59 rows=1 width=163) (actual time=256.331..282.813 rows=1 loops=86)

  • Join Filter: ((employeepo0_.chr_job_oid)::text = (tblvc_9.oid)::text)
  • Rows Removed by Join Filter: 44
18. 3.698 23,869.816 ↑ 1.0 1 86

Nested Loop (cost=11.89..938.62 rows=1 width=176) (actual time=251.075..277.556 rows=1 loops=86)

19. 3.784 23,854.852 ↑ 1.0 1 86

Nested Loop (cost=10.97..845.23 rows=1 width=190) (actual time=250.903..277.382 rows=1 loops=86)

20. 4.730 23,839.028 ↑ 1.0 1 86

Nested Loop (cost=10.05..751.83 rows=1 width=203) (actual time=250.721..277.198 rows=1 loops=86)

21. 9.030 23,818.990 ↑ 1.0 1 86

Nested Loop (cost=9.13..658.44 rows=1 width=217) (actual time=250.491..276.965 rows=1 loops=86)

  • Join Filter: ((tblvc_8.oid)::text = (employeepo0_.chr_location_oid)::text)
  • Rows Removed by Join Filter: 1
22. 40.764 7,893.596 ↓ 2.0 2 86

Nested Loop Left Join (cost=1.95..125.83 rows=1 width=11) (actual time=42.286..91.786 rows=2 loops=86)

  • Join Filter: (((tblvc_8.vpd_key)::text = (chr_val_desc_table_2.vpd_key)::text) AND ((tblvc_8.oid)::text = (chr_val_desc_table_2.oid)::text))
  • Rows Removed by Join Filter: 1,686
23. 35.604 35.604 ↓ 2.0 2 86

Index Scan using uq_chr_location_pl on chr_location_pl tblvc_8 (cost=0.78..31.64 rows=1 width=40) (actual time=0.127..0.414 rows=2 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_LOCATION_PL'::character varying))::text, ','::text))))
24. 7,817.228 7,817.228 ↓ 844.0 844 172

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_2 (cost=1.17..94.18 rows=1 width=28) (actual time=0.120..45.449 rows=844 loops=172)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
25. 46.612 15,916.364 ↑ 1.0 1 172

Nested Loop Left Join (cost=7.18..532.59 rows=1 width=230) (actual time=85.807..92.537 rows=1 loops=172)

  • Join Filter: (((tblvc_4.vpd_key)::text = (chr_val_desc_table_1.vpd_key)::text) AND ((tblvc_4.oid)::text = (chr_val_desc_table_1.oid)::text))
  • Rows Removed by Join Filter: 843
26. 7.740 8,109.284 ↑ 1.0 1 172

Nested Loop (cost=6.01..438.40 rows=1 width=262) (actual time=43.716..47.147 rows=1 loops=172)

  • Join Filter: ((employeepo0_.union_code_oid)::text = (tblvc_4.oid)::text)
27. 28.036 28.036 ↑ 1.0 1 172

Index Scan using pk_chr_union_code_pl on chr_union_code_pl tblvc_4 (cost=0.77..27.59 rows=1 width=32) (actual time=0.161..0.163 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_UNION_CODE_PL'::character varying))::text, ','::text))))
28. 39.732 8,073.508 ↑ 1.0 1 172

Nested Loop Left Join (cost=5.24..410.80 rows=1 width=244) (actual time=43.510..46.939 rows=1 loops=172)

  • Join Filter: (((tblvc_3.vpd_key)::text = (chr_val_desc_table.vpd_key)::text) AND ((tblvc_3.oid)::text = (chr_val_desc_table.oid)::text))
  • Rows Removed by Join Filter: 843
29. 14.276 159.272 ↑ 1.0 1 172

Nested Loop (cost=4.06..316.61 rows=1 width=277) (actual time=0.917..0.926 rows=1 loops=172)

  • Join Filter: ((employeepo0_.union_local_code_oid)::text = (tblvc_3.oid)::text)
30. 22.188 22.188 ↑ 1.0 1 172

Index Scan using pk_chr_union_local_pl on chr_union_local_pl tblvc_3 (cost=0.77..27.59 rows=1 width=33) (actual time=0.128..0.129 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_UNION_LOCAL_PL'::character varying))::text, ','::text))))
31. 7.740 122.808 ↑ 1.0 1 172

Nested Loop (cost=3.29..289.01 rows=1 width=259) (actual time=0.707..0.714 rows=1 loops=172)

32. 7.396 92.880 ↑ 1.0 1 172

Nested Loop (cost=2.37..195.62 rows=1 width=273) (actual time=0.535..0.540 rows=1 loops=172)

33. 7.740 53.320 ↑ 1.0 1 172

Nested Loop (cost=1.45..102.22 rows=1 width=278) (actual time=0.307..0.310 rows=1 loops=172)

34. 22.016 22.016 ↑ 1.0 1 172

Index Scan using ix14_chr_emp_position on chr_emp_position employeepo0_ (cost=0.53..8.83 rows=1 width=284) (actual time=0.127..0.128 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = (f_sel_policy_all('CHR_EMP_POSITION'::character varying))::text) AND ((employee_oid)::text = 'CC1_95441'::text))
  • Filter: (('2020-10-13'::date >= eff_date) AND ('2020-10-13'::date <= eff_date_end) AND (("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_EMP_POSITION'::character varying))::text, ','::text))))
35. 23.564 23.564 ↑ 1.0 1 172

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc (cost=0.92..93.38 rows=1 width=8) (actual time=0.136..0.137 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.job_class_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
36. 32.164 32.164 ↑ 1.0 1 172

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_1 (cost=0.92..93.38 rows=1 width=8) (actual time=0.186..0.187 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.job_change_reason_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
37. 22.188 22.188 ↑ 1.0 1 172

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_2 (cost=0.92..93.38 rows=1 width=8) (actual time=0.127..0.129 rows=1 loops=172)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.job_function_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
38. 7,874.504 7,874.504 ↓ 844.0 844 172

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table (cost=1.17..94.18 rows=1 width=28) (actual time=0.066..45.782 rows=844 loops=172)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
39. 7,760.468 7,760.468 ↓ 844.0 844 172

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_1 (cost=1.17..94.18 rows=1 width=28) (actual time=0.062..45.119 rows=844 loops=172)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
40. 15.308 15.308 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_5 (cost=0.92..93.38 rows=1 width=8) (actual time=0.177..0.178 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.assigned_shift_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
41. 12.040 12.040 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_6 (cost=0.92..93.38 rows=1 width=8) (actual time=0.139..0.140 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.flsa_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
42. 11.266 11.266 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_7 (cost=0.92..93.38 rows=1 width=8) (actual time=0.130..0.131 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.naics_workers_comp_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
43. 447.630 447.630 ↓ 22.5 45 86

Index Scan using pk_chr_job_pl on chr_job_pl tblvc_9 (cost=0.78..38.94 rows=2 width=11) (actual time=0.137..5.205 rows=45 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_JOB_PL'::character varying))::text, ','::text))))
44. 72.756 11,706.922 ↓ 3.0 3 86

Nested Loop Left Join (cost=1.94..121.51 rows=1 width=18) (actual time=26.913..136.127 rows=3 loops=86)

  • Join Filter: (((tblvc_10.vpd_key)::text = (chr_val_desc_table_3.vpd_key)::text) AND ((tblvc_10.oid)::text = (chr_val_desc_table_3.oid)::text))
  • Rows Removed by Join Filter: 2,529
45. 1.720 1.720 ↓ 3.0 3 86

Index Only Scan using pk_chr_pay_grade_pl on chr_pay_grade_pl tblvc_10 (cost=0.77..27.32 rows=1 width=36) (actual time=0.012..0.020 rows=3 loops=86)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: (("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[]))
  • Heap Fetches: 258
46. 11,632.446 11,632.446 ↓ 844.0 844 258

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_3 (cost=1.17..94.18 rows=1 width=28) (actual time=0.059..45.087 rows=844 loops=258)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
47. 3,782.022 3,782.022 ↓ 844.0 844 86

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_4 (cost=1.17..94.18 rows=1 width=28) (actual time=0.063..43.977 rows=844 loops=86)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
48. 28.552 28.552 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_12 (cost=0.92..93.38 rows=1 width=8) (actual time=0.331..0.332 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.home_cost_no_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
49. 13.244 13.244 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_13 (cost=0.92..93.38 rows=1 width=8) (actual time=0.152..0.154 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.home_dept_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
50. 3,853.058 3,853.058 ↓ 844.0 844 86

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_5 (cost=1.17..94.18 rows=1 width=28) (actual time=0.060..44.803 rows=844 loops=86)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
51. 14.190 14.190 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_15 (cost=0.92..93.38 rows=1 width=8) (actual time=0.165..0.165 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.rehire_status_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
52. 11.094 11.094 ↑ 1.0 1 86

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_16 (cost=0.92..93.38 rows=1 width=8) (actual time=0.128..0.129 rows=1 loops=86)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY[sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying), 'NG_COMMON'::character varying])::text[])) AND ((oid)::text = (employeepo0_.emp_type_oid)::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((prod_locale_code)::text = ANY (string_to_array((f_sel_policy_prod_locale('CHR_SIMPLE_VAL'::character varying))::text, ','::text))))
53. 42.289 42.289 ↓ 844.0 844 1

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_6 (cost=1.17..94.18 rows=1 width=28) (actual time=0.100..42.289 rows=844 loops=1)

  • Index Cond: ((vpd_key = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND (vpd_key = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::text[])) AND (vpd_key = (sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying))::text))
  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND ((user_locale_code)::text = (CASE COALESCE(sys_context('ctx_app_ng'::character varying, 'ctx_bypass_user_locale'::character varying), '~'::character varying) WHEN 'AUTO'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) WHEN 'N'::text THEN sys_context('ctx_ng_vpd'::character varying, 'ctx_user_locale'::character varying) ELSE user_locale_code END)::text))
  • Rows Removed by Filter: 1,315
  • Heap Fetches: 0
54. 0.048 0.048 ↑ 1.0 1 1

Index Only Scan using ix7_chr_associate on chr_associate employeeli23_ (cost=0.53..8.56 rows=1 width=11) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: ((vpd_key = (f_sel_policy_all('CHR_ASSOCIATE'::character varying))::text) AND (oid = 'CC1_95441'::text))
  • Filter: (("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[]))
  • Heap Fetches: 1
55. 0.026 0.026 ↑ 1.0 1 1

Index Only Scan using ix_payroll_agreement on payroll_agreement payrollagr24_ (cost=0.53..8.56 rows=1 width=10) (actual time=0.025..0.026 rows=1 loops=1)

  • Index Cond: ((vpd_key = (f_sel_policy_all('PAYROLL_AGREEMENT'::character varying))::text) AND (paid = (employeepo0_.paid)::text))
  • Filter: (("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[]))
  • Heap Fetches: 1
Planning time : 33.504 ms
Execution time : 43,888.579 ms