Updated on 2023-10-23 GMT+08:00

GLOBAL_STAT_USER_FUNCTIONS

GLOBAL_STAT_USER_FUNCTIONS displays statistics about user-defined functions on each node in the database.

Table 1 GLOBAL_STAT_USER_FUNCTIONS columns

Name

Type

Description

node_name

name

Node name

funcid

oid

ID of the function

schemaname

name

Schema name

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 (unit: ms)

self_time

double precision

Total time spent in this function, excluding other functions called by it (unit: ms)