Last active
November 30, 2022 06:17
-
-
Save arajkumar/8bb0f1b7ab6964edb6d08e71c2127cdf to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": { | |
"type": "grafana", | |
"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": 1, | |
"id": 100, | |
"links": [], | |
"liveNow": false, | |
"panels": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "wps" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 6, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"editorMode": "code", | |
"exemplar": true, | |
"expr": "sum by (kind) (rate(promscale_ingest_items_total[$__rate_interval]))", | |
"interval": "", | |
"legendFormat": "{{ kind }}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Ingest Rates", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "none" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [ | |
{ | |
"matcher": { | |
"id": "byFrameRefID", | |
"options": "C" | |
}, | |
"properties": [ | |
{ | |
"id": "custom.axisPlacement", | |
"value": "right" | |
}, | |
{ | |
"id": "max", | |
"value": 1 | |
}, | |
{ | |
"id": "unit", | |
"value": "percentunit" | |
} | |
] | |
} | |
] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 0 | |
}, | |
"id": 23, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [ | |
"last", | |
"max" | |
], | |
"displayMode": "table", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "desc" | |
} | |
}, | |
"pluginVersion": "9.2.2", | |
"targets": [ | |
{ | |
"alias": "fetched", | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"dsType": "prometheus", | |
"editorMode": "code", | |
"expr": "sum(delta(pg_stat_bgwriter_checkpoints_timed_total{}[$__rate_interval]))", | |
"format": "time_series", | |
"groupBy": [ | |
{ | |
"params": [ | |
"$interval" | |
], | |
"type": "time" | |
}, | |
{ | |
"params": [ | |
"null" | |
], | |
"type": "fill" | |
} | |
], | |
"interval": "", | |
"intervalFactor": 2, | |
"legendFormat": "Scheduled", | |
"measurement": "postgresql", | |
"policy": "default", | |
"range": true, | |
"refId": "A", | |
"resultFormat": "time_series", | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"tup_fetched" | |
], | |
"type": "field" | |
}, | |
{ | |
"params": [], | |
"type": "mean" | |
}, | |
{ | |
"params": [ | |
"10s" | |
], | |
"type": "non_negative_derivative" | |
} | |
] | |
], | |
"step": 120, | |
"tags": [ | |
{ | |
"key": "instance", | |
"operator": "=~", | |
"value": "/^$instance$/" | |
} | |
] | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"editorMode": "code", | |
"expr": "sum(delta(pg_stat_bgwriter_checkpoints_req_total{}[$__rate_interval]))", | |
"hide": false, | |
"interval": "", | |
"legendFormat": "Requested", | |
"range": true, | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"editorMode": "code", | |
"expr": "sum by () (rate(pg_stat_bgwriter_checkpoints_req_total{}[$__rate_interval])\n/\n(\n rate(pg_stat_bgwriter_checkpoints_req_total{}[$__rate_interval])\n +\n rate(pg_stat_bgwriter_checkpoints_timed_total{}[$__rate_interval])\n))", | |
"hide": false, | |
"interval": "", | |
"legendFormat": "% of requested", | |
"range": true, | |
"refId": "C" | |
} | |
], | |
"title": "Checkpoints", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "s" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 8 | |
}, | |
"id": 19, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "(\n prometheus_remote_storage_highest_timestamp_in_seconds{} \n- \n ignoring(remote_name, url) group_right(instance) (prometheus_remote_storage_queue_highest_sent_timestamp_seconds{} != 0)\n)\n", | |
"legendFormat": "{{namespace}} - {{url}}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Highest Timestamp In vs. Highest Timestamp Sent", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "ms" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 8 | |
}, | |
"id": 14, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "-sum(rate(pg_stat_bgwriter_checkpoint_sync_time_total[$__rate_interval]))", | |
"legendFormat": "sync", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum(rate(pg_stat_bgwriter_checkpoint_write_time_total[$__rate_interval]))", | |
"hide": false, | |
"legendFormat": "write", | |
"range": true, | |
"refId": "B" | |
} | |
], | |
"title": "Checkpoint write vs sync", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "palette-classic" | |
}, | |
"custom": { | |
"axisCenteredZero": false, | |
"axisColorMode": "text", | |
"axisLabel": "", | |
"axisPlacement": "auto", | |
"barAlignment": 0, | |
"drawStyle": "line", | |
"fillOpacity": 55, | |
"gradientMode": "none", | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"lineInterpolation": "linear", | |
"lineStyle": { | |
"fill": "solid" | |
}, | |
"lineWidth": 1, | |
"pointSize": 5, | |
"scaleDistribution": { | |
"type": "linear" | |
}, | |
"showPoints": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "normal" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
} | |
] | |
}, | |
"unit": "percent" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 16 | |
}, | |
"id": 25, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "desc" | |
} | |
}, | |
"pluginVersion": "9.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"editorMode": "code", | |
"expr": "sum by(mode, instance)(irate(node_cpu_seconds_total{instance=\"192.168.46.6:9100\"}[$__rate_interval])) / ignoring(mode) group_left() sum by(instance)(irate(node_cpu_seconds_total[$__rate_interval])) * 100", | |
"format": "time_series", | |
"hide": false, | |
"interval": "", | |
"legendFormat": "{{mode}}", | |
"range": true, | |
"refId": "C" | |
} | |
], | |
"title": "CPU usage DB node", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 16 | |
}, | |
"id": 30, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false, | |
"unit": "none" | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum(rate(promscale_ingest_items_received_bucket{kind=\"sample\"}[$__rate_interval])) by (le)", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "D" | |
} | |
], | |
"title": "Samples per request", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 24 | |
}, | |
"id": 28, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "go_goroutines{container=\"promscale\"}", | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Go routines", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 24 | |
}, | |
"id": 29, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum by(mode)(pg_locks_count)", | |
"legendFormat": "{{mode}}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Locks", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 32 | |
}, | |
"id": 8, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false, | |
"unit": "s" | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.99, sum(rate(promscale_ingest_insert_duration_seconds_bucket[$__rate_interval])) by (le))", | |
"hide": true, | |
"legendFormat": "P99", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.95, sum(rate(promscale_ingest_insert_duration_seconds_bucket[$__rate_interval])) by (le))", | |
"hide": true, | |
"legendFormat": "P95", | |
"range": true, | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.5, sum(rate(promscale_ingest_insert_duration_seconds_bucket[$__rate_interval])) by (le))", | |
"hide": true, | |
"legendFormat": "P50", | |
"range": true, | |
"refId": "C" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum(rate(promscale_ingest_insert_duration_seconds_bucket[$__rate_interval])) by (le)", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "D" | |
} | |
], | |
"title": "DB insert duration", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 32 | |
}, | |
"id": 26, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum(delta(promscale_sql_database_chunks_count[$__rate_interval]))", | |
"legendFormat": "all chunks", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "-sum(delta(promscale_sql_database_chunks_compressed_count[$__rate_interval]))", | |
"hide": false, | |
"legendFormat": "compressed", | |
"range": true, | |
"refId": "B" | |
} | |
], | |
"title": "All Chunks vs Compressed", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 40 | |
}, | |
"id": 11, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.95, sum(rate(prometheus_remote_storage_sent_batch_duration_seconds_bucket[$__rate_interval])) by (le))", | |
"hide": true, | |
"legendFormat": "P95", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum(rate(prometheus_remote_storage_sent_batch_duration_seconds_bucket[$__rate_interval])) by (le)", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "B" | |
} | |
], | |
"title": "remote write sent duration", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 40 | |
}, | |
"id": 16, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "$datasource" | |
}, | |
"editorMode": "code", | |
"exemplar": true, | |
"expr": "(sum(promscale_ingest_channel_len) / sum(promscale_ingest_channel_cap)) * 100", | |
"interval": "", | |
"legendFormat": "{{ subsystem }}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Ingest channels saturation", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [ | |
{ | |
"__systemRef": "hideSeriesFrom", | |
"matcher": { | |
"id": "byNames", | |
"options": { | |
"mode": "exclude", | |
"names": [ | |
"sample" | |
], | |
"prefix": "All except:", | |
"readOnly": true | |
} | |
}, | |
"properties": [ | |
{ | |
"id": "custom.hideFrom", | |
"value": { | |
"legend": false, | |
"tooltip": false, | |
"viz": true | |
} | |
} | |
] | |
} | |
] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 48 | |
}, | |
"id": 17, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "$datasource" | |
}, | |
"editorMode": "code", | |
"exemplar": true, | |
"expr": "sum by(kind)(rate(promscale_ingest_insert_duration_seconds_count[$__rate_interval]))", | |
"interval": "", | |
"legendFormat": "{{ kind }}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Copy ops", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "wps" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 48 | |
}, | |
"id": 12, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "rate(prometheus_remote_storage_samples_total[$__rate_interval])", | |
"legendFormat": "{{namespace}} - {{url}}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "remote write samples/sec", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 0, | |
"y": 56 | |
}, | |
"id": 13, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "prometheus_remote_storage_shards_desired", | |
"legendFormat": "{{namespace}} - {{url}}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Desired Shards", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 12, | |
"x": 12, | |
"y": 56 | |
}, | |
"id": 18, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "promscale_sql_database_chunks_count - promscale_sql_database_chunks_compressed_count", | |
"legendFormat": "uncompressed", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "All Chunks - Compressed", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": "wps" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 24, | |
"x": 0, | |
"y": 64 | |
}, | |
"id": 20, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${datasource}" | |
}, | |
"editorMode": "code", | |
"exemplar": true, | |
"expr": "sum by(kind)(rate(promscale_ingest_rows_per_insert_sum[$__rate_interval]))", | |
"interval": "", | |
"legendFormat": "{{ pod }}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "DB insert rate", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 24, | |
"x": 0, | |
"y": 72 | |
}, | |
"id": 4, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false, | |
"unit": "none" | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "rate(promscale_ingest_inserts_per_batch_sum{type=\"metric\"}[$__rate_interval]) /rate(promscale_ingest_inserts_per_batch_count{type=\"metric\"}[$__rate_interval])", | |
"format": "heatmap", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "avg", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.1, rate(promscale_ingest_inserts_per_batch_bucket{type=\"metric\"}[$__rate_interval]))", | |
"format": "heatmap", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "P10", | |
"range": true, | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum by(le)(rate(promscale_ingest_inserts_per_batch_bucket{type=\"metric\"}[$__rate_interval]))", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "C" | |
} | |
], | |
"title": "Copy requests per batch", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 24, | |
"x": 0, | |
"y": 80 | |
}, | |
"id": 3, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "rate(promscale_ingest_rows_per_insert_sum{type=\"metric\"}[$__rate_interval]) / rate(promscale_ingest_rows_per_insert_count{type=\"metric\"}[$__rate_interval])", | |
"format": "time_series", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "avg", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.1, rate(promscale_ingest_rows_per_insert_bucket{type=\"metric\"}[$__rate_interval]))", | |
"format": "time_series", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "P10", | |
"range": true, | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum by(le)(rate(promscale_ingest_rows_per_insert_bucket{type=\"metric\"}[$__rate_interval]))", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "C" | |
} | |
], | |
"title": "Rows per Copy operation", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"custom": { | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"scaleDistribution": { | |
"type": "linear" | |
} | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 24, | |
"x": 0, | |
"y": 88 | |
}, | |
"id": 7, | |
"options": { | |
"calculate": false, | |
"cellGap": 1, | |
"color": { | |
"exponent": 0.5, | |
"fill": "dark-orange", | |
"mode": "scheme", | |
"reverse": false, | |
"scale": "exponential", | |
"scheme": "Oranges", | |
"steps": 64 | |
}, | |
"exemplars": { | |
"color": "rgba(255,0,255,0.7)" | |
}, | |
"filterValues": { | |
"le": 1e-9 | |
}, | |
"legend": { | |
"show": true | |
}, | |
"rowsFrame": { | |
"layout": "auto" | |
}, | |
"tooltip": { | |
"show": true, | |
"yHistogram": false | |
}, | |
"yAxis": { | |
"axisPlacement": "left", | |
"reverse": false | |
} | |
}, | |
"pluginVersion": "9.2.6", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "rate(promscale_ingest_rows_per_batch_sum[$__rate_interval]) / rate(promscale_ingest_rows_per_batch_count[$__rate_interval])", | |
"format": "time_series", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "avg", | |
"range": true, | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "histogram_quantile(0.02, rate(promscale_ingest_rows_per_batch_bucket[$__rate_interval]))", | |
"format": "time_series", | |
"hide": true, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "avg", | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "sum by(le)(rate(promscale_ingest_rows_per_batch_bucket[$__rate_interval]))", | |
"format": "heatmap", | |
"hide": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "C" | |
} | |
], | |
"title": "Rows per batch", | |
"type": "heatmap" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"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": [] | |
}, | |
"gridPos": { | |
"h": 8, | |
"w": 24, | |
"x": 0, | |
"y": 96 | |
}, | |
"id": 21, | |
"options": { | |
"legend": { | |
"calcs": [], | |
"displayMode": "list", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "single", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "9.2.5", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "dc08d25c8f267b054f12002f334e6d3d32a853e4" | |
}, | |
"editorMode": "code", | |
"expr": "rate(promscale_ingest_duplicates_total[$__rate_interval])", | |
"format": "time_series", | |
"hide": false, | |
"instant": true, | |
"key": "Q-f69790f6-7438-426c-bb76-390ce694113b-0", | |
"legendFormat": "{{kind}}", | |
"range": true, | |
"refId": "B" | |
} | |
], | |
"title": "Conflicts/Duplicates", | |
"type": "timeseries" | |
} | |
], | |
"refresh": false, | |
"schemaVersion": 37, | |
"style": "dark", | |
"tags": [], | |
"templating": { | |
"list": [] | |
}, | |
"time": { | |
"from": "now-1h", | |
"to": "now" | |
}, | |
"timepicker": {}, | |
"timezone": "utc", | |
"title": "Debugging", | |
"uid": "uNsfPpD4z", | |
"version": 38, | |
"weekStart": "" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment