pg_stat_xact_user_functions
A statistics view showing statistics of functions executed during the current transaction
pg_stat_xact_user_functions is a statistics view showing statistics about executions of each tracked function in the current database during the current transaction.
pg_stat_xact_user_functions was added in PostgreSQL 9.1.
Definition by PostgreSQL version
pg_stat_xact_user_functions (PostgreSQL 16)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 15)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 14)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 13)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 12)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 11)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 10)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Collation | Nullable | Default
------------+------------------+-----------+----------+---------
funcid | oid | | |
schemaname | name | | |
funcname | name | | |
calls | bigint | | |
total_time | double precision | | |
self_time | double precision | | |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.6)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+------------------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | double precision |
self_time | double precision |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.5)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+------------------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | double precision |
self_time | double precision |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.4)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+------------------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | double precision |
self_time | double precision |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.3)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+------------------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | double precision |
self_time | double precision |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.2)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+------------------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | double precision |
self_time | double precision |
Documentation: pg_stat_xact_user_functions
pg_stat_xact_user_functions (PostgreSQL 9.1)
View "pg_catalog.pg_stat_xact_user_functions"
Column | Type | Modifiers
------------+--------+-----------
funcid | oid |
schemaname | name |
funcname | name |
calls | bigint |
total_time | bigint |
self_time | bigint |
Documentation: pg_stat_xact_user_functions
Change history
- PostgreSQL 9.1
- added (commit 46aa77c7)
References
- PostgreSQL documentation: pg_stat_xact_user_functions