Summary Mode in Resource Usage Tables | Teradata Vantage - Summary Mode in Resource Usage Tables - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

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'.