Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('read_metrics_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each read event; auto-incremented.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.267495094+00:00”} |
|
| url | text | 2147483647 | null |
|
|
{“what”:“The URL that was read; the resource identifier.”,“why”:“Without it, cannot attribute metrics to specific content or group by URL.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.281206541+00:00”} |
||
| status | text | 2147483647 | null |
|
|
{“what”:“Outcome of the read, e.g., ‘success’ or ‘error’.”,“why”:“Without it, failed reads are indistinguishable from successful ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.304971158+00:00”} |
||
| rendered_tokens | int4 | 10 | null |
|
|
{“what”:“Number of tokens in the rendered output.”,“why”:“Without it, cannot measure rendering efficiency or compare to raw.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.323181756+00:00”} |
||
| raw_tokens | int4 | 10 | null |
|
|
{“what”:“Number of tokens in the raw source content.”,“why”:“Without it, cannot compute token savings or compression ratio.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.347830382+00:00”} |
||
| tokens_saved | int4 | 10 | null |
|
|
{“what”:“Difference between raw and rendered token counts (raw - rendered).”,“why”:“Without it, the savings from rendering is not directly available for aggregation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.359531950+00:00”} |
||
| cache_hit | bool | 1 | false |
|
|
{“what”:“True if the read was served from cache, false otherwise.”,“why”:“Without it, cache hit rate and its effect on token savings cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.375744555+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of when the read event occurred, in UTC.”,“why”:“Without it, cannot analyze metrics over time or detect trends.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.394831890+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| read_metrics_pkey | Primary key | Asc | id |