Updated on 2025-07-22 GMT+08:00

PG_STAT_XACT_USER_FUNCTIONS

PG_STAT_XACT_USER_FUNCTIONS displays statistics about function execution.

Table 1 PG_STAT_XACT_USER_FUNCTIONS columns

Column

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