Package com.google.cloud.bigquery

Class JobStatistics.QueryStatistics

    • Method Detail

      • 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

      • getDdlOperationPerformed

        public String getDdlOperationPerformed()
        [BETA] For DDL queries, returns the operation applied to the DDL target table.

      • getDdlTargetTable

        public TableId getDdlTargetTable()
        [BETA] For DDL queries, returns the TableID of the targeted table.

      • getDdlTargetRoutine

        public RoutineId getDdlTargetRoutine()
        [BETA] For DDL queries, returns the RoutineId of the targeted routine.

      • getEstimatedBytesProcessed

        public Long getEstimatedBytesProcessed()
        The original estimate of bytes processed for the job.

      • getNumDmlAffectedRows

        public Long getNumDmlAffectedRows()
        The number of rows affected by a DML statement. Present only for DML statements INSERT, UPDATE or DELETE.

      • getDmlStats

        public DmlStats getDmlStats()
        Detailed statistics for DML statements.

      • getReferencedTables

        public List<TableId> getReferencedTables()
        Referenced tables for the job. Queries that reference more than 50 tables will not have a complete list.

      • 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

      • getTotalBytesBilled

        public Long getTotalBytesBilled()
        Returns the total number of bytes billed for the job.

      • getTotalBytesProcessed

        public Long getTotalBytesProcessed()
        Returns the total number of bytes processed by the job.

      • getTotalPartitionsProcessed

        public Long getTotalPartitionsProcessed()
        Total number of partitions processed from all partitioned tables referenced in the job.

      • getTotalSlotMs

        public Long getTotalSlotMs()
        Returns the slot-milliseconds consumed by the query.

      • 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

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

      • getSchema

        public Schema getSchema()
        Returns the schema for the query result. Present only for successful dry run of non-legacy SQL queries.

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

      • getQueryParameters

        public List<com.google.api.services.bigquery.model.QueryParameter> getQueryParameters()
        Standard SQL only: Returns a list of undeclared query parameters detected during a dry run validation.

      • equals

        public final boolean equals​(Object obj)
        Overrides:
        equals in class Object

      • hashCode

        public final int hashCode()
        Overrides:
        hashCode in class Object