pg_stat_xact_user_functions

A transaction can also see its own statistics (not yet flushed out to the shared memory statistics) in the views pg_stat_xact_all_tables, pg_stat_xact_sys_tables, pg_stat_xact_user_tables, and pg_stat_xact_user_functions.

Kind: Statistics views
Columns in this snapshot: 6
Definition source: English manual

Columns 6

The selected manual identifies this view but does not enumerate its columns. The columns below come from the separately attributed catalog snapshot for this version.

Column	Type	Description / reference
`funcid`	`oid`	OID of a function
`schemaname`	`name`	Name of the schema this function is in
`funcname`	`name`	Name of this function
`calls`	`bigint`	Number of times this function has been called This view reports counters for the current transaction.
`total_time`	`double precision`	Total time spent in this function and all other functions called by it, in milliseconds This view reports counters for the current transaction.
`self_time`	`double precision`	Total time spent in this function itself, not including other functions called by it, in milliseconds This view reports counters for the current transaction.

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`funcid`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?
`schemaname`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?
`funcname`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?
`calls`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?
`total_time`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?
`self_time`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	?

Version history 3

Definition snapshot: english-manuals:cdc2769f1b0f8d46cf99646728c… · English manual source