pg_profile: User function statistics

March 10, 2024

Summary: This report section contains top functions in cluster, based on pg_stat_user_functions view.

This section contains the following subsections:

  1. Top functions by total time
  2. Top functions by executions
  3. Top trigger functions by total time

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

See more

pg_profile: PostgreSQL historical workload reports

comments powered by Disqus