将influx percentile函数转换为promQL

Question

我需要将以下涌入查询转换为promQL

SELECT PERCENTILE(value,95) FROM db WHERE cat = 'time' AND metricName = 'CPU Time' AND time > now() - 1h GROUP BY server

Answer 1

尝试以下MetricsQL query

histogram_quantile(0.95,
  sum(
    histogram_over_time(
      db_value{cat="time",metric_name="CPU Time",server=~"s1|s2"}[1h]
    )
  ) by (vmrange,server)
)