explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CcD9

Settings
# exclusive inclusive rows x rows loops node
1. 25.177 2,748.380 ↑ 1.0 1 1

Aggregate (cost=330,762.11..330,762.12 rows=1 width=8) (actual time=2,748.380..2,748.380 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.215 0.215 ↑ 1.0 1 1

Result (cost=0.00..2.51 rows=1 width=1) (actual time=0.214..0.215 rows=1 loops=1)

4. 2,722.988 2,722.988 ↓ 2.0 129,263 1

Seq Scan on slrstaffpos t (cost=0.00..330,598.08 rows=64,610 width=8) (actual time=0.389..2,722.988 rows=129,263 loops=1)

  • Filter: ($0 AND ((iddepartment <> ALL (adm_pfuncafi.gettblaccessforattr_notin(SESSION_USER, 'slrstaffpos'::name, '962001'::numeric))) OR (iddepartment IS NULL)))
Planning time : 0.600 ms