Skip to content

Instantly share code, notes, and snippets.

@tyrm
Created February 24, 2023 20:29
Show Gist options
  • Save tyrm/58d5208ec57a46e78612542939123ffb to your computer and use it in GitHub Desktop.
Save tyrm/58d5208ec57a46e78612542939123ffb to your computer and use it in GitHub Desktop.
{
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "datasource",
"uid": "grafana"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": 19,
"links": [],
"liveNow": false,
"panels": [
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 0
},
"id": 197,
"panels": [],
"title": "Relay",
"type": "row"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "purple",
"mode": "thresholds"
},
"mappings": [],
"max": 500,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "yellow",
"value": 450
},
{
"color": "red",
"value": 490
}
]
},
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 3,
"x": 0,
"y": 1
},
"id": 226,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": false,
"expr": "faktory_busy_workers_gauge{host=\"data-sfo3-01\"}",
"instant": true,
"interval": "",
"legendFormat": "Busy",
"range": false,
"refId": "A"
}
],
"title": "Busy",
"type": "gauge"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Failed"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 7,
"x": 3,
"y": 1
},
"id": 225,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(faktory_processed_jobs_total_counter{host=\"data-sfo3-01\"})[1s]",
"interval": "",
"legendFormat": "Processed",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(faktory_failed_jobs_total_counter{host=\"data-sfo3-01\"})[1s]",
"hide": false,
"interval": "",
"legendFormat": "Failed",
"range": true,
"refId": "B"
}
],
"title": "Job Processing Rate",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Successes",
"binary": {
"left": "Processed",
"operator": "-",
"reducer": "sum",
"right": "Failed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"Time",
"Failed",
"Successes"
]
}
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {
"Failed": 2,
"Successes": 1,
"Time": 0
},
"renameByName": {}
}
}
],
"type": "timeseries"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "locale"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "delivery"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "priority"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 7,
"x": 10,
"y": 1
},
"id": 201,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "faktory_queue_enqueued_jobs_gauge{host=\"data-sfo3-01\"}",
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "A"
}
],
"title": "Enqueued Jobs",
"type": "timeseries"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "locale"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Retries"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "semi-dark-red",
"mode": "fixed"
}
},
{
"id": "custom.lineWidth",
"value": 2
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 7,
"x": 17,
"y": 1
},
"id": 248,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "faktory_retry_jobs_gauge{host=\"data-sfo3-01\"}",
"interval": "",
"legendFormat": "Retries",
"range": true,
"refId": "A"
}
],
"title": "Retries",
"type": "timeseries"
},
{
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 6
},
"id": 125,
"title": "Mastodon",
"type": "row"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 0,
"y": 7
},
"id": 172,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"expr": "mastodon_stats_v2_active_users_gauge{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}",
"interval": "15m",
"legendFormat": "active",
"range": true,
"refId": "A"
}
],
"timeFrom": "1d",
"title": "Active Users",
"transformations": [],
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 6,
"y": 7
},
"id": 513,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"expr": "mastodon_stats_user_count_counter{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}",
"hide": false,
"interval": "15m",
"legendFormat": "total",
"range": true,
"refId": "B"
}
],
"timeFrom": "1d",
"title": "Total Users",
"transformations": [],
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 12,
"y": 7
},
"id": 173,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"expr": "mastodon_stats_status_count_counter{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}",
"interval": "15m",
"legendFormat": "total",
"range": true,
"refId": "A"
}
],
"timeFrom": "1d",
"title": "Posts",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 6,
"x": 18,
"y": 7
},
"id": 174,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"expr": "mastodon_stats_domain_count_counter{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}",
"interval": "15m",
"legendFormat": "total",
"range": true,
"refId": "A"
}
],
"timeFrom": "1d",
"title": "Domains",
"type": "stat"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "line"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 12,
"x": 0,
"y": 12
},
"hideTimeOverride": true,
"id": 315,
"interval": "1d",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": false,
"expr": "delta(mastodon_stats_v2_active_users_gauge{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}[1d])",
"format": "time_series",
"instant": false,
"interval": "1d",
"legendFormat": "total",
"range": true,
"refId": "A"
}
],
"timeFrom": "30d",
"title": "Daily User Delta",
"transformations": [],
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "fixed"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "line"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "locale"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 12,
"x": 12,
"y": 12
},
"hideTimeOverride": true,
"id": 404,
"interval": "1d",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": false,
"expr": "delta(mastodon_stats_status_count_counter{host=\"web-do-sfo3-01\",url=\"http://localhost:9123/metrics\"}[1d])",
"format": "time_series",
"instant": false,
"interval": "1d",
"legendFormat": "total",
"range": true,
"refId": "A"
}
],
"timeFrom": "30d",
"title": "Daily Post Delta",
"transformations": [],
"type": "timeseries"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "line"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "2xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "3xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "4xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "5xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 8,
"x": 0,
"y": 17
},
"hideTimeOverride": true,
"id": 337,
"interval": "1m",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (status) (\ncount_over_time({filename=\"/var/log/nginx/ptzo-access.log\"}| pattern `<_> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<_>\" <_>` [1m])\n)",
"legendFormat": "{{status}}",
"queryType": "range",
"range": true,
"refId": "A"
}
],
"title": "Web Traffic",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "2xx",
"mode": "reduceRow",
"reduce": {
"include": [
"200",
"202",
"206"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "3xx",
"mode": "reduceRow",
"reduce": {
"include": [
"301",
"302",
"304",
"303"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "4xx",
"mode": "reduceRow",
"reduce": {
"include": [
"403",
"404",
"409",
"410",
"413",
"422",
"429",
"499"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "5xx",
"mode": "reduceRow",
"reduce": {
"include": [
"500",
"503"
],
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"pattern": "(?!200|202|206|301|302|303|304|400|401|402|403|404|406|408|409|410|413|422|429|499|500|503|Value).*"
}
}
}
],
"type": "timeseries"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "palette-classic"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": [],
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 8,
"y": 17
},
"hideTimeOverride": true,
"id": 338,
"interval": "1m",
"options": {
"legend": {
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (host) (\ncount_over_time({filename=\"/var/log/nginx/ptzo-access.log\"}[1m])\n)",
"legendFormat": "{{host}}",
"queryType": "range",
"range": true,
"refId": "A"
}
],
"title": "Web Traffic",
"transformations": [
{
"id": "renameByRegex",
"options": {
"regex": "web(?:-do)?-sfo3-(.*)",
"renamePattern": "$1"
}
}
],
"type": "piechart"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "smooth",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "line"
}
},
"mappings": [],
"noValue": "0",
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "400"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "403"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 12,
"x": 12,
"y": 17
},
"hideTimeOverride": true,
"id": 426,
"interval": "1m",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (blocked) (\ncount_over_time({filename=~\"/var/log/nginx/(ptzo|ptzo-stream)-access.log\"}| pattern `<_> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<_>\" blocked=<blocked>`|blocked!=\"no\"[1m])\n)",
"legendFormat": "{{blocked}}",
"queryType": "range",
"range": true,
"refId": "B"
}
],
"title": "Blocked Requests",
"transformations": [],
"type": "timeseries"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"axisSoftMin": 0,
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "line"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "2xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "3xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "4xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "5xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "1xx"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 8,
"x": 0,
"y": 22
},
"hideTimeOverride": true,
"id": 360,
"interval": "1m",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (status) (\ncount_over_time({filename=\"/var/log/nginx/ptzo-stream-access.log\"}| pattern `<_> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<_>\" <_>` [1m])\n)",
"legendFormat": "{{status}}",
"queryType": "range",
"range": true,
"refId": "A"
}
],
"title": "Stream Traffic",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "1xx",
"mode": "reduceRow",
"reduce": {
"include": [
"101"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "2xx",
"mode": "reduceRow",
"reduce": {
"include": [
"200",
"202",
"206"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "3xx",
"mode": "reduceRow",
"reduce": {
"include": [
"301",
"302",
"304",
"303"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "4xx",
"mode": "reduceRow",
"reduce": {
"include": [
"403",
"404",
"405",
"409",
"410",
"413",
"422",
"429",
"499"
],
"reducer": "sum"
}
}
},
{
"id": "calculateField",
"options": {
"alias": "5xx",
"mode": "reduceRow",
"reduce": {
"include": [
"500",
"503"
],
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"pattern": "(?!101|200|202|206|301|302|303|304|400|401|402|403|404|405|406|408|409|410|413|422|429|499|500|503|Value).*"
}
}
}
],
"type": "timeseries"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"fixedColor": "blue",
"mode": "palette-classic"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": [],
"unit": "short"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 8,
"y": 22
},
"hideTimeOverride": true,
"id": 382,
"interval": "1m",
"options": {
"legend": {
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"sum"
],
"fields": "",
"values": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (host) (\ncount_over_time({filename=\"/var/log/nginx/ptzo-stream-access.log\"}[1m])\n)",
"legendFormat": "{{host}}",
"queryType": "range",
"refId": "A"
}
],
"title": "Web Traffic",
"transformations": [
{
"id": "renameByRegex",
"options": {
"regex": "web(?:-do)?-sfo3-(.*)",
"renamePattern": "$1"
}
}
],
"type": "piechart"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"align": "auto",
"displayMode": "auto",
"filterable": false,
"inspect": false
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 10,
"w": 12,
"x": 12,
"y": 22
},
"hideTimeOverride": true,
"id": 448,
"interval": "1h",
"options": {
"footer": {
"fields": "",
"reducer": [
"sum"
],
"show": false
},
"showHeader": false,
"sortBy": [
{
"desc": true,
"displayName": "Value #B"
}
]
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by(ua, blocked) (\ncount_over_time(\n{filename=~\"/var/log/nginx/(ptzo|ptzo-stream)-access.log\"} | pattern `<_> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<ua>\" <_> blocked=<blocked>`| blocked!=\"no\" [$__range]\n)\n)",
"legendFormat": "{{ua}}",
"queryType": "instant",
"refId": "B"
}
],
"timeFrom": "1h",
"title": "Blocked UAs",
"transformations": [
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"ua",
"Value #B",
"blocked"
]
}
}
}
],
"type": "table"
},
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byRegexp",
"options": "^2[0-9]{2}$"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "^3[0-9]{2}$"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "^4[0-9]{2}$"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "403"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "^5[0-9]{2}$"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 7,
"x": 0,
"y": 27
},
"id": 271,
"interval": "1m",
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "zNkMrlC7z"
},
"editorMode": "code",
"expr": "sum by (status) (\ncount_over_time({filename=\"/var/log/nginx-quic/translate-access.log\"}|~ \"POST /translate\"| pattern `<_> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<_>\" <_>` [1m])\n)",
"queryType": "range",
"refId": "C"
}
],
"title": "Translation Requests",
"type": "timeseries"
},
{
"datasource": {
"type": "loki",
"uid": "FdGyvkFVz"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": []
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 5,
"x": 7,
"y": 27
},
"id": 293,
"interval": "1m",
"options": {
"legend": {
"displayMode": "list",
"placement": "right",
"showLegend": true
},
"pieType": "pie",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"pluginVersion": "9.2.4",
"targets": [
{
"datasource": {
"type": "loki",
"uid": "FdGyvkFVz"
},
"editorMode": "code",
"expr": "sum by (ip) (\ncount_over_time({filename=\"/var/log/nginx-quic/translate-access.log\"}|~ \"POST /translate\"| pattern `<ip> - - <_> \"<_> <_> <_>\" <status> <_> <_> \"<_>\" <_>` [1m])\n)",
"hide": false,
"legendFormat": "{{ip}}",
"queryType": "range",
"range": true,
"refId": "C"
}
],
"title": "Translation Requests",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Petting Zoo",
"binary": {
"left": "128.199.9.49",
"reducer": "sum",
"right": "164.92.91.69"
},
"mode": "reduceRow",
"reduce": {
"include": [
"128.199.9.49",
"164.92.91.69"
],
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"pattern": "(?!128\\.199\\.9\\.49|164\\.92\\.91\\.69).*"
}
}
}
],
"type": "piechart"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 32
},
"id": 9,
"panels": [],
"title": "Sidekiq",
"type": "row"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "short"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "ingress"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#57e6f2",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 12,
"x": 0,
"y": 33
},
"id": 13,
"options": {
"colorMode": "value",
"graphMode": "area",
"justifyMode": "auto",
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"textMode": "auto"
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": false,
"expr": "sidekiq_queue_enqueued_jobs_gauge{host=\"worker-do-sfo3-01\",url=\"http://localhost:9292/metrics\"}",
"instant": true,
"interval": "",
"legendFormat": "{{name}}",
"range": false,
"refId": "A"
}
],
"title": "Enqueued Jobs",
"type": "stat"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "#EAB839",
"value": 60
},
{
"color": "red",
"value": 300
}
]
},
"unit": "s"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 12,
"x": 12,
"y": 33
},
"id": 12,
"options": {
"orientation": "auto",
"reduceOptions": {
"calcs": [
"lastNotNull"
],
"fields": "",
"values": false
},
"showThresholdLabels": false,
"showThresholdMarkers": true
},
"pluginVersion": "9.2.6",
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": false,
"expr": "sidekiq_queue_latency_seconds_gauge{host=\"worker-do-sfo3-01\",url=\"http://localhost:9292/metrics\"}",
"instant": true,
"interval": "",
"legendFormat": "{{name}}",
"range": false,
"refId": "A"
}
],
"title": "Queue Latency",
"type": "gauge"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Failed"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 38
},
"id": 2,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(sidekiq_processed_jobs_total_counter{host=\"worker-do-sfo3-01\"})[1s]",
"interval": "",
"legendFormat": "Processed",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(sidekiq_failed_jobs_total_counter{host=\"worker-do-sfo3-01\"})[1s]",
"hide": false,
"interval": "",
"legendFormat": "Failed",
"range": true,
"refId": "B"
}
],
"title": "Job Processing Rate",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Successes",
"binary": {
"left": "Processed",
"operator": "-",
"reducer": "sum",
"right": "Failed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"Time",
"Failed",
"Successes"
]
}
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {
"Failed": 2,
"Successes": 1,
"Time": 0
},
"renameByName": {}
}
}
],
"type": "timeseries"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "bars",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "ingress"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#57e6f2",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 38
},
"id": 10,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "sidekiq_queue_busy_workers_gauge{host=\"worker-do-sfo3-01\"}",
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "A"
}
],
"title": "Busy Workers",
"transformations": [
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"Time",
"default",
"pull",
"push",
"scheduler",
"ingress"
]
}
}
}
],
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Failed"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 46
},
"id": 23,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(sidekiq_processed_jobs_total_counter{host=\"worker-do-sfo3-01\"})[1h]",
"interval": "1h",
"legendFormat": "Processed",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "delta(sidekiq_failed_jobs_total_counter{host=\"worker-do-sfo3-01\"})[1h]",
"hide": false,
"interval": "1h",
"legendFormat": "Failed",
"range": true,
"refId": "B"
}
],
"timeFrom": "7d",
"title": "Job Processing History (hourly)",
"transformations": [
{
"id": "calculateField",
"options": {
"alias": "Successes",
"binary": {
"left": "Processed",
"operator": "-",
"reducer": "sum",
"right": "Failed"
},
"mode": "binary",
"reduce": {
"reducer": "sum"
}
}
},
{
"id": "filterFieldsByName",
"options": {
"include": {
"names": [
"Time",
"Failed",
"Successes"
]
}
}
},
{
"id": "organize",
"options": {
"excludeByName": {},
"indexByName": {
"Failed": 2,
"Successes": 1,
"Time": 0
},
"renameByName": {}
}
}
],
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "retry"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
},
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "ingress"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "#57e6f2",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 8,
"w": 12,
"x": 12,
"y": 46
},
"id": 3,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "sidekiq_queue_enqueued_jobs_gauge{host=\"worker-do-sfo3-01\",url=\"http://localhost:9292/metrics\"}",
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"expr": "sidekiq_retry_jobs_gauge{host=\"worker-do-sfo3-01\",url=\"http://localhost:9292/metrics\"}",
"hide": false,
"legendFormat": "retry",
"range": true,
"refId": "B"
}
],
"title": "Enqueued Jobs",
"type": "timeseries"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 54
},
"id": 25,
"panels": [],
"repeat": "server",
"repeatDirection": "h",
"title": "$server",
"type": "row"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 100,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"max": 100,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 0,
"y": 55
},
"id": 99,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_guest{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "guest",
"range": true,
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_guest_nice{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "guest_nice",
"range": true,
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_iowait{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "iowait",
"range": true,
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_irq{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "irq",
"range": true,
"refId": "E"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_nice{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "nice",
"range": true,
"refId": "F"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_softirq{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "softirq",
"range": true,
"refId": "G"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_steal{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "steal",
"range": true,
"refId": "H"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_system{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "system",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "cpu_usage_user{host=\"$server\",cpu=\"cpu-total\"}",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "user",
"range": true,
"refId": "I"
}
],
"title": "CPU Usage",
"type": "timeseries"
},
{
"datasource": {},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 4,
"y": 55
},
"id": 56,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "100 - cpu_usage_idle{host=\"$server\", cpu!=\"cpu-total\"}",
"interval": "$mini_intr",
"legendFormat": "{{cpu}}",
"range": true,
"refId": "A"
}
],
"title": "Core Usage",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 46,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "normal"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "bytes"
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "Total"
},
"properties": [
{
"id": "custom.fillOpacity",
"value": 0
},
{
"id": "custom.stacking",
"value": {
"group": "A",
"mode": "none"
}
},
{
"id": "color",
"value": {
"fixedColor": "dark-red",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 4,
"x": 8,
"y": 55
},
"id": 66,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "median(mem_used{host =~ \"$server$\"})",
"interval": "$mini_intr",
"legendFormat": "Used",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "median(mem_cached{host =~ \"$server$\"})",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "Cached",
"range": true,
"refId": "B"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "median(mem_total{host =~ \"$server$\"})",
"hide": false,
"interval": "$mini_intr",
"legendFormat": "Total",
"range": true,
"refId": "C"
}
],
"title": "Memory Used",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 12,
"y": 55
},
"id": 67,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "swap_used_percent{host=\"$server\"}",
"interval": "$mini_intr",
"legendFormat": "{{cpu}}",
"range": true,
"refId": "A"
}
],
"title": "Swap Used",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": true,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 10,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
}
]
},
"unit": "binbps"
},
"overrides": [
{
"matcher": {
"id": "byRegexp",
"options": "eth0: .*"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "red",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": ".*: in"
},
"properties": [
{
"id": "custom.transform",
"value": "negative-Y"
}
]
},
{
"matcher": {
"id": "byRegexp",
"options": "eth1: .*"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
}
]
},
"gridPos": {
"h": 5,
"w": 4,
"x": 16,
"y": 55
},
"id": 83,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"alias": "$tag_host: $tag_interface: $col",
"col": "in",
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"dsType": "prometheus",
"editorMode": "code",
"expr": "abs(ideriv(median(net_bytes_recv{host =~ \"$server\",interface =~ \"eth[01]\"}) by (host,interface)))*8",
"function": "derivative",
"g": true,
"groupBy": " by (host,interface)",
"interval": "$mini_intr",
"legendFormat": "{{interface}}: in",
"measurement": "net",
"policy": "default",
"query": "SELECT non_negative_derivative(mean(bytes_recv),1s)*8 as \"in\" FROM \"net\" WHERE host =~ /$server/ AND interface =~ /$netif/ AND $timeFilter GROUP BY time($interval), * fill(none)",
"range": true,
"rawQuery": true,
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"bytes_recv"
],
"type": "non_negative_derivative(mean"
}
]
],
"tags": "{host =~ \"$server\",interface =~ \"$netif\"}"
},
{
"alias": "$tag_host: $tag_interface: $col",
"col": "out",
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"dsType": "prometheus",
"editorMode": "code",
"expr": "abs(ideriv(median(net_bytes_sent{host =~ \"$server\",interface =~ \"eth[01]\"}) by (host,interface)))*8",
"function": "derivative",
"g": true,
"groupBy": " by (host,interface)",
"interval": "$mini_intr",
"legendFormat": "{{interface}}: out",
"measurement": "net",
"policy": "default",
"query": "SELECT non_negative_derivative(mean(bytes_sent),1s)*8 as \"out\" FROM \"net\" WHERE host =~ /$server/ AND interface =~ /$netif/ AND $timeFilter GROUP BY time($interval), * fill(none)",
"range": true,
"rawQuery": true,
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
"bytes_sent"
],
"type": "non_negative_derivative(mean"
}
]
],
"tags": "{host =~ \"$server\",interface =~ \"$netif\"}"
}
],
"title": "Net",
"transformations": [],
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineStyle": {
"fill": "solid"
},
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"max": 100,
"min": 0,
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
},
"unit": "percent"
},
"overrides": []
},
"gridPos": {
"h": 5,
"w": 4,
"x": 20,
"y": 55
},
"id": 477,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": false
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"editorMode": "code",
"exemplar": true,
"expr": "disk_used_percent{host=\"$server\"}",
"interval": "$mini_intr",
"legendFormat": "{{cpu}}",
"range": true,
"refId": "A"
}
],
"title": "Disk Used",
"type": "timeseries"
},
{
"collapsed": false,
"gridPos": {
"h": 1,
"w": 24,
"x": 0,
"y": 90
},
"id": 18,
"panels": [],
"title": "Data",
"type": "row"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "retry"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 91
},
"id": 19,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "postgresql_numbackends{host=\"data-sfo3-01\",db=\"mastodon_production\",server=\"pzpostgres-do-sfo3-01\"}",
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "A"
}
],
"title": "Postgres Backends",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "retry"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 91
},
"id": 20,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "rate(postgresql_tup_fetched{host=\"data-sfo3-01\",db=\"mastodon_production\",server=\"pzpostgres-do-sfo3-01\"})[$__interval]",
"hide": false,
"interval": "",
"legendFormat": "Fetched",
"range": true,
"refId": "A"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "rate(postgresql_tup_updated{host=\"data-sfo3-01\",db=\"mastodon_production\",server=\"pzpostgres-do-sfo3-01\"})[$__interval]",
"hide": false,
"interval": "",
"legendFormat": "Updated",
"range": true,
"refId": "C"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "rate(postgresql_tup_inserted{host=\"data-sfo3-01\",db=\"mastodon_production\",server=\"pzpostgres-do-sfo3-01\"})[$__interval]",
"hide": false,
"interval": "",
"legendFormat": "Inserted",
"range": true,
"refId": "D"
},
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "rate(postgresql_tup_deleted{host=\"data-sfo3-01\",db=\"mastodon_production\",server=\"pzpostgres-do-sfo3-01\"})[$__interval]",
"hide": false,
"interval": "",
"legendFormat": "Deleted",
"range": true,
"refId": "E"
}
],
"title": "Postgres Tuples",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "retry"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 100
},
"id": 21,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "redis_clients{host=\"data-sfo3-01\", port=\"16379\"}",
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "A"
}
],
"title": "Redis Clients",
"type": "timeseries"
},
{
"datasource": {
"type": "prometheus",
"uid": "wrJoLev4z"
},
"description": "",
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green"
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": [
{
"matcher": {
"id": "byName",
"options": "default"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "blue",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "mailers"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "purple",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "pull"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "yellow",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "push"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "orange",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "scheduler"
},
"properties": [
{
"id": "color",
"value": {
"fixedColor": "green",
"mode": "fixed"
}
}
]
},
{
"matcher": {
"id": "byName",
"options": "retry"
},
"properties": [
{
"id": "custom.lineStyle",
"value": {
"dash": [
10,
10
],
"fill": "dash"
}
}
]
}
]
},
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
"y": 100
},
"id": 22,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"datasource": {
"type": "prometheus",
"uid": "DVDNQxt7k"
},
"editorMode": "code",
"exemplar": true,
"expr": "rate(redis_total_commands_processed{host=\"data-sfo3-01\", port=\"16379\"})[$__interval]",
"hide": false,
"interval": "",
"legendFormat": "{{name}}",
"range": true,
"refId": "B"
}
],
"title": "Redis Commands",
"type": "timeseries"
}
],
"refresh": "10s",
"schemaVersion": 37,
"style": "dark",
"tags": [],
"templating": {
"list": [
{
"current": {
"selected": true,
"text": [
"All"
],
"value": [
"$__all"
]
},
"hide": 0,
"includeAll": true,
"multi": true,
"name": "server",
"options": [
{
"selected": true,
"text": "All",
"value": "$__all"
},
{
"selected": false,
"text": "data-sfo3-01",
"value": "data-sfo3-01"
},
{
"selected": false,
"text": "util-do-sfo3-01",
"value": "util-do-sfo3-01"
},
{
"selected": false,
"text": "web-do-sfo3-01",
"value": "web-do-sfo3-01"
},
{
"selected": false,
"text": "web-do-sfo3-02",
"value": "web-do-sfo3-02"
},
{
"selected": false,
"text": "worker-do-sfo3-01",
"value": "worker-do-sfo3-01"
},
{
"selected": false,
"text": "worker-do-sfo3-02",
"value": "worker-do-sfo3-02"
}
],
"query": "data-sfo3-01,util-do-sfo3-01,web-do-sfo3-01,web-do-sfo3-02,worker-do-sfo3-01,worker-do-sfo3-02",
"queryValue": "",
"skipUrlSync": false,
"type": "custom"
},
{
"hide": 2,
"name": "mini_intr",
"query": "1m",
"skipUrlSync": false,
"type": "constant"
}
]
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {},
"timezone": "",
"title": "Petting Zoo Mastodon",
"uid": "z-dH7HDVz",
"version": 19,
"weekStart": ""
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment