range query: timestamps are inconsistent on year range #5392

melck · 2023-11-26T18:33:39Z

Is your question request related to a specific component?

Victoria Metrics

Describe the question in detail

I've just started using Victoria Metrics and I love it, but I'm experiencing some strange behavior.

I use it with grafana and I want to have a monthly graph over the year. I am in the "Europe/Paris" time zone and I query a range of the current year with one data per day, then I apply a transformation to get the monthly sum. When I try to do this, I have a timestamp before the requested start and the desired step is not respected, but it works when the range is less important (like 7 days).

For example start=1672527600, end=1704063599, step=1, query="test_sensor_energy_kwh default 0" with the following fake metric gives me a timestamp at 2022-MM-DD 00:00:00 UTC instead of 2022-MM-DD 23:00:00 UTC and the first one is out of range at 2022-12-31 00:00:00 UTC:

{
     "metric": {
       "__name__": "test_sensor_energy_kwh",
       "job": "test",
       "instance": "test"
     },
     "timestamps": [
       1700348400000,
       1700434800000,
       1700521200000,
       1700607600000,
       1700694000000,
       1700780400000,
       1700866800000,
       1700953200000
     ],
     "values": [
       17,
       12,
       12,
       14,
       16,
       16,
       11,
       13
     ]
}

Is this expected behavior or am I missing something?

Troubleshooting docs

General - https://docs.victoriametrics.com/Troubleshooting.html
vmagent - https://docs.victoriametrics.com/vmagent.html#troubleshooting
vmalert - https://docs.victoriametrics.com/vmalert.html#troubleshooting

The text was updated successfully, but these errors were encountered:

hagen1778 · 2023-11-28T09:56:50Z

Hello @melck!

When I try to do this, I have a timestamp before the requested start and the desired step is not respected, but it works when the range is less important (like 7 days).

Could you elaborate more on step not respected? Could it be that grafana interprets received timestamps according to the light-time-saving changes?

melck · 2023-11-28T14:45:38Z

Hi @hagen1778

Sorry if I'm not clear. If we ignore the grafana part, when I directly query api query range, I have a difference in the response. In the two examples below, the first answers what I expect. The second responds to me with less than 23 hours.

Is it normal ? I will test later with prometheus to see if it is the same behavior.

Example over 17 days

I ask every day at 23h UTC:

# query: test_sensor_energy_kwh default 0
# start: 2023-11-09T23:00:00+00:00
# end: 2023-11-26T22:59:59+00:00
curl -G \
  -d 'query=test_sensor_energy_kwh%20default%200' \
  -d 'start=1699570800' \
  -d 'end=1701039599' \
  -d 'step=1d' \
  'http://localhost:8428/api/v1/query_range'

Answers every day at 23h UTC:

Datetime	Value
2023-11-09T23:00:00+00:00	0
2023-11-10T23:00:00+00:00	0
2023-11-11T23:00:00+00:00	0
2023-11-12T23:00:00+00:00	0
2023-11-13T23:00:00+00:00	0
2023-11-14T23:00:00+00:00	0
2023-11-15T23:00:00+00:00	0
2023-11-16T23:00:00+00:00	0
2023-11-17T23:00:00+00:00	0
2023-11-18T23:00:00+00:00	17
2023-11-19T23:00:00+00:00	12
2023-11-20T23:00:00+00:00	12
2023-11-21T23:00:00+00:00	14
2023-11-22T23:00:00+00:00	16
2023-11-23T23:00:00+00:00	16
2023-11-24T23:00:00+00:00	11
2023-11-25T23:00:00+00:00	13

Example over 1 year

Asking to do each day at 23h UTC:

# query: test_sensor_energy_kwh default 0
# start: 2022-12-31T23:00:00+00:00
# end: 2023-12-31T22:59:59+00:00
curl -G \
  -d 'query=test_sensor_energy_kwh%20default%200' \
  -d 'start=1672527600' \
  -d 'end=1704063599' \
  -d 'step=1d' \
  'http://localhost:8428/api/v1/query_range'

Answers every day at 0h UTC:

