collection_runs


Description

{“what”:“A single execution of a data collection job, with timing and outcome counts.”,“why”:“Without it, there is no record of when each collector ran and what it changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:41.234224977+00:00”}

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

Relationships