QueryPlanEntry()QueryPlanEntry represents a single stage of a query execution plan.
See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ExplainQueryStage for the underlying API representation within query statistics.
Inheritance
builtins.object > QueryPlanEntryProperties
completed_parallel_inputs
Optional[int]: Number of parallel input segments completed.
compute_ms_avg
Optional[int]: Milliseconds the average worker spent on CPU-bound processing.
compute_ms_max
Optional[int]: Milliseconds the slowest worker spent on CPU-bound processing.
compute_ratio_avg
Optional[float]: Ratio of time the average worker spent on CPU-bound processing, relative to the longest time spent by any worker in any stage of the overall plan.
compute_ratio_max
Optional[float]: Ratio of time the slowest worker spent on CPU-bound processing, relative to the longest time spent by any worker in any stage of the overall plan.
end
Optional[Datetime]: Datetime when the stage ended.
entry_id
Optional[str]: Unique ID for the stage within the plan.
input_stages
List(int): Entry IDs for stages that were inputs for this stage.
name
Optional[str]: Human-readable name of the stage.
parallel_inputs
Optional[int]: Number of parallel input segments within the stage.
read_ms_avg
Optional[int]: Milliseconds the average worker spent reading input.
read_ms_max
Optional[int]: Milliseconds the slowest worker spent reading input.
read_ratio_avg
Optional[float]: Ratio of time the average worker spent reading input, relative to the longest time spent by any worker in any stage of the overall plan.
read_ratio_max
Optional[float]: Ratio of time the slowest worker spent reading to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.
records_read
Optional[int]: Number of records read by this stage.
records_written
Optional[int]: Number of records written by this stage.
shuffle_output_bytes
Optional[int]: Number of bytes written by this stage to intermediate shuffle.
shuffle_output_bytes_spilled
Optional[int]: Number of bytes written by this stage to intermediate shuffle and spilled to disk.
start
Optional[Datetime]: Datetime when the stage started.
status
Optional[str]: status of this stage.
steps
List(QueryPlanEntryStep): List of step operations performed by each worker in the stage.
wait_ms_avg
Optional[int]: Milliseconds the average worker spent waiting to be scheduled.
wait_ms_max
Optional[int]: Milliseconds the slowest worker spent waiting to be scheduled.
wait_ratio_avg
Optional[float]: Ratio of time the average worker spent waiting to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.
wait_ratio_max
Optional[float]: Ratio of time the slowest worker spent waiting to be scheduled, relative to the longest time spent by any worker in any stage of the overall plan.
write_ms_avg
Optional[int]: Milliseconds the average worker spent writing output data.
write_ms_max
Optional[int]: Milliseconds the slowest worker spent writing output data.
write_ratio_avg
Optional[float]: Ratio of time the average worker spent writing output data, relative to the longest time spent by any worker in any stage of the overall plan.
write_ratio_max
Optional[float]: Ratio of time the slowest worker spent writing output data, relative to the longest time spent by any worker in any stage of the overall plan.
Methods
from_api_repr
from_api_repr(resource: dict)Factory: construct instance from the JSON repr.
| Type | Description |
| google.cloud.bigquery.job.QueryPlanEntry | Query plan entry parsed from ``resource``. |
__init__
__init__()Initialize self. See help(type(self)) for accurate signature.
QueryPlanEntry
QueryPlanEntry()QueryPlanEntry represents a single stage of a query execution plan.
See https://cloud.google.com/bigquery/docs/reference/rest/v2/Job#ExplainQueryStage for the underlying API representation within query statistics.