explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XsiK : test

Settings
# exclusive inclusive rows x rows loops node
1. 2.915 3,425.202 ↑ 1.0 1 1

Aggregate (cost=49,201.10..49,201.11 rows=1 width=8) (actual time=3,425.201..3,425.202 rows=1 loops=1)

2. 3,422.287 3,422.287 ↓ 1.3 13,158 1

Seq Scan on chr_simple_val (cost=0.00..49,176.40 rows=9,881 width=0) (actual time=2.380..3,422.287 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((chr_simple_val.*)::character varying, prod_locale_code))
  • Rows Removed by Filter: 75,771
Planning time : 0.089 ms
Execution time : 3,425.237 ms