Datetime	Value
2022-12-31T00:00:00+00:00	0
2023-01-01T00:00:00+00:00	0
2023-01-02T00:00:00+00:00	0
2023-01-03T00:00:00+00:00	0
2023-01-04T00:00:00+00:00	0
2023-01-05T00:00:00+00:00	0
2023-01-06T00:00:00+00:00	0
2023-01-07T00:00:00+00:00	0
2023-01-08T00:00:00+00:00	0
2023-01-09T00:00:00+00:00	0
2023-01-10T00:00:00+00:00	0
2023-01-11T00:00:00+00:00	0
2023-01-12T00:00:00+00:00	0
2023-01-13T00:00:00+00:00	0
2023-01-14T00:00:00+00:00	0
2023-01-15T00:00:00+00:00	0
2023-01-16T00:00:00+00:00	0
2023-01-17T00:00:00+00:00	0
2023-01-18T00:00:00+00:00	0
2023-01-19T00:00:00+00:00	0
2023-01-20T00:00:00+00:00	0
2023-01-21T00:00:00+00:00	0
2023-01-22T00:00:00+00:00	0
2023-01-23T00:00:00+00:00	0
2023-01-24T00:00:00+00:00	0
2023-01-25T00:00:00+00:00	0
2023-01-26T00:00:00+00:00	0
2023-01-27T00:00:00+00:00	0
2023-01-28T00:00:00+00:00	0
2023-01-29T00:00:00+00:00	0
2023-01-30T00:00:00+00:00	0
2023-01-31T00:00:00+00:00	0
2023-02-01T00:00:00+00:00	0
2023-02-02T00:00:00+00:00	0
2023-02-03T00:00:00+00:00	0
2023-02-04T00:00:00+00:00	0
2023-02-05T00:00:00+00:00	0
2023-02-06T00:00:00+00:00	0
2023-02-07T00:00:00+00:00	0
2023-02-08T00:00:00+00:00	0
2023-02-09T00:00:00+00:00	0
2023-02-10T00:00:00+00:00	0
2023-02-11T00:00:00+00:00	0
2023-02-12T00:00:00+00:00	0
2023-02-13T00:00:00+00:00	0
2023-02-14T00:00:00+00:00	0
2023-02-15T00:00:00+00:00	0
2023-02-16T00:00:00+00:00	0
2023-02-17T00:00:00+00:00	0
2023-02-18T00:00:00+00:00	0
2023-02-19T00:00:00+00:00	0
2023-02-20T00:00:00+00:00	0
2023-02-21T00:00:00+00:00	0
2023-02-22T00:00:00+00:00	0
2023-02-23T00:00:00+00:00	0
2023-02-24T00:00:00+00:00	0
2023-02-25T00:00:00+00:00	0
2023-02-26T00:00:00+00:00	0
2023-02-27T00:00:00+00:00	0
2023-02-28T00:00:00+00:00	0
2023-03-01T00:00:00+00:00	0
2023-03-02T00:00:00+00:00	0
2023-03-03T00:00:00+00:00	0
2023-03-04T00:00:00+00:00	0
2023-03-05T00:00:00+00:00	0
2023-03-06T00:00:00+00:00	0
2023-03-07T00:00:00+00:00	0
2023-03-08T00:00:00+00:00	0
2023-03-09T00:00:00+00:00	0
2023-03-10T00:00:00+00:00	0
2023-03-11T00:00:00+00:00	0
2023-03-12T00:00:00+00:00	0
2023-03-13T00:00:00+00:00	0
2023-03-14T00:00:00+00:00	0
2023-03-15T00:00:00+00:00	0
2023-03-16T00:00:00+00:00	0
2023-03-17T00:00:00+00:00	0
2023-03-18T00:00:00+00:00	0
2023-03-19T00:00:00+00:00	0
2023-03-20T00:00:00+00:00	0
2023-03-21T00:00:00+00:00	0
2023-03-22T00:00:00+00:00	0
2023-03-23T00:00:00+00:00	0
2023-03-24T00:00:00+00:00	0
2023-03-25T00:00:00+00:00	0
2023-03-26T00:00:00+00:00	0
2023-03-27T00:00:00+00:00	0
2023-03-28T00:00:00+00:00	0
2023-03-29T00:00:00+00:00	0
2023-03-30T00:00:00+00:00	0
2023-03-31T00:00:00+00:00	0
2023-04-01T00:00:00+00:00	0
2023-04-02T00:00:00+00:00	0
2023-04-03T00:00:00+00:00	0
2023-04-04T00:00:00+00:00	0
2023-04-05T00:00:00+00:00	0
2023-04-06T00:00:00+00:00	0
2023-04-07T00:00:00+00:00	0
2023-04-08T00:00:00+00:00	0
2023-04-09T00:00:00+00:00	0
2023-04-10T00:00:00+00:00	0
2023-04-11T00:00:00+00:00	0
2023-04-12T00:00:00+00:00	0
2023-04-13T00:00:00+00:00	0
2023-04-14T00:00:00+00:00	0
2023-04-15T00:00:00+00:00	0
2023-04-16T00:00:00+00:00	0
2023-04-17T00:00:00+00:00	0
2023-04-18T00:00:00+00:00	0
2023-04-19T00:00:00+00:00	0
2023-04-20T00:00:00+00:00	0
2023-04-21T00:00:00+00:00	0
2023-04-22T00:00:00+00:00	0
2023-04-23T00:00:00+00:00	0
2023-04-24T00:00:00+00:00	0
2023-04-25T00:00:00+00:00	0
2023-04-26T00:00:00+00:00	0
2023-04-27T00:00:00+00:00	0
2023-04-28T00:00:00+00:00	0
2023-04-29T00:00:00+00:00	0
2023-04-30T00:00:00+00:00	0
2023-05-01T00:00:00+00:00	0
2023-05-02T00:00:00+00:00	0
2023-05-03T00:00:00+00:00	0
2023-05-04T00:00:00+00:00	0
2023-05-05T00:00:00+00:00	0
2023-05-06T00:00:00+00:00	0
2023-05-07T00:00:00+00:00	0
2023-05-08T00:00:00+00:00	0
2023-05-09T00:00:00+00:00	0
2023-05-10T00:00:00+00:00	0
2023-05-11T00:00:00+00:00	0
2023-05-12T00:00:00+00:00	0
2023-05-13T00:00:00+00:00	0
2023-05-14T00:00:00+00:00	0
2023-05-15T00:00:00+00:00	0
2023-05-16T00:00:00+00:00	0
2023-05-17T00:00:00+00:00	0
2023-05-18T00:00:00+00:00	0
2023-05-19T00:00:00+00:00	0
2023-05-20T00:00:00+00:00	0
2023-05-21T00:00:00+00:00	0
2023-05-22T00:00:00+00:00	0
2023-05-23T00:00:00+00:00	0
2023-05-24T00:00:00+00:00	0
2023-05-25T00:00:00+00:00	0
2023-05-26T00:00:00+00:00	0
2023-05-27T00:00:00+00:00	0
2023-05-28T00:00:00+00:00	0
2023-05-29T00:00:00+00:00	0
2023-05-30T00:00:00+00:00	0
2023-05-31T00:00:00+00:00	0
2023-06-01T00:00:00+00:00	0
2023-06-02T00:00:00+00:00	0
2023-06-03T00:00:00+00:00	0
2023-06-04T00:00:00+00:00	0
2023-06-05T00:00:00+00:00	0
2023-06-06T00:00:00+00:00	0
2023-06-07T00:00:00+00:00	0
2023-06-08T00:00:00+00:00	0
2023-06-09T00:00:00+00:00	0
2023-06-10T00:00:00+00:00	0
2023-06-11T00:00:00+00:00	0
2023-06-12T00:00:00+00:00	0
2023-06-13T00:00:00+00:00	0
2023-06-14T00:00:00+00:00	0
2023-06-15T00:00:00+00:00	0
2023-06-16T00:00:00+00:00	0
2023-06-17T00:00:00+00:00	0
2023-06-18T00:00:00+00:00	0
2023-06-19T00:00:00+00:00	0
2023-06-20T00:00:00+00:00	0
2023-06-21T00:00:00+00:00	0
2023-06-22T00:00:00+00:00	0
2023-06-23T00:00:00+00:00	0
2023-06-24T00:00:00+00:00	0
2023-06-25T00:00:00+00:00	0
2023-06-26T00:00:00+00:00	0
2023-06-27T00:00:00+00:00	0
2023-06-28T00:00:00+00:00	0
2023-06-29T00:00:00+00:00	0
2023-06-30T00:00:00+00:00	0
2023-07-01T00:00:00+00:00	0
2023-07-02T00:00:00+00:00	0
2023-07-03T00:00:00+00:00	0
2023-07-04T00:00:00+00:00	0
2023-07-05T00:00:00+00:00	0
2023-07-06T00:00:00+00:00	0
2023-07-07T00:00:00+00:00	0
2023-07-08T00:00:00+00:00	0
2023-07-09T00:00:00+00:00	0
2023-07-10T00:00:00+00:00	0
2023-07-11T00:00:00+00:00	0
2023-07-12T00:00:00+00:00	0
2023-07-13T00:00:00+00:00	0
2023-07-14T00:00:00+00:00	0
2023-07-15T00:00:00+00:00	0
2023-07-16T00:00:00+00:00	0
2023-07-17T00:00:00+00:00	0
2023-07-18T00:00:00+00:00	0
2023-07-19T00:00:00+00:00	0
2023-07-20T00:00:00+00:00	0
2023-07-21T00:00:00+00:00	0
2023-07-22T00:00:00+00:00	0
2023-07-23T00:00:00+00:00	0
2023-07-24T00:00:00+00:00	0
2023-07-25T00:00:00+00:00	0
2023-07-26T00:00:00+00:00	0
2023-07-27T00:00:00+00:00	0
2023-07-28T00:00:00+00:00	0
2023-07-29T00:00:00+00:00	0
2023-07-30T00:00:00+00:00	0
2023-07-31T00:00:00+00:00	0
2023-08-01T00:00:00+00:00	0
2023-08-02T00:00:00+00:00	0
2023-08-03T00:00:00+00:00	0
2023-08-04T00:00:00+00:00	0
2023-08-05T00:00:00+00:00	0
2023-08-06T00:00:00+00:00	0
2023-08-07T00:00:00+00:00	0
2023-08-08T00:00:00+00:00	0
2023-08-09T00:00:00+00:00	0
2023-08-10T00:00:00+00:00	0
2023-08-11T00:00:00+00:00	0
2023-08-12T00:00:00+00:00	0
2023-08-13T00:00:00+00:00	0
2023-08-14T00:00:00+00:00	0
2023-08-15T00:00:00+00:00	0
2023-08-16T00:00:00+00:00	0
2023-08-17T00:00:00+00:00	0
2023-08-18T00:00:00+00:00	0
2023-08-19T00:00:00+00:00	0
2023-08-20T00:00:00+00:00	0
2023-08-21T00:00:00+00:00	0
2023-08-22T00:00:00+00:00	0
2023-08-23T00:00:00+00:00	0
2023-08-24T00:00:00+00:00	0
2023-08-25T00:00:00+00:00	0
2023-08-26T00:00:00+00:00	0
2023-08-27T00:00:00+00:00	0
2023-08-28T00:00:00+00:00	0
2023-08-29T00:00:00+00:00	0
2023-08-30T00:00:00+00:00	0
2023-08-31T00:00:00+00:00	0
2023-09-01T00:00:00+00:00	0
2023-09-02T00:00:00+00:00	0
2023-09-03T00:00:00+00:00	0
2023-09-04T00:00:00+00:00	0
2023-09-05T00:00:00+00:00	0
2023-09-06T00:00:00+00:00	0
2023-09-07T00:00:00+00:00	0
2023-09-08T00:00:00+00:00	0
2023-09-09T00:00:00+00:00	0
2023-09-10T00:00:00+00:00	0
2023-09-11T00:00:00+00:00	0
2023-09-12T00:00:00+00:00	0
2023-09-13T00:00:00+00:00	0
2023-09-14T00:00:00+00:00	0
2023-09-15T00:00:00+00:00	0
2023-09-16T00:00:00+00:00	0
2023-09-17T00:00:00+00:00	0
2023-09-18T00:00:00+00:00	0
2023-09-19T00:00:00+00:00	0
2023-09-20T00:00:00+00:00	0
2023-09-21T00:00:00+00:00	0
2023-09-22T00:00:00+00:00	0
2023-09-23T00:00:00+00:00	0
2023-09-24T00:00:00+00:00	0
2023-09-25T00:00:00+00:00	0
2023-09-26T00:00:00+00:00	0
2023-09-27T00:00:00+00:00	0
2023-09-28T00:00:00+00:00	0
2023-09-29T00:00:00+00:00	0
2023-09-30T00:00:00+00:00	0
2023-10-01T00:00:00+00:00	0
2023-10-02T00:00:00+00:00	0
2023-10-03T00:00:00+00:00	0
2023-10-04T00:00:00+00:00	0
2023-10-05T00:00:00+00:00	0
2023-10-06T00:00:00+00:00	0
2023-10-07T00:00:00+00:00	0
2023-10-08T00:00:00+00:00	0
2023-10-09T00:00:00+00:00	0
2023-10-10T00:00:00+00:00	0
2023-10-11T00:00:00+00:00	0
2023-10-12T00:00:00+00:00	0
2023-10-13T00:00:00+00:00	0
2023-10-14T00:00:00+00:00	0
2023-10-15T00:00:00+00:00	0
2023-10-16T00:00:00+00:00	0
2023-10-17T00:00:00+00:00	0
2023-10-18T00:00:00+00:00	0
2023-10-19T00:00:00+00:00	0
2023-10-20T00:00:00+00:00	0
2023-10-21T00:00:00+00:00	0
2023-10-22T00:00:00+00:00	0
2023-10-23T00:00:00+00:00	0
2023-10-24T00:00:00+00:00	0
2023-10-25T00:00:00+00:00	0
2023-10-26T00:00:00+00:00	0
2023-10-27T00:00:00+00:00	0
2023-10-28T00:00:00+00:00	0
2023-10-29T00:00:00+00:00	0
2023-10-30T00:00:00+00:00	0
2023-10-31T00:00:00+00:00	0
2023-11-01T00:00:00+00:00	0
2023-11-02T00:00:00+00:00	0
2023-11-03T00:00:00+00:00	0
2023-11-04T00:00:00+00:00	0
2023-11-05T00:00:00+00:00	0
2023-11-06T00:00:00+00:00	0
2023-11-07T00:00:00+00:00	0
2023-11-08T00:00:00+00:00	0
2023-11-09T00:00:00+00:00	0
2023-11-10T00:00:00+00:00	0
2023-11-11T00:00:00+00:00	0
2023-11-12T00:00:00+00:00	0
2023-11-13T00:00:00+00:00	0
2023-11-14T00:00:00+00:00	0
2023-11-15T00:00:00+00:00	0
2023-11-16T00:00:00+00:00	0
2023-11-17T00:00:00+00:00	0
2023-11-18T00:00:00+00:00	0
2023-11-19T00:00:00+00:00	17
2023-11-20T00:00:00+00:00	12
2023-11-21T00:00:00+00:00	12
2023-11-22T00:00:00+00:00	14
2023-11-23T00:00:00+00:00	16
2023-11-24T00:00:00+00:00	16
2023-11-25T00:00:00+00:00	11
2023-11-26T00:00:00+00:00	13
2023-11-27T00:00:00+00:00	13
2023-11-28T00:00:00+00:00	0
2023-11-29T00:00:00+00:00	0
2023-11-30T00:00:00+00:00	0
2023-12-01T00:00:00+00:00	0
2023-12-02T00:00:00+00:00	0
2023-12-03T00:00:00+00:00	0
2023-12-04T00:00:00+00:00	0
2023-12-05T00:00:00+00:00	0
2023-12-06T00:00:00+00:00	0
2023-12-07T00:00:00+00:00	0
2023-12-08T00:00:00+00:00	0
2023-12-09T00:00:00+00:00	0
2023-12-10T00:00:00+00:00	0
2023-12-11T00:00:00+00:00	0
2023-12-12T00:00:00+00:00	0
2023-12-13T00:00:00+00:00	0
2023-12-14T00:00:00+00:00	0
2023-12-15T00:00:00+00:00	0
2023-12-16T00:00:00+00:00	0
2023-12-17T00:00:00+00:00	0
2023-12-18T00:00:00+00:00	0
2023-12-19T00:00:00+00:00	0
2023-12-20T00:00:00+00:00	0
2023-12-21T00:00:00+00:00	0
2023-12-22T00:00:00+00:00	0
2023-12-23T00:00:00+00:00	0
2023-12-24T00:00:00+00:00	0
2023-12-25T00:00:00+00:00	0
2023-12-26T00:00:00+00:00	0
2023-12-27T00:00:00+00:00	0
2023-12-28T00:00:00+00:00	0
2023-12-29T00:00:00+00:00	0
2023-12-30T00:00:00+00:00	0

melck · 2023-11-28T15:53:45Z

I made a very simple comparison with Prometheus. Prometheus gives me the datetimes I expect.

Victora Metrics

START	END	STEP	QUERY
2022-12-31T23:00:00+00:00	2023-12-31T22:59:59+00:00	1d	1

TIMESTAMP	VALUE
2022-12-31T00:00:00+00:00	1
2023-01-01T00:00:00+00:00	1
2023-01-02T00:00:00+00:00	1
2023-01-03T00:00:00+00:00	1
2023-01-04T00:00:00+00:00	1
2023-01-05T00:00:00+00:00	1
2023-01-06T00:00:00+00:00	1
2023-01-07T00:00:00+00:00	1
2023-01-08T00:00:00+00:00	1
2023-01-09T00:00:00+00:00	1
2023-01-10T00:00:00+00:00	1
2023-01-11T00:00:00+00:00	1
2023-01-12T00:00:00+00:00	1
2023-01-13T00:00:00+00:00	1
2023-01-14T00:00:00+00:00	1
2023-01-15T00:00:00+00:00	1
2023-01-16T00:00:00+00:00	1
2023-01-17T00:00:00+00:00	1
2023-01-18T00:00:00+00:00	1
2023-01-19T00:00:00+00:00	1
2023-01-20T00:00:00+00:00	1
2023-01-21T00:00:00+00:00	1
2023-01-22T00:00:00+00:00	1
2023-01-23T00:00:00+00:00	1
2023-01-24T00:00:00+00:00	1
2023-01-25T00:00:00+00:00	1
2023-01-26T00:00:00+00:00	1
2023-01-27T00:00:00+00:00	1
2023-01-28T00:00:00+00:00	1
2023-01-29T00:00:00+00:00	1
2023-01-30T00:00:00+00:00	1
2023-01-31T00:00:00+00:00	1
2023-02-01T00:00:00+00:00	1
2023-02-02T00:00:00+00:00	1
2023-02-03T00:00:00+00:00	1
2023-02-04T00:00:00+00:00	1
2023-02-05T00:00:00+00:00	1
2023-02-06T00:00:00+00:00	1
2023-02-07T00:00:00+00:00	1
2023-02-08T00:00:00+00:00	1
2023-02-09T00:00:00+00:00	1
2023-02-10T00:00:00+00:00	1
2023-02-11T00:00:00+00:00	1
2023-02-12T00:00:00+00:00	1
2023-02-13T00:00:00+00:00	1
2023-02-14T00:00:00+00:00	1
2023-02-15T00:00:00+00:00	1
2023-02-16T00:00:00+00:00	1
2023-02-17T00:00:00+00:00	1
2023-02-18T00:00:00+00:00	1
2023-02-19T00:00:00+00:00	1
2023-02-20T00:00:00+00:00	1
2023-02-21T00:00:00+00:00	1
2023-02-22T00:00:00+00:00	1
2023-02-23T00:00:00+00:00	1
2023-02-24T00:00:00+00:00	1
2023-02-25T00:00:00+00:00	1
2023-02-26T00:00:00+00:00	1
2023-02-27T00:00:00+00:00	1
2023-02-28T00:00:00+00:00	1
2023-03-01T00:00:00+00:00	1
2023-03-02T00:00:00+00:00	1
2023-03-03T00:00:00+00:00	1
2023-03-04T00:00:00+00:00	1
2023-03-05T00:00:00+00:00	1
2023-03-06T00:00:00+00:00	1
2023-03-07T00:00:00+00:00	1
2023-03-08T00:00:00+00:00	1
2023-03-09T00:00:00+00:00	1
2023-03-10T00:00:00+00:00	1
2023-03-11T00:00:00+00:00	1
2023-03-12T00:00:00+00:00	1
2023-03-13T00:00:00+00:00	1
2023-03-14T00:00:00+00:00	1
2023-03-15T00:00:00+00:00	1
2023-03-16T00:00:00+00:00	1
2023-03-17T00:00:00+00:00	1
2023-03-18T00:00:00+00:00	1
2023-03-19T00:00:00+00:00	1
2023-03-20T00:00:00+00:00	1
2023-03-21T00:00:00+00:00	1
2023-03-22T00:00:00+00:00	1
2023-03-23T00:00:00+00:00	1
2023-03-24T00:00:00+00:00	1
2023-03-25T00:00:00+00:00	1
2023-03-26T00:00:00+00:00	1
2023-03-27T00:00:00+00:00	1
2023-03-28T00:00:00+00:00	1
2023-03-29T00:00:00+00:00	1
2023-03-30T00:00:00+00:00	1
2023-03-31T00:00:00+00:00	1
2023-04-01T00:00:00+00:00	1
2023-04-02T00:00:00+00:00	1
2023-04-03T00:00:00+00:00	1
2023-04-04T00:00:00+00:00	1
2023-04-05T00:00:00+00:00	1
2023-04-06T00:00:00+00:00	1
2023-04-07T00:00:00+00:00	1
2023-04-08T00:00:00+00:00	1
2023-04-09T00:00:00+00:00	1
2023-04-10T00:00:00+00:00	1
2023-04-11T00:00:00+00:00	1
2023-04-12T00:00:00+00:00	1
2023-04-13T00:00:00+00:00	1
2023-04-14T00:00:00+00:00	1
2023-04-15T00:00:00+00:00	1
2023-04-16T00:00:00+00:00	1
2023-04-17T00:00:00+00:00	1
2023-04-18T00:00:00+00:00	1
2023-04-19T00:00:00+00:00	1
2023-04-20T00:00:00+00:00	1
2023-04-21T00:00:00+00:00	1
2023-04-22T00:00:00+00:00	1
2023-04-23T00:00:00+00:00	1
2023-04-24T00:00:00+00:00	1
2023-04-25T00:00:00+00:00	1
2023-04-26T00:00:00+00:00	1
2023-04-27T00:00:00+00:00	1
2023-04-28T00:00:00+00:00	1
2023-04-29T00:00:00+00:00	1
2023-04-30T00:00:00+00:00	1
2023-05-01T00:00:00+00:00	1
2023-05-02T00:00:00+00:00	1
2023-05-03T00:00:00+00:00	1
2023-05-04T00:00:00+00:00	1
2023-05-05T00:00:00+00:00	1
2023-05-06T00:00:00+00:00	1
2023-05-07T00:00:00+00:00	1
2023-05-08T00:00:00+00:00	1
2023-05-09T00:00:00+00:00	1
2023-05-10T00:00:00+00:00	1
2023-05-11T00:00:00+00:00	1
2023-05-12T00:00:00+00:00	1
2023-05-13T00:00:00+00:00	1
2023-05-14T00:00:00+00:00	1
2023-05-15T00:00:00+00:00	1
2023-05-16T00:00:00+00:00	1
2023-05-17T00:00:00+00:00	1
2023-05-18T00:00:00+00:00	1
2023-05-19T00:00:00+00:00	1
2023-05-20T00:00:00+00:00	1
2023-05-21T00:00:00+00:00	1
2023-05-22T00:00:00+00:00	1
2023-05-23T00:00:00+00:00	1
2023-05-24T00:00:00+00:00	1
2023-05-25T00:00:00+00:00	1
2023-05-26T00:00:00+00:00	1
2023-05-27T00:00:00+00:00	1
2023-05-28T00:00:00+00:00	1
2023-05-29T00:00:00+00:00	1
2023-05-30T00:00:00+00:00	1
2023-05-31T00:00:00+00:00	1
2023-06-01T00:00:00+00:00	1
2023-06-02T00:00:00+00:00	1
2023-06-03T00:00:00+00:00	1
2023-06-04T00:00:00+00:00	1
2023-06-05T00:00:00+00:00	1
2023-06-06T00:00:00+00:00	1
2023-06-07T00:00:00+00:00	1
2023-06-08T00:00:00+00:00	1
2023-06-09T00:00:00+00:00	1
2023-06-10T00:00:00+00:00	1
2023-06-11T00:00:00+00:00	1
2023-06-12T00:00:00+00:00	1
2023-06-13T00:00:00+00:00	1
2023-06-14T00:00:00+00:00	1
2023-06-15T00:00:00+00:00	1
2023-06-16T00:00:00+00:00	1
2023-06-17T00:00:00+00:00	1
2023-06-18T00:00:00+00:00	1
2023-06-19T00:00:00+00:00	1
2023-06-20T00:00:00+00:00	1
2023-06-21T00:00:00+00:00	1
2023-06-22T00:00:00+00:00	1
2023-06-23T00:00:00+00:00	1
2023-06-24T00:00:00+00:00	1
2023-06-25T00:00:00+00:00	1
2023-06-26T00:00:00+00:00	1
2023-06-27T00:00:00+00:00	1
2023-06-28T00:00:00+00:00	1
2023-06-29T00:00:00+00:00	1
2023-06-30T00:00:00+00:00	1
2023-07-01T00:00:00+00:00	1
2023-07-02T00:00:00+00:00	1
2023-07-03T00:00:00+00:00	1
2023-07-04T00:00:00+00:00	1
2023-07-05T00:00:00+00:00	1
2023-07-06T00:00:00+00:00	1
2023-07-07T00:00:00+00:00	1
2023-07-08T00:00:00+00:00	1
2023-07-09T00:00:00+00:00	1
2023-07-10T00:00:00+00:00	1
2023-07-11T00:00:00+00:00	1
2023-07-12T00:00:00+00:00	1
2023-07-13T00:00:00+00:00	1
2023-07-14T00:00:00+00:00	1
2023-07-15T00:00:00+00:00	1
2023-07-16T00:00:00+00:00	1
2023-07-17T00:00:00+00:00	1
2023-07-18T00:00:00+00:00	1
2023-07-19T00:00:00+00:00	1
2023-07-20T00:00:00+00:00	1
2023-07-21T00:00:00+00:00	1
2023-07-22T00:00:00+00:00	1
2023-07-23T00:00:00+00:00	1
2023-07-24T00:00:00+00:00	1
2023-07-25T00:00:00+00:00	1
2023-07-26T00:00:00+00:00	1
2023-07-27T00:00:00+00:00	1
2023-07-28T00:00:00+00:00	1
2023-07-29T00:00:00+00:00	1
2023-07-30T00:00:00+00:00	1
2023-07-31T00:00:00+00:00	1
2023-08-01T00:00:00+00:00	1
2023-08-02T00:00:00+00:00	1
2023-08-03T00:00:00+00:00	1
2023-08-04T00:00:00+00:00	1
2023-08-05T00:00:00+00:00	1
2023-08-06T00:00:00+00:00	1
2023-08-07T00:00:00+00:00	1
2023-08-08T00:00:00+00:00	1
2023-08-09T00:00:00+00:00	1
2023-08-10T00:00:00+00:00	1
2023-08-11T00:00:00+00:00	1
2023-08-12T00:00:00+00:00	1
2023-08-13T00:00:00+00:00	1
2023-08-14T00:00:00+00:00	1
2023-08-15T00:00:00+00:00	1
2023-08-16T00:00:00+00:00	1
2023-08-17T00:00:00+00:00	1
2023-08-18T00:00:00+00:00	1
2023-08-19T00:00:00+00:00	1
2023-08-20T00:00:00+00:00	1
2023-08-21T00:00:00+00:00	1
2023-08-22T00:00:00+00:00	1
2023-08-23T00:00:00+00:00	1
2023-08-24T00:00:00+00:00	1
2023-08-25T00:00:00+00:00	1
2023-08-26T00:00:00+00:00	1
2023-08-27T00:00:00+00:00	1
2023-08-28T00:00:00+00:00	1
2023-08-29T00:00:00+00:00	1
2023-08-30T00:00:00+00:00	1
2023-08-31T00:00:00+00:00	1
2023-09-01T00:00:00+00:00	1
2023-09-02T00:00:00+00:00	1
2023-09-03T00:00:00+00:00	1
2023-09-04T00:00:00+00:00	1
2023-09-05T00:00:00+00:00	1
2023-09-06T00:00:00+00:00	1
2023-09-07T00:00:00+00:00	1
2023-09-08T00:00:00+00:00	1
2023-09-09T00:00:00+00:00	1
2023-09-10T00:00:00+00:00	1
2023-09-11T00:00:00+00:00	1
2023-09-12T00:00:00+00:00	1
2023-09-13T00:00:00+00:00	1
2023-09-14T00:00:00+00:00	1
2023-09-15T00:00:00+00:00	1
2023-09-16T00:00:00+00:00	1
2023-09-17T00:00:00+00:00	1
2023-09-18T00:00:00+00:00	1
2023-09-19T00:00:00+00:00	1
2023-09-20T00:00:00+00:00	1
2023-09-21T00:00:00+00:00	1
2023-09-22T00:00:00+00:00	1
2023-09-23T00:00:00+00:00	1
2023-09-24T00:00:00+00:00	1
2023-09-25T00:00:00+00:00	1
2023-09-26T00:00:00+00:00	1
2023-09-27T00:00:00+00:00	1
2023-09-28T00:00:00+00:00	1
2023-09-29T00:00:00+00:00	1
2023-09-30T00:00:00+00:00	1
2023-10-01T00:00:00+00:00	1
2023-10-02T00:00:00+00:00	1
2023-10-03T00:00:00+00:00	1
2023-10-04T00:00:00+00:00	1
2023-10-05T00:00:00+00:00	1
2023-10-06T00:00:00+00:00	1
2023-10-07T00:00:00+00:00	1
2023-10-08T00:00:00+00:00	1
2023-10-09T00:00:00+00:00	1
2023-10-10T00:00:00+00:00	1
2023-10-11T00:00:00+00:00	1
2023-10-12T00:00:00+00:00	1
2023-10-13T00:00:00+00:00	1
2023-10-14T00:00:00+00:00	1
2023-10-15T00:00:00+00:00	1
2023-10-16T00:00:00+00:00	1
2023-10-17T00:00:00+00:00	1
2023-10-18T00:00:00+00:00	1
2023-10-19T00:00:00+00:00	1
2023-10-20T00:00:00+00:00	1
2023-10-21T00:00:00+00:00	1
2023-10-22T00:00:00+00:00	1
2023-10-23T00:00:00+00:00	1
2023-10-24T00:00:00+00:00	1
2023-10-25T00:00:00+00:00	1
2023-10-26T00:00:00+00:00	1
2023-10-27T00:00:00+00:00	1
2023-10-28T00:00:00+00:00	1
2023-10-29T00:00:00+00:00	1
2023-10-30T00:00:00+00:00	1
2023-10-31T00:00:00+00:00	1
2023-11-01T00:00:00+00:00	1
2023-11-02T00:00:00+00:00	1
2023-11-03T00:00:00+00:00	1
2023-11-04T00:00:00+00:00	1
2023-11-05T00:00:00+00:00	1
2023-11-06T00:00:00+00:00	1
2023-11-07T00:00:00+00:00	1
2023-11-08T00:00:00+00:00	1
2023-11-09T00:00:00+00:00	1
2023-11-10T00:00:00+00:00	1
2023-11-11T00:00:00+00:00	1
2023-11-12T00:00:00+00:00	1
2023-11-13T00:00:00+00:00	1
2023-11-14T00:00:00+00:00	1
2023-11-15T00:00:00+00:00	1
2023-11-16T00:00:00+00:00	1
2023-11-17T00:00:00+00:00	1
2023-11-18T00:00:00+00:00	1
2023-11-19T00:00:00+00:00	1
2023-11-20T00:00:00+00:00	1
2023-11-21T00:00:00+00:00	1
2023-11-22T00:00:00+00:00	1
2023-11-23T00:00:00+00:00	1
2023-11-24T00:00:00+00:00	1
2023-11-25T00:00:00+00:00	1
2023-11-26T00:00:00+00:00	1
2023-11-27T00:00:00+00:00	1
2023-11-28T00:00:00+00:00	1
2023-11-29T00:00:00+00:00	1
2023-11-30T00:00:00+00:00	1
2023-12-01T00:00:00+00:00	1
2023-12-02T00:00:00+00:00	1
2023-12-03T00:00:00+00:00	1
2023-12-04T00:00:00+00:00	1
2023-12-05T00:00:00+00:00	1
2023-12-06T00:00:00+00:00	1
2023-12-07T00:00:00+00:00	1
2023-12-08T00:00:00+00:00	1
2023-12-09T00:00:00+00:00	1
2023-12-10T00:00:00+00:00	1
2023-12-11T00:00:00+00:00	1
2023-12-12T00:00:00+00:00	1
2023-12-13T00:00:00+00:00	1
2023-12-14T00:00:00+00:00	1
2023-12-15T00:00:00+00:00	1
2023-12-16T00:00:00+00:00	1
2023-12-17T00:00:00+00:00	1
2023-12-18T00:00:00+00:00	1
2023-12-19T00:00:00+00:00	1
2023-12-20T00:00:00+00:00	1
2023-12-21T00:00:00+00:00	1
2023-12-22T00:00:00+00:00	1
2023-12-23T00:00:00+00:00	1
2023-12-24T00:00:00+00:00	1
2023-12-25T00:00:00+00:00	1
2023-12-26T00:00:00+00:00	1
2023-12-27T00:00:00+00:00	1
2023-12-28T00:00:00+00:00	1
2023-12-29T00:00:00+00:00	1
2023-12-30T00:00:00+00:00	1

