Time Series Sub-tab

The Time Series sub-tab of the Database panel is the UI for ArcadeDB’s native time-series types: create and drop types, query them with a builder or PromQL, see the result as a chart and a raw table, and find ready-made ingestion snippets for InfluxDB Line Protocol, SQL, Java and Grafana.

See Time Series for the underlying concepts.

Under the sub-tab bar, a toolbar shows the Type Selector, which lists every TimeSeries type in the selected database along with its record count. Two buttons sit next to it:

Create TimeSeries Type — open a modal to define a new type (timestamp column, tags, fields, sharding, retention, downsampling).
Drop Type — irreversibly delete the selected type.

The sub-tab has three inner tabs: Query, Schema and Quick Tour.

To chart a time series from the Query panel instead, pick the PromQL (Time Series) language there, or run a SQL query against the type and open the Chart tab (see Chart).

Query

The default sub-tab. It has two modes, toggled at the top:

Builder mode offers structured controls — no need to write a query by hand:

Time Range — Last 5 min, 1h, 24h, 7d, All, or Custom (which exposes From and To datetime inputs).
Aggregation — None, AVG, SUM, MIN, MAX, COUNT.
Bucket Interval — 1s, 10s, 1m, 5m, 1h, 1d.
Tag Filters — one input per indexed tag of the selected type.
Fields — checkboxes to pick which numeric measures to plot.
Query — run with the current filters.
Latest — fetch the most recent point per series.
Auto-Refresh — Off, 10s, 30s, 1m.

PromQL mode exposes a textarea where you can type a PromQL expression and execute it with the Run button or Ctrl+Enter / Cmd+Enter.

Below the controls the panel shows the Query Stats label (record count + elapsed ms), the Chart and the Data Table. Each of the two visualisations can be toggled on or off independently.

The Chart is an ApexCharts line/area chart; toggle the style from the chart toolbar. The Data Table is a paginated grid of the raw (or aggregated) values returned by the query.

Schema

Shows the schema of the selected type: timestamp column, indexed tag dimensions, numeric fields, shard count, retention policy and downsampling policies.

Quick Tour

Inline documentation cards with copy-ready snippets for common tasks:

Creating a TimeSeries type in SQL.
Ingesting data via InfluxDB Line Protocol (curl example).
Inserting points with SQL INSERT.
Using the Java API to write points.
Analytical SQL functions (ts.rate(), ts.percentile(), etc.).
Configuring downsampling and retention.

A second section covers the Grafana integration: how to point the Infinity datasource at ArcadeDB, the available HTTP endpoints (/health, /metadata, /query), metadata discovery, the DataFrame format and a curl example.