Send feedback
Class JobStatistics.QueryStatistics (2.40.2)
Stay organized with collections
Save and categorize content based on your preferences.
Version 2.40.2 keyboard_arrow_down
public static class JobStatistics . QueryStatistics extends JobStatistics
A Google BigQuery Query Job statistics.
Methods
equals(Object obj)
public final boolean equals ( Object obj )
Parameter
Name
Description
obj
Object
Overrides
getBiEngineStats()
public BiEngineStats getBiEngineStats ()
Returns query statistics specific to the use of BI Engine.
getBillingTier()
public Integer getBillingTier ()
Returns the billing tier for the job.
getCacheHit()
public Boolean getCacheHit ()
Returns whether the query result was fetched from the query cache.
See Also: Query Caching
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.
getDdlTargetTable()
public TableId getDdlTargetTable ()
[BETA] For DDL queries, returns the TableID of the targeted table.
getDmlStats()
public DmlStats getDmlStats ()
Detailed statistics for DML statements.
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.
public MetadataCacheStats getMetadataCacheStats ()
Statistics for metadata caching in BigLake tables.
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
getReferencedTables()
public List<TableId> getReferencedTables ()
Referenced tables for the job. Queries that reference more than 50 tables will not have a
complete list.
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.
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
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.
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
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-10-04 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
Need to tell us more?
{"lastModified": "Last updated 2024-10-04 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-04 UTC."]]