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 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