metrics_snapshots


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('metrics_snapshots_id_seq'::regclass)

{“what”:“Unique numeric identifier for each snapshot row.”,“why”:“Enables referencing and updating individual snapshots.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.846513559+00:00”}

timestamp text 2147483647 null

{“what”:“Snapshot time as text, likely ISO 8601 format.”,“why”:“Orders snapshots chronologically and correlates with other events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.878297415+00:00”}

pending int8 19 null

{“what”:“Number of jobs waiting to be processed at snapshot time.”,“why”:“Tracks backlog size to detect queue buildup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.911951336+00:00”}

running int8 19 null

{“what”:“Number of jobs currently executing at snapshot time.”,“why”:“Shows active workload and concurrency level.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:35.952817521+00:00”}

retry_wait int8 19 null

{“what”:“Number of jobs in retry wait state at snapshot time.”,“why”:“Indicates jobs delayed due to failures, helps assess error rates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:36.000195319+00:00”}

completed int8 19 null

{“what”:“Number of jobs finished successfully by snapshot time.”,“why”:“Measures throughput and overall progress.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:36.023895637+00:00”}

dead int8 19 null

{“what”:“Number of jobs that failed permanently at snapshot time.”,“why”:“Reveals failure rate and need for intervention.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:36.045668996+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metrics_snapshots_pkey Primary key Asc id
idx_metrics_ts Performance Asc timestamp

Relationships