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

Categories

Statistics / monitoring view

See also

track_functions, pg_stat_user_functions