Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |