cert_run_log


Description

{“what”:“Log of certificate operation runs, one row per attempt.”,“why”:“Without it, no history of certificate checks or failures for auditing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:25.791320984+00:00”}

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

Relationships