• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_STAT_XACT_USER_FUNCTIONS

PG_STAT_XACT_USER_FUNCTIONS

PG_STAT_XACT_USER_FUNCTIONS contains each row of the tracing function, showing the statistics about function execution.

Table 1 PG_STAT_XACT_USER_FUNCTIONS columns

Name

Type

Description

funcid

oid

OID of a function

schemaname

name

Schema name

funcname

name

Function name

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