explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tcQ1

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 778.525 ↑ 1.0 1 1

Nested Loop Left Join (cost=23.12..1,720.16 rows=1 width=30) (actual time=720.493..778.525 rows=1 loops=1)

2. 0.126 778.405 ↑ 1.0 1 1

Nested Loop (cost=22.59..1,711.59 rows=1 width=40) (actual time=720.376..778.405 rows=1 loops=1)

3. 0.055 778.243 ↑ 1.0 1 1

Nested Loop (cost=22.06..1,703.02 rows=1 width=51) (actual time=720.214..778.243 rows=1 loops=1)

4. 0.075 777.986 ↑ 1.0 1 1

Nested Loop (cost=21.14..1,609.63 rows=1 width=65) (actual time=719.958..777.986 rows=1 loops=1)

5. 0.304 777.663 ↑ 1.0 1 1

Nested Loop Left Join (cost=20.22..1,516.23 rows=1 width=79) (actual time=719.637..777.663 rows=1 loops=1)

  • 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
6. 0.059 694.498 ↑ 1.0 1 1

Nested Loop (cost=19.05..1,422.04 rows=1 width=109) (actual time=640.282..694.498 rows=1 loops=1)

  • Join Filter: ((employeepo0_.benefits_elig_class_oid)::text = (tblvc_14.oid)::text)
7. 0.313 0.313 ↑ 1.0 1 1

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.311..0.313 rows=1 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('BN_ELIGIBILITY_CLASS_PL'::character varying))::text, ','::text))))
8. 0.055 694.126 ↑ 1.0 1 1

Nested Loop (cost=18.40..1,407.69 rows=1 width=93) (actual time=639.912..694.126 rows=1 loops=1)

9. 0.096 693.867 ↑ 1.0 1 1

Nested Loop (cost=17.48..1,314.30 rows=1 width=104) (actual time=639.655..693.867 rows=1 loops=1)

10. 0.318 693.519 ↑ 1.0 1 1

Nested Loop Left Join (cost=16.56..1,220.90 rows=1 width=117) (actual time=639.310..693.519 rows=1 loops=1)

  • 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
11. 0.057 628.556 ↑ 1.0 1 1

Nested Loop (cost=15.39..1,126.71 rows=1 width=149) (actual time=579.958..628.556 rows=1 loops=1)

  • Join Filter: ((employeepo0_.business_unit_oid)::text = (tblvc_11.oid)::text)
12. 0.193 0.193 ↑ 1.0 1 1

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.191..0.193 rows=1 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_BUSINESS_UNIT_PL'::character varying))::text, ','::text))))
13. 0.065 628.306 ↑ 1.0 1 1

Nested Loop Left Join (cost=14.61..1,099.11 rows=1 width=131) (actual time=579.710..628.306 rows=1 loops=1)

  • 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
14. 0.065 441.436 ↑ 1.0 1 1

Nested Loop (cost=12.67..977.59 rows=1 width=149) (actual time=399.853..441.436 rows=1 loops=1)

  • Join Filter: ((employeepo0_.chr_job_oid)::text = (tblvc_9.oid)::text)
  • Rows Removed by Join Filter: 44
15. 0.055 434.483 ↑ 1.0 1 1

Nested Loop (cost=11.89..938.62 rows=1 width=162) (actual time=392.901..434.483 rows=1 loops=1)

16. 0.056 434.233 ↑ 1.0 1 1

Nested Loop (cost=10.97..845.23 rows=1 width=176) (actual time=392.653..434.233 rows=1 loops=1)

17. 0.066 433.978 ↑ 1.0 1 1

Nested Loop (cost=10.05..751.83 rows=1 width=189) (actual time=392.400..433.978 rows=1 loops=1)

18. 0.134 433.667 ↑ 1.0 1 1

Nested Loop (cost=9.13..658.44 rows=1 width=203) (actual time=392.091..433.667 rows=1 loops=1)

  • Join Filter: ((tblvc_8.oid)::text = (employeepo0_.chr_location_oid)::text)
  • Rows Removed by Join Filter: 1
19. 0.628 143.299 ↓ 2.0 2 1

Nested Loop Left Join (cost=1.95..125.83 rows=1 width=11) (actual time=73.676..143.299 rows=2 loops=1)

  • 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
