Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Object/ GLOBAL_STAT_XACT_USER_FUNCTIONS

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

View PDF

GLOBAL_STAT_XACT_USER_FUNCTIONS

Displays statistics about function execution in the current transaction on each node in the cluster, as described in Table 1. (It is used on CNs.)

**Table 1** GLOBAL_STAT_XACT_USER_FUNCTIONS columns
Name	Type	Description
node_name	name	Node name.
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.