Query Spotlight View Metrics - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
Metrics available for monitoring and display are as following. For a list of metric sources for some of the metrics listed as following, see Metric Sources Overview.
Metric Description Type
Duration How long the query has been running Number
End Time that the query stopped running on Analytics Database Number
Host Host ID or LAN ID associated with the PE that processed the login request for the session Number
Hot AMP Spool (Teradata Database 16.0 and later) Current spool value of the highest spool utilized AMP for the query. If no request is running on the session, no value displays. Number
Impact CPU CPU impact on the system based on the highest utilized AMP. (Teradata Database 15.0 and earlier) Calculated at the snapshot level. (Teradata Database 15.10 and later) Calculated at the request level. Number
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 (Teradata Database 15.0 and later) Name of the proxy user when a trusted session is used String
Req CPU CPU seconds needed to run the query Number
Req CPU Skew (Teradata Database 15.10 and later) CPU skew for the current query Percent
Req I/O Disk I/Os performed to run the query Number
Req I/O Skew (Teradata Database 15.10 and later) I/O skew for the current query Percent
Req Number Number of the specific request Number
Session ID Unique session identifier Number
Spool Spool space the query requires, using a 1024 byte kilobyte as the base Number
Spool Skew (Teradata Database 16.0 and later) Current spool value of the highest spool utilized AMP for the query. If no request is running on the session, no value displays. Percent
Start Time that the query started running on Analytics Database Number
Unnecessary I/O All AMP I/O divided by all AMP CPU, displayed in milliseconds, to reveal large amounts of I/O occurring over a short period of time Number
Username Name of the user who submitted the query String