Class JobStatistics.QueryStatistics (2.37.0)

public static class JobStatistics.QueryStatistics extends JobStatistics

A Google BigQuery Query Job statistics.

Inheritance

Object > JobStatistics > JobStatistics.QueryStatistics

Methods

equals(Object obj)

public final boolean equals(Object obj)
Parameter
NameDescription
objObject
Returns
TypeDescription
boolean
Overrides

getBiEngineStats()

public BiEngineStats getBiEngineStats()

Returns query statistics specific to the use of BI Engine.

Returns
TypeDescription
BiEngineStats

getBillingTier()

public Integer getBillingTier()

Returns the billing tier for the job.

Returns
TypeDescription
Integer

getCacheHit()

public Boolean getCacheHit()

Returns whether the query result was fetched from the query cache. See Also: Query Caching

Returns
TypeDescription
Boolean

getDdlOperationPerformed()

public String getDdlOperationPerformed()

[BETA] For DDL queries, returns the operation applied to the DDL target table.

Returns
TypeDescription
String

getDdlTargetRoutine()

public RoutineId getDdlTargetRoutine()

[BETA] For DDL queries, returns the RoutineId of the targeted routine.

Returns
TypeDescription
RoutineId

getDdlTargetTable()

public TableId getDdlTargetTable()

[BETA] For DDL queries, returns the TableID of the targeted table.

Returns
TypeDescription
TableId

getDmlStats()

public DmlStats getDmlStats()

Detailed statistics for DML statements.

Returns
TypeDescription
DmlStats

getEstimatedBytesProcessed()

public Long getEstimatedBytesProcessed()

The original estimate of bytes processed for the job.

Returns
TypeDescription
Long

getNumDmlAffectedRows()

public Long getNumDmlAffectedRows()

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

Returns
TypeDescription
Long

getQueryParameters()

public List<QueryParameter> getQueryParameters()

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

Returns
TypeDescription
List<com.google.api.services.bigquery.model.QueryParameter>

getQueryPlan()

public List<QueryStage> getQueryPlan()

Returns the query plan as a list of stages or null if a query plan is not available. Each stage involves a number of steps that read from data sources, perform a series of transformations on the input, and emit an output to a future stage (or the final result). The query plan is available for a completed query job and is retained for 7 days. See Also: Query Plan

Returns
TypeDescription
List<QueryStage>

getReferencedTables()

public List<TableId> getReferencedTables()

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

Returns
TypeDescription
List<TableId>

getSchema()

public Schema getSchema()

Returns the schema for the query result. Present only for successful dry run of non-legacy SQL queries.

Returns
TypeDescription
Schema

getSearchStats()

public SearchStats getSearchStats()

Statistics for a search query. Populated as part of JobStatistics2. Provides information about how indexes are used in search queries. If an index is not used, you can retrieve debugging information about the reason why.

Returns
TypeDescription
SearchStats

getStatementType()

public JobStatistics.QueryStatistics.StatementType getStatementType()

[BETA] The type of query statement, if valid. Possible values include: SELECT INSERT UPDATE DELETE CREATE_TABLE CREATE_TABLE_AS_SELECT DROP_TABLE CREATE_VIEW DROP_VIEW

Returns
TypeDescription
JobStatistics.QueryStatistics.StatementType

getTimeline()

public List<TimelineSample> getTimeline()

Return the timeline for the query, as a list of timeline samples. Each sample provides information about the overall progress of the query. Information includes time of the sample, progress reporting on active, completed, and pending units of work, as well as the cumulative estimation of slot-milliseconds consumed by the query.

Returns
TypeDescription
List<TimelineSample>

getTotalBytesBilled()

public Long getTotalBytesBilled()

Returns the total number of bytes billed for the job.

Returns
TypeDescription
Long

getTotalBytesProcessed()

public Long getTotalBytesProcessed()

Returns the total number of bytes processed by the job.

Returns
TypeDescription
Long

getTotalPartitionsProcessed()

public Long getTotalPartitionsProcessed()

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

Returns
TypeDescription
Long

getTotalSlotMs()

public Long getTotalSlotMs()

Returns the slot-milliseconds consumed by the query.

Returns
TypeDescription
Long

hashCode()

public final int hashCode()
Returns
TypeDescription
int
Overrides