Skip to content
Partner Developer Portal byOptum

Schema

Column NameData TypeDescription
usrvarcharCognito username of the user who submitted the query
queryvarcharFull SQL text of the executed query
query_statevarcharLifecycle state of the query (for example FINISHED, FAILED, RUNNING)
query_planvarcharInternal execution plan produced by the query engine
query_typevarcharCategory of the query (for example SELECT, INSERT)
total_rowsbigintTotal number of rows read or processed during execution
output_rowsbigintNumber of rows returned to the caller
cpu_time_msbigintTotal CPU time consumed across all workers, in milliseconds
wall_time_msbigintEnd-to-end elapsed (wall-clock) time, in milliseconds
queued_time_msbigintTime the query spent waiting in the scheduler queue before execution started, in milliseconds
cumulative_memorybigintPeak cumulative memory allocated across all query stages, in bytes
analysis_timevarcharDuration of the query analysis (planning) phase
execution_timevarcharDuration of the actual execution phase
create_timetimestampTimestamp when the query was submitted to the engine
end_timetimestampTimestamp when the query completed (successfully or otherwise)
failure_infovarcharStructured failure details when query_state is FAILED; NULL for successful queries