Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DBE_PERF Schema/ Object/ STAT_USER_FUNCTIONS
Updated on 2025-08-19 GMT+08:00
View PDF

STAT_USER_FUNCTIONS

Displays statistics about user-defined functions (the function language is not an internal language) in all the schemas of the current node, as shown in Table 1.

Table 1 STAT_USER_FUNCTIONS columns

Name

Type

Description

funcid

oid

OID of a function.

schemaname

name

Schema name.

funcname

name

Rename the customized function.

calls

bigint

Number of times that 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).
Parent topic: Object