Last active
August 26, 2025 13:41
-
-
Save nuved/a58dcb6d9ae21928cee15c5f579f1d08 to your computer and use it in GitHub Desktop.
JDBC details for java spring projects
This file contains hidden or 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": "datasource", | |
| "uid": "grafana" | |
| }, | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "enable": true, | |
| "expr": "resets(process_uptime_seconds{application=\"$application\", region=\"$region\", instance=\"$instance\"}[1m]) > 0", | |
| "hide": false, | |
| "iconColor": "rgba(255, 96, 96, 1)", | |
| "limit": 100, | |
| "name": "Restart Detection", | |
| "showIn": 0, | |
| "step": "1m", | |
| "tagKeys": "restart-tag", | |
| "tags": [], | |
| "textFormat": "uptime reset", | |
| "titleFormat": "Restart", | |
| "type": "tags" | |
| } | |
| ] | |
| }, | |
| "description": "HikariCP & JDBC Dashboard (Micrometer.io)", | |
| "editable": true, | |
| "fiscalYearStartMonth": 0, | |
| "graphTooltip": 1, | |
| "id": 675, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 4, | |
| "panels": [], | |
| "title": "JDBC Connections", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 0, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "match": "null", | |
| "result": { | |
| "text": "N/A" | |
| } | |
| }, | |
| "type": "special" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 20, | |
| "maxDataPoints": 100, | |
| "options": { | |
| "legend": { | |
| "calcs": [], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_min{namespace=\"$namespace\",application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Min", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 0, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "match": "null", | |
| "result": { | |
| "text": "N/A" | |
| } | |
| }, | |
| "type": "special" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 8, | |
| "y": 1 | |
| }, | |
| "id": 21, | |
| "maxDataPoints": 100, | |
| "options": { | |
| "legend": { | |
| "calcs": [], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_active{namespace=\"$namespace\",application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Active", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 0, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "match": "null", | |
| "result": { | |
| "text": "N/A" | |
| } | |
| }, | |
| "type": "special" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 16, | |
| "y": 1 | |
| }, | |
| "id": 8, | |
| "maxDataPoints": 100, | |
| "options": { | |
| "legend": { | |
| "calcs": [], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_max{namespace=\"$namespace\",application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Max", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "id": 2, | |
| "panels": [], | |
| "title": "Hikari Connections", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 25, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "dashed" | |
| } | |
| }, | |
| "fieldMinMax": false, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "hikaricp_connections_active" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "thresholds", | |
| "value": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| } | |
| ] | |
| } | |
| }, | |
| { | |
| "id": "fieldMinMax", | |
| "value": true | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "hikaricp_connections_max" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.stacking", | |
| "value": { | |
| "group": "A", | |
| "mode": "none" | |
| } | |
| }, | |
| { | |
| "id": "custom.fillOpacity", | |
| "value": 0 | |
| }, | |
| { | |
| "id": "color", | |
| "value": { | |
| "mode": "continuous-reds" | |
| } | |
| }, | |
| { | |
| "id": "custom.pointSize", | |
| "value": 1 | |
| }, | |
| { | |
| "id": "custom.hideFrom", | |
| "value": { | |
| "legend": true, | |
| "tooltip": false, | |
| "viz": false | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 9, | |
| "x": 0, | |
| "y": 9 | |
| }, | |
| "id": 10, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "min", | |
| "max", | |
| "mean" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_active{namespace=\"$namespace\", application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "C" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_max{namespace=\"$namespace\", application=~\"$application\"}", | |
| "hide": false, | |
| "instant": false, | |
| "legendFormat": "Max Connections - {{pod}}", | |
| "range": true, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Active", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 10, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "never", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "normal" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [], | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "short" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 8, | |
| "x": 9, | |
| "y": 9 | |
| }, | |
| "id": 19, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "max", | |
| "min" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "multi", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_pending{namespace=\"$namespace\",application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "B" | |
| } | |
| ], | |
| "title": "Pending", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "description": "How long a thread in the application has to wait to get a connection from the pool. it points to a problem with the application's connection pool. \nImportant indicator of pool performance; high values suggest pool saturation.\n", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 10, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "line" | |
| } | |
| }, | |
| "fieldMinMax": true, | |
| "mappings": [], | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 90 | |
| } | |
| ] | |
| }, | |
| "unit": "s" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 7, | |
| "x": 17, | |
| "y": 9 | |
| }, | |
| "id": 22, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "max", | |
| "min", | |
| "mean" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "multi", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "irate(hikaricp_connections_acquire_seconds_sum{namespace=\"$namespace\", application=\"$application\"}[5m]) / irate(hikaricp_connections_acquire_seconds_count{namespace=\"$namespace\", application=\"$application\"}[5m])", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "B" | |
| } | |
| ], | |
| "title": "Average Connection Acquire Time (s)", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 5, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "area" | |
| } | |
| }, | |
| "fieldMinMax": false, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "dark-red" | |
| }, | |
| { | |
| "color": "dark-green", | |
| "value": 10 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 9, | |
| "x": 0, | |
| "y": 15 | |
| }, | |
| "id": 24, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "min", | |
| "max", | |
| "mean" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "hikaricp_connections_idle{namespace=\"$namespace\",application=\"$application\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "C" | |
| } | |
| ], | |
| "title": "Idle", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "description": "Average of time connections spend being used. The Usage Time spike tells you that running business queries is also slow during that same period. Helps identify long-running queries or transactions that don’t release connections promptly.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 10, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineStyle": { | |
| "fill": "solid" | |
| }, | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "never", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "none" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "dashed" | |
| } | |
| }, | |
| "fieldMinMax": true, | |
| "mappings": [], | |
| "min": 0, | |
| "thresholds": { | |
| "mode": "percentage", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| }, | |
| { | |
| "color": "#E24D42", | |
| "value": 50 | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 90 | |
| }, | |
| { | |
| "color": "#6ED0E0", | |
| "value": 99 | |
| } | |
| ] | |
| }, | |
| "unit": "s" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 8, | |
| "x": 9, | |
| "y": 15 | |
| }, | |
| "id": 16, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "max", | |
| "min", | |
| "mean" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "multi", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "exemplar": true, | |
| "expr": "irate(hikaricp_connections_usage_seconds_sum{namespace=\"$namespace\", application=\"$application\"}[5m]) / irate(hikaricp_connections_usage_seconds_count{namespace=\"$namespace\", application=\"$application\"}[5m])", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "C" | |
| } | |
| ], | |
| "title": "Average Connection Usage Time", | |
| "type": "timeseries" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "description": "How long it takes for the application to establish a brand new physical connection to the database. This is slow, expensive operation that involves network handshakes, authentication. It points to a problem with your database or network. \n", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisBorderShow": false, | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "barWidthFactor": 0.6, | |
| "drawStyle": "line", | |
| "fillOpacity": 10, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "never", | |
| "spanNulls": false, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "normal" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "fieldMinMax": true, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green" | |
| } | |
| ] | |
| }, | |
| "unit": "s" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 7, | |
| "w": 7, | |
| "x": 17, | |
| "y": 15 | |
| }, | |
| "id": 23, | |
| "options": { | |
| "legend": { | |
| "calcs": [ | |
| "min", | |
| "max" | |
| ], | |
| "displayMode": "table", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "hideZeros": false, | |
| "mode": "multi", | |
| "sort": "none" | |
| } | |
| }, | |
| "pluginVersion": "11.6.0", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "expr": "irate(hikaricp_connections_creation_seconds_sum{namespace=\"$namespace\", application=\"$application\"}[5m]) / irate(hikaricp_connections_creation_seconds_count{namespace=\"$namespace\", application=\"$application\"}[5m])", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{pod}}", | |
| "range": true, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Average Connection Creation (ns)", | |
| "type": "timeseries" | |
| } | |
| ], | |
| "preload": false, | |
| "refresh": "5s", | |
| "schemaVersion": 41, | |
| "tags": [ | |
| "prometheus", | |
| "hikaricp", | |
| "micrometer", | |
| "spring boot", | |
| "jdbc" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allowCustomValue": true, | |
| "current": { | |
| "text": "default", | |
| "value": "default" | |
| }, | |
| "definition": "label_values(up,namespace)", | |
| "includeAll": false, | |
| "label": "namespace", | |
| "name": "namespace", | |
| "options": [], | |
| "query": { | |
| "qryType": 1, | |
| "query": "label_values(up,namespace)", | |
| "refId": "PrometheusVariableQueryEditor-VariableQuery" | |
| }, | |
| "refresh": 1, | |
| "regex": "", | |
| "type": "query" | |
| }, | |
| { | |
| "current": { | |
| "text": "message-broadcaster", | |
| "value": "message-broadcaster" | |
| }, | |
| "datasource": "prometheus", | |
| "definition": "label_values(up{namespace=\"$namespace\"},application)", | |
| "includeAll": false, | |
| "label": "Application", | |
| "name": "application", | |
| "options": [], | |
| "query": { | |
| "qryType": 1, | |
| "query": "label_values(up{namespace=\"$namespace\"},application)", | |
| "refId": "PrometheusVariableQueryEditor-VariableQuery" | |
| }, | |
| "refresh": 2, | |
| "regex": "", | |
| "type": "query" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-3h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Spring Boot HikariCP / JDBC / CC / Novid", | |
| "uid": "e9763d8a-784c-4e07-91e6-79bc1c91ea57", | |
| "version": 23 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment