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)

  • )"PL/pgSQL function tvs_dbo.pri_get_role_for_entity(tvs_security_service.list_guid,smallint,uuid,tvs_security_service.list_guid,character varying,integer,integer,character varying,integer,tvs_dbo.column_filter[],smallint,uuid) line 48 at assignmentPL/pgSQL function tvs_dbo.pub_get_role_for_user(character varying,integer,integer,character varying,integer,tvs_dbo.column_filter[],smallint,uuid) line 48 at RETURN QUERY
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);Context: SQL statement "SELECT ARRAY(
  • 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