Prometheus

START	END	STEP	QUERY
2022-12-31T23:00:00+00:00	2023-12-31T22:59:59+00:00	1d	1

TIMESTAMP	VALUE
2022-12-31T23:00:00+00:00	1
2023-01-01T23:00:00+00:00	1
2023-01-02T23:00:00+00:00	1
2023-01-03T23:00:00+00:00	1
2023-01-04T23:00:00+00:00	1
2023-01-05T23:00:00+00:00	1
2023-01-06T23:00:00+00:00	1
2023-01-07T23:00:00+00:00	1
2023-01-08T23:00:00+00:00	1
2023-01-09T23:00:00+00:00	1
2023-01-10T23:00:00+00:00	1
2023-01-11T23:00:00+00:00	1
2023-01-12T23:00:00+00:00	1
2023-01-13T23:00:00+00:00	1
2023-01-14T23:00:00+00:00	1
2023-01-15T23:00:00+00:00	1
2023-01-16T23:00:00+00:00	1
2023-01-17T23:00:00+00:00	1
2023-01-18T23:00:00+00:00	1
2023-01-19T23:00:00+00:00	1
2023-01-20T23:00:00+00:00	1
2023-01-21T23:00:00+00:00	1
2023-01-22T23:00:00+00:00	1
2023-01-23T23:00:00+00:00	1
2023-01-24T23:00:00+00:00	1
2023-01-25T23:00:00+00:00	1
2023-01-26T23:00:00+00:00	1
2023-01-27T23:00:00+00:00	1
2023-01-28T23:00:00+00:00	1
2023-01-29T23:00:00+00:00	1
2023-01-30T23:00:00+00:00	1
2023-01-31T23:00:00+00:00	1
2023-02-01T23:00:00+00:00	1
2023-02-02T23:00:00+00:00	1
2023-02-03T23:00:00+00:00	1
2023-02-04T23:00:00+00:00	1
2023-02-05T23:00:00+00:00	1
2023-02-06T23:00:00+00:00	1
2023-02-07T23:00:00+00:00	1
2023-02-08T23:00:00+00:00	1
2023-02-09T23:00:00+00:00	1
2023-02-10T23:00:00+00:00	1
2023-02-11T23:00:00+00:00	1
2023-02-12T23:00:00+00:00	1
2023-02-13T23:00:00+00:00	1
2023-02-14T23:00:00+00:00	1
2023-02-15T23:00:00+00:00	1
2023-02-16T23:00:00+00:00	1
2023-02-17T23:00:00+00:00	1
2023-02-18T23:00:00+00:00	1
2023-02-19T23:00:00+00:00	1
2023-02-20T23:00:00+00:00	1
2023-02-21T23:00:00+00:00	1
2023-02-22T23:00:00+00:00	1
2023-02-23T23:00:00+00:00	1
2023-02-24T23:00:00+00:00	1
2023-02-25T23:00:00+00:00	1
2023-02-26T23:00:00+00:00	1
2023-02-27T23:00:00+00:00	1
2023-02-28T23:00:00+00:00	1
2023-03-01T23:00:00+00:00	1
2023-03-02T23:00:00+00:00	1
2023-03-03T23:00:00+00:00	1
2023-03-04T23:00:00+00:00	1
2023-03-05T23:00:00+00:00	1
2023-03-06T23:00:00+00:00	1
2023-03-07T23:00:00+00:00	1
2023-03-08T23:00:00+00:00	1
2023-03-09T23:00:00+00:00	1
2023-03-10T23:00:00+00:00	1
2023-03-11T23:00:00+00:00	1
2023-03-12T23:00:00+00:00	1
2023-03-13T23:00:00+00:00	1
2023-03-14T23:00:00+00:00	1
2023-03-15T23:00:00+00:00	1
2023-03-16T23:00:00+00:00	1
2023-03-17T23:00:00+00:00	1
2023-03-18T23:00:00+00:00	1
2023-03-19T23:00:00+00:00	1
2023-03-20T23:00:00+00:00	1
2023-03-21T23:00:00+00:00	1
2023-03-22T23:00:00+00:00	1
2023-03-23T23:00:00+00:00	1
2023-03-24T23:00:00+00:00	1
2023-03-25T23:00:00+00:00	1
2023-03-26T23:00:00+00:00	1
2023-03-27T23:00:00+00:00	1
2023-03-28T23:00:00+00:00	1
2023-03-29T23:00:00+00:00	1
2023-03-30T23:00:00+00:00	1
2023-03-31T23:00:00+00:00	1
2023-04-01T23:00:00+00:00	1
2023-04-02T23:00:00+00:00	1
2023-04-03T23:00:00+00:00	1
2023-04-04T23:00:00+00:00	1
2023-04-05T23:00:00+00:00	1
2023-04-06T23:00:00+00:00	1
2023-04-07T23:00:00+00:00	1
2023-04-08T23:00:00+00:00	1
2023-04-09T23:00:00+00:00	1
2023-04-10T23:00:00+00:00	1
2023-04-11T23:00:00+00:00	1
2023-04-12T23:00:00+00:00	1
2023-04-13T23:00:00+00:00	1
2023-04-14T23:00:00+00:00	1
2023-04-15T23:00:00+00:00	1
2023-04-16T23:00:00+00:00	1
2023-04-17T23:00:00+00:00	1
2023-04-18T23:00:00+00:00	1
2023-04-19T23:00:00+00:00	1
2023-04-20T23:00:00+00:00	1
2023-04-21T23:00:00+00:00	1
2023-04-22T23:00:00+00:00	1
2023-04-23T23:00:00+00:00	1
2023-04-24T23:00:00+00:00	1
2023-04-25T23:00:00+00:00	1
2023-04-26T23:00:00+00:00	1
2023-04-27T23:00:00+00:00	1
2023-04-28T23:00:00+00:00	1
2023-04-29T23:00:00+00:00	1
2023-04-30T23:00:00+00:00	1
2023-05-01T23:00:00+00:00	1
2023-05-02T23:00:00+00:00	1
2023-05-03T23:00:00+00:00	1
2023-05-04T23:00:00+00:00	1
2023-05-05T23:00:00+00:00	1
2023-05-06T23:00:00+00:00	1
2023-05-07T23:00:00+00:00	1
2023-05-08T23:00:00+00:00	1
2023-05-09T23:00:00+00:00	1
2023-05-10T23:00:00+00:00	1
2023-05-11T23:00:00+00:00	1
2023-05-12T23:00:00+00:00	1
2023-05-13T23:00:00+00:00	1
2023-05-14T23:00:00+00:00	1
2023-05-15T23:00:00+00:00	1
2023-05-16T23:00:00+00:00	1
2023-05-17T23:00:00+00:00	1
2023-05-18T23:00:00+00:00	1
2023-05-19T23:00:00+00:00	1
2023-05-20T23:00:00+00:00	1
2023-05-21T23:00:00+00:00	1
2023-05-22T23:00:00+00:00	1
2023-05-23T23:00:00+00:00	1
2023-05-24T23:00:00+00:00	1
2023-05-25T23:00:00+00:00	1
2023-05-26T23:00:00+00:00	1
2023-05-27T23:00:00+00:00	1
2023-05-28T23:00:00+00:00	1
2023-05-29T23:00:00+00:00	1
2023-05-30T23:00:00+00:00	1
2023-05-31T23:00:00+00:00	1
2023-06-01T23:00:00+00:00	1
2023-06-02T23:00:00+00:00	1
2023-06-03T23:00:00+00:00	1
2023-06-04T23:00:00+00:00	1
2023-06-05T23:00:00+00:00	1
2023-06-06T23:00:00+00:00	1
2023-06-07T23:00:00+00:00	1
2023-06-08T23:00:00+00:00	1
2023-06-09T23:00:00+00:00	1
2023-06-10T23:00:00+00:00	1
2023-06-11T23:00:00+00:00	1
2023-06-12T23:00:00+00:00	1
2023-06-13T23:00:00+00:00	1
2023-06-14T23:00:00+00:00	1
2023-06-15T23:00:00+00:00	1
2023-06-16T23:00:00+00:00	1
2023-06-17T23:00:00+00:00	1
2023-06-18T23:00:00+00:00	1
2023-06-19T23:00:00+00:00	1
2023-06-20T23:00:00+00:00	1
2023-06-21T23:00:00+00:00	1
2023-06-22T23:00:00+00:00	1
2023-06-23T23:00:00+00:00	1
2023-06-24T23:00:00+00:00	1
2023-06-25T23:00:00+00:00	1
2023-06-26T23:00:00+00:00	1
2023-06-27T23:00:00+00:00	1
2023-06-28T23:00:00+00:00	1
2023-06-29T23:00:00+00:00	1
2023-06-30T23:00:00+00:00	1
2023-07-01T23:00:00+00:00	1
2023-07-02T23:00:00+00:00	1
2023-07-03T23:00:00+00:00	1
2023-07-04T23:00:00+00:00	1
2023-07-05T23:00:00+00:00	1
2023-07-06T23:00:00+00:00	1
2023-07-07T23:00:00+00:00	1
2023-07-08T23:00:00+00:00	1
2023-07-09T23:00:00+00:00	1
2023-07-10T23:00:00+00:00	1
2023-07-11T23:00:00+00:00	1
2023-07-12T23:00:00+00:00	1
2023-07-13T23:00:00+00:00	1
2023-07-14T23:00:00+00:00	1
2023-07-15T23:00:00+00:00	1
2023-07-16T23:00:00+00:00	1
2023-07-17T23:00:00+00:00	1
2023-07-18T23:00:00+00:00	1
2023-07-19T23:00:00+00:00	1
2023-07-20T23:00:00+00:00	1
2023-07-21T23:00:00+00:00	1
2023-07-22T23:00:00+00:00	1
2023-07-23T23:00:00+00:00	1
2023-07-24T23:00:00+00:00	1
2023-07-25T23:00:00+00:00	1
2023-07-26T23:00:00+00:00	1
2023-07-27T23:00:00+00:00	1
2023-07-28T23:00:00+00:00	1
2023-07-29T23:00:00+00:00	1
2023-07-30T23:00:00+00:00	1
2023-07-31T23:00:00+00:00	1
2023-08-01T23:00:00+00:00	1
2023-08-02T23:00:00+00:00	1
2023-08-03T23:00:00+00:00	1
2023-08-04T23:00:00+00:00	1
2023-08-05T23:00:00+00:00	1
2023-08-06T23:00:00+00:00	1
2023-08-07T23:00:00+00:00	1
2023-08-08T23:00:00+00:00	1
2023-08-09T23:00:00+00:00	1
2023-08-10T23:00:00+00:00	1
2023-08-11T23:00:00+00:00	1
2023-08-12T23:00:00+00:00	1
2023-08-13T23:00:00+00:00	1
2023-08-14T23:00:00+00:00	1
2023-08-15T23:00:00+00:00	1
2023-08-16T23:00:00+00:00	1
2023-08-17T23:00:00+00:00	1
2023-08-18T23:00:00+00:00	1
2023-08-19T23:00:00+00:00	1
2023-08-20T23:00:00+00:00	1
2023-08-21T23:00:00+00:00	1
2023-08-22T23:00:00+00:00	1
2023-08-23T23:00:00+00:00	1
2023-08-24T23:00:00+00:00	1
2023-08-25T23:00:00+00:00	1
2023-08-26T23:00:00+00:00	1
2023-08-27T23:00:00+00:00	1
2023-08-28T23:00:00+00:00	1
2023-08-29T23:00:00+00:00	1
2023-08-30T23:00:00+00:00	1
2023-08-31T23:00:00+00:00	1
2023-09-01T23:00:00+00:00	1
2023-09-02T23:00:00+00:00	1
2023-09-03T23:00:00+00:00	1
2023-09-04T23:00:00+00:00	1
2023-09-05T23:00:00+00:00	1
2023-09-06T23:00:00+00:00	1
2023-09-07T23:00:00+00:00	1
2023-09-08T23:00:00+00:00	1
2023-09-09T23:00:00+00:00	1
2023-09-10T23:00:00+00:00	1
2023-09-11T23:00:00+00:00	1
2023-09-12T23:00:00+00:00	1
2023-09-13T23:00:00+00:00	1
2023-09-14T23:00:00+00:00	1
2023-09-15T23:00:00+00:00	1
2023-09-16T23:00:00+00:00	1
2023-09-17T23:00:00+00:00	1
2023-09-18T23:00:00+00:00	1
2023-09-19T23:00:00+00:00	1
2023-09-20T23:00:00+00:00	1
2023-09-21T23:00:00+00:00	1
2023-09-22T23:00:00+00:00	1
2023-09-23T23:00:00+00:00	1
2023-09-24T23:00:00+00:00	1
2023-09-25T23:00:00+00:00	1
2023-09-26T23:00:00+00:00	1
2023-09-27T23:00:00+00:00	1
2023-09-28T23:00:00+00:00	1
2023-09-29T23:00:00+00:00	1
2023-09-30T23:00:00+00:00	1
2023-10-01T23:00:00+00:00	1
2023-10-02T23:00:00+00:00	1
2023-10-03T23:00:00+00:00	1
2023-10-04T23:00:00+00:00	1
2023-10-05T23:00:00+00:00	1
2023-10-06T23:00:00+00:00	1
2023-10-07T23:00:00+00:00	1
2023-10-08T23:00:00+00:00	1
2023-10-09T23:00:00+00:00	1
2023-10-10T23:00:00+00:00	1
2023-10-11T23:00:00+00:00	1
2023-10-12T23:00:00+00:00	1
2023-10-13T23:00:00+00:00	1
2023-10-14T23:00:00+00:00	1
2023-10-15T23:00:00+00:00	1
2023-10-16T23:00:00+00:00	1
2023-10-17T23:00:00+00:00	1
2023-10-18T23:00:00+00:00	1
2023-10-19T23:00:00+00:00	1
2023-10-20T23:00:00+00:00	1
2023-10-21T23:00:00+00:00	1
2023-10-22T23:00:00+00:00	1
2023-10-23T23:00:00+00:00	1
2023-10-24T23:00:00+00:00	1
2023-10-25T23:00:00+00:00	1
2023-10-26T23:00:00+00:00	1
2023-10-27T23:00:00+00:00	1
2023-10-28T23:00:00+00:00	1
2023-10-29T23:00:00+00:00	1
2023-10-30T23:00:00+00:00	1
2023-10-31T23:00:00+00:00	1
2023-11-01T23:00:00+00:00	1
2023-11-02T23:00:00+00:00	1
2023-11-03T23:00:00+00:00	1
2023-11-04T23:00:00+00:00	1
2023-11-05T23:00:00+00:00	1
2023-11-06T23:00:00+00:00	1
2023-11-07T23:00:00+00:00	1
2023-11-08T23:00:00+00:00	1
2023-11-09T23:00:00+00:00	1
2023-11-10T23:00:00+00:00	1
2023-11-11T23:00:00+00:00	1
2023-11-12T23:00:00+00:00	1
2023-11-13T23:00:00+00:00	1
2023-11-14T23:00:00+00:00	1
2023-11-15T23:00:00+00:00	1
2023-11-16T23:00:00+00:00	1
2023-11-17T23:00:00+00:00	1
2023-11-18T23:00:00+00:00	1
2023-11-19T23:00:00+00:00	1
2023-11-20T23:00:00+00:00	1
2023-11-21T23:00:00+00:00	1
2023-11-22T23:00:00+00:00	1
2023-11-23T23:00:00+00:00	1
2023-11-24T23:00:00+00:00	1
2023-11-25T23:00:00+00:00	1
2023-11-26T23:00:00+00:00	1
2023-11-27T23:00:00+00:00	1
2023-11-28T23:00:00+00:00	1
2023-11-29T23:00:00+00:00	1
2023-11-30T23:00:00+00:00	1
2023-12-01T23:00:00+00:00	1
2023-12-02T23:00:00+00:00	1
2023-12-03T23:00:00+00:00	1
2023-12-04T23:00:00+00:00	1
2023-12-05T23:00:00+00:00	1
2023-12-06T23:00:00+00:00	1
2023-12-07T23:00:00+00:00	1
2023-12-08T23:00:00+00:00	1
2023-12-09T23:00:00+00:00	1
2023-12-10T23:00:00+00:00	1
2023-12-11T23:00:00+00:00	1
2023-12-12T23:00:00+00:00	1
2023-12-13T23:00:00+00:00	1
2023-12-14T23:00:00+00:00	1
2023-12-15T23:00:00+00:00	1
2023-12-16T23:00:00+00:00	1
2023-12-17T23:00:00+00:00	1
2023-12-18T23:00:00+00:00	1
2023-12-19T23:00:00+00:00	1
2023-12-20T23:00:00+00:00	1
2023-12-21T23:00:00+00:00	1
2023-12-22T23:00:00+00:00	1
2023-12-23T23:00:00+00:00	1
2023-12-24T23:00:00+00:00	1
2023-12-25T23:00:00+00:00	1
2023-12-26T23:00:00+00:00	1
2023-12-27T23:00:00+00:00	1
2023-12-28T23:00:00+00:00	1
2023-12-29T23:00:00+00:00	1
2023-12-30T23:00:00+00:00	1

