GCP Cloud Monitoring の Aggregation を理解する

---
displayName: ALIGN_PERCENT_CHANGE
gridLayout:
  columns: '2'
  widgets:
  - title: GKE Container - CPU utilization for 1bb1eb3c-117b-11ea-aa67-42010a92023b
    xyChart:
      chartOptions:
        mode: COLOR
      dataSets:
      - minAlignmentPeriod: 60s
        plotType: LINE
        timeSeriesQuery:
          timeSeriesFilter:
            aggregation:
              perSeriesAligner: ALIGN_PERCENT_CHANGE
            filter: metric.type="container.googleapis.com/container/cpu/utilization"
              resource.type="gke_container" resource.label."pod_id"="1bb1eb3c-117b-11ea-aa67-42010a92023b"
            secondaryAggregation: {}
          unitOverride: '%'
      timeshiftDuration: 0s
      yAxis:
        label: y1Axis
        scale: LINEAR

$ gcloud monitoring dashboards create --config-from-file=ALIGN_PERCENT_CHANGE.yml
Created [7a3076af-d4ef-4227-8a5e-cf48ccf083b0].

---
displayName: ALIGN_COUNT_FALSE
gridLayout:
  columns: '2'
  widgets:
  - title: Check passed for 1bb1eb3c-117b-11ea-aa67-42010a92023b
    xyChart:
      chartOptions:
        mode: COLOR
      dataSets:
      - minAlignmentPeriod: 60s
        plotType: LINE
        timeSeriesQuery:
          timeSeriesFilter:
            aggregation:
              perSeriesAligner: ALIGN_COUNT_FALSE
            filter: metric.type="monitoring.googleapis.com/uptime_check/check_passed"
              resource.type="gce_instance" resource.label."instance_id"="7131606653945400975"
            secondaryAggregation: {}
          unitOverride: '1'
      timeshiftDuration: 0s
      yAxis:
        label: y1Axis
        scale: LINEAR

---
displayName: REDUCE_COUNT_TRUE
gridLayout:
  columns: '2'
  widgets:
  - title: GKE Container - Page faults
    xyChart:
      chartOptions:
        mode: COLOR
      dataSets:
      - minAlignmentPeriod: 60s
        plotType: LINE
        timeSeriesQuery:
          timeSeriesFilter:
            aggregation:
              crossSeriesReducer: REDUCE_COUNT_TRUE
              perSeriesAligner: ALIGN_DELTA
            filter: metric.type="container.googleapis.com/container/memory/page_fault_count"
              resource.type="gke_container"
            secondaryAggregation: {}
          unitOverride: '1'
      timeshiftDuration: 0s
      yAxis:
        label: y1Axis
        scale: LINEAR

$ PROJECT_ID='YOUR_PROJECT_ID'

$ ACCESS_TOKEN="$( gcloud auth print-access-token )"

$ FILTER="$( echo -n 'metric.type = "cloudsql.googleapis.com/database/mysql/replication/slave_io_running"' | ruby -n -r 'cgi' -e 'print(CGI.escape($_))' )"

$ START="$( echo -n '2020-05-15T05:50:00.000000Z' | ruby -n -r 'cgi' -e 'print(CGI.escape($_))' )"

$ END="$( echo -n '2020-05-15T05:55:00.000000Z' | ruby -n -r 'cgi' -e 'print(CGI.escape($_))' )"

$ curl -H "Authorization: Bearer ${ACCESS_TOKEN}" \
    "https://monitoring.googleapis.com/v3/projects/${PROJECT_ID}/timeSeries/?filter=${FILTER}&interval.startTime=${START}&interval.endTime=${END}"
{
  "timeSeries": [
    {
      "metric": {
        "type": "cloudsql.googleapis.com/database/mysql/replication/slave_io_running"
      },
      "resource": {
        "type": "cloudsql_database",
        "labels": {
          "project_id": "YOUR_PROJECT_ID",
          "database_id": "YOUR_PROJECT_ID:qg-hogehage123-replica1",
          "region": "asia-northeast1"
        }
      },
      "metricKind": "GAUGE",
      "valueType": "STRING",
      "points": [
        {
          "interval": {
            "startTime": "2020-05-15T05:54:24.820Z",
            "endTime": "2020-05-15T05:54:24.820Z"
          },
          "value": {
            "stringValue": "Yes"
          }
        },
        {
          "interval": {
            "startTime": "2020-05-15T05:53:24.820Z",
            "endTime": "2020-05-15T05:53:24.820Z"
          },
          "value": {
            "stringValue": "Yes"
          }
        }
      ]
    }
  ]
}

$ curl -H "Authorization: Bearer ${ACCESS_TOKEN}" \
    "https://monitoring.googleapis.com/v3/projects/${PROJECT_ID}/timeSeries/?filter=metric.type+%3D+%22container.googleapis.com%2Fcontainer%2Fmemory%2Fpage_fault_count%22&interval.startTime=2020-05-15T05%3A50%3A00.000000Z&interval.endTime=2020-05-15T05%3A55%3A00.000000Z&aggregation.alignmentPeriod=60s&aggregation.perSeriesAligner=ALIGN_COUNT"
{
  ...
  {
    "metric": {
      "labels": {
        "fault_type": "minor"
      },
      "type": "container.googleapis.com/container/memory/page_fault_count"
    },
    "resource": {
      ...
    },
    "metricKind": "GAUGE",
    "valueType": "INT64",
    "points": [
      ...
    ]
  }
}