Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('collection_runs_id_seq'::regclass) |
|
|
{“what”:“Unique integer identifier for this run, from sequence.”,“why”:“Needed to reference a specific run in logs or audits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.375638501+00:00”} |
|
| collector_name | text | 2147483647 | null |
|
|
{“what”:“Name of the collector job that executed, e.g. ‘catalog’.”,“why”:“Without it, runs from different collectors are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.463406766+00:00”} |
||
| started_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the run started, in UTC with timezone.”,“why”:“Without it, cannot measure run duration or order runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.478863825+00:00”} |
||
| finished_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the run finished, null if still running or crashed.”,“why”:“Without it, cannot know if a run completed or how long it took.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.522181111+00:00”} |
|
| offerings_found | int4 | 10 | √ | 0 |
|
|
{“what”:“Count of offerings discovered during the run.”,“why”:“Without it, no record of how many items were seen.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.560829398+00:00”} |
|
| offerings_updated | int4 | 10 | √ | 0 |
|
|
{“what”:“Count of existing offerings whose data was changed.”,“why”:“Without it, cannot measure how much the run modified the catalog.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.615183954+00:00”} |
|
| prices_recorded | int4 | 10 | √ | 0 |
|
|
{“what”:“Count of price entries written during the run.”,“why”:“Without it, no record of price capture volume.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.628744610+00:00”} |
|
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message if the run failed, null on success.”,“why”:“Without it, failures are silent and cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.650114493+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| collection_runs_pkey | Primary key | Asc | id |