Last active
November 9, 2021 06:22
-
-
Save kevinbin/03253981b73e52b223c177f240b2b1ef to your computer and use it in GitHub Desktop.
PostgreSQL Dashboard View
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": "", | |
| "editable": true, | |
| "gnetId": 3300, | |
| "graphTooltip": 1, | |
| "id": 21, | |
| "iteration": 1636357523213, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 116, | |
| "panels": [ | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#d44a3a", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#299c46" | |
| ], | |
| "datasource": null, | |
| "description": "Reports whether PMM Server can connect to the PostgreSQL instance.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 63, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "expr": "pg_up{instance=~\"$host\"}", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "0,1", | |
| "title": "Connected", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| }, | |
| { | |
| "op": "=", | |
| "text": "NO", | |
| "value": "0" | |
| }, | |
| { | |
| "op": "=", | |
| "text": "YES", | |
| "value": "1" | |
| } | |
| ], | |
| "valueName": "avg" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": null, | |
| "description": "The parameter work_mem defines the amount of memory assigned for internal sort operations and hash tables before writing to temporary disk files. The default is 4MB.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "bytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 4, | |
| "y": 1 | |
| }, | |
| "id": 69, | |
| "interval": null, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "GUC-WORK-MEM", | |
| "url": "https://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-WORK-MEM" | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "5.0.0", | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_settings_work_mem_bytes{instance=~\"$host\"}[$interval]) or\nmax_over_time(pg_settings_work_mem_bytes{instance=~\"$host\"}[5m]) ", | |
| "format": "time_series", | |
| "instant": true, | |
| "interval": "", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Memory Size for each Sort", | |
| "type": "stat" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": null, | |
| "description": "PostgreSQL's effective_cache_size variable tunes how much RAM you expect to be available for disk caching. Generally adding Linux free+cached will give you a good idea. This value is used by the query planner whether plans will fit in memory, and when defined too low, can lead to some plans rejecting certain indexes.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [ | |
| { | |
| "id": 0, | |
| "op": "=", | |
| "text": "N/A", | |
| "type": 1, | |
| "value": "null" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "bytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 8, | |
| "y": 1 | |
| }, | |
| "id": 70, | |
| "interval": null, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "GUC-EFFECTIVE-CACHE-SIZE", | |
| "url": "https://www.postgresql.org/docs/current/static/runtime-config-query.html#GUC-EFFECTIVE-CACHE-SIZE" | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "horizontal", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "5.0.0", | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_settings_effective_cache_size_bytes{instance=~\"$host\"}[$interval]) or\nmax_over_time(pg_settings_effective_cache_size_bytes{instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "instant": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Disk Cache Size", | |
| "type": "stat" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": true, | |
| "colors": [ | |
| "#d44a3a", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#299c46" | |
| ], | |
| "datasource": null, | |
| "description": "Whether autovacuum process is enabled or not. Generally the solution is to vacuum more often, not less.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 12, | |
| "y": 1 | |
| }, | |
| "id": 85, | |
| "interval": null, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "AUTOVACUUM", | |
| "url": "https://www.postgresql.org/docs/current/static/routine-vacuuming.html#AUTOVACUUM" | |
| } | |
| ], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_settings_autovacuum{instance=~\"$host\"}[$interval]) or\nmax_over_time(pg_settings_autovacuum{instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "instant": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "0,1", | |
| "title": "Autovacuum", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| }, | |
| { | |
| "op": "=", | |
| "text": "NO", | |
| "value": "0" | |
| }, | |
| { | |
| "op": "=", | |
| "text": "YES", | |
| "value": "1" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": null, | |
| "description": "The setting wal_buffers defines how much memory is used for caching the write-ahead log entries. Generally this value is small (3% of shared_buffers value), but it may need to be modified for heavily loaded servers.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [ | |
| { | |
| "id": 0, | |
| "op": "=", | |
| "text": "N/A", | |
| "type": 1, | |
| "value": "null" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "bytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 16, | |
| "y": 1 | |
| }, | |
| "id": 68, | |
| "interval": null, | |
| "links": [ | |
| { | |
| "title": "GUC-WAL-BUFFERS", | |
| "url": "https://www.postgresql.org/docs/current/static/runtime-config-wal.html#GUC-WAL-BUFFERS" | |
| }, | |
| { | |
| "targetBlank": true, | |
| "title": "GUC-SHARED-BUFFERS", | |
| "url": "https://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-SHARED-BUFFERS" | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "horizontal", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "5.0.0", | |
| "targets": [ | |
| { | |
| "datasource": "universe", | |
| "expr": "max_over_time(pg_settings_wal_buffers_bytes{instance=~\"$host\"}[$interval]) or\nmax_over_time(pg_settings_wal_buffers_bytes{instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "instant": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Disk-Page Buffers", | |
| "type": "stat" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "datasource": null, | |
| "description": "Defines the amount of memory the database server uses for shared memory buffers. Default is 128MB. Guidance on tuning is 25% of RAM, but generally doesn't exceed 40%.", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": {}, | |
| "decimals": 2, | |
| "mappings": [ | |
| { | |
| "id": 0, | |
| "op": "=", | |
| "text": "N/A", | |
| "type": 1, | |
| "value": "null" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| } | |
| ] | |
| }, | |
| "unit": "bytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 2, | |
| "w": 4, | |
| "x": 20, | |
| "y": 1 | |
| }, | |
| "id": 67, | |
| "interval": null, | |
| "links": [ | |
| { | |
| "targetBlank": true, | |
| "title": "GUC-SHARED-BUFFERS", | |
| "url": "https://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-SHARED-BUFFERS" | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "none", | |
| "justifyMode": "auto", | |
| "orientation": "horizontal", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "text": {}, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "5.0.0", | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_settings_shared_buffers_bytes{instance=~\"$host\"}[$interval]) or\nmax_over_time(pg_settings_shared_buffers_bytes{instance=~\"$host\"}[5m]) ", | |
| "format": "time_series", | |
| "instant": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Shared Buffers", | |
| "type": "stat" | |
| } | |
| ], | |
| "title": "PG Summary", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 88, | |
| "panels": [ | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "format": "dateTimeAsIso", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 8, | |
| "x": 0, | |
| "y": 2 | |
| }, | |
| "id": 108, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": false | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "expr": "node_boot_time_seconds{instance=\"$host\"} * 1000", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "System Uptime(days)", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "System Start Time", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "columns": [], | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fontSize": "100%", | |
| "gridPos": { | |
| "h": 6, | |
| "w": 16, | |
| "x": 8, | |
| "y": 2 | |
| }, | |
| "id": 114, | |
| "links": [], | |
| "pageSize": null, | |
| "scroll": true, | |
| "showHeader": true, | |
| "sort": { | |
| "col": 9, | |
| "desc": false | |
| }, | |
| "styles": [ | |
| { | |
| "alias": "Available Size", | |
| "align": "auto", | |
| "colorMode": "cell", | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "decimals": 1, | |
| "link": false, | |
| "pattern": "Value #A", | |
| "thresholds": [ | |
| "1000000000", | |
| "5000000000" | |
| ], | |
| "type": "number", | |
| "unit": "bytes" | |
| }, | |
| { | |
| "alias": "Size Used Percent ", | |
| "align": "auto", | |
| "colorMode": "cell", | |
| "colors": [ | |
| "rgba(50, 172, 45, 0.97)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(245, 54, 54, 0.9)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 1, | |
| "mappingType": 1, | |
| "pattern": "Value #B", | |
| "thresholds": [ | |
| "0.8", | |
| "0.9" | |
| ], | |
| "type": "number", | |
| "unit": "percentunit" | |
| }, | |
| { | |
| "alias": "Total Size", | |
| "align": "auto", | |
| "colorMode": null, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 0, | |
| "mappingType": 1, | |
| "pattern": "Value #C", | |
| "thresholds": [], | |
| "type": "number", | |
| "unit": "bytes" | |
| }, | |
| { | |
| "alias": "FIle System", | |
| "align": "auto", | |
| "colorMode": null, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 2, | |
| "mappingType": 1, | |
| "pattern": "fstype", | |
| "thresholds": [], | |
| "type": "number", | |
| "unit": "short" | |
| }, | |
| { | |
| "alias": "Disk", | |
| "align": "auto", | |
| "colorMode": null, | |
| "colors": [ | |
| "#37872D", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 2, | |
| "mappingType": 1, | |
| "pattern": "device", | |
| "thresholds": [], | |
| "type": "number", | |
| "unit": "short" | |
| }, | |
| { | |
| "alias": "Mount Point", | |
| "align": "auto", | |
| "colorMode": null, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 2, | |
| "mappingType": 1, | |
| "pattern": "mountpoint", | |
| "thresholds": [], | |
| "type": "number", | |
| "unit": "short" | |
| }, | |
| { | |
| "alias": "", | |
| "align": "auto", | |
| "colorMode": null, | |
| "colors": [ | |
| "rgba(245, 54, 54, 0.9)", | |
| "rgba(237, 129, 40, 0.89)", | |
| "rgba(50, 172, 45, 0.97)" | |
| ], | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "decimals": 2, | |
| "mappingType": 1, | |
| "pattern": "/.*/", | |
| "thresholds": [], | |
| "type": "hidden", | |
| "unit": "short" | |
| } | |
| ], | |
| "targets": [ | |
| { | |
| "expr": " (node_filesystem_size_bytes{instance='$host',fstype=~\"ext3|ext4|xfs|nfs|tmpfs\"})/100 *100", | |
| "format": "table", | |
| "instant": true, | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "C" | |
| }, | |
| { | |
| "expr": "node_filesystem_avail_bytes {instance='$host',fstype=~\"ext3|ext4|xfs|nfs|tmpfs\"}", | |
| "format": "table", | |
| "instant": true, | |
| "intervalFactor": 1, | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "1-(node_filesystem_free_bytes{instance='$host',fstype=~\"ext3|ext4|xfs|nfs|tmpfs\"} / node_filesystem_size_bytes{instance='$host',fstype=~\"ext3|ext4|xfs|nfs|tmpfs\"})", | |
| "format": "table", | |
| "instant": true, | |
| "intervalFactor": 1, | |
| "refId": "B" | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Disk Usage", | |
| "transform": "table", | |
| "type": "table-old" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 4, | |
| "x": 0, | |
| "y": 5 | |
| }, | |
| "id": 110, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": false | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "expr": "count(count(node_cpu_seconds_total{instance=\"$host\", mode='system'}) by (cpu))", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "CPU Cores", | |
| "type": "singlestat", | |
| "valueFontSize": "120%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": false, | |
| "colorValue": false, | |
| "colors": [ | |
| "#299c46", | |
| "rgba(237, 129, 40, 0.89)", | |
| "#d44a3a" | |
| ], | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "format": "bytes", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 4, | |
| "x": 4, | |
| "y": 5 | |
| }, | |
| "id": 112, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": false, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": false | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "expr": "node_memory_MemTotal_bytes{instance=\"$host\"}", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": "", | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "Memory Size", | |
| "type": "singlestat", | |
| "valueFontSize": "80%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "current" | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 5, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 90, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideEmpty": true, | |
| "hideZero": true, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "100 - (avg(rate(node_cpu_seconds_total{instance=\"$host\",mode=\"idle\"}[5m])) * 100)", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{mode}}", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "", | |
| "refId": "B" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "CPU Usage", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percent", | |
| "label": null, | |
| "logBase": 1, | |
| "max": "100", | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": { | |
| "Max CPU Core Utilization": "#bf1b00" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 92, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Max CPU Core Utilization", | |
| "lines": false, | |
| "pointradius": 1, | |
| "points": true, | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "(avg_over_time(node_procs_running{instance=~\"$host\"}[$interval])-1) / scalar(count(node_cpu{mode=\"user\", instance=~\"$host\"})) or (avg_over_time(node_procs_running{instance=~\"$host\"}[5m])-1) / scalar(count(node_cpu{mode=\"user\", instance=~\"$host\"}))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Normalized CPU Load", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "clamp_max(max by () (sum by (cpu) ( (clamp_max(rate(node_cpu{instance=~\"$host\",mode!=\"idle\",mode!=\"iowait\"}[$interval]),1)) or (clamp_max(irate(node_cpu{instance=~\"$host\",mode!=\"idle\",mode!=\"iowait\"}[5m]),1)) )),1)", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Max CPU Core Utilization", | |
| "refId": "B" | |
| }, | |
| { | |
| "expr": "avg_over_time(node_procs_blocked{instance=~\"$host\"}[$interval]) or avg_over_time(node_procs_blocked{instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "IO Load", | |
| "refId": "C" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Saturation and Max Core Usage", | |
| "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": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "percentunit", | |
| "label": null, | |
| "logBase": 1, | |
| "max": "1", | |
| "min": "0", | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 94, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Disk Writes (Page Out)", | |
| "transform": "negative-Y" | |
| }, | |
| { | |
| "alias": "Total", | |
| "legend": false, | |
| "lines": false | |
| }, | |
| { | |
| "alias": "Swap Out (Writes)", | |
| "transform": "negative-Y" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "rate(node_vmstat_pgpgin{instance=~\"$host\"}[$interval]) * 1024 or irate(node_vmstat_pgpgin{instance=~\"$host\"}[5m]) * 1024", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Disk Reads (Page In)", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "(rate(node_vmstat_pgpgout{instance=~\"$host\"}[$interval]) * 1024 or irate(node_vmstat_pgpgout{instance=~\"$host\"}[5m]) * 1024)", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Disk Writes (Page Out)", | |
| "refId": "B" | |
| }, | |
| { | |
| "expr": "(rate(node_vmstat_pgpgin{instance=~\"$host\"}[$interval]) * 1024 or irate(node_vmstat_pgpgin{instance=~\"$host\"}[5m]) * 1024 ) + \n(rate(node_vmstat_pgpgout{instance=~\"$host\"}[$interval]) * 1024 or irate(node_vmstat_pgpgout{instance=~\"$host\"}[5m]) * 1024)", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Total", | |
| "refId": "C" | |
| }, | |
| { | |
| "expr": "rate(node_vmstat_pswpin{instance=~\"$host\"}[$interval]) * 4096 or irate(node_vmstat_pswpin{instance=~\"$host\"}[5m]) * 4096", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Swap In (Reads)", | |
| "refId": "D" | |
| }, | |
| { | |
| "expr": "rate(node_vmstat_pswpout{instance=~\"$host\"}[$interval]) * 4096 or \nirate(node_vmstat_pswpout{instance=~\"$host\"}[5m]) * 4096", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Swap Out (Writes)", | |
| "refId": "E" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Disk I/O and Swap Activity", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "Bps", | |
| "label": "Page Out (-) / Page In (+)", | |
| "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": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 96, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "network_transmit", | |
| "transform": "negative-Y" | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(node_network_transmit_bytes_total{instance=\"$host\"}[1m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "network_transmit", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "sum(rate(node_network_receive_bytes_total{instance=\"$host\"}[1m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "network_receive", | |
| "refId": "B" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Network Traffic", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "Bps", | |
| "label": "Outbound (-) / Inbound (+)", | |
| "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 | |
| } | |
| } | |
| ], | |
| "title": "System Summary", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 2 | |
| }, | |
| "id": 74, | |
| "panels": [ | |
| { | |
| "aliasColors": { | |
| "Maximum commections": "#bf1b00" | |
| }, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 0, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 2 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 34, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "Maximum connections", | |
| "color": "#bf1b00", | |
| "fill": 0, | |
| "stack": false | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_stat_database_numbackends{datname=~\"$db\",instance=~\"$host\"}[$interval]) or \nmax_over_time(pg_stat_database_numbackends{datname=~\"$db\",instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "hide": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{datname}}", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "max_over_time(pg_settings_max_connections{instance=~\"$host\"}[$interval]) or \nmax_over_time(pg_settings_max_connections{instance=~\"$host\"}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Maximum connections", | |
| "refId": "B" | |
| }, | |
| { | |
| "expr": "max_over_time(pg_stat_activity_count{instance=~\"$host\",datname=~\"$db\",state='active'}[$interval]) or\nmax_over_time(pg_stat_activity_count{instance=~\"$host\",datname=~\"$db\",state='active'}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{datname}}", | |
| "refId": "C" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Active Connections", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "short", | |
| "label": null, | |
| "logBase": 2, | |
| "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": null, | |
| "decimals": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 2 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 106, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"LWLock\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "LWLock", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"Lock\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "Lock", | |
| "refId": "B" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"BufferPin\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "BufferPin", | |
| "refId": "C" | |
| }, | |
| { | |
| "expr": " sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"Activity\"})", | |
| "format": "time_series", | |
| "interval": "", | |
| "intervalFactor": 1, | |
| "legendFormat": "Activity", | |
| "refId": "D" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"Extension\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "Extension", | |
| "refId": "E" | |
| }, | |
| { | |
| "expr": " sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"Client\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "Client", | |
| "refId": "F" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"IPC\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "IPC", | |
| "refId": "G" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$server\",datname!~\"postgres|template0|template1\",wait_event_type=\"Timeout\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "Timeout", | |
| "refId": "H" | |
| }, | |
| { | |
| "expr": "sum(pg_wait_count{instance=\"$host\",datname!~\"postgres|template0|template1\",wait_event_type=\"IO\"})", | |
| "format": "time_series", | |
| "intervalFactor": 1, | |
| "legendFormat": "IO", | |
| "refId": "I" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Wait Event", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "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 | |
| } | |
| } | |
| ], | |
| "title": "Connections", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 3 | |
| }, | |
| "id": 76, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 3 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 36, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_fetched{datname=~\"$db\",instance=~\"$host\"}[$interval])) or \nsum(irate(pg_stat_database_tup_fetched{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Fetched", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_returned{datname=~\"$db\",instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_returned{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Returned", | |
| "refId": "B" | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_inserted{datname=~\"$db\",instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_inserted{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Inserted", | |
| "refId": "C" | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_updated{datname=~\"$db\",instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_updated{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Updated", | |
| "refId": "D" | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_deleted{datname=~\"$db\",instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_deleted{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Deleted", | |
| "refId": "E" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Tuples", | |
| "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": "0", | |
| "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": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 3 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 24, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_returned{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_returned{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows returned by queries", | |
| "refId": "A", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_fetched{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_fetched{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows fetched by queries", | |
| "refId": "B", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Read Tuple Activity", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ops", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "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": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 11 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 25, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_inserted{instance=~\"$host\"}[1m])) or\nsum(irate(pg_stat_database_tup_inserted{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows inserted by queries", | |
| "metric": "pg_stat_database_tup", | |
| "refId": "C", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_updated{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_updated{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows updated by queries", | |
| "metric": "pg_stat_database_tup", | |
| "refId": "D", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_tup_deleted{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_tup_deleted{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rows deleted by queries", | |
| "metric": "pg_stat_database_tup", | |
| "refId": "E", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Tuples Changed per $interval", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ops", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "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": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 11 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 22, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideEmpty": false, | |
| "hideZero": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "rate(pg_stat_bgwriter_checkpoint_sync_time{instance=\"$host\"}[$interval]) or\nirate(pg_stat_bgwriter_checkpoint_sync_time{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Files Synchronization to disk", | |
| "metric": "pg_stat_bgwriter_checkpoint_sync_time", | |
| "refId": "A", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "rate(pg_stat_bgwriter_checkpoint_write_time{instance=\"$host\"}[$interval]) or\nirate(pg_stat_bgwriter_checkpoint_write_time{instance=\"$host\"}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Written Files to disk", | |
| "metric": "pg_stat_bgwriter_checkpoint_write_time", | |
| "refId": "B", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Checkpoint stats", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ops", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "ms", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "Tuples", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 4 | |
| }, | |
| "id": 78, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 4 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 26, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(pg_stat_database_xact_commit{instance=~\"$host\"}[$interval])) or \nsum(irate(pg_stat_database_xact_commit{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Commits", | |
| "metric": "pg_stat_database_xact_commit", | |
| "refId": "A", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_xact_rollback{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_xact_rollback{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Rollbacks", | |
| "metric": "pg_stat_database_xact_commit", | |
| "refId": "B", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Transactions", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ops", | |
| "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": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 4 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 18, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_stat_activity_max_tx_duration{instance='$host'}[$interval]) or\nmax_over_time(pg_stat_activity_max_tx_duration{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{state}}", | |
| "metric": "pg_stat_activity_max_tx_duration", | |
| "refId": "A", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Duration of Transactions", | |
| "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": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "s", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "Transactions", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 5 | |
| }, | |
| "id": 80, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 0, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 5 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 48, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": true, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_stat_database_temp_files{instance=~\"$host\",datname!~\"template.*\"}[$interval]) or \nmax_over_time(pg_stat_database_temp_files{instance=~\"$host\",datname!~\"template.*\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{datname}}", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Number of Temp Files", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "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": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 5 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 49, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "increase *", | |
| "bars": true, | |
| "lines": false | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "max_over_time(pg_stat_database_temp_bytes{instance=~\"$host\",datname!~\"template.*\"}[$interval]) or \nmax_over_time(pg_stat_database_temp_bytes{instance=~\"$host\",datname!~\"template.*\"}[5m])", | |
| "format": "time_series", | |
| "hide": false, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{datname}}", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "rate(pg_stat_database_temp_bytes{instance=~\"$host\",datname!~\"template.*\"}[$interval]) or\nirate(pg_stat_database_temp_bytes{instance=~\"$host\",datname!~\"template.*\"}[5m])", | |
| "format": "time_series", | |
| "hide": true, | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "increase {{datname}}", | |
| "refId": "B" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Size of Temp Files", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 2, | |
| "format": "bytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "Temp Files", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 6 | |
| }, | |
| "id": 82, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 1, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 6 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 3, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "conflicts", | |
| "dsType": "prometheus", | |
| "expr": "sum(rate(pg_stat_database_deadlocks{datname=~\"$db\",instance=~\"$host\"}[$interval])) or \nsum(irate(pg_stat_database_deadlocks{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Deadlocks", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "conflicts" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "deadlocks", | |
| "dsType": "prometheus", | |
| "expr": "sum(rate(pg_stat_database_conflicts{datname=~\"$db\",instance=~\"$host\"}[$interval])) or \nsum(irate(pg_stat_database_conflicts{datname=~\"$db\",instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Conflicts", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "deadlocks" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Conflicts/Deadlocks", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "ops", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": 0, | |
| "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": null, | |
| "decimals": 0, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 6 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 61, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "conflicts", | |
| "dsType": "prometheus", | |
| "expr": "max_over_time(pg_locks_count{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}[$interval]) or\nmax_over_time(pg_locks_count{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{mode}} - {{datname}}", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "conflicts" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Number of Locks", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "Conflicts & Locks", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 7 | |
| }, | |
| "id": 84, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 7 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 50, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [ | |
| { | |
| "alias": "/Write */", | |
| "yaxis": 2 | |
| } | |
| ], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "rate(pg_stat_database_blk_read_time{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}[$interval]) or\nirate(pg_stat_database_blk_read_time{datname=~\"$db\",instance=~\"$host\",datname!~\"template.\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Read {{datname}}", | |
| "refId": "A" | |
| }, | |
| { | |
| "expr": "rate(pg_stat_database_blk_write_time{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}[$interval]) or\nirate(pg_stat_database_blk_write_time{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}[5m])", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Write {{datname}}", | |
| "refId": "B" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Operations with Blocks", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "rps", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "decimals": 0, | |
| "format": "wps", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 7 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 2, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "hideZero": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "Buffers Allocated", | |
| "dsType": "prometheus", | |
| "expr": "rate(pg_stat_bgwriter_buffers_alloc{instance='$host'}[$interval]) or \nirate(pg_stat_bgwriter_buffers_alloc{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Allocated", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "buffers_alloc" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Buffers Allocated", | |
| "dsType": "prometheus", | |
| "expr": "rate(pg_stat_bgwriter_buffers_backend_fsync{instance='$host'}[$interval]) or\nirate(pg_stat_bgwriter_buffers_backend_fsync{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Fsync calls by a backend", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "B", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "buffers_alloc" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Buffers Allocated", | |
| "dsType": "prometheus", | |
| "expr": "rate(pg_stat_bgwriter_buffers_backend{instance='$host'}[$interval]) or\nirate(pg_stat_bgwriter_buffers_backend{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Written directly by a backend", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "C", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "buffers_alloc" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Buffers Allocated", | |
| "dsType": "prometheus", | |
| "expr": "rate(pg_stat_bgwriter_buffers_clean{instance='$host'}[$interval]) or \nirate(pg_stat_bgwriter_buffers_clean{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Written by the background writer", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "D", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "buffers_alloc" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| }, | |
| { | |
| "alias": "Buffers Allocated", | |
| "dsType": "prometheus", | |
| "expr": "rate(pg_stat_bgwriter_buffers_checkpoint{instance='$host'}[5m]) or\nirate(pg_stat_bgwriter_buffers_checkpoint{instance='$host'}[5m])", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Written during checkpoints", | |
| "measurement": "postgresql", | |
| "policy": "default", | |
| "refId": "E", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "buffers_alloc" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| }, | |
| { | |
| "params": [], | |
| "type": "difference" | |
| } | |
| ] | |
| ], | |
| "step": 2, | |
| "tags": [ | |
| { | |
| "key": "host", | |
| "operator": "=~", | |
| "value": "/^$host$/" | |
| } | |
| ] | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Buffers", | |
| "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": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "Buffers & Blocks Operations", | |
| "type": "row" | |
| }, | |
| { | |
| "collapsed": true, | |
| "datasource": null, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "id": 72, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "decimals": 0, | |
| "description": "Based on pg_stat_database_conflicts view", | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 28, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(rate(pg_stat_database_conflicts_confl_bufferpin{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_conflicts_confl_bufferpin{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Pinned buffers", | |
| "metric": "pg_stat_database_conflicts_confl_bufferpin", | |
| "refId": "A", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_conflicts_confl_deadlock{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_conflicts_confl_deadlock{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Deadlocks", | |
| "metric": "pg_stat_database_conflicts_confl_bufferpin", | |
| "refId": "B", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_conflicts_confl_lock{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_conflicts_confl_lock{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Lock timeouts", | |
| "metric": "pg_stat_database_conflicts_confl_bufferpin", | |
| "refId": "C", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_conflicts_confl_snapshot{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_conflicts_confl_snapshot{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Old snapshots", | |
| "metric": "pg_stat_database_conflicts_confl_bufferpin", | |
| "refId": "D", | |
| "step": 2 | |
| }, | |
| { | |
| "expr": "sum(rate(pg_stat_database_conflicts_confl_tablespace{instance=~\"$host\"}[$interval])) or\nsum(irate(pg_stat_database_conflicts_confl_tablespace{instance=~\"$host\"}[5m]))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Dropped tablespaces ", | |
| "metric": "pg_stat_database_conflicts_confl_bufferpin", | |
| "refId": "E", | |
| "step": 2 | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Canceled Queries", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "decimals": 0, | |
| "format": "ops", | |
| "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": null, | |
| "decimals": 2, | |
| "editable": true, | |
| "error": false, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {}, | |
| "links": [] | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 2, | |
| "fillGradient": 0, | |
| "grid": {}, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 8 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 14, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": false, | |
| "max": true, | |
| "min": true, | |
| "show": true, | |
| "sort": "avg", | |
| "sortDesc": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "maxPerRow": 6, | |
| "nullPointMode": "connected", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": true, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 1, | |
| "points": false, | |
| "renderer": "flot", | |
| "repeat": null, | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "sum(pg_stat_database_blks_hit{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}) by (datname) /\n(sum(pg_stat_database_blks_hit{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}) by (datname) + \nsum(pg_stat_database_blks_read{datname=~\"$db\",instance=~\"$host\",datname!~\"template.*\"}) by (datname))", | |
| "format": "time_series", | |
| "interval": "$interval", | |
| "intervalFactor": 1, | |
| "legendFormat": "Cache hit rate {{datname}}", | |
| "refId": "B" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Cache Hit Ratio", | |
| "tooltip": { | |
| "msResolution": false, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "percentunit", | |
| "label": null, | |
| "logBase": 1, | |
| "max": "1", | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "percent", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 0, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 98, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "pg_database_size_bytes{instance=\"$host\",datname!~\"template.*\",datname=~\"$db\"}", | |
| "format": "time_series", | |
| "interval": "", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{datname}}", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Database Size", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "decbytes", | |
| "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 | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": null, | |
| "fieldConfig": { | |
| "defaults": { | |
| "custom": {} | |
| }, | |
| "overrides": [] | |
| }, | |
| "fill": 0, | |
| "fillGradient": 0, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 12, | |
| "x": 12, | |
| "y": 16 | |
| }, | |
| "hiddenSeries": false, | |
| "id": 100, | |
| "legend": { | |
| "alignAsTable": false, | |
| "avg": false, | |
| "current": false, | |
| "max": false, | |
| "min": false, | |
| "rightSide": false, | |
| "show": true, | |
| "total": false, | |
| "values": false | |
| }, | |
| "lines": true, | |
| "linewidth": 1, | |
| "links": [], | |
| "nullPointMode": "null", | |
| "options": { | |
| "alertThreshold": true | |
| }, | |
| "paceLength": 10, | |
| "percentage": false, | |
| "pluginVersion": "5.0.0", | |
| "pointradius": 2, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "pg_database_size_bytes{instance=\"$host\",datname=~\"wal\"}", | |
| "format": "time_series", | |
| "interval": "", | |
| "intervalFactor": 1, | |
| "legendFormat": "wal_size", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Wal Size", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "bits", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "decbytes", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "title": "DB Size", | |
| "type": "row" | |
| } | |
| ], | |
| "refresh": "15m", | |
| "schemaVersion": 27, | |
| "style": "dark", | |
| "tags": [ | |
| "PostgreSQL" | |
| ], | |
| "templating": { | |
| "list": [ | |
| { | |
| "auto": true, | |
| "auto_count": 200, | |
| "auto_min": "1s", | |
| "current": { | |
| "selected": false, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| "description": null, | |
| "error": null, | |
| "hide": 0, | |
| "label": "Interval", | |
| "name": "interval", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1s", | |
| "value": "1s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5s", | |
| "value": "5s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5m", | |
| "value": "5m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "6h", | |
| "value": "6h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1d", | |
| "value": "1d" | |
| } | |
| ], | |
| "query": "1s,5s,1m,5m,1h,6h,1d", | |
| "refresh": 2, | |
| "skipUrlSync": false, | |
| "type": "interval" | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "selected": false, | |
| "text": "10.186.63.99:9187", | |
| "value": "10.186.63.99:9187" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "Host", | |
| "multi": false, | |
| "name": "host", | |
| "options": [], | |
| "query": "label_values(pg_up,instance)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 1, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": ".*", | |
| "current": { | |
| "selected": false, | |
| "text": "postgres", | |
| "value": "postgres" | |
| }, | |
| "datasource": "universe", | |
| "definition": "label_values(pg_stat_database_tup_fetched{instance=~\"$host\",datname!~\"template.*|postgres\"},datname)", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 0, | |
| "includeAll": true, | |
| "label": "DB", | |
| "multi": false, | |
| "name": "db", | |
| "options": [], | |
| "query": "label_values(pg_stat_database_tup_fetched{instance=~\"$host\",datname!~\"template.*|postgres\"},datname)", | |
| "refresh": 2, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "text": "10.11", | |
| "value": "10.11" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "version", | |
| "options": [], | |
| "query": "label_values(pg_static{instance=~\"$host\"},version)", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 2, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_connections", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_connections{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "shared_buffers", | |
| "options": [], | |
| "query": "query_result(pg_settings_shared_buffers_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "work_mem", | |
| "options": [], | |
| "query": "query_result(pg_settings_work_mem_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "wal_buffers", | |
| "options": [], | |
| "query": "query_result(pg_settings_wal_buffers_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "wal_segment_size", | |
| "options": [], | |
| "query": "query_result(pg_settings_wal_segment_size_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "maintenance_work_mem", | |
| "options": [], | |
| "query": "query_result(pg_settings_maintenance_work_mem_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "block_size", | |
| "options": [], | |
| "query": "query_result(pg_settings_block_size{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "checkpoint_segments", | |
| "options": [], | |
| "query": "query_result(pg_settings_checkpoint_segments{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "checkpoint_timeout", | |
| "options": [], | |
| "query": "query_result(pg_settings_checkpoint_timeout_seconds{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "default_statistics_target", | |
| "options": [], | |
| "query": "query_result(pg_settings_default_statistics_target{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "seq_page_cost", | |
| "options": [], | |
| "query": "query_result(pg_settings_seq_page_cost{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "random_page_cost", | |
| "options": [], | |
| "query": "query_result(pg_settings_random_page_cost{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "effective_cache_size", | |
| "options": [], | |
| "query": "query_result(pg_settings_effective_cache_size_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "effective_io_concurrency", | |
| "options": [], | |
| "query": "query_result(pg_settings_effective_io_concurrency{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "fsync", | |
| "options": [], | |
| "query": "query_result(pg_settings_fsync{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_analyze_scale_factor", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_analyze_scale_factor{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_analyze_threshold", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_analyze_threshold{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_vacuum_scale_factor", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_vacuum_scale_factor{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_vacuum_threshold", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_vacuum_threshold{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_vacuum_cost_limit", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_vacuum_cost_limit{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_vacuum_cost_delay", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_vacuum_cost_delay_seconds{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_max_workers", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_max_workers{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_naptime", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_naptime_seconds{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_freeze_max_age", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_freeze_max_age{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "logging_collector", | |
| "options": [], | |
| "query": "query_result(pg_settings_logging_collector{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "log_min_duration_statement", | |
| "options": [], | |
| "query": "query_result(pg_settings_log_min_duration_statement_seconds{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "log_duration", | |
| "options": [], | |
| "query": "query_result(pg_settings_log_duration{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "log_lock_waits", | |
| "options": [], | |
| "query": "query_result(pg_settings_log_lock_waits{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_wal_senders", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_wal_senders{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_wal_size", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_wal_size_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "min_wal_size", | |
| "options": [], | |
| "query": "query_result(pg_settings_min_wal_size_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "wal_compression", | |
| "options": [], | |
| "query": "query_result(pg_settings_wal_compression{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_worker_processes", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_worker_processes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_parallel_workers_per_gather", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_parallel_workers_per_gather{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "max_parallel_workers", | |
| "options": [], | |
| "query": "query_result(pg_settings_max_parallel_workers_per_gather{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_work_mem", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_work_mem_bytes{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "isNone": true, | |
| "text": "None", | |
| "value": "" | |
| }, | |
| "datasource": "universe", | |
| "definition": "", | |
| "description": null, | |
| "error": { | |
| "message": "Datasource named Prometheus was not found" | |
| }, | |
| "hide": 2, | |
| "includeAll": false, | |
| "label": null, | |
| "multi": false, | |
| "name": "autovacuum_multixact_freeze_max_age", | |
| "options": [], | |
| "query": "query_result(pg_settings_autovacuum_multixact_freeze_max_age{instance=~\"$host\",job=\"postgresql\"})", | |
| "refresh": 2, | |
| "regex": "/ ([0-9\\.]+)/", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-12h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "hidden": false, | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ] | |
| }, | |
| "timezone": "browser", | |
| "title": "PostgreSQL Dashboard", | |
| "uid": "postgresql", | |
| "version": 9 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment