explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wLtp

Settings
# exclusive inclusive rows x rows loops node
1. 37.341 19,621.276 ↑ 1.0 1 1

Aggregate (cost=330,736.66..330,736.67 rows=1 width=8) (actual time=19,621.276..19,621.276 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.345 0.345 ↑ 1.0 1 1

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

4. 19,583.590 19,583.590 ↓ 2.2 121,466 1

Seq Scan on slrstaffpos t (cost=0.00..330,598.08 rows=54,428 width=8) (actual time=0.928..19,583.590 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 : 16.418 ms
Execution time : 19,621.474 ms