Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Object/ SUMMARY_STAT_USER_FUNCTIONS
Updated on 2024-06-03 GMT+08:00

SUMMARY_STAT_USER_FUNCTIONS

Displays the summary of statistics about user-defined functions on each node in the entire cluster. It is used on CNs and the status information of user-defined functions on each node is summed up by function name, as described in Table 1.

Table 1 SUMMARY_STAT_USER_FUNCTIONS columns

Name

Type

Description

schemaname

name

Schema name.

funcname

name

UDF name.

calls

numeric

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).