Created
December 26, 2023 17:48
-
-
Save pen-pal/4623b8d6c4a5c995e4ed56f892dba4d7 to your computer and use it in GitHub Desktop.
postgresql-operator-dashboard
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"annotations": { | |
"list": [ | |
{ | |
"builtIn": 1, | |
"datasource": { | |
"type": "datasource", | |
"uid": "grafana" | |
}, | |
"enable": true, | |
"hide": true, | |
"iconColor": "rgba(0, 211, 255, 1)", | |
"name": "Annotations & Alerts", | |
"type": "dashboard" | |
} | |
] | |
}, | |
"description": "This dashboard works with postgres_exporter for prometheus", | |
"editable": true, | |
"fiscalYearStartMonth": 0, | |
"gnetId": 9628, | |
"graphTooltip": 0, | |
"id": 228, | |
"links": [], | |
"liveNow": false, | |
"panels": [ | |
{ | |
"collapsed": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 0 | |
}, | |
"id": 32, | |
"panels": [], | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"refId": "A" | |
} | |
], | |
"title": "Settings", | |
"type": "row" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "bytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 0, | |
"y": 1 | |
}, | |
"id": 40, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_shared_buffers_bytes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Shared Buffers", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "bytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 3, | |
"y": 1 | |
}, | |
"id": 42, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_effective_cache_size_bytes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Effective Cache", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "bytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 6, | |
"y": 1 | |
}, | |
"id": 44, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_maintenance_work_mem_bytes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Maintenance Work Mem", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "bytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 9, | |
"y": 1 | |
}, | |
"id": 46, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_work_mem_bytes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "", | |
"refId": "A" | |
} | |
], | |
"title": "Work Mem", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"decimals": 1, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "bytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 12, | |
"y": 1 | |
}, | |
"id": 48, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_max_wal_size_bytes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Max WAL Size", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 3, | |
"x": 15, | |
"y": 1 | |
}, | |
"id": 50, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_random_page_cost{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Random Page Cost", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 2, | |
"x": 18, | |
"y": 1 | |
}, | |
"id": 52, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_seq_page_cost", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Seq Page Cost", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 2, | |
"x": 20, | |
"y": 1 | |
}, | |
"id": 54, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"mean" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_max_worker_processes{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Max Worker Processes", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 2, | |
"x": 22, | |
"y": 1 | |
}, | |
"id": 56, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_settings_max_parallel_workers{instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"refId": "A" | |
} | |
], | |
"title": "Max Parallel Workers", | |
"type": "stat" | |
}, | |
{ | |
"collapsed": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 4 | |
}, | |
"id": 34, | |
"panels": [], | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"refId": "A" | |
} | |
], | |
"title": "General Counters, CPU, Memory and File Descriptor Stats", | |
"type": "row" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 0, | |
"y": 5 | |
}, | |
"id": 36, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "value", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"mean" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "name", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_static{release=\"$release\", instance=\"$instance\"}", | |
"format": "time_series", | |
"instant": true, | |
"intervalFactor": 1, | |
"legendFormat": "{{short_version}}", | |
"refId": "A" | |
} | |
], | |
"title": "Version", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"description": "start time of the process", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "dateTimeFromNow" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 4, | |
"y": 5 | |
}, | |
"id": 28, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"mean" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"editorMode": "code", | |
"expr": "pg_postmaster_start_time_seconds{release=\"$release\", instance=\"$instance\"} * 1000", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Start Time", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "decbytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 8, | |
"y": 5 | |
}, | |
"id": 10, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "SUM(pg_stat_database_tup_fetched{datname=~\"$datname\", instance=~\"$instance\"})", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"refId": "A", | |
"step": 4 | |
} | |
], | |
"title": "Current fetch data", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "decbytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 12, | |
"y": 5 | |
}, | |
"id": 11, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "SUM(pg_stat_database_tup_inserted{release=\"$release\", datname=~\"$datname\", instance=~\"$instance\"})", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"refId": "A", | |
"step": 4 | |
} | |
], | |
"title": "Current insert data", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "decbytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 16, | |
"y": 5 | |
}, | |
"id": 12, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "SUM(pg_stat_database_tup_updated{datname=~\"$datname\", instance=~\"$instance\"})", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"refId": "A", | |
"step": 4 | |
} | |
], | |
"title": "Current update data", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "thresholds" | |
}, | |
"mappings": [ | |
{ | |
"options": { | |
"match": "null", | |
"result": { | |
"text": "N/A" | |
} | |
}, | |
"type": "special" | |
} | |
], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "none" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 3, | |
"w": 4, | |
"x": 20, | |
"y": 5 | |
}, | |
"id": 38, | |
"links": [], | |
"maxDataPoints": 100, | |
"options": { | |
"colorMode": "none", | |
"graphMode": "none", | |
"justifyMode": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"mean" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"textMode": "auto", | |
"wideLayout": true | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"editorMode": "code", | |
"expr": "pg_settings_max_connections{release=\"$release\", instance=\"$instance\"}", | |
"format": "time_series", | |
"hide": true, | |
"intervalFactor": 1, | |
"range": true, | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"editorMode": "code", | |
"expr": "pg_settings_max_connections{release=\"$release\", instance=\"$instance\"}", | |
"format": "time_series", | |
"hide": false, | |
"intervalFactor": 1, | |
"range": true, | |
"refId": "B" | |
} | |
], | |
"title": "Max Connections", | |
"type": "stat" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"description": "Average user and system CPU time spent in seconds.", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "palette-classic" | |
}, | |
"custom": { | |
"axisBorderShow": false, | |
"axisCenteredZero": false, | |
"axisColorMode": "text", | |
"axisLabel": "", | |
"axisPlacement": "auto", | |
"barAlignment": 0, | |
"drawStyle": "line", | |
"fillOpacity": 10, | |
"gradientMode": "none", | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineInterpolation": "linear", | |
"lineWidth": 1, | |
"pointSize": 5, | |
"scaleDistribution": { | |
"type": "linear" | |
}, | |
"showPoints": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "none" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"links": [], | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "s" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 9, | |
"w": 8, | |
"x": 0, | |
"y": 8 | |
}, | |
"id": 22, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [ | |
"mean", | |
"lastNotNull", | |
"max", | |
"min" | |
], | |
"displayMode": "table", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "avg(rate(process_cpu_seconds_total{release=\"$release\", instance=\"$instance\"}[5m]) * 1000)", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "CPU Time", | |
"refId": "A" | |
} | |
], | |
"title": "Average CPU Usage", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"description": "Virtual and Resident memory size in bytes, averages over 5 min interval", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "palette-classic" | |
}, | |
"custom": { | |
"axisBorderShow": false, | |
"axisCenteredZero": false, | |
"axisColorMode": "text", | |
"axisLabel": "", | |
"axisPlacement": "auto", | |
"barAlignment": 0, | |
"drawStyle": "line", | |
"fillOpacity": 10, | |
"gradientMode": "none", | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineInterpolation": "linear", | |
"lineWidth": 1, | |
"pointSize": 5, | |
"scaleDistribution": { | |
"type": "linear" | |
}, | |
"showPoints": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "none" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"links": [], | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "decbytes" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 9, | |
"w": 8, | |
"x": 8, | |
"y": 8 | |
}, | |
"id": 24, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [ | |
"mean", | |
"lastNotNull", | |
"max", | |
"min" | |
], | |
"displayMode": "table", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "avg(rate(process_resident_memory_bytes{release=\"$release\", instance=\"$instance\"}[5m]))", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "Resident Mem", | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "avg(rate(process_virtual_memory_bytes{release=\"$release\", instance=\"$instance\"}[5m]))", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "Virtual Mem", | |
"refId": "B" | |
} | |
], | |
"title": "Average Memory Usage", | |
"type": "timeseries" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"description": "Number of open file descriptors", | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "palette-classic" | |
}, | |
"custom": { | |
"axisBorderShow": false, | |
"axisCenteredZero": false, | |
"axisColorMode": "text", | |
"axisLabel": "", | |
"axisPlacement": "auto", | |
"barAlignment": 0, | |
"drawStyle": "line", | |
"fillOpacity": 10, | |
"gradientMode": "none", | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineInterpolation": "linear", | |
"lineWidth": 1, | |
"pointSize": 5, | |
"scaleDistribution": { | |
"type": "linear" | |
}, | |
"showPoints": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "none" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"links": [], | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "short" | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 9, | |
"w": 8, | |
"x": 16, | |
"y": 8 | |
}, | |
"id": 26, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [ | |
"mean", | |
"lastNotNull", | |
"max", | |
"min" | |
], | |
"displayMode": "table", | |
"placement": "bottom", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "none" | |
} | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "process_open_fds{release=\"$release\", instance=\"$instance\"}", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "Open FD", | |
"refId": "A" | |
} | |
], | |
"title": "Open File Descriptors", | |
"type": "timeseries" | |
}, | |
{ | |
"collapsed": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"gridPos": { | |
"h": 1, | |
"w": 24, | |
"x": 0, | |
"y": 17 | |
}, | |
"id": 30, | |
"panels": [], | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"refId": "A" | |
} | |
], | |
"title": "Database Stats", | |
"type": "row" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "${DS_PROMETHEUS}" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "continuous-GrYlRd" | |
}, | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
} | |
}, | |
"overrides": [] | |
}, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 0, | |
"y": 18 | |
}, | |
"id": 72, | |
"options": { | |
"displayMode": "lcd", | |
"minVizHeight": 10, | |
"minVizWidth": 0, | |
"namePlacement": "auto", | |
"orientation": "horizontal", | |
"reduceOptions": { | |
"calcs": [ | |
"lastNotNull" | |
], | |
"fields": "", | |
"values": false | |
}, | |
"showUnfilled": true, | |
"valueMode": "color" | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"editorMode": "code", | |
"expr": "sum by (state) (pg_stat_activity_count)", | |
"instant": false, | |
"legendFormat": "__auto", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Connection Count", | |
"type": "bargauge" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"color": { | |
"mode": "palette-classic" | |
}, | |
"custom": { | |
"axisBorderShow": false, | |
"axisCenteredZero": false, | |
"axisColorMode": "text", | |
"axisLabel": "", | |
"axisPlacement": "auto", | |
"barAlignment": 0, | |
"drawStyle": "line", | |
"fillOpacity": 10, | |
"gradientMode": "none", | |
"hideFrom": { | |
"legend": false, | |
"tooltip": false, | |
"viz": false | |
}, | |
"insertNulls": false, | |
"lineInterpolation": "linear", | |
"lineWidth": 1, | |
"pointSize": 5, | |
"scaleDistribution": { | |
"type": "linear" | |
}, | |
"showPoints": "never", | |
"spanNulls": false, | |
"stacking": { | |
"group": "A", | |
"mode": "normal" | |
}, | |
"thresholdsStyle": { | |
"mode": "off" | |
} | |
}, | |
"links": [], | |
"mappings": [], | |
"thresholds": { | |
"mode": "absolute", | |
"steps": [ | |
{ | |
"color": "green", | |
"value": null | |
}, | |
{ | |
"color": "red", | |
"value": 80 | |
} | |
] | |
}, | |
"unit": "short" | |
}, | |
"overrides": [ | |
{ | |
"matcher": { | |
"id": "byValue", | |
"options": { | |
"op": "gte", | |
"reducer": "allIsZero", | |
"value": 0 | |
} | |
}, | |
"properties": [ | |
{ | |
"id": "custom.hideFrom", | |
"value": { | |
"legend": true, | |
"tooltip": true, | |
"viz": false | |
} | |
} | |
] | |
}, | |
{ | |
"matcher": { | |
"id": "byValue", | |
"options": { | |
"op": "gte", | |
"reducer": "allIsNull", | |
"value": 0 | |
} | |
}, | |
"properties": [ | |
{ | |
"id": "custom.hideFrom", | |
"value": { | |
"legend": true, | |
"tooltip": true, | |
"viz": false | |
} | |
} | |
] | |
} | |
] | |
}, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 11, | |
"y": 18 | |
}, | |
"id": 71, | |
"links": [], | |
"options": { | |
"legend": { | |
"calcs": [ | |
"mean", | |
"lastNotNull", | |
"max", | |
"min" | |
], | |
"displayMode": "table", | |
"placement": "right", | |
"showLegend": true | |
}, | |
"tooltip": { | |
"mode": "multi", | |
"sort": "desc" | |
} | |
}, | |
"pluginVersion": "10.2.2", | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"editorMode": "code", | |
"expr": "topk(100, (pg_stat_activity_count{instance=\"$instance\"}))", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}} {{state}}", | |
"range": true, | |
"refId": "A" | |
} | |
], | |
"title": "Connections in detail", | |
"type": "timeseries" | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 25 | |
}, | |
"hiddenSeries": false, | |
"id": 1, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": true, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": false, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "connected", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 3, | |
"points": true, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_activity_count{datname=~\"$datname\", instance=~\"$instance\", state=\"active\"} !=0", | |
"format": "time_series", | |
"interval": "", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}, s: {{state}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Active sessions", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"decimals": 0, | |
"format": "none", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 25 | |
}, | |
"hiddenSeries": false, | |
"id": 60, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_database_xact_commit{instance=\"$instance\", datname=~\"$datname\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}} commits", | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_database_xact_rollback{instance=\"$instance\", datname=~\"$datname\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}} rollbacks", | |
"refId": "B" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Transactions", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 32 | |
}, | |
"hiddenSeries": false, | |
"id": 6, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_tup_inserted{datname=~\"$datname\", instance=~\"$instance\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Insert data", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 32 | |
}, | |
"hiddenSeries": false, | |
"id": 8, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_tup_updated{datname=~\"$datname\", instance=~\"$instance\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Update data", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 39 | |
}, | |
"hiddenSeries": false, | |
"id": 5, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_tup_fetched{datname=~\"$datname\", instance=~\"$instance\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Fetch data (SELECT)", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 39 | |
}, | |
"hiddenSeries": false, | |
"id": 14, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "total", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_tup_returned{datname=~\"$datname\", instance=~\"$instance\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Return data", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"decimals": 2, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 46 | |
}, | |
"hiddenSeries": false, | |
"id": 62, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_blks_hit{instance=\"$instance\", datname=~\"$datname\"} / (pg_stat_database_blks_read{instance=\"$instance\", datname=~\"$datname\"} + pg_stat_database_blks_hit{instance=\"$instance\", datname=~\"$datname\"})", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{ datname }}", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Cache Hit Rate", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"decimals": 4, | |
"format": "percentunit", | |
"label": "", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"decimals": 0, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 46 | |
}, | |
"hiddenSeries": false, | |
"id": 3, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"hideEmpty": false, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_locks_count{datname=~\"$datname\", instance=~\"$instance\", mode=~\"$mode\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}},{{mode}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Lock tables", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"decimals": 0, | |
"format": "short", | |
"logBase": 1, | |
"min": "0", | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"description": "Total amount of data written to temporary files by queries in this database. All temporary files are counted, regardless of why the temporary file was created, and regardless of the log_temp_files setting.", | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 53 | |
}, | |
"hiddenSeries": false, | |
"id": 68, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_database_temp_bytes{instance=\"$instance\", datname=~\"$datname\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}}", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Temp File (Bytes)", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"min": "0", | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 53 | |
}, | |
"hiddenSeries": false, | |
"id": 4, | |
"legend": { | |
"alignAsTable": true, | |
"avg": false, | |
"current": true, | |
"max": true, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": false, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_activity_count{datname=~\"$datname\", instance=~\"$instance\", state=~\"idle|idle in transaction|idle in transaction (aborted)\"}", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}, s: {{state}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Idle sessions", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"logBase": 1, | |
"min": "0", | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 60 | |
}, | |
"hiddenSeries": false, | |
"id": 64, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": true, | |
"min": true, | |
"rightSide": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_buffers_backend{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "buffers_backend", | |
"refId": "A" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_buffers_alloc{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "buffers_alloc", | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_buffers_backend_fsync{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "backend_fsync", | |
"refId": "C" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_buffers_checkpoint{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "buffers_checkpoint", | |
"refId": "D" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_buffers_clean{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "buffers_clean", | |
"refId": "E" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Buffers (bgwriter)", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fieldConfig": { | |
"defaults": { | |
"links": [] | |
}, | |
"overrides": [] | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 60 | |
}, | |
"hiddenSeries": false, | |
"id": 7, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"sort": "current", | |
"sortDesc": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "pg_stat_database_tup_deleted{datname=~\"$datname\", instance=~\"$instance\"} != 0", | |
"format": "time_series", | |
"intervalFactor": 2, | |
"legendFormat": "{{datname}}", | |
"refId": "A", | |
"step": 2 | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Delete data", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "bytes", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 13, | |
"x": 0, | |
"y": 67 | |
}, | |
"hiddenSeries": false, | |
"id": 70, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": true, | |
"min": true, | |
"show": true, | |
"total": false, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_checkpoint_write_time{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "write_time - Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk.", | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_bgwriter_checkpoint_sync_time{instance=\"$instance\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "sync_time - Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk.", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Checkpoint Stats", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "ms", | |
"logBase": 1, | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
}, | |
{ | |
"aliasColors": {}, | |
"bars": false, | |
"dashLength": 10, | |
"dashes": false, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"decimals": 0, | |
"fill": 1, | |
"fillGradient": 0, | |
"gridPos": { | |
"h": 7, | |
"w": 11, | |
"x": 13, | |
"y": 67 | |
}, | |
"hiddenSeries": false, | |
"id": 66, | |
"legend": { | |
"alignAsTable": true, | |
"avg": true, | |
"current": true, | |
"max": false, | |
"min": false, | |
"rightSide": true, | |
"show": true, | |
"total": true, | |
"values": true | |
}, | |
"lines": true, | |
"linewidth": 1, | |
"links": [], | |
"nullPointMode": "null", | |
"options": { | |
"alertThreshold": true | |
}, | |
"percentage": false, | |
"pluginVersion": "10.2.2", | |
"pointradius": 5, | |
"points": false, | |
"renderer": "flot", | |
"seriesOverrides": [], | |
"spaceLength": 10, | |
"stack": false, | |
"steppedLine": false, | |
"targets": [ | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_database_conflicts{instance=\"$instance\", datname=~\"$datname\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}} conflicts", | |
"refId": "B" | |
}, | |
{ | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"expr": "irate(pg_stat_database_deadlocks{instance=\"$instance\", datname=~\"$datname\"}[5m])", | |
"format": "time_series", | |
"intervalFactor": 1, | |
"legendFormat": "{{datname}} deadlocks", | |
"refId": "A" | |
} | |
], | |
"thresholds": [], | |
"timeRegions": [], | |
"title": "Conflicts/Deadlocks", | |
"tooltip": { | |
"shared": true, | |
"sort": 0, | |
"value_type": "individual" | |
}, | |
"type": "graph", | |
"xaxis": { | |
"mode": "time", | |
"show": true, | |
"values": [] | |
}, | |
"yaxes": [ | |
{ | |
"format": "short", | |
"logBase": 1, | |
"min": "0", | |
"show": true | |
}, | |
{ | |
"format": "short", | |
"logBase": 1, | |
"show": true | |
} | |
], | |
"yaxis": { | |
"align": false | |
} | |
} | |
], | |
"refresh": "5m", | |
"schemaVersion": 38, | |
"tags": [ | |
"postgres", | |
"db", | |
"stats" | |
], | |
"templating": { | |
"list": [ | |
{ | |
"current": { | |
"selected": false, | |
"text": "Prometheus", | |
"value": "prometheus" | |
}, | |
"hide": 0, | |
"includeAll": false, | |
"label": "datasource", | |
"multi": false, | |
"name": "DS_PROMETHEUS", | |
"options": [], | |
"query": "prometheus", | |
"refresh": 1, | |
"regex": "", | |
"skipUrlSync": false, | |
"type": "datasource" | |
}, | |
{ | |
"auto": true, | |
"auto_count": 200, | |
"auto_min": "1s", | |
"current": { | |
"selected": false, | |
"text": "auto", | |
"value": "$__auto_interval_interval" | |
}, | |
"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" | |
}, | |
{ | |
"current": { | |
"isNone": true, | |
"selected": false, | |
"text": "None", | |
"value": "" | |
}, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"definition": "", | |
"hide": 2, | |
"includeAll": false, | |
"label": "Namespace", | |
"multi": false, | |
"name": "namespace", | |
"options": [], | |
"query": "query_result(pg_exporter_last_scrape_duration_seconds)", | |
"refresh": 2, | |
"regex": "/.*kubernetes_namespace=\"([^\"]+).*/", | |
"skipUrlSync": false, | |
"sort": 1, | |
"tagValuesQuery": "", | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
}, | |
{ | |
"current": { | |
"isNone": true, | |
"selected": false, | |
"text": "None", | |
"value": "" | |
}, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"definition": "", | |
"hide": 2, | |
"includeAll": false, | |
"label": "Release", | |
"multi": false, | |
"name": "release", | |
"options": [], | |
"query": "query_result(pg_exporter_last_scrape_duration_seconds{kubernetes_namespace=\"$namespace\"})", | |
"refresh": 2, | |
"regex": "/.*release=\"([^\"]+)/", | |
"skipUrlSync": false, | |
"sort": 1, | |
"tagValuesQuery": "", | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
}, | |
{ | |
"current": { | |
"selected": false, | |
"text": "pgexporter-prometheus-postgres-exporter:80", | |
"value": "pgexporter-prometheus-postgres-exporter:80" | |
}, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"definition": "", | |
"hide": 0, | |
"includeAll": false, | |
"label": "Instance", | |
"multi": false, | |
"name": "instance", | |
"options": [], | |
"query": "query_result(pg_up{release=\"$release\"})", | |
"refresh": 1, | |
"regex": "/.*instance=\"([^\"]+).*/", | |
"skipUrlSync": false, | |
"sort": 1, | |
"tagValuesQuery": "", | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
}, | |
{ | |
"current": { | |
"selected": false, | |
"text": "All", | |
"value": "$__all" | |
}, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"definition": "", | |
"hide": 0, | |
"includeAll": true, | |
"label": "Database", | |
"multi": true, | |
"name": "datname", | |
"options": [], | |
"query": "label_values(datname)", | |
"refresh": 1, | |
"regex": "", | |
"skipUrlSync": false, | |
"sort": 1, | |
"tagValuesQuery": "", | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
}, | |
{ | |
"current": { | |
"selected": false, | |
"text": "All", | |
"value": "$__all" | |
}, | |
"datasource": { | |
"type": "prometheus", | |
"uid": "prometheus" | |
}, | |
"definition": "", | |
"hide": 0, | |
"includeAll": true, | |
"label": "Lock table", | |
"multi": true, | |
"name": "mode", | |
"options": [], | |
"query": "label_values({mode=~\"accessexclusivelock|accesssharelock|exclusivelock|rowexclusivelock|rowsharelock|sharelock|sharerowexclusivelock|shareupdateexclusivelock\"}, mode)", | |
"refresh": 1, | |
"regex": "", | |
"skipUrlSync": false, | |
"sort": 0, | |
"tagValuesQuery": "", | |
"tagsQuery": "", | |
"type": "query", | |
"useTags": false | |
} | |
] | |
}, | |
"time": { | |
"from": "now-6h", | |
"to": "now" | |
}, | |
"timepicker": { | |
"refresh_intervals": [ | |
"5s", | |
"10s", | |
"30s", | |
"1m", | |
"5m", | |
"15m", | |
"30m", | |
"1h", | |
"2h", | |
"1d" | |
], | |
"time_options": [ | |
"5m", | |
"15m", | |
"1h", | |
"6h", | |
"12h", | |
"24h", | |
"2d", | |
"7d", | |
"30d" | |
] | |
}, | |
"timezone": "", | |
"title": "PostgreSQL", | |
"uid": "000000039", | |
"version": 10, | |
"weekStart": "" | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment