JobStatistics

Output only. Statistics for a single job execution.

JSON representation
{
  "creationTime": string,
  "startTime": string,
  "endTime": string,
  "totalBytesProcessed": string,
  "completionRatio": number,
  "quotaDeferments": [
    string
  ],
  "query": {
    object (JobStatistics2)
  },
  "load": {
    object (JobStatistics3)
  },
  "extract": {
    object (JobStatistics4)
  },
  "totalSlotMs": string,
  "reservationUsage": [
    {
      "name": string,
      "slotMs": {
        "value": string
      }
    }
  ],
  "numChildJobs": string,
  "parentJobId": string
}
Fields
creationTime

string (int64 format)

Output only. Creation time of this job, in milliseconds since the epoch. This field will be present on all jobs.

startTime

string (int64 format)

Output only. Start time of this job, in milliseconds since the epoch. This field will be present when the job transitions from the PENDING state to either RUNNING or DONE.

endTime

string (int64 format)

Output only. End time of this job, in milliseconds since the epoch. This field will be present whenever a job is in the DONE state.

totalBytesProcessed

string (Int64Value format)

Output only. Total bytes processed for the job.

completionRatio

number

Output only. [TrustedTester] Job progress (0.0 -> 1.0) for LOAD and EXTRACT jobs.

quotaDeferments[]

string

Ouput only. Quotas which delayed this job's start time.

query

object (JobStatistics2)

Output only. Statistics for a query job.

load

object (JobStatistics3)

Output only. Statistics for a load job.

extract

object (JobStatistics4)

Output only. Statistics for an extract job.

totalSlotMs

string (Int64Value format)

Output only. Slot-milliseconds for the job.

reservationUsage[]

object

Output only. Job resource usage breakdown by reservation.

reservationUsage[].name

string

Reservation name or "unreserved" for on-demand resources usage.

reservationUsage[].slotMs

string (Int64Value format)

Total slot milliseconds used by the reservation for a particular job.

numChildJobs

string (int64 format)

Number of child jobs executed.

parentJobId

string

If this is a child job, specifies the job ID of the parent.

JobStatistics2

Output only. Statistics for a query job.

JSON representation
{
  "queryPlan": [
    {
      object (ExplainQueryStage)
    }
  ],
  "estimatedBytesProcessed": string,
  "timeline": [
    {
      object (QueryTimelineSample)
    }
  ],
  "totalPartitionsProcessed": string,
  "totalBytesProcessed": string,
  "totalBytesProcessedAccuracy": string,
  "totalBytesBilled": string,
  "billingTier": number,
  "totalSlotMs": string,
  "reservationUsage": [
    {
      "name": string,
      "slotMs": {
        "value": string
      }
    }
  ],
  "cacheHit": boolean,
  "referencedTables": [
    {
      object (TableReference)
    }
  ],
  "schema": {
    object (TableSchema)
  },
  "numDmlAffectedRows": string,
  "undeclaredQueryParameters": [
    {
      object (QueryParameter)
    }
  ],
  "statementType": string,
  "ddlOperationPerformed": string,
  "ddlTargetTable": {
    object (TableReference)
  }
}
Fields
queryPlan[]

object (ExplainQueryStage)

Output only. Describes execution plan for the query.

estimatedBytesProcessed

string (Int64Value format)

Output only. The original estimate of bytes processed for the job.

timeline[]

object (QueryTimelineSample)

Output only. [Beta] Describes a timeline of job execution.

totalPartitionsProcessed

string (Int64Value format)

Output only. Total number of partitions processed from all partitioned tables referenced in the job.

totalBytesProcessed

string (Int64Value format)

Output only. Total bytes processed for the job.

totalBytesProcessedAccuracy

string

Output only. For dry-run jobs, totalBytesProcessed is an estimate and this field specifies the accuracy of the estimate. Possible values can be: UNKNOWN: accuracy of the estimate is unknown. PRECISE: estimate is precise. LOWER_BOUND: estimate is lower bound of what the query would cost. UPPER_BOUND: estimate is upper bound of what the query would cost.

totalBytesBilled

string (Int64Value format)

Output only. Total bytes billed for the job.

