Интеграция с Grafana

{
  "uid": "pobp-metrics-golden",
  "title": "ProtoOBP — Метрики (Golden Signals)",
  "schemaVersion": 39,
  "version": 1,
  "time": { "from": "now-3h", "to": "now" },
  "templating": {
    "list": [
      {
        "name": "service",
        "type": "query",
        "datasource": { "type": "victoriametrics-metrics-datasource", "uid": "pobp-metrics" },
        "query": { "query": "label_values(services_calls, service)", "refId": "ServiceVar" },
        "refresh": 2, "includeAll": true, "multi": true, "allValue": ".*",
        "current": { "text": "All", "value": "$__all" }, "sort": 1
      }
    ]
  },
  "panels": [
    {
      "id": 1, "type": "timeseries", "title": "Пропускная способность (calls/min) по сервисам",
      "gridPos": { "h": 8, "w": 24, "x": 0, "y": 0 },
      "datasource": { "type": "victoriametrics-metrics-datasource", "uid": "pobp-metrics" },
      "targets": [ { "refId": "A", "expr": "sum by (service) (services_calls{service=~\"$service\"})", "legendFormat": "{{service}}" } ]
    },
    {
      "id": 2, "type": "timeseries", "title": "Латентность (avg, мс) по сервисам",
      "gridPos": { "h": 8, "w": 12, "x": 0, "y": 8 },
      "datasource": { "type": "victoriametrics-metrics-datasource", "uid": "pobp-metrics" },
      "fieldConfig": { "defaults": { "unit": "ms" }, "overrides": [] },
      "targets": [ { "refId": "A", "expr": "avg by (service) (services_callduration{service=~\"$service\"})", "legendFormat": "{{service}}" } ]
    },
    {
      "id": 3, "type": "timeseries", "title": "Доля ошибок (%) по сервисам",
      "gridPos": { "h": 8, "w": 12, "x": 12, "y": 8 },
      "datasource": { "type": "victoriametrics-metrics-datasource", "uid": "pobp-metrics" },
      "fieldConfig": { "defaults": { "unit": "percent" }, "overrides": [] },
      "targets": [ { "refId": "A", "expr": "max by (service) (services_errorcallsperc{service=~\"$service\"})", "legendFormat": "{{service}}" } ]
    }
  ]
}

{
  "uid": "pobp-logs-explorer",
  "title": "ProtoOBP — Логи (Explorer)",
  "schemaVersion": 39,
  "version": 1,
  "time": { "from": "now-1h", "to": "now" },
  "panels": [
    {
      "id": 1, "type": "timeseries", "title": "Объём логов по severity",
      "gridPos": { "h": 9, "w": 24, "x": 0, "y": 0 },
      "datasource": { "type": "victoriametrics-logs-datasource", "uid": "pobp-logs" },
      "targets": [ { "refId": "A", "expr": "* | stats by (status) count() logs", "queryType": "statsRange" } ]
    },
    {
      "id": 2, "type": "logs", "title": "Последние ошибки",
      "gridPos": { "h": 12, "w": 24, "x": 0, "y": 9 },
      "datasource": { "type": "victoriametrics-logs-datasource", "uid": "pobp-logs" },
      "options": { "showTime": true, "showLabels": false, "wrapLogMessage": true, "enableLogDetails": true, "sortOrder": "Descending", "dedupStrategy": "none" },
      "targets": [ { "refId": "A", "expr": "status:(error OR critical) | sort by (_time desc) | limit 100", "queryType": "instant" } ]
    }
  ]
}

