Help Center> GaussDB> Centralized_3.x> Schemas> DBE_PERF Schema> Object> GLOBAL_STAT_USER_FUNCTIONS

Updated on 2024-05-07 GMT+08:00

View PDF

GLOBAL_STAT_USER_FUNCTIONS

Displays the statistics of UDFs on each database node. The statistics on different nodes are not summed up.

**Table 1** GLOBAL_STAT_USER_FUNCTIONS columns
Name	Type	Description
node_name	name	Node name.
funcid	oid	ID of the function.
schemaname	name	Name of the schema where the function is located.
funcname	name	UDF name.
calls	bigint	Number of times the function has been called.
total_time	double precision	Total time spent in this function, including other functions called by it (unit: ms).
self_time	double precision	Time spent in this function, excluding other functions called by it (unit: ms).