scrape_bench_steps


Description

{“what”:“One step in a scraping benchmark run, identified by run_id and measured_at.”,“why”:“Without it, per-step performance and status history would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.649161178+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('scrape_bench_steps_id_seq'::regclass)

{“what”:“Surrogate key for the step record.”,“why”:“Without it, steps cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.676905530+00:00”}

run_id uuid 2147483647 null
scrape_bench_runs.run_id scrape_bench_steps_run_id_fkey C

{“what”:“UUID of the benchmark run this step belongs to.”,“why”:“Groups steps into a single run; without it, steps from different runs are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.692426503+00:00”}

pool_size int4 10 null

{“what”:“Number of concurrent workers used for this step.”,“why”:“Allows comparing performance across different concurrency settings.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.722661819+00:00”}

mode text 2147483647 null

{“what”:“Scraping mode or strategy used, e.g., ‘sequential’ or ‘parallel’.”,“why”:“Distinguishes behavior variants; without it, results from different modes are mixed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.761357009+00:00”}

step_status text 2147483647 null

{“what”:“Outcome of the step, e.g., ‘success’, ‘failed’, ‘timeout’.”,“why”:“Enables filtering and success-rate analysis; without it, failed steps are invisible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.791971711+00:00”}

metrics jsonb 2147483647 null

{“what”:“Arbitrary performance metrics as JSON, e.g., duration, memory usage.”,“why”:“Captures flexible measurements without schema changes; without it, detailed performance data is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.818510641+00:00”}

measured_at timestamptz 35,6 null

{“what”:“Timestamp when the step was measured, with timezone.”,“why”:“Provides chronological ordering and time-based analysis; without it, step timing is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:04.841260616+00:00”}

Indexes

Constraint Name Type Sort Column(s)
scrape_bench_steps_pkey Primary key Asc id
idx_scrape_bench_steps_run Performance Asc run_id

Relationships