English 中文(简体)
我如何在维多利亚Metrics时代系列中找到最老点?
原标题:How do I get the oldest point in a VictoriaMetrics time series?

维多利亚Metrics的这种非奢侈品的 que问是什么?

SELECT * FROM ${measurement}
    WHERE ...
    LIMIT 1

VictoriaMetrics doesn t have a LIMIT modifier, so a query like
${metric}{...labels...}[20y]
will return ALL points. (Also, 20y is dicey, but an arbitrarily large duration won t work.)

我只需要时间。

问题回答

其中一个答案是tfirst_over_time:

每一次从特定系列的_子返回的系列中,先线标/代码的首批原始样本的时序号。

因此,

tfirst_over_time(${metric}{...labels...}[100y])

您仍然必须提供任意的大笔时间,但令人惊讶的是,100yt t 似乎在bugtfirst_over_time





相关问题
how to regex path in prometheus relabel_configs

i have a metric and label like this: namedprocess_namegroup_num_procs{groupname:"/data/home/user01/app.service.1/service"}, i want to get the last field: service, and the number in last but ...

Change indexdb and data location for vm storage

We have a VM cluster running on multiple nodes, each node has two local file systems Ideally the data should be written to "/server/victoria-metrics/data" FS according to the configuration -...