{
  "uid": "pobp-traces",
  "title": "ProtoOBP — Трейсы",
  "schemaVersion": 39,
  "version": 1,
  "time": { "from": "now-1h", "to": "now" },
  "templating": {
    "list": [
      { "name": "trace_id", "type": "textbox", "label": "Trace ID (hex)", "query": "", "current": { "text": "", "value": "" } }
    ]
  },
  "panels": [
    {
      "id": 1, "type": "table", "title": "Поиск трейсов (root spans)",
      "gridPos": { "h": 10, "w": 24, "x": 0, "y": 0 },
      "datasource": { "type": "grafana-clickhouse-datasource", "uid": "pobp-clickhouse" },
      "targets": [
        {
          "refId": "A", "editorType": "sql", "queryType": "table", "format": 1, "pluginVersion": "4.18.0",
          "rawSql": "SELECT lower(hex(traceID)) AS trace_id, service, name AS operation, toUnixTimestamp64Milli(start) AS start_ms, round(duration/1e6, 2) AS duration_ms, error FROM proto.spans WHERE $__timeFilter(start) AND is_top_level = 1 ORDER BY start DESC LIMIT 100",
          "builderOptions": { "database": "proto", "table": "spans", "queryType": "table", "mode": "list", "columns": [], "filters": [], "orderBy": [], "limit": 100, "meta": {} },
          "meta": { "builderOptions": { "database": "proto", "table": "spans", "queryType": "table", "mode": "list", "columns": [], "filters": [], "orderBy": [], "limit": 100, "meta": {} } }
        }
      ],
      "fieldConfig": {
        "defaults": {},
        "overrides": [
          { "matcher": { "id": "byName", "options": "trace_id" },
            "properties": [ { "id": "links", "value": [ { "title": "Показать трейс", "url": "/d/pobp-traces?var-trace_id=${__value.raw}" } ] } ] }
        ]
      }
    },
    {
      "id": 2, "type": "traces", "title": "Waterfall трейса: $trace_id",
      "gridPos": { "h": 16, "w": 24, "x": 0, "y": 10 },
      "datasource": { "type": "grafana-clickhouse-datasource", "uid": "pobp-clickhouse" },
      "targets": [
        {
          "refId": "A", "editorType": "sql", "queryType": "traces", "format": 3, "pluginVersion": "4.18.0",
          "rawSql": "SELECT lower(hex(s.traceID)) AS traceID, toString(s.spanID) AS spanID, if(s.parentID = 0, '', toString(s.parentID)) AS parentSpanID, s.service AS serviceName, s.name AS operationName, toUnixTimestamp64Milli(s.start) AS startTime, s.duration/1e6 AS duration, arrayMap(k -> map('key', k, 'value', s.meta[k]), mapKeys(s.meta)) AS tags FROM proto.spans AS s WHERE lower(hex(s.traceID)) = '${trace_id}' ORDER BY s.start ASC",
          "builderOptions": { "database": "proto", "table": "spans", "queryType": "traces", "mode": "trace", "columns": [], "filters": [], "orderBy": [], "limit": 1000, "meta": { "isTraceIdMode": true, "traceId": "${trace_id}", "traceDurationUnit": "milliseconds" } },
          "meta": { "builderOptions": { "database": "proto", "table": "spans", "queryType": "traces", "mode": "trace", "columns": [], "filters": [], "orderBy": [], "limit": 1000, "meta": { "isTraceIdMode": true, "traceId": "${trace_id}", "traceDurationUnit": "milliseconds" } } }
        }
      ]
    },
    {
      "id": 3, "type": "table", "title": "Спаны трейса (таблица): $trace_id",
      "gridPos": { "h": 12, "w": 24, "x": 0, "y": 26 },
      "datasource": { "type": "grafana-clickhouse-datasource", "uid": "pobp-clickhouse" },
      "targets": [
        {
          "refId": "A", "editorType": "sql", "queryType": "table", "format": 1, "pluginVersion": "4.18.0",
          "rawSql": "SELECT toString(s.spanID) AS span_id, if(s.parentID = 0, '', toString(s.parentID)) AS parent_id, s.service AS service, s.name AS operation, round(s.duration/1e6, 2) AS duration_ms, s.error AS error, toUnixTimestamp64Milli(s.start) AS start_ms FROM proto.spans AS s WHERE lower(hex(s.traceID)) = '${trace_id}' ORDER BY s.start ASC",
          "builderOptions": { "database": "proto", "table": "spans", "queryType": "table", "mode": "list", "columns": [], "filters": [], "orderBy": [], "limit": 1000, "meta": {} },
          "meta": { "builderOptions": { "database": "proto", "table": "spans", "queryType": "table", "mode": "list", "columns": [], "filters": [], "orderBy": [], "limit": 1000, "meta": {} } }
        }
      ]
    }
  ]
}

{
  "uid": "pobp-business-cube",
  "title": "ProtoOBP — Бизнес-аналитика (Cube.js)",
  "schemaVersion": 39,
  "version": 1,
  "time": { "from": "now-24h", "to": "now" },
  "panels": [
    {
      "id": 1, "type": "table", "title": "Вызовы по сервисам (Calls.count)",
      "gridPos": { "h": 10, "w": 24, "x": 0, "y": 0 },
      "datasource": { "type": "grafana-cube-datasource", "uid": "pobp-cube" },
      "targets": [
        {
          "refId": "A",
          "measures": ["Calls.count"], "dimensions": ["Calls.service"],
          "timeDimensions": [ { "dimension": "Calls.date", "dateRange": "Last 24 hours" } ],
          "filters": [], "order": [ ["Calls.count", "desc"] ]
        }
      ]
    },
    {
      "id": 2, "type": "barchart", "title": "Top сервисы по вызовам",
      "gridPos": { "h": 10, "w": 24, "x": 0, "y": 10 },
      "datasource": { "type": "grafana-cube-datasource", "uid": "pobp-cube" },
      "targets": [
        {
          "refId": "A",
          "measures": ["Calls.count"], "dimensions": ["Calls.service"],
          "timeDimensions": [ { "dimension": "Calls.date", "dateRange": "Last 24 hours" } ],
          "filters": [], "order": [ ["Calls.count", "desc"] ], "limit": 10
        }
      ]
    }
  ]
}