billingTier

number

Output only. Billing tier for the job.

totalSlotMs

string (Int64Value format)

Output only. Slot-milliseconds for the job.

reservationUsage[]

object

Output only. Job resource usage breakdown by reservation.

reservationUsage[].name

string

Reservation name or "unreserved" for on-demand resources usage.

reservationUsage[].slotMs

string (Int64Value format)

Total slot milliseconds used by the reservation for a particular job.

cacheHit

boolean

Output only. Whether the query result was fetched from the query cache.

referencedTables[]

object (TableReference)

Output only. Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.

schema

object (TableSchema)

Output only. The schema of the results. Present only for successful dry run of non-legacy SQL queries.

numDmlAffectedRows

string (Int64Value format)

Output only. The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.

undeclaredQueryParameters[]

object (QueryParameter)

Output only. Standard SQL only: list of undeclared query parameters detected during a dry run validation.

statementType

string

Output only. The type of query statement, if valid. Possible values (new values might be added in the future): "SELECT": SELECT query. "INSERT": INSERT query; see https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language. "UPDATE": UPDATE query; see https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language. "DELETE": DELETE query; see https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language. "MERGE": MERGE query; see https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language. "ALTER_TABLE": ALTER TABLE query. "ALTER_VIEW": ALTER VIEW query. "CREATE_FUNCTION": CREATE FUNCTION query. "CREATE_MODEL": CREATE [OR REPLACE] MODEL ... AS SELECT ... . "CREATE_PROCEDURE": CREATE PROCEDURE query. "CREATE_TABLE": CREATE [OR REPLACE] TABLE without AS SELECT. "CREATE_TABLE_AS_SELECT": CREATE [OR REPLACE] TABLE ... AS SELECT ... . "CREATE_VIEW": CREATE [OR REPLACE] VIEW ... AS SELECT ... . "DROP_FUNCTION" : DROP FUNCTION query. "DROP_PROCEDURE": DROP PROCEDURE query. "DROP_TABLE": DROP TABLE query. "DROP_VIEW": DROP VIEW query.

ddlOperationPerformed

string

Output only. The DDL operation performed, possibly dependent on the pre-existence of the DDL target.

ddlTargetTable

object (TableReference)

Output only. The DDL target table. Present only for CREATE/DROP TABLE/VIEW queries.

ExplainQueryStage

Output only. A single stage of query execution.

JSON representation
{
  "name": string,
  "id": string,
  "startMs": string,
  "endMs": string,
  "inputStages": [
    string
  ],
  "waitRatioAvg": number,
  "waitMsAvg": string,
  "waitRatioMax": number,
  "waitMsMax": string,
  "readRatioAvg": number,
  "readMsAvg": string,
  "readRatioMax": number,
  "readMsMax": string,
  "computeRatioAvg": number,
  "computeMsAvg": string,
  "computeRatioMax": number,
  "computeMsMax": string,
  "writeRatioAvg": number,
  "writeMsAvg": string,
  "writeRatioMax": number,
  "writeMsMax": string,
  "shuffleOutputBytes": string,
  "shuffleOutputBytesSpilled": string,
  "recordsRead": string,
  "recordsWritten": string,
  "parallelInputs": string,
  "completedParallelInputs": string,
  "status": string,
  "steps": [
    {
      object (ExplainQueryStep)
    }
  ]
}
Fields
name

string

Human-readable name for the stage.

id

string (Int64Value format)

Unique ID for the stage within the plan.

startMs

string (int64 format)

Stage start time represented as milliseconds since the epoch.

endMs

string (int64 format)

Stage end time represented as milliseconds since the epoch.

inputStages[]

string (int64 format)

IDs for stages that are inputs to this stage.

waitRatioAvg

number

Relative amount of time the average shard spent waiting to be scheduled.

waitMsAvg

string (Int64Value format)

Milliseconds the average shard spent waiting to be scheduled.

waitRatioMax

number

Relative amount of time the slowest shard spent waiting to be scheduled.

waitMsMax

string (Int64Value format)

Milliseconds the slowest shard spent waiting to be scheduled.

readRatioAvg

number

Relative amount of time the average shard spent reading input.

readMsAvg

string (Int64Value format)

Milliseconds the average shard spent reading input.

readRatioMax

number

Relative amount of time the slowest shard spent reading input.

readMsMax

string (Int64Value format)

Milliseconds the slowest shard spent reading input.

computeRatioAvg

number

Relative amount of time the average shard spent on CPU-bound tasks.

computeMsAvg

string (Int64Value format)

Milliseconds the average shard spent on CPU-bound tasks.

computeRatioMax

number

Relative amount of time the slowest shard spent on CPU-bound tasks.

computeMsMax

string (Int64Value format)

Milliseconds the slowest shard spent on CPU-bound tasks.

writeRatioAvg

number

Relative amount of time the average shard spent on writing output.

writeMsAvg

string (Int64Value format)

Milliseconds the average shard spent on writing output.

writeRatioMax

number

Relative amount of time the slowest shard spent on writing output.

writeMsMax

string (Int64Value format)

Milliseconds the slowest shard spent on writing output.

shuffleOutputBytes

string (Int64Value format)

Total number of bytes written to shuffle.

shuffleOutputBytesSpilled

string (Int64Value format)

Total number of bytes written to shuffle and spilled to disk.

recordsRead

string (Int64Value format)

Number of records read into the stage.

recordsWritten

string (Int64Value format)

Number of records written by the stage.

parallelInputs

string (Int64Value format)

Number of parallel input segments to be processed

completedParallelInputs

string (Int64Value format)

Number of parallel input segments completed.

status

string

Current status for this stage.

steps[]

object (ExplainQueryStep)

tabledata.list of operations within the stage in dependency order (approximately chronological).

ExplainQueryStep

Output only. An operation within a stage.

JSON representation
{
  "kind": string,
  "substeps": [
    string
  ]
}
Fields
kind

string

Machine-readable operation type.

substeps[]

string

Human-readable description of the step(s).

QueryTimelineSample

Output only. Summary of the state of query execution at a given time.

JSON representation
{
  "elapsedMs": string,
  "totalSlotMs": string,
  "pendingUnits": string,
  "completedUnits": string,
  "activeUnits": string
}
Fields
elapsedMs

string (Int64Value format)

Milliseconds elapsed since the start of query execution.

totalSlotMs

string (Int64Value format)

Cumulative slot-ms consumed by the query.

pendingUnits

string (Int64Value format)

Total parallel units of work remaining for the active stages.

completedUnits

string (Int64Value format)

Total parallel units of work completed by this query.

activeUnits

string (Int64Value format)

Total number of active workers. This does not correspond directly to slot usage. This is the largest value observed since the last sample.

JobStatistics3

Output only. Statistics for a load job.

JSON representation
{
  "inputFiles": string,
  "inputFileBytes": string,
  "outputRows": string,
  "outputBytes": string,
  "badRecords": string
}
Fields
inputFiles

string (Int64Value format)

Output only. Number of source files in a load job.

inputFileBytes

string (Int64Value format)

Output only. Number of bytes of source data in a load job.

outputRows

string (Int64Value format)

Output only. Number of rows imported in a load job. Note that while an import job is in the running state, this value may change.

outputBytes

string (Int64Value format)

Output only. Size of the loaded data in bytes. Note that while a load job is in the running state, this value may change.

badRecords

string (Int64Value format)

Output only. The number of bad records encountered. Note that if the job has failed because of more bad records encountered than the maximum allowed in the load job configuration, then this number can be less than the total number of bad records present in the input data.

JobStatistics4

Output only. Statistics for an extract job.

JSON representation
{
  "destinationUriFileCounts": [
    string
  ],
  "inputBytes": string
}
Fields
destinationUriFileCounts[]

string (int64 format)

Output only. Number of files per destination URI or URI pattern specified in the extract configuration. These values will be in the same order as the URIs specified in the 'destinationUris' field.

inputBytes

string (Int64Value format)

Number of user bytes extracted into the result. This is the byte count as computed by BigQuery for billing purposes and doesn't have any relationship with the number of actual result bytes extracted in the desired format.

¿Te ha resultado útil esta página? Enviar comentarios:

Enviar comentarios sobre...