PG_STAT_XACT_USER_FUNCTIONS¶
PG_STAT_XACT_USER_FUNCTIONS displays statistics about function executions, with statistics about each execution displayed in a row.
Name | Type | Description |
---|---|---|
funcid | oid | Function OID |
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 |