explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yoJv

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 28.164 ↑ 1.0 1 1

Result (cost=314.75..314.76 rows=1 width=32) (actual time=28.164..28.164 rows=1 loops=1)

2.          

Initplan (for Result)

3. 28.160 28.160 ↑ 200.0 1 1

HashAggregate (cost=262.75..314.75 rows=200 width=16) (actual time=28.158..28.160 rows=1 loops=1)

  • Group Key: "isnull"(corporate_id, 'ffffffff-ffff-ffff-ffff-ffffffffffff'::uuid)
  • -> Function Scan on fn_get_user_access_to_list_corporate t (cost=0.25..260.25 rows=1000 width=16) (actual time=28.153..28.153 rows=1 loops=1);
  • SELECT DISTINCT ISNULL(t.corporate_id,m_fguid)
  • FROM tvs_security_service.fn_get_user_access_to_list_corporate(p_current_user_id) AS t