Class JobStatistics.QueryStatistics (2.45.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
Name Description
obj Object
Returns
Type Description
boolean
Overrides

getBiEngineStats()

public BiEngineStats getBiEngineStats()

Returns query statistics specific to the use of BI Engine.

Returns
Type Description
BiEngineStats

getBillingTier()

public Integer getBillingTier()

Returns the billing tier for the job.

Returns
Type Description
Integer

getCacheHit()

public Boolean getCacheHit()

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

Returns
Type Description
Boolean

getDdlOperationPerformed()

public String getDdlOperationPerformed()

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

Returns
Type Description
String

getDdlTargetRoutine()

public RoutineId getDdlTargetRoutine()

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

Returns
Type Description
RoutineId

getDdlTargetTable()

public TableId getDdlTargetTable()

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

Returns
Type Description
TableId

getDmlStats()

public DmlStats getDmlStats()

Detailed statistics for DML statements.

Returns
Type Description
DmlStats

getEstimatedBytesProcessed()

public Long getEstimatedBytesProcessed()

The original estimate of bytes processed for the job.

Returns
Type Description
Long

getExportDataStats()

public JobStatistics.QueryStatistics.ExportDataStats getExportDataStats()

Detailed statistics for EXPORT DATA statement.

Returns
Type Description
JobStatistics.QueryStatistics.ExportDataStats

getMetadataCacheStats()

public MetadataCacheStats getMetadataCacheStats()

Statistics for metadata caching in BigLake tables.

Returns
Type Description
MetadataCacheStats

getNumDmlAffectedRows()

public Long getNumDmlAffectedRows()

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

Returns
Type Description
Long

getQueryParameters()

public List<QueryParameter> getQueryParameters()

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

Returns
Type Description
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
Type Description
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
Type Description
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
Type Description
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
Type Description
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
Type Description
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
Type Description
List<TimelineSample>

getTotalBytesBilled()

public Long getTotalBytesBilled()

Returns the total number of bytes billed for the job.

Returns
Type Description
Long

getTotalBytesProcessed()

public Long getTotalBytesProcessed()

Returns the total number of bytes processed by the job.

Returns
Type Description
Long

getTotalPartitionsProcessed()

public Long getTotalPartitionsProcessed()

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

Returns
Type Description
Long

hashCode()

public final int hashCode()
Returns
Type Description
int
Overrides