207.3.3 PROMQL_INSTANT Function

This function is for queries that request time series for a particular time-stamp.

The PROMQL_INSTANT function returns a CLOB of time series for a particular time-stamp.

Syntax

promql_instant(
       promql_query       IN VARCHAR2,
       instant_time_epoch IN NUMBER,
       fetch_sql          IN NUMBER DEFAULT 0) 
return clob;

Parameters

Table 207-4 PROMQL_INSTANT Function Parameters

Parameter Description
promql_query

The PromQL query from the user

instant_time_epoch

The time-stamp at which the time series data is requested

fetch_sql

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