207.3.4 PROMQL_SERIES Function

This function enables users to fetch time series metadata (metric name and tags).

The PROMQL_SERIES function returns a CLOB for time series metadata.

Syntax

promql_series(
       promql_query     IN VARCHAR2,
       start_time_epoch IN NUMBER,
       end_time_epoch   IN NUMBER,
       fetch_sql        IN NUMBER DEFAULT 0) 
return clob;

Parameters

Table 207-5 PROMQL_SERIES Function Parameters

Parameter Description
promql_query

The PromQL query from the user

start_time_epoch

The start time of the query

end_time_epoch

The end time of the query

fetch_sql

Result desired by the client (set it to 1 if you want SQL, 2 for JSON)