PG_STAT_XACT_USER_FUNCTIONS

PG_STAT_XACT_USER_FUNCTIONS displays statistics about function executions, with statistics about each execution displayed in a row.

**Table 1** PG_STAT_XACT_USER_FUNCTIONS columns
Name	Type	Description
funcid	oid	Function OID
schemaname	name	Schema name
funcname	name	Function name
calls	bigint	Number of times this function has been called
total_time	double precision	Total time spent in this function and all other functions called by it
self_time	double precision	Total time spent in this function itself, excluding other functions called by it

Parent topic: System Views

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center