{
  "tags": [],
  "title": "Postgres Overview",
  "widgets": [
    {
      "layout": {
        "x": 0,
        "y": 0,
        "width": 10,
        "height": 2
      },
      "definition": {
        "type": "timeseries",
        "title": "Rows",
        "yaxis": {
          "max": "auto",
          "min": "auto",
          "label": "",
          "scale": "linear",
          "include_zero": true
        },
        "requests": [
          {
            "style": {
              "palette": "dog_classic",
              "line_type": "solid",
              "line_width": "normal"
            },
            "queries": [
              {
                "name": "query1",
                "query": "sum:postgresql.rows_fetched{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query2",
                "query": "sum:postgresql.rows_returned{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query3",
                "query": "sum:postgresql.rows_inserted{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query4",
                "query": "sum:postgresql.rows_updated{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query5",
                "query": "sum:postgresql.rows_deleted{$db,$host}",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "alias": "fetched",
                "formula": "query1"
              },
              {
                "alias": "returned",
                "formula": "query2"
              },
              {
                "alias": "inserted",
                "formula": "query3"
              },
              {
                "alias": "updated",
                "formula": "query4"
              },
              {
                "alias": "deleted",
                "formula": "query5"
              }
            ],
            "display_type": "area",
            "response_format": "timeseries"
          }
        ],
        "show_legend": true,
        "legend_layout": "auto",
        "legend_columns": [
          "avg",
          "min",
          "max",
          "value",
          "sum"
        ]
      }
    },
    {
      "layout": {
        "x": 10,
        "y": 0,
        "width": 2,
        "height": 1
      },
      "definition": {
        "type": "query_value",
        "title": "QPS",
        "requests": [
          {
            "queries": [
              {
                "name": "query1",
                "query": "sum:postgresql.commits{$db,$host}",
                "aggregator": "last",
                "data_source": "metrics"
              },
              {
                "name": "query2",
                "query": "sum:postgresql.rollbacks{$db,$host}",
                "aggregator": "last",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "formula": "query1 + query2"
              }
            ],
            "response_format": "scalar"
          }
        ],
        "autoscale": true,
        "precision": 2,
        "text_align": "center"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 2,
        "width": 6,
        "height": 2
      },
      "definition": {
        "type": "timeseries",
        "title": "Buffers",
        "yaxis": {
          "max": "auto",
          "min": "auto",
          "label": "",
          "scale": "linear",
          "include_zero": true
        },
        "requests": [
          {
            "style": {
              "palette": "dog_classic",
              "line_type": "solid",
              "line_width": "normal"
            },
            "queries": [
              {
                "name": "query1",
                "query": "avg:postgresql.buffers_alloc{$host}",
                "data_source": "metrics"
              },
              {
                "name": "query2",
                "query": "avg:postgresql.buffers_backend_fsync{$host}",
                "data_source": "metrics"
              },
              {
                "name": "query3",
                "query": "avg:postgresql.buffers_backend{$host}",
                "data_source": "metrics"
              },
              {
                "name": "query4",
                "query": "avg:postgresql.buffers_clean{$host}",
                "data_source": "metrics"
              },
              {
                "name": "query5",
                "query": "avg:postgresql.buffers_checkpoint{$host}",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "alias": "buffers_alloc",
                "formula": "query1"
              },
              {
                "alias": "buffers_backend_fsync",
                "formula": "query2"
              },
              {
                "alias": "buffers_backend",
                "formula": "query3"
              },
              {
                "alias": "buffers_clean",
                "formula": "query4"
              },
              {
                "alias": "buffers_checkpoint",
                "formula": "query5"
              }
            ],
            "display_type": "area",
            "response_format": "timeseries"
          }
        ],
        "show_legend": true,
        "legend_layout": "auto",
        "legend_columns": [
          "avg",
          "min",
          "max",
          "value",
          "sum"
        ]
      }
    },
    {
      "layout": {
        "x": 6,
        "y": 2,
        "width": 6,
        "height": 2
      },
      "definition": {
        "type": "timeseries",
        "title": "Conflicts/Deadlocks",
        "yaxis": {
          "max": "auto",
          "min": "auto",
          "label": "",
          "scale": "linear",
          "include_zero": true
        },
        "requests": [
          {
            "style": {
              "palette": "dog_classic",
              "line_type": "solid",
              "line_width": "normal"
            },
            "queries": [
              {
                "name": "query1",
                "query": "sum:postgresql.deadlocks{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query2",
                "query": "sum:postgresql.conflicts{$db,$host}",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "alias": "deadlocks",
                "formula": "query1"
              },
              {
                "alias": "conflicts",
                "formula": "query2"
              }
            ],
            "display_type": "area",
            "response_format": "timeseries"
          }
        ],
        "show_legend": true,
        "legend_layout": "auto",
        "legend_columns": [
          "avg",
          "min",
          "max",
          "value",
          "sum"
        ]
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 4,
        "width": 6,
        "height": 2
      },
      "definition": {
        "type": "timeseries",
        "title": "Cache hit ratio",
        "yaxis": {
          "max": "auto",
          "min": "auto",
          "label": "",
          "scale": "linear",
          "include_zero": true
        },
        "requests": [
          {
            "style": {
              "palette": "dog_classic",
              "line_type": "solid",
              "line_width": "normal"
            },
            "queries": [
              {
                "name": "query1",
                "query": "sum:postgresql.buffer_hit{$db,$host}",
                "data_source": "metrics"
              },
              {
                "name": "query2",
                "query": "sum:postgresql.disk_read{$db,$host}",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "alias": "cache hit rate",
                "formula": "(query1 / (query1 + query2)) * 100"
              }
            ],
            "display_type": "area",
            "response_format": "timeseries"
          }
        ],
        "show_legend": true,
        "legend_layout": "auto",
        "legend_columns": [
          "avg",
          "min",
          "max",
          "value",
          "sum"
        ]
      }
    },
    {
      "layout": {
        "x": 6,
        "y": 4,
        "width": 6,
        "height": 2
      },
      "definition": {
        "type": "timeseries",
        "title": "Number of active connections",
        "yaxis": {
          "max": "auto",
          "min": "auto",
          "label": "",
          "scale": "linear",
          "include_zero": true
        },
        "requests": [
          {
            "style": {
              "palette": "dog_classic",
              "line_type": "solid",
              "line_width": "normal"
            },
            "queries": [
              {
                "name": "query1",
                "query": "avg:postgresql.connections{$db,$host}",
                "data_source": "metrics"
              }
            ],
            "formulas": [
              {
                "formula": "query1"
              }
            ],
            "display_type": "area",
            "response_format": "timeseries"
          }
        ],
        "show_legend": true,
        "legend_layout": "auto",
        "legend_columns": [
          "avg",
          "min",
          "max",
          "value",
          "sum"
        ]
      }
    }
  ],
  "description": "Converted from Grafana dashboard https://grafana.com/grafana/dashboards/455 (by hagen). Performance metrics for Postgres",
  "layout_type": "ordered",
  "reflow_type": "fixed",
  "template_variables": [
    {
      "name": "host",
      "prefix": "host",
      "default": "*",
      "available_values": []
    },
    {
      "name": "db",
      "prefix": "db",
      "default": "*",
      "available_values": []
    }
  ]
}