Class ExplainQueryStage
A single stage of query execution.
Implements
Inherited Members
Namespace: Google.Apis.Bigquery.v2.Data
Assembly: Google.Apis.Bigquery.v2.dll
Syntax
public class ExplainQueryStage : IDirectResponseSchema
Properties
CompletedParallelInputs
Number of parallel input segments completed.
Declaration
[JsonProperty("completedParallelInputs")]
public virtual long? CompletedParallelInputs { get; set; }
Property Value
Type | Description |
---|---|
long? |
ComputeMode
Output only. Compute mode for this stage.
Declaration
[JsonProperty("computeMode")]
public virtual string ComputeMode { get; set; }
Property Value
Type | Description |
---|---|
string |
ComputeMsAvg
Milliseconds the average shard spent on CPU-bound tasks.
Declaration
[JsonProperty("computeMsAvg")]
public virtual long? ComputeMsAvg { get; set; }
Property Value
Type | Description |
---|---|
long? |
ComputeMsMax
Milliseconds the slowest shard spent on CPU-bound tasks.
Declaration
[JsonProperty("computeMsMax")]
public virtual long? ComputeMsMax { get; set; }
Property Value
Type | Description |
---|---|
long? |
ComputeRatioAvg
Relative amount of time the average shard spent on CPU-bound tasks.
Declaration
[JsonProperty("computeRatioAvg")]
public virtual double? ComputeRatioAvg { get; set; }
Property Value
Type | Description |
---|---|
double? |
ComputeRatioMax
Relative amount of time the slowest shard spent on CPU-bound tasks.
Declaration
[JsonProperty("computeRatioMax")]
public virtual double? ComputeRatioMax { get; set; }
Property Value
Type | Description |
---|---|
double? |
ETag
The ETag of the item.
Declaration
public virtual string ETag { get; set; }
Property Value
Type | Description |
---|---|
string |
EndMs
Stage end time represented as milliseconds since the epoch.
Declaration
[JsonProperty("endMs")]
public virtual long? EndMs { get; set; }
Property Value
Type | Description |
---|---|
long? |
Id
Unique ID for the stage within the plan.
Declaration
[JsonProperty("id")]
public virtual long? Id { get; set; }
Property Value
Type | Description |
---|---|
long? |
InputStages
IDs for stages that are inputs to this stage.
Declaration
[JsonProperty("inputStages")]
public virtual IList<long?> InputStages { get; set; }
Property Value
Type | Description |
---|---|
IList<long?> |
Name
Human-readable name for the stage.
Declaration
[JsonProperty("name")]
public virtual string Name { get; set; }
Property Value
Type | Description |
---|---|
string |
ParallelInputs
Number of parallel input segments to be processed
Declaration
[JsonProperty("parallelInputs")]
public virtual long? ParallelInputs { get; set; }
Property Value
Type | Description |
---|---|
long? |
ReadMsAvg
Milliseconds the average shard spent reading input.
Declaration
[JsonProperty("readMsAvg")]
public virtual long? ReadMsAvg { get; set; }
Property Value
Type | Description |
---|---|
long? |
ReadMsMax
Milliseconds the slowest shard spent reading input.
Declaration
[JsonProperty("readMsMax")]
public virtual long? ReadMsMax { get; set; }
Property Value
Type | Description |
---|---|
long? |
ReadRatioAvg
Relative amount of time the average shard spent reading input.
Declaration
[JsonProperty("readRatioAvg")]
public virtual double? ReadRatioAvg { get; set; }
Property Value
Type | Description |
---|---|
double? |
ReadRatioMax
Relative amount of time the slowest shard spent reading input.
Declaration
[JsonProperty("readRatioMax")]
public virtual double? ReadRatioMax { get; set; }
Property Value
Type | Description |
---|---|
double? |
RecordsRead
Number of records read into the stage.
Declaration
[JsonProperty("recordsRead")]
public virtual long? RecordsRead { get; set; }
Property Value
Type | Description |
---|---|
long? |
RecordsWritten
Number of records written by the stage.
Declaration
[JsonProperty("recordsWritten")]
public virtual long? RecordsWritten { get; set; }
Property Value
Type | Description |
---|---|
long? |
ShuffleOutputBytes
Total number of bytes written to shuffle.
Declaration
[JsonProperty("shuffleOutputBytes")]
public virtual long? ShuffleOutputBytes { get; set; }
Property Value
Type | Description |
---|---|
long? |
ShuffleOutputBytesSpilled
Total number of bytes written to shuffle and spilled to disk.
Declaration
[JsonProperty("shuffleOutputBytesSpilled")]
public virtual long? ShuffleOutputBytesSpilled { get; set; }
Property Value
Type | Description |
---|---|
long? |
SlotMs
Slot-milliseconds used by the stage.
Declaration
[JsonProperty("slotMs")]
public virtual long? SlotMs { get; set; }
Property Value
Type | Description |
---|---|
long? |
StartMs
Stage start time represented as milliseconds since the epoch.
Declaration
[JsonProperty("startMs")]
public virtual long? StartMs { get; set; }
Property Value
Type | Description |
---|---|
long? |
Status
Current status for this stage.
Declaration
[JsonProperty("status")]
public virtual string Status { get; set; }
Property Value
Type | Description |
---|---|
string |
Steps
List of operations within the stage in dependency order (approximately chronological).
Declaration
[JsonProperty("steps")]
public virtual IList<ExplainQueryStep> Steps { get; set; }
Property Value
Type | Description |
---|---|
IList<ExplainQueryStep> |
WaitMsAvg
Milliseconds the average shard spent waiting to be scheduled.
Declaration
[JsonProperty("waitMsAvg")]
public virtual long? WaitMsAvg { get; set; }
Property Value
Type | Description |
---|---|
long? |
WaitMsMax
Milliseconds the slowest shard spent waiting to be scheduled.
Declaration
[JsonProperty("waitMsMax")]
public virtual long? WaitMsMax { get; set; }
Property Value
Type | Description |
---|---|
long? |
WaitRatioAvg
Relative amount of time the average shard spent waiting to be scheduled.
Declaration
[JsonProperty("waitRatioAvg")]
public virtual double? WaitRatioAvg { get; set; }
Property Value
Type | Description |
---|---|
double? |
WaitRatioMax
Relative amount of time the slowest shard spent waiting to be scheduled.
Declaration
[JsonProperty("waitRatioMax")]
public virtual double? WaitRatioMax { get; set; }
Property Value
Type | Description |
---|---|
double? |
WriteMsAvg
Milliseconds the average shard spent on writing output.
Declaration
[JsonProperty("writeMsAvg")]
public virtual long? WriteMsAvg { get; set; }
Property Value
Type | Description |
---|---|
long? |
WriteMsMax
Milliseconds the slowest shard spent on writing output.
Declaration
[JsonProperty("writeMsMax")]
public virtual long? WriteMsMax { get; set; }
Property Value
Type | Description |
---|---|
long? |
WriteRatioAvg
Relative amount of time the average shard spent on writing output.
Declaration
[JsonProperty("writeRatioAvg")]
public virtual double? WriteRatioAvg { get; set; }
Property Value
Type | Description |
---|---|
double? |
WriteRatioMax
Relative amount of time the slowest shard spent on writing output.
Declaration
[JsonProperty("writeRatioMax")]
public virtual double? WriteRatioMax { get; set; }
Property Value
Type | Description |
---|---|
double? |