Summary Mode in Resource Usage Tables | Teradata Vantage - 17.05 - Summary Mode in Resource Usage Tables - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

Summary Mode combines data from the multiple data rows normally generated into one or more rows. When multiple rows are condensed into a single row, the data is combined using the rules in the following table.

For the following Mode … Summary fields are combined by…
Count summing the values from all the contributing rows.
For example, the ResUsageSawt.FlowCtlCnt field provides the total number of times that the system entered flow control state from a non-flow control state.
  • In normal mode, the values are reported per AMP.
  • In Summary Mode, the value needs to be divided by the number of AMPs if you wish to determine the average number per AMP rather than the total.
Max taking the maximum value from all the contributing rows.

In Summary Mode, the reported value for a Max field such as ResUsageSpdsk.ConcurrentWriteMax is the maximum value from all the rows that are combined into a single summary row.

Min taking the minimum value from all the contributing rows.

In Summary Mode, the reported value for a Min field, such as AvailableMin is the minimum value from all the rows that are combined into a single summary row.

Track summing the values from all the contributing rows.

In Summary Mode, the Track values from each row to be combined are summed together. For example, ResUsageSawt.FlowControlled is a track field so that in Summary Mode, all the AMP vproc rows are combined into a single row and the FlowControlled field will report the summed value from each of the AMP vproc rows.

Summary Mode is applicable to all tables except ResUsageSpma, ResUsageIpma, and ResUsageSps. If the information for a row of a table is in Summary Mode, the SummaryFlag value is set to 'S'. If the row is being logged normally, the SummaryFlag value is set to 'N'.