17.00 - Summary Mode - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

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

When Summary Mode is active for the ResUsageSawt table, one row is written to the database for each node in the system for each log interval. The AMP Worker Task data will be combined for all the AMP vprocs on the node.

You can determine if a row is in Summary Mode by checking the SummaryFlag column for that row.

IF the SummaryFlag column value is… THEN the data for that row is being logged…
'S' in Summary Mode.
'N' normally.