explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EqDJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.240 3,797.583 ↑ 2.9 228 1

Hash Join (cost=49,299.91..51,848.83 rows=651 width=42) (actual time=3,512.692..3,797.583 rows=228 loops=1)

  • Hash Cond: ((cep.home_dept_oid)::text = (ctc.oid)::text)
2. 329.435 329.435 ↑ 1.9 228 1

Seq Scan on chr_emp_position cep (cost=0.00..2,437.77 rows=436 width=11) (actual time=44.713..329.435 rows=228 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND f_sel_policy_all(vpd_key, 'CHR_EMP_POSITION'::character varying) AND f_sel_policy_prod_locale((cep.*)::character varying, prod_locale_code))
  • Rows Removed by Filter: 3,695
3. 6.979 3,467.908 ↓ 1.3 13,158 1

Hash (cost=49,176.40..49,176.40 rows=9,881 width=31) (actual time=3,467.907..3,467.908 rows=13,158 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,031kB
4. 3,460.929 3,460.929 ↓ 1.3 13,158 1

Seq Scan on chr_simple_val ctc (cost=0.00..49,176.40 rows=9,881 width=31) (actual time=2.191..3,460.929 rows=13,158 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfnadmin,skipvpd}'::text[])) AND f_sel_policy_ty_static(vpd_key) AND f_sel_policy_prod_locale((ctc.*)::character varying, prod_locale_code))
  • Rows Removed by Filter: 75,771
Planning time : 0.297 ms
Execution time : 3,797.768 ms