Functions

Overview

The Functions page displays statistics on functions for the selected database as well as providing comparisons between functions in the three graphs at the top of the page. Tracking of function call counts and timing requires that track_functions is enabled.

Data

Top Section – Function Comparisons

  • Highest Calls Rate – Compares call rates of most frequently called functions.
  • Longest Avg Self Time – Compares self time for functions with highest average time.
  • Longest Avg Total Time – Compares total time for functions with highest average total time.

Bottom Section – Functions Table

  • Health – Shows the overall health of the function.
  • OID – OID of the function.
  • Name – The name of the function.
  • Schema – Schema that owns the function.
  • Calls – Number of calls to the function.
  • Calls Rate – Rate at which the function is called.
  • Self Time Avg – Average time spent in the function, not including calls to other functions.
  • Self Time – Total time spent in the function, not including calls to other functions.
  • Total Time Avg – Average time spent in the function, including calls to other functions.
  • Total Time – Total time spent in the function, including calls to other functions.

Actions

Function Table

  • Health (dwell or drilldown) - Shows a breakdown of child objects in a warning, critical, or fatal state.
  • Calls – A popup time plot of the number of calls.
  • Calls Rate – A popup time plot of the calls rate.
  • Self Time Avg – A popup time plot of the average self time.
  • Self Time – A popup time plot of the self time.
  • Total Time Avg – A popup time plot of the average total time.
  • Total Time – A popup time plot of the total time.

Admin Actions

If your user account has the PostgreSQL Administrator role and the PostgreSQL user provided to the agent has the appropriate permissions, you can perform administrative actions on the server from the dashboard. Click the icon in the Admin table column to perform one of the following actions:

  • Stat Reset – Resets statistics for the selected function.

Functions