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.
Tablespaces
The Tablespaces page shows tablespaces used by the selected PostgreSQL server. The table on the left displays a row for each tablespace while the graphs on the right show a visual distribution of disk spaze. In the action panel on the right pane, the PostgreSQL Agent Selector allows you to switch between PostgreSQL servers.
Data
Table
- Health – Shows the overall health of the tablespace.
- OID – OID of the tablespace.
- Name – Name of the tablespace.
- Owner – Owner of the tablespace.
- Size – Disk size of the tablespace.
Graphs
- Disk Space Distribution – Shows the distribution of disk space on the host between tablespaces, other used space, and free space. If host storage information is not being collected, only tablespace sizes are shown.
- Tablespace Sizes – Compares tablespace sizes to each other and shows combined total space used.
Actions
- Health (dwell or drilldown) - Shows a breakdown of child objects in a warning, critical, or fatal state.
- Size (dwell) – A popup time plot of the disk size.