Skip to content

Instantly share code, notes, and snippets.

@vakaobr
Created September 18, 2019 14:57
Show Gist options
  • Save vakaobr/b82f3dee2a7465ca96dbd0b46b6ca795 to your computer and use it in GitHub Desktop.
Save vakaobr/b82f3dee2a7465ca96dbd0b46b6ca795 to your computer and use it in GitHub Desktop.
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": "-- Grafana --",
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
"description": "This leverages the Prometheus exporter I wrote to fetch information about GitLab CI pipelines status.\n\nhttps://github.com/mvisonneau/gitlab-ci-pipelines-exporter",
"editable": true,
"gnetId": 10620,
"graphTooltip": 0,
"id": 6,
"links": [],
"panels": [
{
"bgColor": null,
"clockType": "24 hour",
"countdownSettings": {
"customFormat": null,
"endCountdownTime": "2019-09-08T15:51:00.000Z",
"endText": "00:00:00"
},
"dateSettings": {
"dateFormat": "DD-MM-YYYY",
"fontSize": "18px",
"fontWeight": "normal",
"showDate": true
},
"gridPos": {
"h": 4,
"w": 3,
"x": 0,
"y": 0
},
"id": 112,
"mode": "time",
"options": {},
"refreshSettings": {
"syncWithDashboard": false
},
"timeFrom": null,
"timeSettings": {
"customFormat": "HH:mm:ss",
"fontSize": "50px",
"fontWeight": "normal"
},
"timeShift": null,
"timezone": "Europe/Lisbon",
"timezoneSettings": {
"fontSize": "18px",
"fontWeight": "normal",
"showTimezone": true,
"zoneFormat": "nameOffset"
},
"title": "",
"type": "grafana-clock-panel"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"decimals": 1,
"format": "dtdurations",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 3,
"x": 3,
"y": 0
},
"id": 106,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": true
},
"tableColumn": "",
"targets": [
{
"expr": "avg(gitlab_ci_pipeline_last_run_duration_seconds)",
"format": "time_series",
"intervalFactor": 1,
"refId": "A"
}
],
"thresholds": "180,300",
"timeFrom": null,
"timeShift": null,
"title": "Average Pipeline Duration",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": false,
"colorValue": false,
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#C4162A"
],
"decimals": 1,
"format": "dtdurations",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 4,
"x": 6,
"y": 0
},
"id": 108,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": true
},
"tableColumn": "",
"targets": [
{
"expr": "avg(gitlab_ci_pipeline_time_since_last_run_seconds)",
"format": "time_series",
"intervalFactor": 1,
"refId": "A"
}
],
"thresholds": "5184000,15552000",
"timeFrom": null,
"timeShift": null,
"title": "Average Pipeline Run Frequency",
"type": "singlestat",
"valueFontSize": "80%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"cacheTimeout": null,
"colorBackground": true,
"colorValue": false,
"colors": [
"#299c46",
"#C4162A",
"#d44a3a"
],
"decimals": 0,
"format": "none",
"gauge": {
"maxValue": 100,
"minValue": 0,
"show": false,
"thresholdLabels": false,
"thresholdMarkers": true
},
"gridPos": {
"h": 4,
"w": 2,
"x": 10,
"y": 0
},
"id": 107,
"interval": null,
"links": [],
"mappingType": 1,
"mappingTypes": [
{
"name": "value to text",
"value": 1
},
{
"name": "range to text",
"value": 2
}
],
"maxDataPoints": 100,
"nullPointMode": "connected",
"nullText": null,
"options": {},
"postfix": "",
"postfixFontSize": "50%",
"prefix": "",
"prefixFontSize": "50%",
"rangeMaps": [
{
"from": "null",
"text": "N/A",
"to": "null"
}
],
"sparkline": {
"fillColor": "rgba(31, 118, 189, 0.18)",
"full": false,
"lineColor": "rgb(31, 120, 193)",
"show": true
},
"tableColumn": "",
"targets": [
{
"expr": "count(gitlab_ci_pipeline_last_run_status{status=\"failed\"} > 0) or vector(0)",
"format": "time_series",
"instant": false,
"intervalFactor": 1,
"refId": "A"
}
],
"thresholds": "1",
"timeFrom": null,
"timeShift": null,
"title": "FAILED",
"type": "singlestat",
"valueFontSize": "120%",
"valueMaps": [
{
"op": "=",
"text": "N/A",
"value": "null"
}
],
"valueName": "current"
},
{
"colors": [
"#299c46",
"rgba(237, 129, 40, 0.89)",
"#d44a3a"
],
"gridPos": {
"h": 4,
"w": 12,
"x": 12,
"y": 0
},
"id": 110,
"links": [],
"options": {},
"polystat": {
"animationSpeed": 5000,
"columnAutoSize": true,
"columns": 15,
"defaultClickThrough": "",
"defaultClickThroughSanitize": false,
"displayLimit": 100,
"fontAutoScale": true,
"fontSize": 12,
"fontType": "Roboto",
"globalDecimals": 2,
"globalDisplayMode": "all",
"globalDisplayTextTriggeredEmpty": "OK",
"globalOperatorName": "avg",
"globalUnitFormat": "short",
"gradientEnabled": false,
"hexagonSortByDirection": "asc",
"hexagonSortByField": "value",
"maxMetrics": 0,
"polygonBorderColor": "#10111c",
"polygonBorderSize": 1,
"polygonGlobalFillColor": "#0a50a1",
"radius": 17,
"radiusAutoSize": false,
"rowAutoSize": false,
"rows": 10,
"shape": "hexagon_pointed_top",
"tooltipDisplayMode": "all",
"tooltipDisplayTextTriggeredEmpty": "OK",
"tooltipFontSize": 12,
"tooltipFontType": "Roboto",
"tooltipPrimarySortDirection": "desc",
"tooltipPrimarySortField": "thresholdLevel",
"tooltipSecondarySortDirection": "desc",
"tooltipSecondarySortField": "value",
"tooltipTimestampEnabled": false
},
"savedComposites": [],
"savedOverrides": [
{
"clickThrough": "MYAWESOMEGITLABURL/${__cell:raw}/pipelines",
"colors": [
"#299c46",
"#e5ac0e",
"#bf1b00",
"#ffffff"
],
"decimals": "",
"enabled": true,
"label": "OVERRIDE 1",
"metricName": "/.*/",
"operatorName": "current",
"prefix": "",
"sanitizeURLEnabled": true,
"scaledDecimals": null,
"suffix": "",
"thresholds": [
{
"color": "#299c46",
"state": 0,
"value": 1
},
{
"color": "#1F60C4",
"state": 3,
"value": 2
},
{
"color": "#bf1b00",
"state": 2,
"value": 3
}
],
"unitFormat": "short"
}
],
"targets": [
{
"expr": "(gitlab_ci_pipeline_last_run_status{status=\"success\"} * 1 > 0) or (gitlab_ci_pipeline_last_run_status{status=\"running\"} * 2 > 0) or (gitlab_ci_pipeline_last_run_status{status=\"failed\"} * 3 > 0)",
"format": "time_series",
"hide": false,
"instant": true,
"intervalFactor": 1,
"legendFormat": "{{project}}",
"refId": "A"
}
],
"timeFrom": null,
"timeShift": null,
"title": "Status of All Pipelines",
"transparent": true,
"type": "grafana-polystat-panel"
},
{
"columns": [],
"fontSize": "100%",
"gridPos": {
"h": 21,
"w": 12,
"x": 0,
"y": 4
},
"id": 103,
"interval": "",
"links": [],
"options": {},
"pageSize": null,
"scroll": true,
"showHeader": true,
"sort": {
"col": 2,
"desc": false
},
"styles": [
{
"alias": "Time",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "Status",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"#1F60C4",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "Value #A",
"preserveFormat": false,
"sanitize": false,
"thresholds": [
"2"
],
"type": "string",
"unit": "short",
"valueMaps": [
{
"text": "OK",
"value": "1"
},
{
"text": "RUNNING",
"value": "2"
}
]
},
{
"alias": "Last run",
"colorMode": null,
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Value #B",
"thresholds": [
""
],
"type": "number",
"unit": "s"
},
{
"alias": "Duration",
"colorMode": null,
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "Value #C",
"thresholds": [
""
],
"type": "number",
"unit": "dtdurations"
},
{
"alias": "Repository",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": true,
"linkTargetBlank": true,
"linkTooltip": "Go to pipeline",
"linkUrl": "MYAWESOMEGITLABURL/${__cell:raw}/pipelines/${__cell_6:raw}",
"mappingType": 1,
"pattern": "project",
"thresholds": [],
"type": "string",
"unit": "short",
"valueMaps": []
},
{
"alias": "Branch",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "ref",
"thresholds": [],
"type": "string",
"unit": "short",
"valueMaps": []
},
{
"alias": "Latest ID",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"link": true,
"linkTargetBlank": true,
"linkTooltip": "Go to pipeline",
"linkUrl": "MYAWESOMEGITLABURL/${__cell_1:raw}/pipelines/${__cell:raw}",
"mappingType": 1,
"pattern": "Value #D",
"sanitize": false,
"thresholds": [
"*"
],
"type": "string",
"unit": "none"
},
{
"alias": "",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"decimals": 2,
"pattern": "/.*/",
"thresholds": [],
"type": "number",
"unit": "short"
}
],
"targets": [
{
"expr": "max(gitlab_ci_pipeline_time_since_last_run_seconds) by (project, ref) unless (min(gitlab_ci_pipeline_last_run_status{status=~\"failed\"}) by (ref, project) > 0)",
"format": "table",
"instant": true,
"intervalFactor": 1,
"refId": "B"
},
{
"expr": "max(gitlab_ci_pipeline_last_run_duration_seconds) by (project, ref) unless (min(gitlab_ci_pipeline_last_run_status{status=~\"failed\"}) by (ref, project) > 0)",
"format": "table",
"hide": false,
"instant": true,
"intervalFactor": 1,
"refId": "C"
},
{
"expr": "min(gitlab_ci_pipeline_last_run_status{status=~\"success\"} * 1) by (project, ref) > 0 ",
"format": "table",
"instant": true,
"intervalFactor": 1,
"refId": "A"
},
{
"expr": "(min(gitlab_ci_pipeline_last_run_status{status=~\"success\"} * 1) by (project, ref) > 0) + on(project, ref) group_left(id) ( gitlab_ci_pipeline_last_run_id -1 )",
"format": "table",
"instant": true,
"refId": "D"
}
],
"timeFrom": null,
"timeShift": null,
"title": "HEALTHY",
"transform": "table",
"type": "table"
},
{
"columns": [],
"fontSize": "100%",
"gridPos": {
"h": 10,
"w": 12,
"x": 12,
"y": 4
},
"id": 113,
"links": [],
"options": {},
"pageSize": null,
"scroll": true,
"showHeader": true,
"sort": {
"col": 3,
"desc": false
},
"styles": [
{
"alias": "Time",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "Status",
"colorMode": "row",
"colors": [
"rgba(50, 172, 45, 0.97)",
"#1F60C4",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"link": false,
"mappingType": 1,
"pattern": "Value",
"preserveFormat": false,
"sanitize": false,
"thresholds": [
"2"
],
"type": "string",
"unit": "short",
"valueMaps": [
{
"text": "RUNNING",
"value": "2"
}
]
},
{
"alias": "Branch",
"colorMode": "cell",
"colors": [
"#1F60C4",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "ref",
"thresholds": [
""
],
"type": "string",
"unit": "short"
},
{
"alias": "Repository",
"colorMode": "cell",
"colors": [
"#1F60C4",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": true,
"linkTargetBlank": true,
"linkTooltip": "Open repository pipelines page",
"linkUrl": "MYAWESOMEGITLABURL/${__cell:raw}/pipelines",
"mappingType": 1,
"pattern": "project",
"thresholds": [
""
],
"type": "string",
"unit": "short"
},
{
"alias": "",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"decimals": 2,
"pattern": "/.*/",
"thresholds": [],
"type": "number",
"unit": "short"
}
],
"targets": [
{
"expr": "min(gitlab_ci_pipeline_last_run_status{status=~\"running\"} * 2) by (project, ref) > 0",
"format": "table",
"instant": true,
"intervalFactor": 1,
"legendFormat": "{{project}}",
"refId": "A"
}
],
"timeFrom": null,
"timeShift": null,
"title": "RUNNING",
"transform": "table",
"type": "table"
},
{
"columns": [],
"fontSize": "100%",
"gridPos": {
"h": 11,
"w": 12,
"x": 12,
"y": 14
},
"id": 104,
"links": [
{
"title": "",
"url": ""
}
],
"options": {},
"pageSize": 10,
"scroll": true,
"showHeader": true,
"sort": {
"col": 3,
"desc": false
},
"styles": [
{
"alias": "Time",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "Status",
"colorMode": "cell",
"colors": [
"rgba(245, 54, 54, 0.9)",
"#1F60C4",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": false,
"mappingType": 1,
"pattern": "Value #A",
"preserveFormat": false,
"sanitize": false,
"thresholds": [
"2"
],
"type": "string",
"unit": "short",
"valueMaps": [
{
"text": "FAILED",
"value": "1"
}
]
},
{
"alias": "Last run",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 0,
"mappingType": 1,
"pattern": "Value #B",
"thresholds": [
"172800",
"432000"
],
"type": "number",
"unit": "s"
},
{
"alias": "Duration",
"colorMode": "cell",
"colors": [
"rgba(50, 172, 45, 0.97)",
"rgba(237, 129, 40, 0.89)",
"rgba(245, 54, 54, 0.9)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 1,
"mappingType": 1,
"pattern": "Value #C",
"thresholds": [
"900",
"1200"
],
"type": "number",
"unit": "dtdurations"
},
{
"alias": "Branch",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "ref",
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "Repository",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"link": true,
"linkTargetBlank": true,
"linkTooltip": "Open Repository Pipelines Page",
"linkUrl": "MYAWESOMEGITLABURL/${__cell:raw}/pipelines",
"mappingType": 1,
"pattern": "project",
"preserveFormat": false,
"sanitize": false,
"thresholds": [],
"type": "string",
"unit": "short"
},
{
"alias": "",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"decimals": 2,
"pattern": "/.*/",
"thresholds": [],
"type": "number",
"unit": "short"
}
],
"targets": [
{
"expr": "(max(gitlab_ci_pipeline_time_since_last_run_seconds) by (project, ref) * min(gitlab_ci_pipeline_last_run_status{status=~\"failed\"}) by (project, ref)) > 0",
"format": "table",
"hide": false,
"instant": true,
"intervalFactor": 1,
"refId": "B"
},
{
"expr": "(max(gitlab_ci_pipeline_last_run_duration_seconds) by (project, ref) * min(gitlab_ci_pipeline_last_run_status{status=~\"failed\"}) by (project, ref)) > 0",
"format": "table",
"hide": false,
"instant": true,
"intervalFactor": 1,
"refId": "C"
},
{
"expr": "min(gitlab_ci_pipeline_last_run_status{status=~\"failed\"}) by (project, ref) > 0",
"format": "table",
"hide": false,
"instant": true,
"intervalFactor": 1,
"refId": "A"
}
],
"timeFrom": null,
"timeShift": null,
"title": "FAILED PIPELINES",
"transform": "table",
"type": "table"
}
],
"refresh": "1m",
"schemaVersion": 19,
"style": "dark",
"tags": [
"gitlab",
"ci"
],
"templating": {
"list": []
},
"time": {
"from": "now-30m",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
]
},
"timezone": "",
"title": "GitLab CI Pipelines Status",
"uid": "gitlab-exporter",
"version": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment