Summary View | VantageCloud Lake - Summary View - Teradata VantageCloud Lake

Lake - Using Queries, UDFs, and External Stored Procedures

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-08-12
dita:mapPath
vgj1683671089901.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
vgj1683671089901

The Summary view displays all queries running on the primary cluster. The metrics displayed are as follows:

Metric Description Type
Compute Group The name of the compute group associated with the query. Compute Group contains one or more Compute Profiles. Compute Groups associate the Compute Profile resources with users and their queries. String
Compute group - Request AMP CPU Average of the total CPU seconds consumed to run the query on compute groups. Number
Compute group - Request AMP IO Average of the total number of disk I/Os performed while running on the compute groups. Number
Duration Time the query has been running. Number
Host ID Host 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 used AMP and calculated at the request level. Number
Primary cluster - Request AMP CPU Total CPU seconds consumed while running the query on the primary cluster. Number
Primary cluster Request AMP IO Total number of disk I/Os performed while running the query on the primary cluster. Number
Request count Number of queries submitted by the session. Number
Run VPROC no Vproc number of the AMP or PE currently assigned to process the session requests. Number
Session ID Unique session identifier Number
Start time Time at which the query started running String
State Text describing the current state of the query. String
Unnecessary IO 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
User name Name of the user who submitted the query. String
Workload name Workload in which the query is running. String