Updated on 2024-09-02 GMT+08:00

PG_STAT_USER_FUNCTIONS

PG_STAT_USER_FUNCTIONS displays user-defined function status information in the namespace. (The language of the function is non-internal language.)

Table 1 PG_STAT_USER_FUNCTIONS columns

Name

Type

Description

funcid

oid

Function OID

schemaname

name

Schema name

funcname

name

Name of the function

calls

bigint

Number of times this function has been called

total_time

double precision

Total time spent in this function and all other functions called by it

self_time

double precision

Total time spent in this function itself, excluding other functions called by it