20. 0.389 0.389 ↓ 2.0 2 1

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.192..0.389 rows=2 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_LOCATION_PL'::character varying))::text, ','::text))))
21. 142.282 142.282 ↓ 844.0 844 2

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.097..71.141 rows=844 loops=2)

  • 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
22. 0.670 290.234 ↑ 1.0 1 2

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

  • 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
23. 0.112 156.750 ↑ 1.0 1 2

Nested Loop (cost=6.01..438.40 rows=1 width=248) (actual time=72.910..78.375 rows=1 loops=2)

  • Join Filter: ((employeepo0_.union_code_oid)::text = (tblvc_4.oid)::text)
24. 0.438 0.438 ↑ 1.0 1 2

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.217..0.219 rows=1 loops=2)

  • 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))))
25. 0.666 156.200 ↑ 1.0 1 2

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

  • 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
26. 0.210 6.508 ↑ 1.0 1 2

Nested Loop (cost=4.06..316.61 rows=1 width=263) (actual time=3.245..3.254 rows=1 loops=2)

  • Join Filter: ((employeepo0_.union_local_code_oid)::text = (tblvc_3.oid)::text)
27. 0.356 0.356 ↑ 1.0 1 2

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.177..0.178 rows=1 loops=2)

  • 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))))
28. 0.128 5.942 ↑ 1.0 1 2

Nested Loop (cost=3.29..289.01 rows=1 width=245) (actual time=2.963..2.971 rows=1 loops=2)

29. 0.120 5.456 ↑ 1.0 1 2

Nested Loop (cost=2.37..195.62 rows=1 width=259) (actual time=2.723..2.728 rows=1 loops=2)

30. 0.120 4.968 ↑ 1.0 1 2

Nested Loop (cost=1.45..102.22 rows=1 width=264) (actual time=2.480..2.484 rows=1 loops=2)

31. 4.436 4.436 ↑ 1.0 1 2

Index Scan using ix14_chr_emp_position on chr_emp_position employeepo0_ (cost=0.53..8.83 rows=1 width=270) (actual time=2.217..2.218 rows=1 loops=2)

  • 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))))
32. 0.412 0.412 ↑ 1.0 1 2

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

  • 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))))
33. 0.368 0.368 ↑ 1.0 1 2

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.183..0.184 rows=1 loops=2)

  • 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))))
34. 0.358 0.358 ↑ 1.0 1 2

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.178..0.179 rows=1 loops=2)

  • 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))))
35. 149.026 149.026 ↓ 844.0 844 2

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.093..74.513 rows=844 loops=2)

  • 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
36. 132.814 132.814 ↓ 844.0 844 2

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.093..66.407 rows=844 loops=2)

  • 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
37. 0.245 0.245 ↑ 1.0 1 1

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.243..0.245 rows=1 loops=1)

  • 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))))
38. 0.199 0.199 ↑ 1.0 1 1

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.198..0.199 rows=1 loops=1)

  • 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))))
39. 0.195 0.195 ↑ 1.0 1 1

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.194..0.195 rows=1 loops=1)

  • 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))))
40. 6.888 6.888 ↓ 22.5 45 1

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.200..6.888 rows=45 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_JOB_PL'::character varying))::text, ','::text))))
41. 0.951 186.805 ↓ 3.0 3 1

Nested Loop Left Join (cost=1.94..121.51 rows=1 width=18) (actual time=39.571..186.805 rows=3 loops=1)

  • 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
42. 0.043 0.043 ↓ 3.0 3 1

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.034..0.043 rows=3 loops=1)

  • 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: 3
43. 185.811 185.811 ↓ 844.0 844 3

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.089..61.937 rows=844 loops=3)

  • 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
44. 64.645 64.645 ↓ 844.0 844 1

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.122..64.645 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
45. 0.252 0.252 ↑ 1.0 1 1

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.251..0.252 rows=1 loops=1)

  • 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))))
46. 0.204 0.204 ↑ 1.0 1 1

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.203..0.204 rows=1 loops=1)

  • 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))))
47. 82.861 82.861 ↓ 844.0 844 1

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.106..82.861 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
48. 0.248 0.248 ↑ 1.0 1 1

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.247..0.248 rows=1 loops=1)

  • 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))))
49. 0.202 0.202 ↑ 1.0 1 1

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.201..0.202 rows=1 loops=1)

  • 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))))
50. 0.036 0.036 ↑ 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.035..0.036 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
51. 0.030 0.030 ↑ 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.029..0.030 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 : 44.043 ms
Execution time : 779.747 ms