Class JobStatistics.QueryStatistics (2.46.0)

publicstaticclass JobStatistics.QueryStatisticsextendsJobStatistics

A Google BigQuery Query Job statistics.

Inheritance

Object > JobStatistics > JobStatistics.QueryStatistics

Inherited Members

publicfinalbooleanequals(Objectobj)

Object.equals(Object)

publicBiEngineStatsgetBiEngineStats()

Returns query statistics specific to the use of BI Engine.

publicIntegergetBillingTier()

Returns the billing tier for the job.

publicBooleangetCacheHit()

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

publicStringgetDdlOperationPerformed()

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

publicRoutineIdgetDdlTargetRoutine()

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

publicTableIdgetDdlTargetTable()

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

publicDmlStatsgetDmlStats()

Detailed statistics for DML statements.

publicLonggetEstimatedBytesProcessed()

The original estimate of bytes processed for the job.

publicJobStatistics.QueryStatistics.ExportDataStatsgetExportDataStats()

Detailed statistics for EXPORT DATA statement.

publicMetadataCacheStatsgetMetadataCacheStats()

Statistics for metadata caching in BigLake tables.

publicLonggetNumDmlAffectedRows()

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

publicList<QueryParameter>getQueryParameters()

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

publicList<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

publicList<TableId>getReferencedTables()

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

publicSchemagetSchema()

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

publicSearchStatsgetSearchStats()

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.

publicJobStatistics.QueryStatistics.StatementTypegetStatementType()

[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

publicList<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.

publicLonggetTotalBytesBilled()

Returns the total number of bytes billed for the job.

publicLonggetTotalBytesProcessed()

Returns the total number of bytes processed by the job.

publicLonggetTotalPartitionsProcessed()

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

publicfinalinthashCode()

Object.hashCode()