I am searching for the examples whether next time series is possible to be implemented in grafana:
another workers example I have found:
I have dynamic list of workers (proceses) that can be started multiple times and each execution is logged as start-end interval and should be connected and displayed.
Processes are dynamic and stored in the database as well:
CREATE TABLE log_table (
id SERIAL PRIMARY KEY,
process TEXT NOT NULL,
execution TEXT NOT NULL,
start_time TIMESTAMP NOT NULL,
end_time TIMESTAMP NOT NULL
);
So far I have only found examples where y is harcoded as select in the SQL statement, but for me it can vary.
In addition, I would need to display idle times in red.
I would appreciate any links or examples.
I don’t think you can pass run number into your graph (what I presume in execution column); and read as process not run will be everywhere. But implementation of this is possible.
You need to generate list of equidistant timestamps (with step 1 minute, for example) between
$__from
and$__to
(search for your DBMS, it might be something like recursive CTE orconnect by
), and then for each process return if it was run on each step or not.