pg_stat_user_functions

The pg_stat_user_functions view will contain one row for each tracked function, showing statistics about executions of that function.

Columns 6

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
`total_time`	`double precision`	Total time spent in this function and all other functions called by it, in milliseconds
`self_time`	`double precision`	Total time spent in this function itself, not including other functions called by it, in milliseconds

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`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`stats_reset`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 8

Definition snapshot: english-manuals:222fd51a8ed5debe0bb390e29fb… · English manual source