task_run


Description

{“what”:“One execution of a background task, tied to an entity via entity_type/entity_id.”,“why”:“Without it, there is no audit trail of task runs, so failures and retries cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.523925670+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
task_history.run_id fk_task_history_run_id N

{“what”:“Surrogate key; unique integer per run.”,“why”:“Without it, runs cannot be referenced individually, breaking updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.550424578+00:00”}

run_type varchar 32 null

{“what”:“Categorizes the task kind; values are application-defined.”,“why”:“Without it, you cannot filter runs by task kind, so per-type monitoring and retries fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.622817507+00:00”}

entity_type varchar 32 null

{“what”:“Type of entity the run operates on; values are application-defined.”,“why”:“Without it, entity_id is meaningless, so you cannot link a run to its subject.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.849629902+00:00”}

entity_id int4 10 null

{“what”:“Integer ID of the entity this run targets, paired with entity_type.”,“why”:“Without it, you cannot identify which specific entity the run processed, breaking per-entity history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:28.968932005+00:00”}

started_at timestamptz 35,6 now()

{“what”:“Timestamp when the run started; timezone-aware.”,“why”:“Without it, run duration and ordering are unknown, so performance analysis fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:29.027171075+00:00”}

ended_at timestamptz 35,6 √ null

{“what”:“Timestamp when the run finished; null if still running or failed to end.”,“why”:“Without it, you cannot compute duration or detect stuck runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:29.049536397+00:00”}

status varchar 21 null

{“what”:“State of the run; values are application-defined.”,“why”:“Without it, you cannot know if a run succeeded or failed, so error handling and retries are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:29.073970175+00:00”}

process_uuid varchar 36 'unknown'::character varying

{“what”:“UUID of the process that executed the run; ‘unknown’ if not set.”,“why”:“Without it, you cannot correlate a run with a specific process instance, making distributed debugging hard.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:29.091323092+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to this run’s row.”,“why”:“Without it, you cannot detect stale or recently modified runs, so monitoring and cleanup fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:29.107102037+00:00”}

Indexes

Constraint Name Type Sort Column(s)
task_run_pkey Primary key Asc id
idx_task_run_started_at Performance Desc started_at
idx_task_run_type_entity Performance Asc/Asc/Asc run_type + entity_type + entity_id

Relationships