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

GLOBAL_STAT_XACT_USER_FUNCTIONS

Displays statistics about function execution in a transaction on each database node, as shown in Table 1. Data on different nodes is not summed up.

Table 1 GLOBAL_STAT_XACT_USER_FUNCTIONS columns

Name

Type

Description

node_name

name

Node name.

funcid

oid

OID of a function.

schemaname

name

Name of the schema where the function is located.

funcname

name

Function name.

calls

bigint

Number of times that the 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

Time spent in this function, excluding other functions called by it.