explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WpCE : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=28.49..2,174.50 rows=1 width=30) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=27.96..2,165.93 rows=1 width=41) (actual rows= loops=)

  • Join Filter: (((tblvc_19.vpd_key)::text = (chr_val_desc_table_8.vpd_key)::text) AND ((tblvc_19.oid)::text = (chr_val_desc_table_8.oid)::text))
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=26.78..2,071.74 rows=1 width=72) (actual rows= loops=)

  • Join Filter: ((employeepo0_.rehire_reason_oid)::text = (tblvc_19.oid)::text)
4. 0.000 0.000 ↓ 0.0

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_19 (cost=0.79..51.90 rows=1 width=31) (actual rows= loops=)

  • 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))))
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=26.00..2,019.82 rows=1 width=56) (actual rows= loops=)

  • Join Filter: (((tblvc_18.vpd_key)::text = (chr_val_desc_table_7.vpd_key)::text) AND ((tblvc_18.oid)::text = (chr_val_desc_table_7.oid)::text))
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=24.82..1,925.63 rows=1 width=87) (actual rows= loops=)

  • Join Filter: ((employeepo0_.loa_return_reason_oid)::text = (tblvc_18.oid)::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_18 (cost=0.79..51.90 rows=1 width=31) (actual rows= loops=)

  • 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))))
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24.04..1,873.71 rows=1 width=70) (actual rows= loops=)

  • 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))
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=22.86..1,779.52 rows=1 width=101) (actual rows= loops=)

  • Join Filter: ((employeepo0_.loa_reason_oid)::text = (tblvc_17.oid)::text)
10. 0.000 0.000 ↓ 0.0

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

  • 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))))
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=22.08..1,727.61 rows=1 width=85) (actual rows= loops=)

  • Join Filter: ((employeepo0_.termination_reason_oid)::text = (tblvc_16.oid)::text)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=20.12..1,581.50 rows=1 width=99) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19.20..1,488.10 rows=1 width=113) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=18.27..1,394.71 rows=1 width=127) (actual rows= loops=)

  • Join Filter: (((tblvc_13.vpd_key)::text = (chr_val_desc_table_4.vpd_key)::text) AND ((tblvc_13.oid)::text = (chr_val_desc_table_4.oid)::text))
15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=17.10..1,300.51 rows=1 width=157) (actual rows= loops=)

  • Join Filter: ((employeepo0_.benefits_elig_class_oid)::text = (tblvc_13.oid)::text)
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_bn_eligibility_class_pl on bn_eligibility_class_pl tblvc_13 (cost=0.65..14.33 rows=1 width=30) (actual rows= loops=)

  • 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))))
17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=16.45..1,286.17 rows=1 width=141) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15.53..1,192.77 rows=1 width=152) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14.61..1,099.38 rows=1 width=165) (actual rows= loops=)

  • Join Filter: ((employeepo0_.business_unit_oid)::text = (tblvc_10.oid)::text)
20. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12.67..977.59 rows=1 width=179) (actual rows= loops=)

  • Join Filter: ((employeepo0_.chr_job_oid)::text = (tblvc_9.oid)::text)
21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=11.89..938.62 rows=1 width=192) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.97..845.23 rows=1 width=206) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=10.05..751.83 rows=1 width=219) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.13..658.44 rows=1 width=233) (actual rows= loops=)

  • Join Filter: ((tblvc_8.oid)::text = (employeepo0_.chr_location_oid)::text)
25. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.95..125.83 rows=1 width=41) (actual rows= loops=)

  • 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))
26. 0.000 0.000 ↓ 0.0

Index Scan using uq_chr_location_pl on chr_location_pl tblvc_8 (cost=0.78..31.64 rows=1 width=38) (actual rows= loops=)

  • 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))))
27. 0.000 0.000 ↓ 0.0

Index 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=49) (actual rows= loops=)

  • Index Cond: (((vpd_key)::text = ANY (string_to_array((f_sel_policy_ty_static())::text, ','::text))) AND ((vpd_key)::text = ANY ((ARRAY['NG_COMMON'::character varying, sys_context('ctx_ng_vpd'::character varying, 'ctx_vpd_key'::character varying)])::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 ((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))
28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=7.18..532.59 rows=1 width=216) (actual rows= loops=)

  • 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))
29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.01..438.40 rows=1 width=248) (actual rows= loops=)

  • Join Filter: ((employeepo0_.union_code_oid)::text = (tblvc_4.oid)::text)
30. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))))
31. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.24..410.80 rows=1 width=230) (actual rows= loops=)

  • 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))
32. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.06..316.61 rows=1 width=263) (actual rows= loops=)

  • Join Filter: ((employeepo0_.union_local_code_oid)::text = (tblvc_3.oid)::text)
33. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))))
34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.29..289.01 rows=1 width=245) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.37..195.62 rows=1 width=259) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.45..102.22 rows=1 width=272) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Index Scan using ix14_chr_emp_position on chr_emp_position employeepo0_ (cost=0.53..8.83 rows=1 width=286) (actual rows= loops=)

  • 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))))
38. 0.000 0.000 ↓ 0.0

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

  • 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))))
39. 0.000 0.000 ↓ 0.0

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

  • 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))))
40. 0.000 0.000 ↓ 0.0

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

  • 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))))
41. 0.000 0.000 ↓ 0.0

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

  • 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))
42. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))
43. 0.000 0.000 ↓ 0.0

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

  • 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))))
44. 0.000 0.000 ↓ 0.0

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

  • 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))))
45. 0.000 0.000 ↓ 0.0

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

  • 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))))
46. 0.000 0.000 ↓ 0.0

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

  • 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))))
47. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.94..121.78 rows=1 width=13) (actual rows= loops=)

  • 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))
48. 0.000 0.000 ↓ 0.0

Index Scan using pk_chr_business_unit_pl on chr_business_unit_pl tblvc_10 (cost=0.77..27.59 rows=1 width=32) (actual rows= loops=)

  • 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))))
49. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))
50. 0.000 0.000 ↓ 0.0

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_11 (cost=0.92..93.38 rows=1 width=8) (actual rows= loops=)

  • 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))))
51. 0.000 0.000 ↓ 0.0

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

  • 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))))
52. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))
53. 0.000 0.000 ↓ 0.0

Index Scan using ixt_chr_simple_val on chr_simple_val tblvc_14 (cost=0.92..93.38 rows=1 width=8) (actual rows= loops=)

  • 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))))
54. 0.000 0.000 ↓ 0.0

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

  • 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))))
55. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.96..146.10 rows=1 width=12) (actual rows= loops=)

  • Join Filter: (((tblvc_16.vpd_key)::text = (chr_val_desc_table_5.vpd_key)::text) AND ((tblvc_16.oid)::text = (chr_val_desc_table_5.oid)::text))
56. 0.000 0.000 ↓ 0.0

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_16 (cost=0.79..51.90 rows=1 width=31) (actual rows= loops=)

  • 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))))
57. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))
58. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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))
59. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_7 (cost=1.17..94.18 rows=1 width=28) (actual rows= loops=)

  • 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))
60. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_chr_val_desc_table on chr_val_desc_table chr_val_desc_table_8 (cost=1.17..94.18 rows=1 width=28) (actual rows= loops=)

  • 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))
61. 0.000 0.000 ↓ 0.0

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

  • 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[]))