MonitorSQLSteps Syntax Elements - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
HostIdIn
Logical ID of a host (or client) with sessions logged on.
SessionNoIn
Session number of the SQL to monitor.
RunVprocNo
PE vproc number where the session runs.
HostId
Logical host ID associated with a PE or session. For a PE, HostId identifies one of the hosts or LANs associated with the described PE. For a session, the combination of a host ID and a session number uniquely identifies a user session on the system.
This value is NULL for AMPs. A value of zero represents the Supervisor window.
SessionNo
Number of the current session. With a given host ID, a session number uniquely identifies a session on the database system. This value is assigned by the host (or client) at logon time.
DynamicPlan
Plan type:
  • 0 = Static plan
  • 1 = Dynamic plan
See EXPLAIN Request Modifier.
PartialSteps
Possible values:
  • 0 = All steps are returned
  • 1 = Partial plan or no plan is returned

    If a partial plan is returned, this indicates the steps for the final plan fragment of the dynamic explanation of the request has not yet been generated.

    If no plan is returned, this indicates the request has been throttled and is in the delay queue.

A value 1 cannot occur for a static plan.
For more information on static and dynamic explanations of a request, see STATIC EXPLAIN and DYNAMIC EXPLAIN.
StepNum
Unique number identifying the EXPLAIN step.
Confidence
Confidence level as determined by the optimizer:
  • 0 = None
  • 1= Foreign Key
  • 2 = Low
  • 3 = High
EstRowCount
Estimated row count generated from the Optimizer plan for this step.
For a PRPD plan, the EstRowCount field for the split step (that is, a RETRIEVE or JOIN step with “split into” appearing in the EXPLAIN when target spools are generated) is the estimated row counts for ALL split spools.
For more information on PRPD, see Join Strategies and Methods.
ActRowCount
Actual row count returned from the AMP for this step.
For a PRPD plan, this value includes rows from all split spools for a split step.
See Join Strategies and Methods
EstRowCountSkew
Estimated row count for the skew split spool in PRPD, which contains the rows with skewed values of this spool.
See Join Strategies and Methods
ActRowCountSkew
Actual number of rows for the skew split spool in PRPD.
See Join Strategies and Methods
EstRowCountSkewMatch
Estimated row count for the skew match split spool in PRPD, which contains the rows with skewed values of the other relation to be joined with this relation.
For more information on PRPD, see Join Strategies and Methods
ActRowCountSkewMatch
Actual number of rows for the skew match split spool in PRPD.
For more information on PRPD, see Join Strategies and Methods
EstElapsedTime
Estimated time for the query as generated from the Optimizer plan.
ActElapsedTime
Actual elapsed time calculated by the dispatcher.
SQLStep
Generated text for the step.