semantic_search_token_tracking


Description

{“what”:“Log of token consumption per semantic search request.”,“why”:“Without it, token usage and cost attribution for semantic search are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:49.995978185+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique numeric identifier for each tracking record.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:50.025414041+00:00”}

model_name varchar 256 null

{“what”:“Name of the embedding model used for the request, e.g. ‘text-embedding-3-small’.”,“why”:“Without it, token usage cannot be attributed to a specific model for cost analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:50.202689609+00:00”}

request_type varchar 32 √ null

{“what”:“Type of semantic search request, e.g. ‘query’ or ‘document’.”,“why”:“Without it, usage breakdown by request kind is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:50.258470167+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp when the token usage was recorded.”,“why”:“Without it, time-based trends and billing periods cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:50.297572649+00:00”}

total_tokens int4 10 null

{“what”:“Number of tokens consumed by the request, as reported by the model API.”,“why”:“Without it, total token consumption and associated costs are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:50.360188743+00:00”}

Indexes

Constraint Name Type Sort Column(s)
semantic_search_token_tracking_pkey Primary key Asc id
idx_semantic_search_token_tracking_created_at Performance Asc created_at

Relationships