Queries Metrics for Teradata Database

Teradata Viewpoint User Guide

prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
Metrics for Teradata Database that display in the Viewpoint Mobile Queries view are listed below.
Metric Description Type
Account Account from which a query was submitted String
Blocked Time How long the query has been blocked Number
CPU Skew Percentage of how inefficiently a query or job was executed in terms of CPU parallelism. A value of 0% indicates the query was executed perfectly in parallel, meaning each AMP consumed identical amounts of CPU. A value of 50% indicates a single AMP consumed twice as much CPU as the average. As CPU Skew approaches 100%, it indicates the query or job was not executed in parallel. Percent
CPU Use Percent of available CPU seconds on the system used during the last sampling period Percent
Delay Time Duration of time request has been delayed by utility, system throttle, workload throttle, or workload group throttle rules Number
Delayed By Names of the throttles causing the query to be delayed String
Δ CPU Total CPU usage time consumed, in seconds, since the last sample Number
Δ I/O I/O count since the last sample Number
Duration How long the query has been running Number
Host Host ID or LAN ID associated with the PE that processed the login request for the session Number
Impact CPU CPU impact on the system based on the highest utilized AMP. For Teradata Database 15.0 and earlier, calculated at the snapshot level; for Teradata Database 15.10 and later, calculated at the request level. Number
In State How long the query has been in the current state Number
Partition Partition in which the query is running String
PJI Ratio of the CPU milliseconds per I/O for the query, where a larger Product Join Index number indicates system performance degradation Number
Proxy Username Name of the proxy user when a trusted session is used. For Teradata Database 15.0 and later. String
Query Band Entire query band string. Query bands are a set of name-value pairs defined by the user to tag sessions or transactions with an ID through a SQL interface. String
Req CPU CPU seconds needed to run the query Number
Req CPU Skew CPU skew for the current query. For Teradata Database 15.10 and later. Percent
Req Count Number of queries the session has executed Number
Req I/O Disk I/Os performed to run the query Number
Req I/O Skew I/O skew for the current query. For Teradata Database 15.10 and later. Percent
Session ID Unique session identifier Number
Snapshot CPU Skew CPU skew during the last sample Percent
Snapshot I/O Skew I/O skew during the last sample Percent
Spool Spool space the query requires, using a 1024 byte kilobyte as the base Number
Start Time that the query started running on Teradata Database Number
State Text describing the current state of the query String
State Icon Icon representing the current state of the query Icon
Temp Space Temp space used by the query, using a 1024 byte kilobyte as the base Number
Unnecessary I/O Ratio of I/O to CPU for the current query Number
Username Name of the user who submitted the query String
Workload Workload in which the query is running String