{
    "__inputs": [
        {
            "name": "prometheus",
            "label": "prometheus",
            "description": "",
            "type": "datasource",
            "pluginId": "prometheus",
            "pluginName": "Prometheus"
        }
    ],
    "__requires": [
        {
            "type": "panel",
            "id": "gauge",
            "name": "Gauge",
            "version": ""
        },
        {
            "type": "grafana",
            "id": "grafana",
            "name": "Grafana",
            "version": "7.0.3"
        },
        {
            "type": "panel",
            "id": "graph",
            "name": "Graph",
            "version": ""
        },
        {
            "type": "datasource",
            "id": "prometheus",
            "name": "Prometheus",
            "version": "1.0.0"
        },
        {
            "type": "panel",
            "id": "singlestat",
            "name": "Singlestat",
            "version": ""
        }
    ],
    "annotations": {
        "list": [
            {
                "builtIn": 1,
                "datasource": "-- Grafana --",
                "enable": true,
                "hide": true,
                "iconColor": "rgba(0, 211, 255, 1)",
                "name": "Annotations & Alerts",
                "type": "dashboard"
            }
        ]
    },
    "editable": true,
    "gnetId": 12485,
    "graphTooltip": 0,
    "id": null,
    "iteration": 1592399036513,
    "links": [],
    "panels": [
        {
            "collapsed": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "gridPos": {
                "h": 1,
                "w": 24,
                "x": 0,
                "y": 0
            },
            "id": 18,
            "panels": [],
            "title": "Global Statistics",
            "type": "row"
        },
        {
            "cacheTimeout": null,
            "colorBackground": false,
            "colorValue": false,
            "colors": ["#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a"],
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Source: server_version_num",
            "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": 1
            },
            "id": 11,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "max(pg_settings_server_version_num)",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "PostgreSQL Version",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Max Replication lag behind master in seconds\n\nOnly available on a standby system.\n\nSource: pg_last_xact_replay_timestamp\n\nUse: pg_stat_replication for Details.",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "s",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 4,
                "y": 1
            },
            "id": 84,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "max(pg_replication_lag{instance=\"$Instance\"})",
                    "interval": "",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Max Replication Lag",
            "type": "singlestat",
            "valueFontSize": "80%",
            "valueMaps": [
                {
                    "op": "=",
                    "text": "N/A",
                    "value": "null"
                }
            ],
            "valueName": "max"
        },
        {
            "cacheTimeout": null,
            "colorBackground": false,
            "colorValue": false,
            "colors": ["#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a"],
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Clients executing Statements.\n\nSource: pg_stat_activity",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "none",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 8,
                "y": 1
            },
            "id": 23,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "sum(pg_stat_activity_count{state=\"active\",instance=\"$Instance\"})",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Active clients",
            "type": "singlestat",
            "valueFontSize": "80%",
            "valueMaps": [
                {
                    "op": "=",
                    "text": "N/A",
                    "value": "null"
                }
            ],
            "valueName": "current"
        },
        {
            "cacheTimeout": null,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Shared buffer hits vs reads from disc",
            "fieldConfig": {
                "defaults": {
                    "custom": {},
                    "decimals": 2,
                    "mappings": [
                        {
                            "id": 0,
                            "op": "=",
                            "text": "N/A",
                            "type": 1,
                            "value": "null"
                        }
                    ],
                    "nullValueMode": "connected",
                    "thresholds": {
                        "mode": "absolute",
                        "steps": [
                            {
                                "color": "semi-dark-red",
                                "value": null
                            },
                            {
                                "color": "semi-dark-yellow",
                                "value": 80
                            },
                            {
                                "color": "semi-dark-green",
                                "value": 90
                            }
                        ]
                    },
                    "unit": "percent"
                },
                "overrides": []
            },
            "gridPos": {
                "h": 6,
                "w": 4,
                "x": 12,
                "y": 1
            },
            "id": 16,
            "links": [],
            "options": {
                "orientation": "horizontal",
                "reduceOptions": {
                    "calcs": ["lastNotNull"],
                    "fields": "",
                    "values": false
                },
                "showThresholdLabels": false,
                "showThresholdMarkers": true
            },
            "pluginVersion": "7.0.3",
            "targets": [
                {
                    "expr": "sum(pg_stat_database_blks_hit{instance=~\"$Instance\"})/(sum(pg_stat_database_blks_hit{instance=~\"$Instance\"})+sum(pg_stat_database_blks_read{instance=~\"$Instance\"}))*100",
                    "refId": "A"
                }
            ],
            "timeFrom": null,
            "timeShift": null,
            "title": "Shared Buffer Hits",
            "type": "gauge"
        },
        {
            "cacheTimeout": null,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Percentage of max_connections used",
            "fieldConfig": {
                "defaults": {
                    "custom": {},
                    "decimals": 0,
                    "mappings": [
                        {
                            "id": 0,
                            "op": "=",
                            "text": "N/A",
                            "type": 1,
                            "value": "null"
                        }
                    ],
                    "nullValueMode": "connected",
                    "thresholds": {
                        "mode": "absolute",
                        "steps": [
                            {
                                "color": "semi-dark-green",
                                "value": null
                            },
                            {
                                "color": "semi-dark-yellow",
                                "value": 0.75
                            },
                            {
                                "color": "semi-dark-red",
                                "value": 0.9
                            }
                        ]
                    },
                    "unit": "percentunit"
                },
                "overrides": []
            },
            "gridPos": {
                "h": 6,
                "w": 4,
                "x": 16,
                "y": 1
            },
            "id": 9,
            "links": [],
            "options": {
                "orientation": "horizontal",
                "reduceOptions": {
                    "calcs": ["last"],
                    "fields": "",
                    "values": false
                },
                "showThresholdLabels": false,
                "showThresholdMarkers": true
            },
            "pluginVersion": "7.0.3",
            "targets": [
                {
                    "expr": "sum(pg_stat_database_numbackends)/max(pg_settings_max_connections)",
                    "refId": "A"
                }
            ],
            "timeFrom": null,
            "timeShift": null,
            "title": "Connections used",
            "type": "gauge"
        },
        {
            "cacheTimeout": null,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Transaction committed vs rollbacked",
            "fieldConfig": {
                "defaults": {
                    "custom": {},
                    "decimals": 2,
                    "mappings": [
                        {
                            "id": 0,
                            "op": "=",
                            "text": "N/A",
                            "type": 1,
                            "value": "null"
                        }
                    ],
                    "nullValueMode": "connected",
                    "thresholds": {
                        "mode": "absolute",
                        "steps": [
                            {
                                "color": "semi-dark-red",
                                "value": null
                            },
                            {
                                "color": "#EAB839",
                                "value": 0.75
                            },
                            {
                                "color": "semi-dark-green",
                                "value": 0.9
                            }
                        ]
                    },
                    "unit": "percentunit"
                },
                "overrides": []
            },
            "gridPos": {
                "h": 6,
                "w": 4,
                "x": 20,
                "y": 1
            },
            "id": 15,
            "links": [],
            "options": {
                "orientation": "horizontal",
                "reduceOptions": {
                    "calcs": ["lastNotNull"],
                    "fields": "",
                    "values": false
                },
                "showThresholdLabels": false,
                "showThresholdMarkers": true
            },
            "pluginVersion": "7.0.3",
            "targets": [
                {
                    "expr": "sum(pg_stat_database_xact_commit{instance=\"$Instance\"})/(sum(pg_stat_database_xact_commit{instance=\"$Instance\"}) + sum(pg_stat_database_xact_rollback{instance=\"$Instance\"}))",
                    "refId": "A"
                }
            ],
            "timeFrom": null,
            "timeShift": null,
            "title": "Commit Ratio",
            "type": "gauge"
        },
        {
            "cacheTimeout": null,
            "colorBackground": false,
            "colorValue": false,
            "colors": ["#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a"],
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 1,
            "description": "Source: pg_postmaster_start_time()",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "s",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 0,
                "y": 4
            },
            "id": 57,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "{instance=\"db01vp-nbg6a.obs.noris.net:9187\", job=\"postgres-exporter\", server=\"213.95.132.73:5432\"}",
            "targets": [
                {
                    "expr": "time()-(pg_postmaster_start_time_seconds{instance=\"$Instance\"})",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "PostgreSQL Uptime",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Transactions committed + roolback per minute\n\nSource: pg_stat_database,xact_commit + xact_rollback",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "none",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 4,
                "y": 4
            },
            "id": 14,
            "interval": "",
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "sum((rate(pg_stat_database_xact_commit{instance=\"$Instance\"}[$Interval])))+sum((rate(pg_stat_database_xact_rollback{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Transaction rate",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Statements executed per Minute.\n\nSource: pg_stat_statements.calls",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "none",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 8,
                "y": 4
            },
            "id": 93,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "sum((rate(pg_stat_statements_calls{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Query rate",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 2,
            "description": "Size of all databases in $Instance.\n\nSource: pg_database_size()",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "bytes",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 0,
                "y": 7
            },
            "id": 37,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "sum(pg_database_size{instance=\"$Instance\"})",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Total database size",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Source: pg_stat_statements.total_time / pg_stat_statements.calls",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "s",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 8,
                "y": 7
            },
            "id": 102,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "",
            "targets": [
                {
                    "expr": "sum((delta(pg_stat_statements_total_time_seconds{instance=\"$Instance\"}[$Interval])))/sum((delta(pg_stat_statements_calls{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Average query runtime",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 0,
            "description": "Setting: shared_buffers in PostgreSQL.conf",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "bytes",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 12,
                "y": 7
            },
            "id": 66,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "pg_settings_shared_buffers_bytes{instance=\"db01vp-nbg6a.obs.noris.net:9187\", job=\"postgres-exporter\", server=\"213.95.132.73:5432\"}",
            "targets": [
                {
                    "expr": "pg_settings_shared_buffers_bytes{instance=\"$Instance\"}",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Shared Buffers",
            "type": "singlestat",
            "valueFontSize": "80%",
            "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Setting: max_connections in postgreSQL.conf",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "format": "none",
            "gauge": {
                "maxValue": 100,
                "minValue": 0,
                "show": false,
                "thresholdLabels": false,
                "thresholdMarkers": true
            },
            "gridPos": {
                "h": 3,
                "w": 4,
                "x": 16,
                "y": 7
            },
            "id": 75,
            "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,
                "ymax": null,
                "ymin": null
            },
            "tableColumn": "pg_settings_max_connections{instance=\"db01vp-nbg6a.obs.noris.net:9187\", job=\"postgres-exporter\", server=\"213.95.132.73:5432\"}",
            "targets": [
                {
                    "expr": "pg_settings_max_connections{instance=\"$Instance\"}",
                    "refId": "A"
                }
            ],
            "thresholds": "",
            "timeFrom": null,
            "timeShift": null,
            "title": "Max Connections",
            "type": "singlestat",
            "valueFontSize": "80%",
            "valueMaps": [
                {
                    "op": "=",
                    "text": "N/A",
                    "value": "null"
                }
            ],
            "valueName": "current"
        },
        {
            "aliasColors": {},
            "bars": true,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 0,
            "description": "View: pg_stat_activity",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 0,
                "y": 10
            },
            "hiddenSeries": false,
            "id": 24,
            "interval": "$Interval",
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideEmpty": true,
                "hideZero": true,
                "max": true,
                "min": false,
                "rightSide": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": false,
            "linewidth": 1,
            "links": [
                {
                    "targetBlank": true,
                    "title": "PostgreSQL Documentation",
                    "url": "https://www.postgresql.org/docs/current/monitoring-stats.html"
                }
            ],
            "nullPointMode": "null as zero",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": true,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum by (state) (pg_stat_activity_count{instance=\"$Instance\"})",
                    "legendFormat": "{{state}}",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Connections by state (stacked)",
            "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
                },
                {
                    "decimals": 0,
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": null,
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": true,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 0,
            "description": "View: pg_stat_activity",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 12,
                "y": 10
            },
            "hiddenSeries": false,
            "id": 28,
            "interval": "$Interval",
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideEmpty": true,
                "hideZero": true,
                "max": true,
                "min": false,
                "rightSide": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": false,
            "linewidth": 1,
            "links": [
                {
                    "targetBlank": true,
                    "title": "PostgreSQL Documentation",
                    "url": "https://www.postgresql.org/docs/current/monitoring-stats.html"
                }
            ],
            "nullPointMode": "null as zero",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": true,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum by (datname) (pg_stat_activity_count{instance=\"$Instance\"})",
                    "legendFormat": "{{datname}}",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Connections by database (stacked)",
            "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
                },
                {
                    "decimals": 0,
                    "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "decimals": 2,
            "description": "1 Minute rate of transactions committed or rollback.",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 0,
                "y": 19
            },
            "hiddenSeries": false,
            "id": 12,
            "interval": "",
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideEmpty": false,
                "hideZero": false,
                "max": true,
                "min": false,
                "rightSide": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum ((rate(pg_stat_database_xact_commit[$Interval])))",
                    "interval": "",
                    "legendFormat": "committed",
                    "refId": "A"
                },
                {
                    "expr": "sum ((rate(pg_stat_database_xact_rollback[$Interval])))",
                    "hide": false,
                    "interval": "",
                    "legendFormat": "rollback",
                    "refId": "B"
                }
            ],
            "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": "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
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Source: pg_stat_database",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 12,
                "y": 19
            },
            "hiddenSeries": false,
            "id": 27,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideZero": false,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum((rate(pg_stat_database_tup_inserted{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "Inserts",
                    "refId": "A"
                },
                {
                    "expr": "sum((rate(pg_stat_database_tup_updated{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "Updates",
                    "refId": "B"
                },
                {
                    "expr": "sum((rate(pg_stat_database_tup_deleted{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "Deletes",
                    "refId": "C"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Tuples inserts/updates/deletes",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "none",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                },
                {
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "* blk_read_time: Time spent reading data file blocks by backends in this database, in milliseconds\n* blk_write_time: Time spent writing data file blocks by backends in this database, in milliseconds\n\ntrack_io_timings needs to be activated",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 0,
                "y": 28
            },
            "hiddenSeries": false,
            "id": 26,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum ((rate(pg_stat_database_blk_read_time{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "blk_read_time",
                    "refId": "A"
                },
                {
                    "expr": "sum ((rate(pg_stat_database_blk_write_time{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "blk_read_time",
                    "refId": "B"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "I/O Read/Write time",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "ms",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                },
                {
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Source: pg_stat_database\n\n* tup_fetched: rows needed to satisfy queries\n* tup_returned: rows read/scanned",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 9,
                "w": 12,
                "x": 12,
                "y": 28
            },
            "hiddenSeries": false,
            "id": 111,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideZero": false,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum((rate(pg_stat_database_tup_fetched{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "Fetched",
                    "refId": "A"
                },
                {
                    "expr": "sum((rate(pg_stat_database_tup_returned{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "Returned",
                    "refId": "B"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Tuples fetched/returned",
            "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": "0",
                    "show": false
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Source: pg_locks",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 10,
                "w": 12,
                "x": 0,
                "y": 37
            },
            "hiddenSeries": false,
            "id": 29,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "links": [
                {
                    "title": "PostgreSQL Lock Modes",
                    "url": "https://www.postgresql.org/docs/12/explicit-locking.html#LOCKING-TABLES"
                }
            ],
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum by (mode) (pg_locks_count{instance=\"$Instance\"})",
                    "legendFormat": "{{mode}}",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Locks by state",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "none",
                    "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": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Should be 0 \n\nSource: pg_stat_database\n\nWith log_lock_waits turned on, deadlocks will be logged to the PostgreSQL Logfiles.",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 5,
                "w": 12,
                "x": 12,
                "y": 37
            },
            "hiddenSeries": false,
            "id": 30,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideEmpty": true,
                "hideZero": true,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "links": [
                {
                    "title": "PostgreSQL Locking",
                    "url": "https://www.postgresql.org/docs/12/explicit-locking.html"
                }
            ],
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum by (datname) ((rate(pg_stat_database_deadlocks{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "{{datname}}",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Deadlocks by database",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "none",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                },
                {
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Should be 0. If temporary files are created, it can indicate insufficient work_mem. With log_temp_files the creation of temporary files are logged to the PostgreSQL Logfiles.",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 5,
                "w": 12,
                "x": 12,
                "y": 42
            },
            "hiddenSeries": false,
            "id": 31,
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "hideEmpty": true,
                "hideZero": true,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "links": [
                {
                    "title": "PostgreSQL Ressources",
                    "url": "https://www.postgresql.org/docs/current/runtime-config-resource.html"
                }
            ],
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "sum by (datname) ((rate(pg_stat_database_temp_files{instance=\"$Instance\"}[$Interval])))",
                    "interval": "",
                    "legendFormat": "{{datname}}",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Temporary files by database",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "none",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                },
                {
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "aliasColors": {},
            "bars": false,
            "dashLength": 10,
            "dashes": false,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "description": "Lag behind master in seconds.\n\nOnly available on a standby System.",
            "fieldConfig": {
                "defaults": {
                    "custom": {}
                },
                "overrides": []
            },
            "fill": 1,
            "fillGradient": 0,
            "gridPos": {
                "h": 10,
                "w": 12,
                "x": 0,
                "y": 47
            },
            "hiddenSeries": false,
            "id": 120,
            "interval": "1m",
            "legend": {
                "alignAsTable": true,
                "avg": true,
                "current": true,
                "max": true,
                "min": false,
                "show": true,
                "total": false,
                "values": true
            },
            "lines": true,
            "linewidth": 1,
            "links": [],
            "nullPointMode": "null",
            "options": {
                "dataLinks": []
            },
            "percentage": false,
            "pointradius": 2,
            "points": false,
            "renderer": "flot",
            "seriesOverrides": [],
            "spaceLength": 10,
            "stack": false,
            "steppedLine": false,
            "targets": [
                {
                    "expr": "max(pg_replication_lag{instance=\"$Instance\"})",
                    "instant": false,
                    "intervalFactor": 1,
                    "legendFormat": "lag ",
                    "refId": "A"
                }
            ],
            "thresholds": [],
            "timeFrom": null,
            "timeRegions": [],
            "timeShift": null,
            "title": "Replication lag ",
            "tooltip": {
                "shared": true,
                "sort": 0,
                "value_type": "individual"
            },
            "type": "graph",
            "xaxis": {
                "buckets": null,
                "mode": "time",
                "name": null,
                "show": true,
                "values": []
            },
            "yaxes": [
                {
                    "format": "s",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                },
                {
                    "format": "short",
                    "label": null,
                    "logBase": 1,
                    "max": null,
                    "min": "0",
                    "show": true
                }
            ],
            "yaxis": {
                "align": false,
                "alignLevel": null
            }
        },
        {
            "collapsed": true,
            "datasource": {
                "type": "prometheus",
                "uid": "prometheus"
            },
            "gridPos": {
                "h": 1,
                "w": 24,
                "x": 0,
                "y": 57
            },
            "id": 20,
            "panels": [
                {
                    "cacheTimeout": null,
                    "colorBackground": false,
                    "colorValue": false,
                    "colors": [
                        "#299c46",
                        "rgba(237, 129, 40, 0.89)",
                        "#d44a3a"
                    ],
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "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": 2
                    },
                    "id": 46,
                    "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"
                        }
                    ],
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "sparkline": {
                        "fillColor": "rgba(31, 118, 189, 0.18)",
                        "full": false,
                        "lineColor": "rgb(31, 120, 193)",
                        "show": true,
                        "ymax": null,
                        "ymin": null
                    },
                    "tableColumn": "pg_stat_activity_count{datname=\"grafana\", instance=\"db01vp-nbg6a.obs.noris.net:9187\", job=\"postgres-exporter\", server=\"213.95.132.73:5432\", state=\"active\"}",
                    "targets": [
                        {
                            "expr": "pg_stat_activity_count{state=\"active\",instance=\"$Instance\",datname=~\"$Database\"}",
                            "refId": "A"
                        }
                    ],
                    "thresholds": "",
                    "timeFrom": null,
                    "timeShift": null,
                    "title": "Active clients",
                    "type": "singlestat",
                    "valueFontSize": "80%",
                    "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": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "decimals": 2,
                    "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": 2
                    },
                    "id": 43,
                    "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"
                        }
                    ],
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "sparkline": {
                        "fillColor": "rgba(31, 118, 189, 0.18)",
                        "full": false,
                        "lineColor": "rgb(31, 120, 193)",
                        "show": true,
                        "ymax": null,
                        "ymin": null
                    },
                    "tableColumn": "pg_database_size{datname=\"grafana\", instance=\"db01vp-nbg6a.obs.noris.net:9187\", job=\"postgres-exporter\", server=\"213.95.132.73:5432\"}",
                    "targets": [
                        {
                            "expr": "pg_database_size{instance=\"$Instance\",datname=\"$Database\"}",
                            "refId": "A"
                        }
                    ],
                    "thresholds": "",
                    "timeFrom": null,
                    "timeShift": null,
                    "title": "Database size",
                    "type": "singlestat",
                    "valueFontSize": "80%",
                    "valueMaps": [
                        {
                            "op": "=",
                            "text": "N/A",
                            "value": "null"
                        }
                    ],
                    "valueName": "current"
                },
                {
                    "cacheTimeout": null,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Shared buffer hits vs reads from disc",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {},
                            "decimals": 2,
                            "mappings": [
                                {
                                    "id": 0,
                                    "op": "=",
                                    "text": "N/A",
                                    "type": 1,
                                    "value": "null"
                                }
                            ],
                            "nullValueMode": "connected",
                            "thresholds": {
                                "mode": "absolute",
                                "steps": [
                                    {
                                        "color": "semi-dark-red",
                                        "value": null
                                    },
                                    {
                                        "color": "semi-dark-yellow",
                                        "value": 0.8
                                    },
                                    {
                                        "color": "semi-dark-green",
                                        "value": 0.9
                                    }
                                ]
                            },
                            "unit": "percentunit"
                        },
                        "overrides": []
                    },
                    "gridPos": {
                        "h": 6,
                        "w": 4,
                        "x": 8,
                        "y": 2
                    },
                    "id": 44,
                    "links": [],
                    "options": {
                        "orientation": "horizontal",
                        "reduceOptions": {
                            "calcs": ["lastNotNull"],
                            "fields": "",
                            "values": false
                        },
                        "showThresholdLabels": false,
                        "showThresholdMarkers": true
                    },
                    "pluginVersion": "7.0.3",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "targets": [
                        {
                            "expr": "pg_stat_database_blks_hit{instance=~\"$Instance\",datname=~\"$Database\"}/(pg_stat_database_blks_hit{instance=~\"$Instance\",datname=~\"$Database\"}+pg_stat_database_blks_read{instance=~\"$Instance\",datname=~\"$Database\"})",
                            "refId": "A"
                        }
                    ],
                    "timeFrom": null,
                    "timeShift": null,
                    "title": "Shared Buffer Hits",
                    "type": "gauge"
                },
                {
                    "cacheTimeout": null,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Transaction committed vs rollbacked",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {},
                            "decimals": 2,
                            "mappings": [
                                {
                                    "id": 0,
                                    "op": "=",
                                    "text": "N/A",
                                    "type": 1,
                                    "value": "null"
                                }
                            ],
                            "nullValueMode": "connected",
                            "thresholds": {
                                "mode": "absolute",
                                "steps": [
                                    {
                                        "color": "semi-dark-red",
                                        "value": null
                                    },
                                    {
                                        "color": "#EAB839",
                                        "value": 0.75
                                    },
                                    {
                                        "color": "semi-dark-green",
                                        "value": 0.9
                                    }
                                ]
                            },
                            "unit": "percentunit"
                        },
                        "overrides": []
                    },
                    "gridPos": {
                        "h": 6,
                        "w": 4,
                        "x": 12,
                        "y": 2
                    },
                    "id": 45,
                    "links": [],
                    "options": {
                        "orientation": "horizontal",
                        "reduceOptions": {
                            "calcs": ["lastNotNull"],
                            "fields": "",
                            "values": false
                        },
                        "showThresholdLabels": false,
                        "showThresholdMarkers": true
                    },
                    "pluginVersion": "7.0.3",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "targets": [
                        {
                            "expr": "pg_stat_database_xact_commit{instance=\"$Instance\",datname=~\"$Database\"}/(pg_stat_database_xact_commit{instance=\"$Instance\",datname=~\"$Database\"} + pg_stat_database_xact_rollback{instance=\"$Instance\",datname=~\"$Database\"})",
                            "refId": "A"
                        }
                    ],
                    "timeFrom": null,
                    "timeShift": null,
                    "title": "Commit Ratio",
                    "type": "gauge"
                },
                {
                    "cacheTimeout": null,
                    "colorBackground": false,
                    "colorValue": false,
                    "colors": [
                        "#299c46",
                        "rgba(237, 129, 40, 0.89)",
                        "#d44a3a"
                    ],
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Transactions committed + roolback per minute\n\nSource: pg_stat_database,xact_commit + xact_rollback",
                    "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": 122,
                    "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"
                        }
                    ],
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "sparkline": {
                        "fillColor": "rgba(31, 118, 189, 0.18)",
                        "full": false,
                        "lineColor": "rgb(31, 120, 193)",
                        "show": true,
                        "ymax": null,
                        "ymin": null
                    },
                    "tableColumn": "",
                    "targets": [
                        {
                            "expr": "sum((rate(pg_stat_database_xact_commit{instance=\"$Instance\",datname=\"$Database\"}[$Interval])))+sum((rate(pg_stat_database_xact_rollback{instance=\"$Instance\",datname=\"$Database\"}[$Interval])))",
                            "interval": "",
                            "legendFormat": "",
                            "refId": "A"
                        }
                    ],
                    "thresholds": "",
                    "timeFrom": null,
                    "timeShift": null,
                    "title": "Transaction rate",
                    "type": "singlestat",
                    "valueFontSize": "80%",
                    "valueMaps": [
                        {
                            "op": "=",
                            "text": "N/A",
                            "value": "null"
                        }
                    ],
                    "valueName": "current"
                },
                {
                    "aliasColors": {},
                    "bars": true,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "decimals": 0,
                    "description": "View: pg_stat_activity",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 9,
                        "w": 12,
                        "x": 0,
                        "y": 8
                    },
                    "hiddenSeries": false,
                    "id": 47,
                    "interval": "$Interval",
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideEmpty": true,
                        "hideZero": true,
                        "max": true,
                        "min": false,
                        "rightSide": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": false,
                    "linewidth": 1,
                    "links": [
                        {
                            "targetBlank": true,
                            "title": "PostgreSQL Documentation",
                            "url": "https://www.postgresql.org/docs/current/monitoring-stats.html"
                        }
                    ],
                    "nullPointMode": "null as zero",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": true,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "sum by (state) (pg_stat_activity_count{instance=\"$Instance\",datname=\"$Database\"})",
                            "legendFormat": "{{state}}",
                            "refId": "A"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Connections by state (stacked)",
                    "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
                        },
                        {
                            "decimals": 0,
                            "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": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "decimals": 2,
                    "description": "1 Minute rate of transactions committed or rollback.",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 9,
                        "w": 12,
                        "x": 12,
                        "y": 8
                    },
                    "hiddenSeries": false,
                    "id": 48,
                    "interval": "",
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideEmpty": false,
                        "hideZero": false,
                        "max": true,
                        "min": false,
                        "rightSide": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "rate(pg_stat_database_xact_commit{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "committed",
                            "refId": "A"
                        },
                        {
                            "expr": "rate(pg_stat_database_xact_rollback{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "hide": false,
                            "interval": "",
                            "legendFormat": "rollback",
                            "refId": "B"
                        }
                    ],
                    "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": "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
                    }
                },
                {
                    "aliasColors": {},
                    "bars": false,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Source: pg_stat_database",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 9,
                        "w": 12,
                        "x": 0,
                        "y": 17
                    },
                    "hiddenSeries": false,
                    "id": 124,
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideZero": false,
                        "max": true,
                        "min": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "rate(pg_stat_database_tup_inserted{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "Inserts",
                            "refId": "A"
                        },
                        {
                            "expr": "rate(pg_stat_database_tup_updated{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "Updates",
                            "refId": "B"
                        },
                        {
                            "expr": "rate(pg_stat_database_tup_deleted{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "Deletes",
                            "refId": "C"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Tuples inserts/updates/deletes",
                    "tooltip": {
                        "shared": true,
                        "sort": 0,
                        "value_type": "individual"
                    },
                    "type": "graph",
                    "xaxis": {
                        "buckets": null,
                        "mode": "time",
                        "name": null,
                        "show": true,
                        "values": []
                    },
                    "yaxes": [
                        {
                            "format": "none",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        },
                        {
                            "format": "short",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        }
                    ],
                    "yaxis": {
                        "align": false,
                        "alignLevel": null
                    }
                },
                {
                    "aliasColors": {},
                    "bars": false,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Source: pg_stat_database\n\n* tup_fetched: rows needed to satisfy queries\n* tup_returned: rows read/scanned",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 9,
                        "w": 12,
                        "x": 12,
                        "y": 17
                    },
                    "hiddenSeries": false,
                    "id": 126,
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideZero": false,
                        "max": true,
                        "min": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "rate(pg_stat_database_tup_fetched{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "Fetched",
                            "refId": "A"
                        },
                        {
                            "expr": "rate(pg_stat_database_tup_returned{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "Returned",
                            "refId": "B"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Tuples fetched/returned",
                    "tooltip": {
                        "shared": true,
                        "sort": 0,
                        "value_type": "individual"
                    },
                    "type": "graph",
                    "xaxis": {
                        "buckets": null,
                        "mode": "time",
                        "name": null,
                        "show": true,
                        "values": []
                    },
                    "yaxes": [
                        {
                            "format": "none",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        },
                        {
                            "format": "short",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        }
                    ],
                    "yaxis": {
                        "align": false,
                        "alignLevel": null
                    }
                },
                {
                    "aliasColors": {},
                    "bars": false,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Source: pg_locks",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 10,
                        "w": 12,
                        "x": 0,
                        "y": 26
                    },
                    "hiddenSeries": false,
                    "id": 128,
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "max": true,
                        "min": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "links": [
                        {
                            "title": "PostgreSQL Lock Modes",
                            "url": "https://www.postgresql.org/docs/12/explicit-locking.html#LOCKING-TABLES"
                        }
                    ],
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "sum by (mode) (pg_locks_count{instance=\"$Instance\",datname=\"$Database\"})",
                            "legendFormat": "{{mode}}",
                            "refId": "A"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Locks by state",
                    "tooltip": {
                        "shared": true,
                        "sort": 0,
                        "value_type": "individual"
                    },
                    "type": "graph",
                    "xaxis": {
                        "buckets": null,
                        "mode": "time",
                        "name": null,
                        "show": true,
                        "values": []
                    },
                    "yaxes": [
                        {
                            "format": "none",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        },
                        {
                            "format": "short",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        }
                    ],
                    "yaxis": {
                        "align": false,
                        "alignLevel": null
                    }
                },
                {
                    "aliasColors": {},
                    "bars": false,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Should be 0 \n\nSource: pg_stat_database\n\nWith log_lock_waits turned on, deadlocks will be logged to the PostgreSQL Logfiles.",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 5,
                        "w": 12,
                        "x": 12,
                        "y": 26
                    },
                    "hiddenSeries": false,
                    "id": 130,
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideEmpty": true,
                        "hideZero": true,
                        "max": true,
                        "min": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "links": [
                        {
                            "title": "PostgreSQL Locking",
                            "url": "https://www.postgresql.org/docs/12/explicit-locking.html"
                        }
                    ],
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "rate(pg_stat_database_deadlocks{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "deadlocks",
                            "refId": "A"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Deadlocks by database",
                    "tooltip": {
                        "shared": true,
                        "sort": 0,
                        "value_type": "individual"
                    },
                    "type": "graph",
                    "xaxis": {
                        "buckets": null,
                        "mode": "time",
                        "name": null,
                        "show": true,
                        "values": []
                    },
                    "yaxes": [
                        {
                            "format": "none",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        },
                        {
                            "format": "short",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        }
                    ],
                    "yaxis": {
                        "align": false,
                        "alignLevel": null
                    }
                },
                {
                    "aliasColors": {},
                    "bars": false,
                    "dashLength": 10,
                    "dashes": false,
                    "datasource": {
                        "type": "prometheus",
                        "uid": "prometheus"
                    },
                    "description": "Should be 0. If temporary files are created, it can indicate insufficient work_mem. With log_temp_files the creation of temporary files are logged to the PostgreSQL Logfiles.",
                    "fieldConfig": {
                        "defaults": {
                            "custom": {}
                        },
                        "overrides": []
                    },
                    "fill": 1,
                    "fillGradient": 0,
                    "gridPos": {
                        "h": 5,
                        "w": 12,
                        "x": 12,
                        "y": 31
                    },
                    "hiddenSeries": false,
                    "id": 132,
                    "legend": {
                        "alignAsTable": true,
                        "avg": true,
                        "current": true,
                        "hideEmpty": true,
                        "hideZero": true,
                        "max": true,
                        "min": false,
                        "show": true,
                        "total": false,
                        "values": true
                    },
                    "lines": true,
                    "linewidth": 1,
                    "links": [
                        {
                            "title": "PostgreSQL Ressources",
                            "url": "https://www.postgresql.org/docs/current/runtime-config-resource.html"
                        }
                    ],
                    "nullPointMode": "null",
                    "options": {
                        "dataLinks": []
                    },
                    "percentage": false,
                    "pointradius": 2,
                    "points": false,
                    "renderer": "flot",
                    "scopedVars": {
                        "Database": {
                            "selected": false,
                            "text": "grafana",
                            "value": "grafana"
                        }
                    },
                    "seriesOverrides": [],
                    "spaceLength": 10,
                    "stack": false,
                    "steppedLine": false,
                    "targets": [
                        {
                            "expr": "rate(pg_stat_database_temp_files{instance=\"$Instance\",datname=\"$Database\"}[$Interval])",
                            "interval": "",
                            "legendFormat": "temp_files",
                            "refId": "A"
                        }
                    ],
                    "thresholds": [],
                    "timeFrom": null,
                    "timeRegions": [],
                    "timeShift": null,
                    "title": "Temporary files by database",
                    "tooltip": {
                        "shared": true,
                        "sort": 0,
                        "value_type": "individual"
                    },
                    "type": "graph",
                    "xaxis": {
                        "buckets": null,
                        "mode": "time",
                        "name": null,
                        "show": true,
                        "values": []
                    },
                    "yaxes": [
                        {
                            "format": "none",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        },
                        {
                            "format": "short",
                            "label": null,
                            "logBase": 1,
                            "max": null,
                            "min": "0",
                            "show": true
                        }
                    ],
                    "yaxis": {
                        "align": false,
                        "alignLevel": null
                    }
                }
            ],
            "repeat": "Database",
            "title": "Database: $Database",
            "type": "row"
        }
    ],
    "refresh": "",
    "schemaVersion": 25,
    "style": "dark",
    "tags": [],
    "templating": {
        "list": [
            {
                "allValue": null,
                "current": {},
                "datasource": {
                    "type": "prometheus",
                    "uid": "prometheus"
                },
                "definition": "label_values({job=\"postgres-exporter\"}, instance)",
                "hide": 0,
                "includeAll": false,
                "label": null,
                "multi": false,
                "name": "Instance",
                "options": [],
                "query": "label_values({job=\"postgres-exporter\"}, instance)",
                "refresh": 1,
                "regex": "",
                "skipUrlSync": false,
                "sort": 0,
                "tagValuesQuery": "",
                "tags": [],
                "tagsQuery": "",
                "type": "query",
                "useTags": false
            },
            {
                "allValue": null,
                "current": {},
                "datasource": {
                    "type": "prometheus",
                    "uid": "prometheus"
                },
                "definition": "label_values(datname)",
                "hide": 0,
                "includeAll": true,
                "label": null,
                "multi": true,
                "name": "Database",
                "options": [],
                "query": "label_values(datname)",
                "refresh": 1,
                "regex": "/^(?!template*|postgres).*$/",
                "skipUrlSync": false,
                "sort": 1,
                "tagValuesQuery": "",
                "tags": [],
                "tagsQuery": "",
                "type": "query",
                "useTags": false
            },
            {
                "auto": true,
                "auto_count": 30,
                "auto_min": "10s",
                "current": {
                    "selected": false,
                    "text": "10m",
                    "value": "10m"
                },
                "hide": 0,
                "label": null,
                "name": "Interval",
                "options": [
                    {
                        "selected": false,
                        "text": "auto",
                        "value": "$__auto_interval_Interval"
                    },
                    {
                        "selected": false,
                        "text": "30sec",
                        "value": "30sec"
                    },
                    {
                        "selected": false,
                        "text": "1m",
                        "value": "1m"
                    },
                    {
                        "selected": true,
                        "text": "10m",
                        "value": "10m"
                    },
                    {
                        "selected": false,
                        "text": "30m",
                        "value": "30m"
                    },
                    {
                        "selected": false,
                        "text": "1h",
                        "value": "1h"
                    },
                    {
                        "selected": false,
                        "text": "6h",
                        "value": "6h"
                    },
                    {
                        "selected": false,
                        "text": "12h",
                        "value": "12h"
                    },
                    {
                        "selected": false,
                        "text": "1d",
                        "value": "1d"
                    }
                ],
                "query": "30sec,1m,10m,30m,1h,6h,12h,1d",
                "queryValue": "",
                "refresh": 2,
                "skipUrlSync": false,
                "type": "interval"
            }
        ]
    },
    "time": {
        "from": "now-24h",
        "to": "now"
    },
    "timepicker": {
        "refresh_intervals": ["1m", "5m", "15m", "30m", "1h", "2h", "1d"]
    },
    "timezone": "",
    "title": "Postgres",
    "uid": "postgres",
    "version": 2
}
