GitHub GraphQL to retrieve run times for a particular GHA job

workflow-run-times.csv

workflow-run-times.graphql

query GetWorkflowJobRunTimes {
  resource(url: "https://github.com/getsentry/snuba/actions/workflows/ci.yml") {
    ... on Workflow {
      name
      runs(first: 100, orderBy: { field: CREATED_AT, direction: DESC }) {
        nodes {
          createdAt
          checkSuite {
            checkRuns(
              first: 1
              filterBy: { checkName: "self-hosted-end-to-end" }
            ) {
              nodes {
                name
                startedAt
                completedAt
                conclusion
                detailsUrl
              }
            }
          }
        }
      }
    }
  }
}

workflow-run-times.jq

.
| [
    .data.resource.runs.nodes[].checkSuite[].nodes[]
    | select(.completedAt and .startedAt)
    | .duration = (.completedAt | fromdateiso8601) - (.startedAt | fromdateiso8601)
]
| sort_by(.startedAt)


# convert array of objects to CSV
| (.[0] | keys_unsorted) as $keys
| ( $keys
  , ( .[] | [.[$keys[]]])
  )
| @csv

workflow-run-times.sh

#!/bin/sh
gh api graphql --field [email protected] |
  jq -crf ./workflow-run-times.jq |
  tee workflow-run-times.csv \
;