ttfx_prs

Data source: JuliaCI/julia-ci-timing

pr_head_sha

the pull request's head now; differs from head_commit when it has moved on since the job

head_ref

the pull request's branch, empty when it is in a fork

base_ref

the branch it targets; not master when it is stacked on another pull request, which the job then measured it against

verdict

improvement, regression or same

n_improvements

robust improvements, per task and metric plus suite metrics

n_regressions

robust regressions, counted the same way

suite

JSON: per metric, the geometric mean over tasks of head/base per block, the verdict and the task count

tasks

JSON: the tasks with a robust improvement or regression, their ratios and notes

ci_commit

the pull request head the CI columns were looked up for

ci_build

the newest julia-pr build of ci_commit, NULL when it has none

ci_state

that build's Buildkite state (passed, failed, failing, running, ...), or none when the commit has no build

ci_url

that build on Buildkite

94 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author, draft, job_state, n_tasks, verdict, n_improvements, n_regressions, tasks, ci_state, base_ref, build_created_at (date), finished_at (date)

CREATE TABLE ttfx_prs (
    pr_number        INTEGER PRIMARY KEY,
    title            TEXT NOT NULL DEFAULT '',
    author           TEXT NOT NULL DEFAULT '',
    draft            INTEGER NOT NULL DEFAULT 0,
    pr_head_sha      TEXT NOT NULL DEFAULT '',   
    build            INTEGER NOT NULL,           
    job_uuid         TEXT NOT NULL,
    job_state        TEXT NOT NULL,
    build_created_at TEXT NOT NULL,
    finished_at      TEXT,
    web_url          TEXT,
    head_commit      TEXT NOT NULL DEFAULT '',
    head_version     TEXT NOT NULL DEFAULT '',
    base_commit      TEXT NOT NULL DEFAULT '',
    base_version     TEXT NOT NULL DEFAULT '',
    blocks           INTEGER,
    n_tasks          INTEGER,
    verdict          TEXT NOT NULL,              
    n_improvements   INTEGER NOT NULL,
    n_regressions    INTEGER NOT NULL,
    suite            TEXT NOT NULL,              
    tasks            TEXT NOT NULL,              
    change_seq       INTEGER NOT NULL
, ci_commit TEXT, ci_build INTEGER, ci_state TEXT, ci_url TEXT, head_ref TEXT NOT NULL DEFAULT '', base_ref TEXT NOT NULL DEFAULT '');