explain.depesz.com

PostgreSQL's explain analyze made readable

Result: weXx

Settings
# exclusive inclusive rows x rows loops node
1. 19.004 17,254.015 ↑ 1.0 1 1

Aggregate (cost=330,727.84..330,727.85 rows=1 width=8) (actual time=17,254.015..17,254.015 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.202 0.202 ↑ 1.0 1 1

Result (cost=0.00..2.51 rows=1 width=1) (actual time=0.201..0.202 rows=1 loops=1)

4. 17,234.809 17,234.809 ↓ 2.4 121,466 1

Seq Scan on slrstaffpos t (cost=0.00..330,598.08 rows=50,900 width=8) (actual time=0.619..17,234.809 rows=121,466 loops=1)

  • Filter: ($0 AND ((iddepartment <> ALL (adm_pfuncafi.gettblaccessforattr_notin(SESSION_USER, 'slrstaffpos'::name, '962001'::numeric))) OR (iddepartment IS NULL)))
  • Rows Removed by Filter: 7797
Planning time : 15.049 ms
Execution time : 17,254.133 ms