The time it takes from when a PR is issued until the first comment is added to that PR.
PR Pickup Time shows how engaged your team is in collaborative work by identifying the delay in picking up PRs.
Data Sources Required
This metric relies on PRs/MRs collected from GitHub, GitLab, BitBucket, Gitee or other code review tools.
Data Transformation Required
N/A
SQL Queries
The following SQL shows how to find the pickup time
of a specific PR. DevLake pre-calculates the metric and stores it in table.pull_requests.
SELECT review_lag/60 as 'PR Pickup Time(h)' FROM pull_requests
If you want to measure the monthly trend of PR pickup time
in the screenshot below, please run the following SQL in Grafana.
SELECT DATE_ADD(date(created_date), INTERVAL -DAY(date(created_date))+1 DAY) as time, avg(review_lag)/60 as 'PR Pickup Time(h)' FROM pull_requests GROUP BY 1 ORDER BY 1