pool_jobs

Data source: JuliaCI/julia-ci-timing

build

the build number within the pipeline

queue

the queue of the job's agent query rules; with os and arch this is the pool

runnable_at

when every dependency had finished and the job could take an agent

started_at

when an agent started it; NULL while queued, or when canceled before starting

finished_at

when it finished or was canceled; NULL while queued or running

128,776 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: runnable_at (date), started_at (date), finished_at (date)

Next page

CREATE TABLE pool_jobs (
    job_uuid    TEXT PRIMARY KEY,
    pipeline    TEXT NOT NULL,
    build       INTEGER NOT NULL,
    name        TEXT NOT NULL,
    queue       TEXT NOT NULL DEFAULT '',
    os          TEXT NOT NULL DEFAULT '',
    arch        TEXT NOT NULL DEFAULT '',
    state       TEXT NOT NULL,
    runnable_at TEXT NOT NULL,
    started_at  TEXT,
    finished_at TEXT,
    change_seq  INTEGER NOT NULL
);
CREATE INDEX pool_jobs_runnable ON pool_jobs (runnable_at);