15.10 - Resource Usage Views Overview - Teradata Database

Teradata Database Resource Usage Macros and Tables

Teradata Database
Release Number
April 2016
English (United States)
Last Update

This chapter provides information for accessing the resource usage views.

Views are the recommended method to access the resource usage table data.

To see the view definitions, execute SHOW VIEW viewname, where viewname is the name of the view whose most recent SQL create text is to be reported. For details on using the SHOW VIEW statement, see SQL Data Definition Language.

The following views report the table column, GroupId. A homogenous system requires no changes to use this macro because all the nodes will be assigned to group A. For a coexisting system, however, the values need to be set up when the system is installed or reconfigured so that each type of node is assigned to a specific group ID.

Since each of the views include all the columns for the represented table, the views will be changed whenever the base table columns are changed.

Do not change or delete columns in these views. If the columns are modified, the resource usage macros that use these views may not work properly. You can, however, safely add columns.
View Description
ResCPUUsageByAMPView Describes CPU usage per AMP
ResCPUUsageByPEView Describes CPU usage by each PE
ResSawtView Based on the ResUsageSawt table
ResScpuView Based on the ResUsageScpu table
ResShstView Based on the ResUsageShst table
ResSldvView Based on the ResUsageSldv table
ResSpdskView Based on the ResUsageSpdsk table
ResSpmaView Based on the ResUsageSpma table
ResSpsView Based on the ResUsageSps table
ResSvdskView Based on the ResUsageSvdsk table
ResSvprView Based on the ResUsageSvpr table.