Updated on 2024-06-03 GMT+08:00

STAT_XACT_USER_FUNCTIONS

Displays statistics about function executions in the current transaction on the current database node, as described in Table 1.

Table 1 STAT_XACT_USER_FUNCTIONS columns

Name

Type

Description

funcid

oid

OID of the function.

schemaname

name

Name of the schema where the function is located.

funcname

name

Function name.

calls

bigint

Number of times the 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

Time spent in this function, excluding other functions called by it.