March 10, 2024
Summary: This report section contains top functions in cluster, based on pg_stat_user_functions view.
Table of Contents
Top functions by total time
Top functions sorted by time elapsed.
- DB - database name of the function
- Schema - schema name of the index
- Function - function name
- Executions - number of times this function has been called (calls field)
- Time (s) - function timing statistics in seconds
- Total - total time spent in this function and all other functions called by it (total_time field)
- Self - total time spent in this function itself, not including other functions called by it (self_time field)
- Mean - mean time of single function execution
- Mean self - mean self time of single function execution
Top functions by executions
Top functions sorted by executions count.
- DB - database name of the function
- Schema - schema name of the index
- Function - function name
- Executions - number of times this function has been called (calls field)
- Time (s) - function timing statistics in seconds
- Total - total time spent in this function and all other functions called by it (total_time field)
- Self - total time spent in this function itself, not including other functions called by it (self_time field)
- Mean - mean time of single function execution
- Mean self - mean self time of single function execution
Top trigger functions by total time
Top trigger functions sorted by time elapsed.
- DB - database name of the function
- Schema - schema name of the index
- Function - function name
- Executions - number of times this function has been called (calls field)
- Time (s) - function timing statistics in seconds
- Total - total time spent in this function and all other functions called by it (total_time field)
- Self - total time spent in this function itself, not including other functions called by it (self_time field)
- Mean - mean time of single function execution
- Mean self - mean self time of single function execution