appuio_cloud_memory_sub_cpu.promql

# Calculates CPU requests higher than memory requests respecting the fair-use ratio

# Sum values over one hour.
sum_over_time(
  # Average over a one-minute time frame.
  # NOTE: This is a sliding window. Results vary based on the queries' execution time.
  avg_over_time(
    # Add the final product label by joining the base product with the cluster ID, the tenant and the namespace.
    label_join(
      # Add the category label by joining the cluster ID and the namespace.
      label_join(
        # Add the base product identifier.
        label_replace(
          clamp_min(
            (
              sum by(cluster_id, namespace, label_appuio_io_node_class) (
                # Get the CPU requests
                kube_pod_container_resource_requests{resource="cpu"} * on(uid, cluster_id, pod, namespace) group_left kube_pod_status_phase{phase="Running"}
                  * on(cluster_id, node) group_left(label_appuio_io_node_class) (min by(cluster_id, node, label_appuio_io_node_class) (kube_node_labels{label_appuio_io_node_class!=""} or on(cluster_id, node) kube_node_labels{label_appuio_io_node_class=""}))
                # Convert them to their memory equivalent by multiplying them by the memory to CPU ratio
                # Build that ratio from static values
                * on(cluster_id) group_left()(
                  # Build a time series for Cloudscale LPG 2 (4096 MiB/core)
                  label_replace(vector(4294967296), "cluster_id", "c-appuio-cloudscale-lpg-2", "", "")
                  # Build a time series for Exoscale GVA-2 0 (5086 MiB/core)
                  or label_replace(vector(5333057536), "cluster_id", "c-appuio-exoscale-ch-gva-2-0", "", "")
                )
              )
              - sum by(cluster_id, namespace, label_appuio_io_node_class) (kube_pod_container_resource_requests{resource="memory"} * on(uid, cluster_id, pod, namespace) group_left kube_pod_status_phase{phase="Running"}
                * on(cluster_id, node) group_left(label_appuio_io_node_class) (min by(cluster_id, node, label_appuio_io_node_class) (kube_node_labels{label_appuio_io_node_class!=""} or on(cluster_id, node) kube_node_labels{label_appuio_io_node_class=""})))
            )
            *
            # Join namespace label `label_appuio_io_organization` as `tenant_id`.
            on(cluster_id, namespace)
            group_left(tenant_id)
            label_replace(
              kube_namespace_labels{label_appuio_io_organization=~".+"},
              "tenant_id",
              "$1",
              "label_appuio_io_organization", "(.*)"
            ),
            # At least return 0
            0
          ),
          "product",
          "appuio_cloud_memory",
          "product",
          ".*"
        ),
        "category",
        ":",
        "cluster_id",
        "namespace"
      ),
      "product",
      ":",
      "product",
      "cluster_id",
      "tenant_id",
      "namespace",
      "label_appuio_io_node_class"
    )[45s:15s]
  )[59m:1m]
)
# Convert to MiB
/ 1024 / 1024