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

GLOBAL_STAT_USER_FUNCTIONS

Displays statistics about user-defined functions on each node in the entire cluster, as described in Table 1. (It is used on CNs. Status information about functions with the same name on different nodes is not summed up.)

Table 1 GLOBAL_STAT_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

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