Skip to content

Instantly share code, notes, and snippets.

@l1x

l1x/athena_size_time_statistics.sh

Last active September 17, 2019 09:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save l1x/b3a57067291f042b067319552baa0abe to your computer and use it in GitHub Desktop.
Save l1x/b3a57067291f042b067319552baa0abe to your computer and use it in GitHub Desktop.
Download ZIP
One liner to print out runtime statistics for the last N Athena queries
Raw
athena_size_time_statistics.sh
export PROFILE=foxi-maxi
export REGION=eu-west-1
aws --region $REGION --profile $PROFILE athena list-query-executions --max-items 10 \
| jq '.QueryExecutionIds[]' \
| xargs -I {} aws --region $REGION --profile $PROFILE athena get-query-execution --query-execution-id {} \
| jq '.QueryExecution.Statistics'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment