read_metrics


Description

{“what”:“One row per read event, with token usage and cache status.”,“why”:“Without it, no record of read performance or cache effectiveness exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:00.251615060+00:00”}

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

Relationships