Created
July 1, 2021 09:50
-
-
Save hyperius/1a1abaa8e213b71d38c40afd88651696 to your computer and use it in GitHub Desktop.
Grafana RDS dashboard
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": "-- Grafana --", | |
"enable": true, | |
"hide": true, | |
"iconColor": "rgba(0, 211, 255, 1)", | |
"name": "Annotations & Alerts", | |
"type": "dashboard" | |
} | |
] | |
}, | |
"description": "Visualize OS metrics for Amazon RDS instance", | |
"editable": true, | |
"gnetId": 702, | |
"graphTooltip": 1, | |
"id": 19, | |
"iteration": 1625132518014, | |
"links": [], | |
"panels": [ | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 15, | |
"panels": [], | |
"title": "Row", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": { | |
"CPU": "#E24D42" | |
}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 1 | |
}, | |
"id": 2, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "CPU", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "CPUUtilization", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "CPU Utilization", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "percent", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": { | |
"Credits Accumulated": "#447EBC", | |
"Credits Consumed": "#E0752D" | |
}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 1 | |
}, | |
"id": 11, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Credits Accumulated", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "CPUCreditBalance", | |
"namespace": "AWS/RDS", | |
"period": "300", | |
"refId": "B", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
}, | |
{ | |
"alias": "Credits Consumed", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "CPUCreditUsage", | |
"namespace": "AWS/RDS", | |
"period": "300", | |
"refId": "C", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "CPU Credit Usage", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 8 | |
}, | |
"id": 16, | |
"panels": [], | |
"title": "New row", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 9 | |
}, | |
"id": 4, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Read", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "ReadIOPS", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
}, | |
{ | |
"alias": "Write", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "WriteIOPS", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "B", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Disk Operations", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "iops", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 9 | |
}, | |
"id": 3, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Read", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "ReadLatency", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
}, | |
{ | |
"alias": "Write", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "WriteLatency", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "B", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Disk Latency", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "s", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 16 | |
}, | |
"id": 17, | |
"panels": [], | |
"title": "New row", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": { | |
"Outstanding IO Requests": "#BA43A9" | |
}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 17 | |
}, | |
"id": 5, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Outstanding IO Requests", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "DiskQueueDepth", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Disk Queue Depth", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 17 | |
}, | |
"id": 6, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Read", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "ReadThroughput", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
}, | |
{ | |
"alias": "Write", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "WriteThroughput", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "B", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Disk Throughput", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "Bps", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 24 | |
}, | |
"id": 18, | |
"panels": [], | |
"title": "New row", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 25 | |
}, | |
"id": 7, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Available", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "FreeableMemory", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Memory", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 25 | |
}, | |
"id": 8, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Available", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"expression": "", | |
"hide": false, | |
"highResolution": false, | |
"id": "", | |
"intervalFactor": 2, | |
"metricName": "FreeStorageSpace", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"returnData": false, | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Storage Space", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 32 | |
}, | |
"id": 19, | |
"panels": [], | |
"title": "New row", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": { | |
"Used": "#EF843C" | |
}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 33 | |
}, | |
"id": 9, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"sortDesc": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Used", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"intervalFactor": 2, | |
"metricName": "SwapUsage", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Swap Usage", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"fill": 2, | |
"grid": {}, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 33 | |
}, | |
"id": 10, | |
"isNew": true, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": false, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 2, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Inbound", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"expression": "", | |
"highResolution": false, | |
"id": "", | |
"intervalFactor": 2, | |
"metricName": "NetworkReceiveThroughput", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "A", | |
"region": "$region", | |
"returnData": false, | |
"statistics": [ | |
"Average" | |
] | |
}, | |
{ | |
"alias": "Outbound", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expr": "", | |
"expression": "", | |
"highResolution": false, | |
"id": "", | |
"intervalFactor": 2, | |
"metricName": "NetworkTransmitThroughput", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"refId": "B", | |
"region": "$region", | |
"returnData": false, | |
"statistics": [ | |
"Average" | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Network Traffic", | |
"tooltip": { | |
"msResolution": false, | |
"shared": true, | |
"sort": 0, | |
"value_type": "cumulative" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "Bps", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": 0, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": false, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 40 | |
}, | |
"id": 24, | |
"panels": [], | |
"title": "Row title", | |
"type": "row" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"decimals": null, | |
"fill": 1, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 0, | |
"y": 41 | |
}, | |
"id": 22, | |
"legend": { | |
"alignAsTable": false, | |
"avg": false, | |
"current": true, | |
"hideEmpty": false, | |
"hideZero": false, | |
"max": false, | |
"min": false, | |
"rightSide": false, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Replica Lag", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expression": "", | |
"format": "time_series", | |
"group": [], | |
"highResolution": false, | |
"id": "", | |
"metricColumn": "none", | |
"metricName": "ReplicaLag", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"rawQuery": false, | |
"rawSql": "SELECT\n $__time(time_column),\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n", | |
"refId": "A", | |
"region": "$region", | |
"returnData": false, | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "column" | |
} | |
] | |
], | |
"statistics": [ | |
"Average" | |
], | |
"timeColumn": "time", | |
"where": [ | |
{ | |
"name": "$__timeFilter", | |
"params": [], | |
"type": "macro" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Replica lag", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "s", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": false | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": "CloudWatch", | |
"fill": 1, | |
"gridPos": { | |
"h": 7, | |
"w": 12, | |
"x": 12, | |
"y": 41 | |
}, | |
"id": 26, | |
"legend": { | |
"avg": false, | |
"current": false, | |
"max": false, | |
"min": false, | |
"show": true, | |
"total": false, | |
"values": false | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"percentage": false, | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"alias": "Connections", | |
"dimensions": { | |
"DBInstanceIdentifier": "$instance" | |
}, | |
"expression": "", | |
"format": "time_series", | |
"group": [], | |
"highResolution": false, | |
"id": "", | |
"metricColumn": "none", | |
"metricName": "DatabaseConnections", | |
"namespace": "AWS/RDS", | |
"period": "60", | |
"rawQuery": false, | |
"rawSql": "SELECT\n $__time(time_column),\n value1\nFROM\n metric_table\nWHERE\n $__timeFilter(time_column)\n", | |
"refId": "A", | |
"region": "$region", | |
"returnData": false, | |
"select": [ | |
[ | |
{ | |
"params": [ | |
"value" | |
], | |
"type": "column" | |
} | |
] | |
], | |
"statistics": [ | |
"Average" | |
], | |
"timeColumn": "time", | |
"where": [ | |
{ | |
"name": "$__timeFilter", | |
"params": [], | |
"type": "macro" | |
} | |
] | |
} | |
], | |
"thresholds": [], | |
"timeFrom": null, | |
"timeRegions": [], | |
"timeShift": null, | |
"title": "Database Connections", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"buckets": null, | |
"mode": "time", | |
"name": null, | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"label": null, | |
"logBase": 1, | |
"max": null, | |
"min": null, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false, | |
"alignLevel": null | |
} | |
}, | |
{ | |
"collapsed": true, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 48 | |
}, | |
"id": 20, | |
"panels": [ | |
{ | |
"content": "# Setup\n\nAdd CloudWatch datasource to Grafana with the name `CloudWatch`.\n\nCreate IAM user and attach the managed policy `CloudWatchReadOnlyAccess`. Then put the credentials in the file `~grafana/.aws/credentials`:\n```\n[default]\naws_access_key_id = youraccesskeyid\naws_secret_access_key = yoursecretaccesskey\n```", | |
"datasource": "CloudWatch", | |
"editable": true, | |
"error": false, | |
"gridPos": { | |
"h": 7, | |
"w": 24, | |
"x": 0, | |
"y": 49 | |
}, | |
"id": 13, | |
"isNew": true, | |
"links": [], | |
"mode": "markdown", | |
"title": "", | |
"type": "text" | |
} | |
], | |
"title": "Help", | |
"type": "row" | |
} | |
], | |
"schemaVersion": 16, | |
"style": "dark", | |
"tags": [ | |
"Percona", | |
"Cloud " | |
], | |
"templating": { | |
"list": [ | |
{ | |
"current": { | |
"text": "us-east-1", | |
"value": "us-east-1" | |
}, | |
"hide": 2, | |
"label": "Region", | |
"name": "region", | |
"options": [ | |
{ | |
"selected": true, | |
"text": "us-east-1", | |
"value": "us-east-1" | |
} | |
], | |
"query": "us-east-1", | |
"skipUrlSync": false, | |
"type": "constant" | |
}, | |
{ | |
"allValue": "", | |
"current": { | |
"text": "shriners-prod-main-appdb", | |
"value": "shriners-prod-main-appdb" | |
}, | |
"datasource": "CloudWatch", | |
"definition": "", | |
"hide": 0, | |
"includeAll": false, | |
"label": "DB Instance", | |
"multi": false, | |
"name": "instance", | |
"options": [], | |
"query": "dimension_values($region,AWS/RDS,CPUUtilization,DBInstanceIdentifier)", | |
"refresh": 1, | |
"regex": "", | |
"skipUrlSync": false, | |
"sort": 0, | |
"tagValuesQuery": "", | |
"tags": [], | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
} | |
] | |
}, | |
"time": { | |
"from": "now-90d", | |
"to": "now" | |
}, | |
"timepicker": { | |
"refresh_intervals": [ | |
"1m", | |
"5m", | |
"15m", | |
"30m", | |
"1h" | |
], | |
"time_options": [ | |
"5m", | |
"15m", | |
"1h", | |
"6h", | |
"12h", | |
"24h", | |
"2d", | |
"7d", | |
"30d" | |
] | |
}, | |
"timezone": "browser", | |
"title": "Amazon RDS OS Metrics", | |
"uid": "qtBC-KgWz", | |
"version": 10 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment