Get Query Runtime Statistics

athena_get_query_runtime_statistics

R Documentation

Returns query execution runtime statistics related to a single execution of a query if you have access to the workgroup in which the query ran

Description

Returns query execution runtime statistics related to a single execution of a query if you have access to the workgroup in which the query ran. Statistics from the Timeline section of the response object are available as soon as QueryExecutionStatus$State is in a SUCCEEDED or FAILED state. The remaining non-timeline statistics in the response (like stage-level input and output row count and data size) are updated asynchronously and may not be available immediately after a query completes. The non-timeline statistics are also not included when a query has row-level filters defined in Lake Formation.

Usage

athena_get_query_runtime_statistics(QueryExecutionId)

Arguments

QueryExecutionId

[required] The unique ID of the query execution.

Value

A list with the following syntax:

list(
  QueryRuntimeStatistics = list(
    Timeline = list(
      QueryQueueTimeInMillis = 123,
      ServicePreProcessingTimeInMillis = 123,
      QueryPlanningTimeInMillis = 123,
      EngineExecutionTimeInMillis = 123,
      ServiceProcessingTimeInMillis = 123,
      TotalExecutionTimeInMillis = 123
    ),
    Rows = list(
      InputRows = 123,
      InputBytes = 123,
      OutputBytes = 123,
      OutputRows = 123
    ),
    OutputStage = list(
      StageId = 123,
      State = "string",
      OutputBytes = 123,
      OutputRows = 123,
      InputBytes = 123,
      InputRows = 123,
      ExecutionTime = 123,
      QueryStagePlan = list(
        Name = "string",
        Identifier = "string",
        Children = list(
          list()
        ),
        RemoteSources = list(
          "string"
        )
      ),
      SubStages = list(
        list()
      )
    )
  )
)

Request syntax

svc$get_query_runtime_statistics(
  QueryExecutionId = "string"
)