pg_stat_xact_user_functions

A statistics view showing statistics about executions of each tracked function during the current transaction

pg_stat_xact_user_functions is a statistics view showing statistics about executions of each tracked function during the current transaction.

pg_stat_xact_user_functions was added in PostgreSQL 9.1 (commit 46aa77c7).

Definition by PostgreSQL version

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

Categories

Statistics / monitoring view

See also

track_functions, pg_stat_user_functions