Merge request analytics
- Tier: Premium, Ultimate
- Offering: GitLab.com, GitLab Self-Managed, GitLab Dedicated
Analytics mode returns aggregated metrics for merge requests, with data typically available within 10 minutes.
To query individual merge request records, use Merge requests.
Allowed scopes
| Scope | Description |
|---|---|
project | Query merge requests in a specific project. |
group | Query merge requests across all projects in a group, including subgroups. |
To aggregate merge requests across multiple groups or projects, use a list with the in operator.
For more information, see multiple groups and projects.
Query fields
Use these fields in the query parameter to filter your results.
| Field | Name | Operators |
|---|---|---|
| Created at | created | =, >, <, >=, <= |
| Created by Duo | createdByDuo | =, != |
| Merged at | merged | =, >, <, >=, <= |
| State | state | =, in |
| Target branch | targetBranch | =, in |
Created at
Description: Filter merge requests by their creation date.
Allowed value types:
AbsoluteDate(in the formatYYYY-MM-DD)RelativeDate(in the format<sign><digit><unit>, where sign is+,-, or omitted, digit is an integer, andunitis one ofd(days),w(weeks),m(months) ory(years))
Notes:
- For the
=operator, the time range is considered from 00:00 to 23:59 in the user’s time zone.
Created by Duo
Description: Filter merge requests by whether a GitLab Duo Agent Platform session created them.
Allowed value types:
Boolean(trueorfalse)
Merged at
Description: Filter merge requests by their merge date.
Allowed value types:
AbsoluteDate(in the formatYYYY-MM-DD)RelativeDate(in the format<sign><digit><unit>, where sign is+,-, or omitted, digit is an integer, andunitis one ofd(days),w(weeks),m(months) ory(years))
Notes:
- For the
=operator, the time range is considered from 00:00 to 23:59 in the user’s time zone.
State
Description: Filter merge requests by their state.
Allowed value types:
Enum, one ofopened,closed,merged, orlockedList(useinoperator for multiple values)
Notes:
- The
allvalue is not supported. To include merge requests in all states, omit the filter.
Target branch
Description: Filter merge requests by their target branch.
Allowed value types:
StringList(useinoperator for multiple values)
Dimensions
| Dimension | Name | Description |
|---|---|---|
| Created at | created | Group by creation date. Accepts a granularity parameter of daily, weekly, or monthly (default: weekly). For example, created(monthly). |
| Created by Duo | createdByDuo | Group by whether a GitLab Duo Agent Platform session created the merge request. |
| Merged at | merged | Group by merge date. Accepts a granularity parameter of daily, weekly, or monthly (default: weekly). For example, merged(monthly). |
| State | state | Group by merge request state. |
| Target branch | targetBranch | Group by target branch. |
Metrics
| Metric | Name | Description |
|---|---|---|
| Acceptance rate | acceptanceRate | Share of merge requests that were merged. |
| Throughput count | throughputCount | Number of merged merge requests. |
| Time to merge max | timeToMergeMax | Longest time from creation to merge, in seconds. |
| Time to merge mean | timeToMergeMean | Average time from creation to merge, in seconds. |
| Time to merge min | timeToMergeMin | Shortest time from creation to merge, in seconds. |
| Time to merge quantile | timeToMergeQuantile | Time from creation to merge, in seconds, rendered as a duration. For example, 1d 2h. Accepts a quantile parameter between 0.01 and 0.99 (default: 0.5, the median). For example, timeToMergeQuantile(0.95). |
| Time to merge sum | timeToMergeSum | Total time from creation to merge across all merged merge requests, in seconds. |
| Total count | totalCount | Total number of merge requests. |
Sort fields
Sort by any field included in your selected dimensions or metrics. For more information, see analytics mode sorting.
Examples
Weekly merge request throughput trend for the last 30 days:
```glql title: "Weekly merge request throughput (last 30 days)" display: table mode: analytics query: type = MergeRequest and project = "gitlab-org/gitlab" and merged > -30d dimensions: merged(weekly) as "Week" metrics: totalCount as "Total", throughputCount as "Merged", timeToMergeQuantile(0.5) as "Median time to merge" sort: merged desc ```Median and p95 time to merge by week:
```glql title: "Median and p95 time to merge by week" display: table mode: analytics query: type = MergeRequest and project = "gitlab-org/gitlab" and merged > -90d dimensions: merged(weekly) as "Week" metrics: timeToMergeQuantile(0.5) as "Median time to merge", timeToMergeQuantile(0.95) as "p95 time to merge" sort: merged desc ```Merge requests grouped by state:
```glql title: "Merge requests by state (last 30 days)" display: table mode: analytics query: type = MergeRequest and project = "gitlab-org/gitlab" and created > -30d dimensions: state as "State" metrics: totalCount as "Total" sort: totalCount desc ```Throughput per target branch across a group:
```glql title: "Merge request throughput by target branch" display: table mode: analytics query: type = MergeRequest and group = "gitlab-org" and merged > -30d dimensions: targetBranch as "Target branch" metrics: totalCount as "Total", throughputCount as "Merged" sort: throughputCount desc ```Acceptance rate of merge requests created by GitLab Duo compared to other merge requests:
```glql title: "Merge request acceptance rate by origin (last 30 days)" display: table mode: analytics query: type = MergeRequest and group = "gitlab-org" and created > -30d dimensions: createdByDuo as "Created by Duo" metrics: totalCount as "Total", throughputCount as "Merged", acceptanceRate as "Acceptance rate" sort: totalCount desc ```Overall merge request count for a group, without grouping:
```glql title: "Merge requests created in the last 7 days" display: table mode: analytics query: type = MergeRequest and group = "gitlab-org" and created > -7d metrics: totalCount as "Total" ```