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 |