Skip to content
ClickHouse Docs
49.6kGet Started

timeSeriesSelector

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

Reads time series from a TimeSeries table filtered by a selector and with timestamps in a specified interval. This function is similar to range selectors but it’s used to implement instant selectors too.

Syntax

timeSeriesSelector('db_name', 'time_series_table', 'instant_query', min_time, max_time)
timeSeriesSelector(db_name.time_series_table, 'instant_query', min_time, max_time)
timeSeriesSelector('time_series_table', 'instant_query', min_time, max_time)

Arguments

  • db_name - The name of the database where a TimeSeries table is located.
  • time_series_table - The name of a TimeSeries table.
  • instant_query - An instant selector written in PromQL syntax, without @ or offset modifiers.
  • min_time - Start timestamp, inclusive.
  • max_time - End timestamp, inclusive.

min_time and max_time can have fractions of a second even if the timestamps in the table are whole seconds: the function selects the samples with min_time <= timestamp <= max_time exactly, without rounding the bounds to the type of the timestamps.

Returned value

The function returns three columns:

  • id - Contains the identifiers of time series matching the specified selector.
  • timestamp - Contains timestamps.
  • value - Contains values.

There is no specific order for returned data.

Example

SELECT * FROM timeSeriesSelector(mytable, 'http_requests{job="prometheus"}', now() - INTERVAL 10 MINUTES, now())
Navigation