Completed Queries View Metrics

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K

Teradata Aster

Metric Description
User User name that submitted the process
State Process state, such as error, canceled, completed
State Icon Symbol of the process state
Type Values for process types are as follows:
  • SQLMR (SQL-MapReduce)
  • SQL
  • Teradata Import
  • Teradata Export
Duration How long the process ran
Process ID Process identifier
Session ID Session identifier
Start Time the process began running
End Time the process stopped running
Workload Workload name in which the process ran
Database Database name against which the process ran

Teradata Machine Learning Engine

Metric Description
User User name that submitted the process
State Process state, such as error, canceled, completed
State Icon Symbol of the process state
Type Values for process types are as follows:
  • SQLMR (SQL-MapReduce)
  • SQL
  • Teradata Import
  • Teradata Export
Duration How long the process ran
Process ID Process identifier
Session ID Session identifier
Start Time the process began running
End Time the process stopped running
CPU Percent (8.10 or later)
CPU Seconds (8.10 or later)
Memory KB (8.10 or later)
Total I/O (8.10 or later)

Teradata Presto

Metric Description
Query ID ID of the query
Username User who submitted the query
State Current state of the query, such as error, canceled, completed
Principal Kerberos principal for the query
Source Application or client utility that executed the query
Catalog Name of the catalog for the connector used by the query
Schema Name of the schema within the catalog used by the query
Memory Pool Name of the memory pool assigned to the query
Duration How long the query has been running, displayed as hh:mm:ss
Start Time Time that the query started running
End Time Time that the query stopped running
Memory Used Amount of memory in bytes in use for the query
CPU Time Amount of CPU seconds used by the query
Rows Number of rows processed by the query
Data Size Number of bytes of data processed by the query
Splits Completed Number of splits already completed
Error Type Type of error which caused the query to fail
Error Code Code for the error which caused the query to fail

Teradata QueryGrid

Metric Description Type
Start Time Time the query started running Number
User Initiating user String
Link Name Name of the link that defines the initiating and target connectors String
Status Indicates the final status of the query String
Duration How long the query has been running Number
Rows Transferred Number of rows transferred by the query Number
Bytes Transferred Number of bytes transferred by the query Number
Transfer Rate Rate at which data is being transferred Number
Initiating System System that initiated the query String
Initiating Connector Connector that initiated the query String
Target System System being accessed or to which data is being transferred String
Target Connector Connector through which the data is being accessed or transferred String