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 |
|
|
{“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 |