execution_log


Description

{“what”:“Log of each execution attempt for an assessment, with phase and outcome.”,“why”:“Without it, there is no audit trail to debug failures or measure performance across runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:43.263920782+00:00”}

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

Relationships