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.project_pr_metrics.
SELECT pr_pickup_time/60 as 'PR Pickup Time(h)' FROM project_pr_metrics
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(pr.created_date), INTERVAL -DAY(date(pr.created_date))+1 DAY) as time, avg(ppm.pr_pickup_time)/60 as 'PR Pickup Time(h)' FROM pull_requests pr JOIN project_pr_metrics ppm ON pr.id = ppm.id GROUP BY 1 ORDER BY 1