Public PR review timing snapshot for appwrite/appwrite

[xpinc17]

Hi Appwrite maintainers,

I put together a small read-only analysis of recent public PR review timing for appwrite/appwrite. This is based only on public GitHub data, with no app install and nothing posted back to the repository.

The short version: the project appears to move most PRs very quickly, but a small review tail still shows up in the public data. In the 2026-03-09 → 2026-06-07 window:

• 717 PRs were analyzed
• 15 PRs waited more than 48h for a first review
• 14 approved PRs remained unmerged for more than 48h after their last approval
• Median first-review wait was very low, around 0.1h
• The cumulative observed first-review wait was about 47.9 PR-days

So this does not look like a broad review-speed problem. It looks more like the kind of aging-queue visibility issue that can happen in a very active repo: most work moves fast, while a few items can still sit long enough to slip out of view.

A few longest observed first-review waits from the window:

• #11867 — 20.9 days
• #12182 — 10.6 days
• #12324 — 8.9 days

Method caveats:

• This is a historical, read-only estimate from public GitHub data.
• It may not reflect internal reviewer load, branch protection, prioritization, or project policy.
• Aggregate first-review wait may use merge/close time as a fallback when no first-review timestamp is visible.
• The longest-wait examples only include PRs with observed first-review timestamps.

I’m building ApprovalOps, a tool for surfacing aging review items earlier. I’m sharing this because the snapshot seemed potentially useful for a high-volume repo like Appwrite, and I’d be happy to share the methodology or run another read-only window if useful.