PR Statistics from gh CLI Output

Fetching PR Data with Timestamps

gh pr list --repo owner/repo --state all \
  --search "created:2024-12-01..2024-12-31" \
  --limit 500 \
  --json number,state,author,createdAt,mergedAt

The author field returns an object: {"login": "username"}. The state field returns: OPEN, CLOSED, or MERGED.

Computing Average Merge Time with jq

# Filter merged PRs and compute average days to merge
echo "$pr_json" | jq '
  [.[] | select(.state == "MERGED") |
    { created: (.createdAt | fromdateiso8601),
      merged: (.mergedAt | fromdateiso8601) } |
    (.merged - .created) / 86400
  ] | add / length
'

• fromdateiso8601 converts ISO 8601 strings to Unix epoch seconds.
• Divide difference by 86400 to get days.
• add / length computes the mean.

Finding Top Contributor

echo "$pr_json" | jq '
  group_by(.author.login) |
  map({login: .[0].author.login, count: length}) |
  sort_by(-.count) |
  .[0]
'

Counting by State

echo "$pr_json" | jq '{
  total: length,
  merged: [.[] | select(.state == "MERGED")] | length,
  closed: [.[] | select(.state == "CLOSED")] | length
}'

Note: In gh CLI output, CLOSED and MERGED are distinct states. A merged PR has state MERGED, not CLOSED.