flashmouse · 2023-11-30T06:07:08Z

@melck try set search.disableCache=true in vmselect, maybe it's the same reason mentioned in #563

melck · 2023-11-30T08:31:56Z

Thanks @flashmouse its better with search cache disabled.

melck added the question The question issue label Nov 26, 2023

hagen1778 self-assigned this Nov 28, 2023

hagen1778 changed the title ~~Range on year~~ range query: timestamps are inconsistent on year range Nov 28, 2023

hagen1778 added the metricsql label Nov 28, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

range query: timestamps are inconsistent on year range #5392

range query: timestamps are inconsistent on year range #5392

melck commented Nov 26, 2023 •

edited

hagen1778 commented Nov 28, 2023

melck commented Nov 28, 2023

melck commented Nov 28, 2023 •

edited

flashmouse commented Nov 30, 2023

melck commented Nov 30, 2023

range query: timestamps are inconsistent on year range #5392

range query: timestamps are inconsistent on year range #5392

Comments

melck commented Nov 26, 2023 • edited

Is your question request related to a specific component?

Describe the question in detail

Troubleshooting docs

hagen1778 commented Nov 28, 2023

melck commented Nov 28, 2023

melck commented Nov 28, 2023 • edited

flashmouse commented Nov 30, 2023

melck commented Nov 30, 2023

melck commented Nov 26, 2023 •

edited

melck commented Nov 28, 2023 •

edited