explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ox9I : test2

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

Nested Loop (cost=8.37..593.27 rows=1 width=14) (actual rows= loops=)

  • Join Filter: ((employeepo0_.termination_reason_oid)::text = (tblvc_3.oid)::text)
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=6.41..447.16 rows=1 width=28) (actual rows= loops=)

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

Nested Loop (cost=5.24..352.96 rows=1 width=59) (actual rows= loops=)

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

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_2 (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=4.45..301.05 rows=1 width=43) (actual rows= loops=)

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

Nested Loop (cost=3.28..206.86 rows=1 width=74) (actual rows= loops=)

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

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_1 (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=2.49..154.94 rows=1 width=57) (actual rows= loops=)

  • Join Filter: (((tblvc.vpd_key)::text = (chr_val_desc_table.vpd_key)::text) AND ((tblvc.oid)::text = (chr_val_desc_table.oid)::text))
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.32..60.75 rows=1 width=88) (actual rows= loops=)

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

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc (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

Index Scan using ix14_chr_emp_position on chr_emp_position employeepo0_ (cost=0.53..8.83 rows=1 width=72) (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))))
12. 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))
13. 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))
14. 0.000 0.000 ↓ 0.0

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 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))
15. 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_3.vpd_key)::text = (chr_val_desc_table_3.vpd_key)::text) AND ((tblvc_3.oid)::text = (chr_val_desc_table_3.oid)::text))
16. 0.000 0.000 ↓ 0.0

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc_3 (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))))
17. 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))