Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('cert_run_log_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each log entry.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.809808931+00:00”} |
|
| host | text | 2147483647 | null |
|
|
{“what”:“Hostname or IP address of the machine where the run occurred.”,“why”:“Without it, cannot attribute failures or latency to a specific machine.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.830714902+00:00”} |
||
| tier | int2 | 5 | √ | null |
|
|
{“what”:“Numeric environment tier (e.g., dev/staging/prod) if applicable.”,“why”:“Without it, cannot filter or group runs by environment to compare behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.848837141+00:00”} |
|
| source | text | 2147483647 | √ | null |
|
|
{“what”:“Origin of the run, such as a script name or trigger.”,“why”:“Without it, cannot distinguish which process initiated the run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.863167249+00:00”} |
|
| latency_ms | int4 | 10 | √ | null |
|
|
{“what”:“Duration of the run in milliseconds.”,“why”:“Without it, performance regressions or slow runs are undetectable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.875413493+00:00”} |
|
| ok | bool | 1 | √ | null |
|
|
{“what”:“Success indicator: true if run succeeded, false if failed, null if unknown.”,“why”:“Without it, cannot track success rate or identify failed runs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.887843080+00:00”} |
|
| ran_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp (with time zone) of when the run was recorded.”,“why”:“Without it, cannot order events or correlate with other logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.921832074+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cert_run_log_pkey | Primary key | Asc | id |
| idx_certrun_host | Performance | Asc | host |
| idx_certrun_source | Performance | Asc | source |