Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Unique identifier for the log row; generated by gen_random_uuid().”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.281575494+00:00”} |
||
| assessment_id | uuid | 2147483647 | √ | null |
|
|
{“what”:“Identifier of the assessment being executed; null when not assessment-scoped.”,“why”:“Without it, executions cannot be linked to a specific assessment for per-assessment analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.300181380+00:00”} |
|
| domain | text | 2147483647 | null |
|
|
{“what”:“Text label for the domain or subject area of the execution.”,“why”:“Without it, executions from different domains are indistinguishable, breaking domain-specific filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.328587771+00:00”} |
||
| phase | text | 2147483647 | null |
|
|
{“what”:“Name of the execution phase, such as ‘start’ or ‘complete’.”,“why”:“Without it, you cannot tell which step failed or how long each phase took.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.358561646+00:00”} |
||
| success | bool | 1 | true |
|
|
{“what”:“Whether the execution phase completed without error; true by default.”,“why”:“Without it, failed executions would be indistinguishable from successful ones, hiding errors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.373233907+00:00”} |
||
| duration_ms | int4 | 10 | 0 |
|
|
{“what”:“Elapsed time of the phase in milliseconds; 0 if not measured.”,“why”:“Without it, performance regressions cannot be detected or compared across runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.396026115+00:00”} |
||
| outcome | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON payload with phase-specific result details; null if none.”,“why”:“Without it, the detailed result of the execution is lost, making debugging or post-processing impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.410125381+00:00”} |
|
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message or stack trace if the phase failed; null on success.”,“why”:“Without it, the cause of a failure is unknown, preventing root-cause analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.438572248+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when the log entry was created; set to current time by default.”,“why”:“Without it, the order and timing of executions cannot be reconstructed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.453661479+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| execution_log_pkey | Primary key | Asc | id |
| idx_execution_log_assessment | Performance | Asc | assessment_id |
| idx_execution_log_domain | Performance | Asc | domain |