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

GLOBAL_STAT_USER_FUNCTIONS

Displays the statistics of UDFs on each database node, as shown in Table 1. 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).