{
  "tags": [],
  "title": "PostgreSQL Database",
  "widgets": [
    {
      "layout": {
        "x": 0,
        "y": 0,
        "width": 12,
        "height": 3
      },
      "definition": {
        "type": "group",
        "title": "General Counters, CPU, Memory and File Descriptor Stats",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Version",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_static{$release,$instance} by {short_version}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 2,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Start Time",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_postmaster_start_time_seconds{$release,$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1 * 1000"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Current fetch data",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "sum:postgresql.rows_fetched{$datname,$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Current insert data",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "sum:postgresql.rows_inserted{$release,$datname,$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Current update data",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "sum:postgresql.rows_updated{$datname,$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 10,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Max Connections",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:postgresql.max_connections{$release,$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 1,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Average CPU Usage",
              "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:process_cpu_seconds.count{$release,$instance}.as_rate()",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "CPU Time",
                      "formula": "query1 * 1000"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 1,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Average Memory Usage",
              "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:process_resident_memory_bytes{$release,$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:process_virtual_memory_bytes{$release,$instance}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Resident Mem",
                      "formula": "query1"
                    },
                    {
                      "alias": "Virtual Mem",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 1,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Open File Descriptors",
              "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:process_open_fds{$release,$instance}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "Open FD",
                      "formula": "query1"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 3,
        "width": 12,
        "height": 1
      },
      "definition": {
        "type": "group",
        "title": "Settings",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Shared Buffers",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_shared_buffers_bytes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 1,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Effective Cache",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_effective_cache_size_bytes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 3,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Maintenance Work Mem",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_maintenance_work_mem_bytes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Work Mem",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_work_mem_bytes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 6,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Max WAL Size",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_max_wal_size_bytes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center",
              "custom_unit": "B"
            }
          },
          {
            "layout": {
              "x": 7,
              "y": 0,
              "width": 2,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Random Page Cost",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_random_page_cost{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 9,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Seq Page Cost",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_seq_page_cost{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 10,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Max Worker Processes",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_max_worker_processes{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          },
          {
            "layout": {
              "x": 11,
              "y": 0,
              "width": 1,
              "height": 1
            },
            "definition": {
              "type": "query_value",
              "title": "Max Parallel Workers",
              "requests": [
                {
                  "queries": [
                    {
                      "name": "query1",
                      "query": "avg:pg_settings_max_parallel_workers{$instance}",
                      "aggregator": "last",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    }
                  ],
                  "response_format": "scalar"
                }
              ],
              "autoscale": true,
              "precision": 2,
              "text_align": "center"
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    },
    {
      "layout": {
        "x": 0,
        "y": 4,
        "width": 12,
        "height": 10
      },
      "definition": {
        "type": "group",
        "title": "Database Stats",
        "widgets": [
          {
            "layout": {
              "x": 0,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Active sessions",
              "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:pg_stat_activity_count{$datname,$instance,state:active} by {datname,state}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Transactions",
              "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.commits{$instance,$datname} by {db}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:postgresql.rollbacks{$instance,$datname} by {db}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "query1"
                    },
                    {
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 0,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Update data",
              "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.rows_updated{$datname,$instance} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Fetch data (SELECT)",
              "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.rows_fetched{$datname,$instance} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Insert data",
              "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.rows_inserted{$datname,$instance} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 2,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Lock tables",
              "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.locks{$datname,$instance,lock_mode:$mode.value} by {db,lock_mode}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 4,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Return data",
              "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.rows_returned{$datname,$instance} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 4,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Idle sessions",
              "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:pg_stat_activity_count{$datname,$instance,state:idle*} by {datname,state}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 4,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Delete data",
              "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.rows_deleted{$datname,$instance} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 0,
              "y": 6,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Cache Hit Rate",
              "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.buffer_hit{$instance,$datname} by {db}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:postgresql.disk_read{$instance,$datname} by {db}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "(query1 / (query2 + query1)) * 100"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 6,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Buffers (bgwriter)",
              "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.bgwriter.buffers_backend{$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:postgresql.bgwriter.buffers_alloc{$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query3",
                      "query": "avg:postgresql.bgwriter.buffers_backend_fsync{$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query4",
                      "query": "avg:postgresql.bgwriter.buffers_checkpoint{$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query5",
                      "query": "avg:postgresql.bgwriter.buffers_clean{$instance}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "buffers_backend",
                      "formula": "query1"
                    },
                    {
                      "alias": "buffers_alloc",
                      "formula": "query2"
                    },
                    {
                      "alias": "backend_fsync",
                      "formula": "query3"
                    },
                    {
                      "alias": "buffers_checkpoint",
                      "formula": "query4"
                    },
                    {
                      "alias": "buffers_clean",
                      "formula": "query5"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          },
          {
            "layout": {
              "x": 8,
              "y": 6,
              "width": 4,
              "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": "avg:pg_stat_database_conflicts{$instance,$datname} by {datname}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:postgresql.deadlocks{$instance,$datname} by {db}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "formula": "per_second(query1)"
                    },
                    {
                      "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": 8,
              "width": 4,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Temp File (Bytes)",
              "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.temp_bytes{$instance,$datname} by {db}",
                      "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"
              ]
            }
          },
          {
            "layout": {
              "x": 4,
              "y": 8,
              "width": 8,
              "height": 2
            },
            "definition": {
              "type": "timeseries",
              "title": "Checkpoint Stats",
              "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.bgwriter.write_time{$instance}",
                      "data_source": "metrics"
                    },
                    {
                      "name": "query2",
                      "query": "avg:postgresql.bgwriter.sync_time{$instance}",
                      "data_source": "metrics"
                    }
                  ],
                  "formulas": [
                    {
                      "alias": "write_time - Total amount of time that has been spent in the portion of checkpoint processing where files are written to disk.",
                      "formula": "query1"
                    },
                    {
                      "alias": "sync_time - Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk.",
                      "formula": "query2"
                    }
                  ],
                  "display_type": "area",
                  "response_format": "timeseries"
                }
              ],
              "show_legend": true,
              "legend_layout": "auto",
              "legend_columns": [
                "avg",
                "min",
                "max",
                "value",
                "sum"
              ]
            }
          }
        ],
        "show_title": true,
        "layout_type": "ordered"
      }
    }
  ],
  "description": "Converted from Grafana dashboard https://grafana.com/grafana/dashboards/9628 (by Lucas Estienne). This dashboard works with postgres_exporter for prometheus",
  "layout_type": "ordered",
  "reflow_type": "fixed",
  "template_variables": [
    {
      "name": "namespace",
      "prefix": "namespace",
      "default": "*",
      "available_values": []
    },
    {
      "name": "release",
      "prefix": "release",
      "default": "*",
      "available_values": []
    },
    {
      "name": "instance",
      "prefix": "host",
      "default": "*",
      "available_values": []
    },
    {
      "name": "datname",
      "prefix": "db",
      "default": "*",
      "available_values": []
    },
    {
      "name": "mode",
      "prefix": "lock_mode",
      "default": "*",
      "available_values": []
    }
  ]
}