{
  "annotations":{"list":[{"builtIn":1,"datasource":{"type":"datasource","uid":"grafana"},"enable":true,"hide":true,"iconColor":"rgba(0, 211, 255, 1)","name":"Annotations & Alerts","target":{"limit":100,"matchAny":false,"tags":[],"type":"dashboard"},"type":"dashboard"}]},
  "author":"Ruohang Feng (rh@vonng.com)",
  "description":"PostgreSQL Queries for single Instance",
  "editable":true,
  "fiscalYearStartMonth":0,
  "graphTooltip":0,
  "id":null,
  "license":"https://pigsty.io/docs/about/license/",
  "links":[
    { "asDropdown":true,"icon":"external link","includeVars":true,"keepTime":true,"tags":["Pigsty","PGSQL","Overview"],"targetBlank":false,"title":"Overview","tooltip":"","type":"dashboards","url":"" },{ "asDropdown":true,"icon":"external link","includeVars":true,"keepTime":true,"tags":["Pigsty","PGSQL","Cluster"] ,"targetBlank":false,"title":"Cluster" ,"tooltip":"","type":"dashboards","url":"" },
    { "asDropdown":true,"icon":"external link","includeVars":true,"keepTime":true,"tags":["Pigsty","PGSQL","Instance"],"targetBlank":false,"title":"Instance","tooltip":"","type":"dashboards","url":"" },{ "asDropdown":true,"icon":"external link","includeVars":true,"keepTime":true,"tags":["Pigsty","PGSQL","Database"],"targetBlank":false,"title":"Database","tooltip":"","type":"dashboards","url":"" }
  ],
  "panels":[
    {
      "datasource":{"type":"marcusolsson-static-datasource","uid":"ds-static"},
      "description":"",
      "fieldConfig":{
        "defaults":{"color":{"mode":"thresholds"},"mappings":[],"max":2.5,"min":0,"thresholds":{"mode":"absolute","steps":[{"color":"#3e668f","value":0}]}},
        "overrides":[{"matcher":{"id":"byFrameRefID","options":"A"},"properties":[{"id":"links","value":[{"title":"PGSQL Instance : ${primary}","url":"/d/pgsql-instance?var-ins=${primary}&${__url_time_range}"}]}]},{"matcher":{"id":"byFrameRefID","options":"B"},"properties":[{"id":"links","value":[{"title":"PGSQL Cluster : ${cls}","url":"/d/pgsql-cluster?var-cls=${cls}&${__url_time_range}"}]}]}]
      },
      "gridPos":{"h":4,"w":8,"x":0,"y":0},
      "id":156,
      "options":{"colorMode":"background","graphMode":"area","justifyMode":"auto","orientation":"horizontal","percentChangeColorMode":"standard","reduceOptions":{"calcs":["lastNotNull"],"fields":"/.*/","values":true},"showPercentChange":false,"text":{"titleSize":16,"valueSize":16},"textMode":"value_and_name","wideLayout":true},
      "pluginVersion":"12.3.0",
      "targets":[
        { "datasource":{"type":"marcusolsson-static-datasource","uid":"ds-static"},"frame":{"fields":[{"config":{},"name":"Cluster","type":"string","values":["${cls}"]}],"meta":{},"name":""} ,"hide":false,"refId":"B" },
        { "datasource":{"type":"marcusolsson-static-datasource","uid":"ds-static"},"frame":{"fields":[{"config":{},"name":"Leader","type":"string","values":["$primary"]}],"meta":{},"name":""},"hide":false,"refId":"A" }
      ],
      "type":"stat"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"thresholds"},
          "custom":{"axisPlacement":"auto","fillOpacity":60,"hideFrom":{"legend":false,"tooltip":false,"viz":false},"insertNulls":false,"lineWidth":0,"spanNulls":false},
          "links":[{"title":"PGSQL Service : ${__field.labels.proxy}","url":"/d/pgsql-service?var-svc=${__field.labels.proxy}&${__url_time_range}"}],
          "mappings":[{"options":{"match":"null+nan","result":{"color":"#808080","index":1}},"type":"special"}],
          "thresholds":{"mode":"absolute","steps":[{"color":"#cc4637d9","value":0},{"color":"#346f36cc","value":1}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":4,"w":16,"x":8,"y":0},
      "id":152,
      "options":{"alignValue":"left","legend":{"displayMode":"list","placement":"bottom","showLegend":false},"mergeValues":true,"rowHeight":0.9,"showValue":"never","tooltip":{"hideZeros":false,"mode":"single","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","expr":"sum by (cls,proxy) (haproxy_server_status{proxy=~\"$cls-.*\", state=\"UP\"}) > bool 0","instant":false,"legendFormat":"{{ proxy }}","range":true,"refId":"A"}],
      "type":"state-timeline"
    },
    {"collapsed":false,"gridPos":{"h":1,"w":24,"x":0,"y":4},"id":140,"panels":[],"title":"Load","type":"row"},
    {
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Overall pressure for this PostgreSQL Node and Instance. \nmax(node:ins:cpu_usage, pg:ins:load, pgbouncer:ins:load)",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"none",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"linear",
            "lineStyle":{"fill":"solid"},
            "lineWidth":1,
            "pointSize":3,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"area"}
          },
          "links":[],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"green","value":0},{"color":"red","value":0.7},{"color":"#b783af","value":1}]},
          "unit":"percentunit"
        },
        "overrides":[
          { "matcher":{"id":"byFrameRefID","options":"A"},"properties":[{"id":"color","value":{"fixedColor":"#f79f64","mode":"fixed"}},{"id":"custom.lineWidth","value":1},{"id":"links","value":[{"title":"PGSQL Cluster Primary Instance ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&var-cls=${cls}&${__url_time_range}"}]}] },
          { "matcher":{"id":"byName","options":"cluster"},"properties":[{"id":"custom.drawStyle","value":"line"},{"id":"custom.fillOpacity","value":30},{"id":"custom.lineWidth","value":0},{"id":"color","value":{"fixedColor":"rgba(128, 128, 128, 0.2)","mode":"fixed"}}]                                                                                     },
          { "matcher":{"id":"byFrameRefID","options":"B"},"properties":[{"id":"links","value":[{"title":"PGSQL Cluster follower instance ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&var-cls=${cls}&${__url_time_range}"}]}]                                                                                                   }
        ]
      },
      "gridPos":{"h":9,"w":12,"x":0,"y":5},
      "id":127,
      "options":{"legend":{"calcs":["max","last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"pg:cls:load1{cls=\"$cls\"}"                   ,"hide":false,"interval":"","legendFormat":"cluster"               ,"range":true,"refId":"C" },
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"pg:ins:load1{cls=\"$cls\", ins=\"$primary\"}" ,             "interval":"","legendFormat":"{{ ins }} \u2b50\ufe0f","range":true,"refId":"A" },
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"pg:ins:load1{cls=\"$cls\", ins!=\"$primary\"}","hide":false,"interval":"","legendFormat":"{{ ins }}"             ,"range":true,"refId":"B" }
      ],
      "title":"Postgres Load 1m",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"none",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"linear",
            "lineStyle":{"fill":"solid"},
            "lineWidth":1,
            "pointSize":3,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"area"}
          },
          "links":[],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"green","value":0},{"color":"red","value":0.7},{"color":"#b783af","value":1}]},
          "unit":"percentunit"
        },
        "overrides":[
          { "matcher":{"id":"byFrameRefID","options":"A"},"properties":[{"id":"color","value":{"fixedColor":"#f79f64","mode":"fixed"}},{"id":"custom.lineWidth","value":1},{"id":"links","value":[{"title":"PGSQL Cluster Primary Instance ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&var-cls=${cls}&${__url_time_range}"}]}] },
          { "matcher":{"id":"byName","options":"cluster"},"properties":[{"id":"custom.drawStyle","value":"line"},{"id":"custom.fillOpacity","value":30},{"id":"custom.lineWidth","value":0},{"id":"color","value":{"fixedColor":"rgba(128, 128, 128, 0.2)","mode":"fixed"}}]                                                                                     },
          { "matcher":{"id":"byFrameRefID","options":"B"},"properties":[{"id":"links","value":[{"title":"PGSQL Cluster follower instance ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&var-cls=${cls}&${__url_time_range}"}]}]                                                                                                   }
        ]
      },
      "gridPos":{"h":9,"w":12,"x":12,"y":5},
      "id":138,
      "options":{"legend":{"calcs":["max","last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg:cls:cpu_usage_1m{cls=\"$cls\"}"                   ,"hide":false,"interval":"","legendFormat":"cluster"               ,"refId":"C" },
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg:ins:cpu_usage_1m{cls=\"$cls\", ins=\"$primary\"}" ,             "interval":"","legendFormat":"{{ ins }} \u2b50\ufe0f","refId":"A" },
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg:ins:cpu_usage_1m{cls=\"$cls\", ins!=\"$primary\"}","hide":false,"interval":"","legendFormat":"{{ ins }}"             ,"refId":"B" }
      ],
      "title":"CPU Usage 1m",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"\u25b2 for read bandwidth, \u25bc for write bandwidth",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":10,
            "gradientMode":"opacity",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Node : Disk Bandwidth for ${__field.labels.ins}","url":"/d/node-instance?var-id=${__field.labels.ins}&viewPanel=45&${__url_time_range}"}],
          "mappings":[],
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0},{"color":"red","value":80}]},
          "unit":"Bps"
        },
        "overrides":[]
      },
      "gridPos":{"h":9,"w":12,"x":0,"y":14},
      "id":142,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg_up{cls=\"$cls\"} * 0 + on(ip) node:ins:disk_read_bytes_rate1m" ,"interval":"","legendFormat":"\u25b2{{ ins }}","refId":"A" },
        { "datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg_up{cls=\"$cls\"} * 0 - on(ip) node:ins:disk_write_bytes_rate1m","interval":"","legendFormat":"\u25bc{{ ins }}","refId":"B" }
      ],
      "title":"Read/Write Bandwidth",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"\u25b2 for transmit (out) and \u25bc for receive (in)",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":10,
            "gradientMode":"opacity",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Node : Network for ${__field.labels.ins}","url":"/d/node-instance?var-ins=${__field.labels.ins}&viewPanel=178&${__url_time_range}"}],
          "mappings":[],
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"Bps"
        },
        "overrides":[]
      },
      "gridPos":{"h":9,"w":12,"x":12,"y":14},
      "id":144,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"node:ins:network_tx_bytes_rate1m{ip=~\"$members\"}","interval":"","legendFormat":"\u25b2{{ ins }}","refId":"A"},{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"- node:ins:network_rx_bytes_rate1m{ip=~\"$members\"}","interval":"","legendFormat":"\u25bc{{ ins }}","refId":"B"}],
      "title":"Transmit/Receive Bandwidth (Interface)",
      "type":"timeseries"
    },
    {"collapsed":false,"gridPos":{"h":1,"w":24,"x":0,"y":23},"id":125,"panels":[],"title":"Sessions","type":"row"},
    {
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "axisSoftMin":0,
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"none",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"area"}
          },
          "decimals":1,
          "links":[{"title":"PGSQL Database for ${__field.labels.datname}","url":"/d/pgsql-database?var-ins=$ins&var-datname=${__field.labels.datname}&${__url_time_range}"}],
          "mappings":[],
          "thresholds":{"mode":"absolute","steps":[{"color":"#3e668f","value":0},{"color":"green","value":0.1},{"color":"#fcdb72","value":0.3},{"color":"#f79f64","value":0.5},{"color":"red","value":0.7},{"color":"#b783af","value":0.9}]},
          "unit":"percentunit"
        },
        "overrides":[]
      },
      "gridPos":{"h":7,"w":12,"x":0,"y":24},
      "id":121,
      "options":{"legend":{"calcs":["max"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pg:db:conn_usage{cls=\"$cls\", datname!~'postgres|template\\\\d'}","interval":"","legendFormat":"{{ ins }}.{{ datname }}","refId":"A"}],
      "title":"Postgres Conn Usage",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "axisSoftMin":0,
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"none",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"area"}
          },
          "decimals":1,
          "links":[{"title":"PGSQL Database for ${__field.labels.datname}","url":"/d/pgsql-database?var-ins=$ins&var-datname=${__field.labels.datname}&${__url_time_range}"}],
          "mappings":[],
          "thresholds":{"mode":"absolute","steps":[{"color":"#3e668f","value":0},{"color":"green","value":0.1},{"color":"#fcdb72","value":0.3},{"color":"#f79f64","value":0.5},{"color":"red","value":0.7},{"color":"#b783af","value":0.9}]},
          "unit":"percentunit"
        },
        "overrides":[]
      },
      "gridPos":{"h":7,"w":12,"x":12,"y":24},
      "id":130,
      "options":{"legend":{"calcs":["max"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pgbouncer:db:conn_usage{cls=\"$cls\", datname!~'pgbouncer|template\\\\d'}","interval":"","legendFormat":"{{ ins }}.{{ datname }}","refId":"A"}],
      "title":"Pgbouncer Conn Usage",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":36,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0},{"color":"red","value":80}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":8,"w":12,"x":0,"y":31},
      "id":132,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (ins) (pg_activity_count{cls=\"$cls\"})","interval":"","legendFormat":"{{ datname }}","refId":"A"}],
      "title":"Postgres Backends",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":60,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":0,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"normal"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":8,"w":12,"x":12,"y":31},
      "id":146,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (ins) (pg_activity_count{cls=\"$cls\"})","interval":"","legendFormat":"{{ datname }}","refId":"A"}],
      "title":"Postgres Backends (Stacked)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":36,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":7,"w":12,"x":0,"y":39},
      "id":133,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pgbouncer:ins:active_clients{cls=\"$cls\"}","interval":"","legendFormat":"{{ ins }}","refId":"A"}],
      "title":"Pgbouncer Clients",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":36,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":7,"w":12,"x":12,"y":39},
      "id":145,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pgbouncer:ins:waiting_clients{cls=\"$cls\"}","interval":"","legendFormat":"{{ ins }}","refId":"A"}],
      "title":"Pgbouncer Waiting Clients",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":36,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.server}","url":"/d/pgsql-instance?var-ins=${__field.labels.server}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0},{"color":"red","value":80}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":8,"w":12,"x":0,"y":46},
      "id":134,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"sum by (server) (haproxy_server_current_sessions{ip=~\"$members\"})","interval":"","legendFormat":"{{ server }}","range":true,"refId":"A"}],
      "title":"HAproxy Backends (Database Server)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Session by postgres instance",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":60,
            "gradientMode":"none",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":0,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":true,
            "stacking":{"group":"A","mode":"normal"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Proxy for ${__field.labels.ins}","url":"/d/pgsql-proxy?var-ins=${__field.labels.ins}&${__url_time_range}"},{"title":"PGSQL Instance for ${__field.labels.server}","url":"/d/pgsql-instance?var-ins=${__field.labels.server}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"none"
        },
        "overrides":[]
      },
      "gridPos":{"h":16,"w":12,"x":12,"y":46},
      "id":137,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"sum by (ins,server) (haproxy_server_current_sessions{ip=~\"$members\"})","interval":"","legendFormat":"{{ ins }} \u2794 {{ server }}","range":true,"refId":"A"}],
      "title":"Proxy \u2794 Server Sessions",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":36,
            "gradientMode":"hue",
            "hideFrom":{"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"stepBefore",
            "lineWidth":1,
            "pointSize":2,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"auto",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.server}","url":"/d/pgsql-instance?var-ins=${__field.labels.server}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0},{"color":"red","value":80}]}
        },
        "overrides":[]
      },
      "gridPos":{"h":8,"w":12,"x":0,"y":54},
      "id":135,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"sum by (ins) (haproxy_server_current_sessions{ip=~\"$members\"})","interval":"","legendFormat":"{{ ins }}","range":true,"refId":"A"}],
      "title":"HAproxy Frontents (Proxy Instance)",
      "type":"timeseries"
    },
    {"collapsed":false,"gridPos":{"h":1,"w":24,"x":0,"y":62},"id":123,"panels":[],"title":"Xacts","type":"row"},
    {
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Postgres transactions per second according to last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                           },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-green","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":12,"w":12,"x":0,"y":63},
      "id":104,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pg:cls:xact_commit_rate1m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pg:cls:xact_commit_rate5m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pg:cls:xact_commit_rate15m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster Xact Commit Rate",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Postgres rollbacked transactions per second according to last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"#fcdb72","mode":"fixed"}}]                                            },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"#f79f64","mode":"fixed"}}]                                                                                   },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"#cc4637d9","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":12,"w":12,"x":12,"y":63},
      "id":106,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pg:cls:xact_rollback_rate1m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pg:cls:xact_rollback_rate5m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pg:cls:xact_rollback_rate15m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster Xact Rollback",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":25,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#3e668f","value":0}]},
          "unit":"s"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Cluster"},"properties":[{"id":"color","value":{"fixedColor":"#3e668f","mode":"fixed"}}]}]
      },
      "gridPos":{"h":6,"w":12,"x":0,"y":75},
      "id":153,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"exemplar":false,"expr":"pg:cls:active_time_rate1m{cls=\"$cls\"} / pg:cls:xact_total_rate1m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"Cluster","refId":"A"}],
      "title":"Transaction RT (avg1m)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":10,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"s"
        },
        "overrides":[]
      },
      "gridPos":{"h":6,"w":12,"x":12,"y":75},
      "id":154,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"datasource":{"type":"prometheus","uid":"ds-prometheus"},"editorMode":"code","exemplar":false,"expr":"pg:ins:active_time_rate1m{cls=\"$cls\"} / pg:ins:xact_total_rate15m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"{{ ins }}","range":true,"refId":"A"}],
      "title":"Transaction RT (avg1m)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":20,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Xacts for ${__field.labels.ins}","url":"/d/pgsql-xacts?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Instance"},"properties":[{"id":"custom.lineWidth","value":0},{"id":"custom.fillOpacity","value":20}]}]
      },
      "gridPos":{"h":9,"w":12,"x":0,"y":81},
      "id":110,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (ins) (pg:ins:xact_commit_rate1m{cls=\"$cls\", ins=\"$primary\"})","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ ins }} \u2b50\ufe0f","refId":"B"},{"exemplar":false,"expr":"sum by (ins) (pg:ins:xact_commit_rate1m{cls=\"$cls\", ins!=\"$primary\"})","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ ins }}","refId":"A"}],
      "title":"Transaction Commit by Instances",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":20,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Database for ${__field.labels.datname}","url":"/d/pgsql-database?var-ins=${ins}&var-cls=${cls}&var-datname=${__field.labels.datname}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Instance"},"properties":[{"id":"custom.lineWidth","value":0},{"id":"custom.fillOpacity","value":20}]}]
      },
      "gridPos":{"h":9,"w":12,"x":12,"y":81},
      "id":108,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (datname) (pg:db:xact_commit_rate1m{cls=\"$cls\"})","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ datname }}","refId":"B"}],
      "title":"Transaction Commit by Database",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":60,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":0,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"normal"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Xacts for ${__field.labels.ins}","url":"/d/pgsql-xacts?var-ins=${__field.labels.ins}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Instance"},"properties":[{"id":"custom.lineWidth","value":0},{"id":"custom.fillOpacity","value":20}]}]
      },
      "gridPos":{"h":9,"w":12,"x":0,"y":90},
      "id":111,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (ins) (pg:db:xact_commit_rate1m{cls=\"$cls\"})","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ datname }}","refId":"B"}],
      "title":"Transaction Commit by Instances (Stacked)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":60,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":0,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"normal"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Database for ${__field.labels.datname}","url":"/d/pgsql-database?var-ins=${ins}&var-cls=${cls}&var-datname=${__field.labels.datname}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Instance"},"properties":[{"id":"custom.lineWidth","value":0},{"id":"custom.fillOpacity","value":20}]}]
      },
      "gridPos":{"h":9,"w":12,"x":12,"y":90},
      "id":109,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"sum by (datname) (pg:db:xact_commit_rate1m{cls=\"$cls\"})","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ datname }}","refId":"B"}],
      "title":"Transaction Commit by Database (Stacked)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer transactions per second according to last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                           },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-green","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":10,"w":12,"x":0,"y":99},
      "id":148,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:cls:xact_rate1m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:cls:xact_rate5m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:cls:xact_rate15m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster TPS (Pgbouncer)",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer average transaction response time in last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"s"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                            },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                 },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-purple","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":10,"w":12,"x":12,"y":99},
      "id":150,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:cls:xact_rt_1m{cls=\"$cls\"}" ,             "interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:cls:xact_rt_5m{cls=\"$cls\"}" ,"hide":false,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:cls:xact_rt_15m{cls=\"$cls\"}","hide":false,"interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster Xact RT (Pgbouncer)",
      "type":"timeseries"
    },
    {"collapsed":false,"gridPos":{"h":1,"w":24,"x":0,"y":109},"id":129,"panels":[],"title":"Queries","type":"row"},
    {
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer Queries per second according to last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                           },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-green","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":10,"w":12,"x":0,"y":110},
      "id":112,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:cls:query_rate1m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:cls:query_rate5m{cls=\"$cls\"}" ,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:cls:query_rate15m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster QPS",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer query average response time in last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"s"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                            },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                 },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-purple","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":10,"w":12,"x":12,"y":110},
      "id":113,
      "options":{"legend":{"calcs":["mean","min","max","last"],"displayMode":"table","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:cls:query_rt_1m{cls=\"$cls\"}" ,             "interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:cls:query_rt_5m{cls=\"$cls\"}" ,"hide":false,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:cls:query_rt_15m{cls=\"$cls\"}","hide":false,"interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Cluster Query RT",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer Queries per second according to last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                           },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-green","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":8,"w":12,"x":0,"y":120},
      "id":66,
      "options":{"legend":{"calcs":["max","last"],"displayMode":"list","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:ins:query_rate1m{ins=\"$primary\"}" ,"interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:ins:query_rate5m{ins=\"$primary\"}" ,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:ins:query_rate15m{ins=\"$primary\"}","interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Leader ${primary} QPS",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"Pgbouncer query average response time in last 1m, 5m, 15m",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":0,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"s"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"15m"},"properties":[{"id":"custom.fillOpacity","value":20},{"id":"custom.lineWidth","value":1},{"id":"color","value":{"fixedColor":"super-light-blue","mode":"fixed"}}]                                            },
          { "matcher":{"id":"byName","options":"5m"} ,"properties":[{"id":"custom.lineWidth","value":2},{"id":"color","value":{"fixedColor":"super-light-orange","mode":"fixed"}}]                                                                                 },
          { "matcher":{"id":"byName","options":"1m"} ,"properties":[{"id":"color","value":{"fixedColor":"super-light-purple","mode":"fixed"}},{"id":"custom.showPoints","value":"always"},{"id":"custom.pointSize","value":3},{"id":"custom.lineWidth","value":0}] }
        ]
      },
      "gridPos":{"h":8,"w":12,"x":12,"y":120},
      "id":68,
      "options":{"legend":{"calcs":["max","last"],"displayMode":"list","placement":"bottom","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[
        { "exemplar":false,"expr":"pgbouncer:ins:query_rt_1m{ins=\"$primary\"}" ,             "interval":"","intervalFactor":1,"legendFormat":"1m" ,"refId":"A" },{ "exemplar":false,"expr":"pgbouncer:ins:query_rt_5m{ins=\"$primary\"}" ,"hide":false,"interval":"","intervalFactor":1,"legendFormat":"5m" ,"refId":"B" },
        { "exemplar":false,"expr":"pgbouncer:ins:query_rt_15m{ins=\"$primary\"}","hide":false,"interval":"","intervalFactor":1,"legendFormat":"15m","refId":"C" }
      ],
      "title":"Leader ${primary} Query RT",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":15,
            "gradientMode":"hue",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "links":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&var-cls=${__field.labels.cls}&${__url_time_range}"}],
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"short"
        },
        "overrides":[{"matcher":{"id":"byName","options":"Cluster"},"properties":[{"id":"custom.stacking","value":{"group":"A","mode":"none"}},{"id":"custom.lineWidth","value":0}]}]
      },
      "gridPos":{"h":10,"w":12,"x":0,"y":128},
      "id":119,
      "options":{"legend":{"calcs":["mean"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pgbouncer:cls:query_rate5m{cls=\"$cls\"}","hide":false,"interval":"","intervalFactor":1,"legendFormat":"Cluster","refId":"B"},{"exemplar":false,"expr":"pgbouncer:ins:query_rate5m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"{{ ins }}","refId":"A"}],
      "title":"QPS by Instance",
      "type":"timeseries"
    },{
      "datasource":{"type":"prometheus","uid":"ds-prometheus"},
      "description":"",
      "fieldConfig":{
        "defaults":{
          "color":{"mode":"palette-classic"},
          "custom":{
            "axisBorderShow":false,
            "axisCenteredZero":false,
            "axisColorMode":"text",
            "axisLabel":"",
            "axisPlacement":"auto",
            "barAlignment":0,
            "barWidthFactor":0.6,
            "drawStyle":"line",
            "fillOpacity":10,
            "gradientMode":"opacity",
            "hideFrom":{"graph":false,"legend":false,"tooltip":false,"viz":false},
            "insertNulls":false,
            "lineInterpolation":"smooth",
            "lineWidth":1,
            "pointSize":5,
            "scaleDistribution":{"type":"linear"},
            "showPoints":"never",
            "showValues":false,
            "spanNulls":false,
            "stacking":{"group":"A","mode":"none"},
            "thresholdsStyle":{"mode":"off"}
          },
          "mappings":[],
          "min":0,
          "thresholds":{"mode":"absolute","steps":[{"color":"#346f36cc","value":0}]},
          "unit":"s"
        },
        "overrides":[
          { "matcher":{"id":"byName","options":"Cluster"},"properties":[{"id":"custom.fillOpacity","value":21},{"id":"custom.lineWidth","value":0},{"id":"color","value":{"fixedColor":"#3e668f","mode":"fixed"}},{"id":"custom.gradientMode","value":"hue"},{"id":"links","value":[{"title":"PGSQL Cluster for ${__field.labels.cls}","url":"/d/pgsql-instance?var-cls=${__field.labels.cls}&${__url_time_range}"}]}] },
          { "matcher":{"id":"byFrameRefID","options":"B"},"properties":[{"id":"links","value":[{"title":"PGSQL Instance for ${__field.labels.ins}","url":"/d/pgsql-instance?var-ins=${__field.labels.ins}&${__url_time_range}"}]}]                                                                                                                                                                                     }
        ]
      },
      "gridPos":{"h":10,"w":12,"x":12,"y":128},
      "id":117,
      "options":{"legend":{"calcs":["last"],"displayMode":"table","placement":"right","showLegend":true},"tooltip":{"hideZeros":false,"mode":"multi","sort":"none"}},
      "pluginVersion":"12.3.0",
      "targets":[{"exemplar":false,"expr":"pgbouncer:cls:query_rt_1m{cls=\"$cls\"}","interval":"","intervalFactor":1,"legendFormat":"Cluster","refId":"A"},{"exemplar":false,"expr":"pgbouncer:ins:query_rt_1m{cls=\"$cls\"}","hide":false,"interval":"","intervalFactor":1,"legendFormat":"{{ ins }}","refId":"B"}],
      "title":"Query RT by Instance",
      "type":"timeseries"
    }
  ],
  "preload":false,
  "refresh":"",
  "schemaVersion":42,
  "tags":["Pigsty","PGSQL","Cluster"],
  "templating":{
    "list":[
      {
        "current":{},
        "datasource":{"type":"prometheus","uid":"ds-prometheus"},
        "definition":"label_values(pg_up, cls)",
        "description":"Cluster identifier for this postgres instance, cls should be unique among entire environment. such as pg-meta, pg-test",
        "includeAll":false,
        "label":"Cluster",
        "name":"cls",
        "options":[],
        "query":{"query":"label_values(pg_up, cls)","refId":"StandardVariableQuery"},
        "refresh":2,
        "regex":"",
        "sort":1,
        "type":"query"
      },{
        "current":{},
        "datasource":{"type":"prometheus","uid":"ds-prometheus"},
        "definition":"label_values(pg:cls:leader{cls=\"$cls\"}, ins)",
        "description":"Unique instance identifier (e.g pg-meta-1)",
        "hide":2,
        "includeAll":false,
        "label":"Primary",
        "name":"primary",
        "options":[],
        "query":{"query":"label_values(pg:cls:leader{cls=\"$cls\"}, ins)","refId":"StandardVariableQuery"},
        "refresh":2,
        "regex":"",
        "sort":1,
        "type":"query"
      },{
        "current":{},
        "datasource":{"type":"prometheus","uid":"ds-prometheus"},
        "definition":"label_values(pg_up{cls=\"$cls\"}, ip)",
        "description":"Unique instance identifier (e.g pg-meta-1)",
        "hide":2,
        "includeAll":true,
        "label":"Primary",
        "multi":true,
        "name":"members",
        "options":[],
        "query":{"query":"label_values(pg_up{cls=\"$cls\"}, ip)","refId":"StandardVariableQuery"},
        "refresh":2,
        "regex":"",
        "sort":1,
        "type":"query"
      }
    ]
  },
  "time":{"from":"now-1h","to":"now"},
  "timepicker":{},
  "timezone":"browser",
  "title":"PGSQL Activity",
  "uid":"pgsql-activity",
  "version":1,
  "weekStart":""
}