explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AUOd

Settings
# exclusive inclusive rows x rows loops node
1. 17.224 3,321.502 ↓ 86.0 86 1

Nested Loop Left Join (cost=1.96..146.10 rows=1 width=146) (actual time=24.587..3,321.502 rows=86 loops=1)

  • Join Filter: (((tblvc.vpd_key)::text = (chr_val_desc_table.vpd_key)::text) AND ((tblvc.oid)::text = (chr_val_desc_table.oid)::text))
  • Rows Removed by Join Filter: 72,498
2. 11.338 11.338 ↓ 86.0 86 1

Index Scan using pk_chr_reason_pl on chr_reason_pl tblvc (cost=0.79..51.90 rows=1 width=119) (actual time=0.278..11.338 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))))
3. 3,292.940 3,292.940 ↓ 844.0 844 86

Index Scan using pk_chr_val_desc_table on chr_val_desc_table (cost=1.17..94.18 rows=1 width=55) (actual time=0.054..38.290 rows=844 loops=86)

  • 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))
  • Rows Removed by Filter: 1,315
Planning time : 1.181 ms
Execution time : 3,321.590 ms