scrape_bench_runs


Description

{“what”:“One row per benchmark run of the scraping pipeline, capturing environment, versions, and outcome.”,“why”:“Without it, there is no way to correlate timing, config, and results across runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.543586423+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
run_id uuid 2147483647 null
scrape_bench_steps.run_id scrape_bench_steps_run_id_fkey C

{“what”:“UUID assigned at creation; unique key for the run.”,“why”:“Without it, runs cannot be referenced or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.563291390+00:00”}

device text 2147483647 null

{“what”:“Device or environment name where the run executed, e.g., ‘pixel5’.”,“why”:“Without it, performance differences across hardware cannot be attributed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.592809409+00:00”}

started_at timestamptz 35,6 null

{“what”:“Timestamp when the run began, timezone-aware.”,“why”:“Without it, run duration and ordering are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.612009577+00:00”}

ended_at timestamptz 35,6 √ null

{“what”:“Timestamp when the run finished; null if still running or aborted.”,“why”:“Without it, duration and completion status cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.627105407+00:00”}

git_sha_scraper text 2147483647 √ null

{“what”:“Commit SHA of the scraper code used for this run.”,“why”:“Without it, results cannot be traced to a specific code version.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.644056781+00:00”}

git_sha_screen text 2147483647 √ null

{“what”:“Commit SHA of the screen-capture code used.”,“why”:“Without it, screen-related changes cannot be isolated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.666653646+00:00”}

git_sha_parse text 2147483647 √ null

{“what”:“Commit SHA of the parsing code used.”,“why”:“Without it, parse-version effects on results are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.690113901+00:00”}

config jsonb 2147483647 null

{“what”:“JSON object with run parameters such as URLs, selectors, and limits.”,“why”:“Without it, runs are not reproducible or comparable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.712386455+00:00”}

optima jsonb 2147483647 √ null

{“what”:“JSON object with optimization outcomes, e.g., best values found.”,“why”:“Without it, the benchmark’s result is missing and cannot be analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.729239872+00:00”}

status text 2147483647 null

{“what”:“Run state: ‘running’, ‘completed’, ‘failed’, or similar.”,“why”:“Without it, incomplete or failed runs would be indistinguishable from successful ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.743527405+00:00”}

Indexes

Constraint Name Type Sort Column(s)
scrape_bench_runs_pkey Primary key Asc run_id

Relationships