Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| query_hash | bytea | 2147483647 | null |
|
|
{“what”:“Binary hash of the query text; the unique cache key.”,“why”:“Without it, identical queries cannot be matched to cached results.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:10.743761831+00:00”} |
||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last refresh of this cache entry.”,“why”:“Without it, stale entries cannot be identified for eviction.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:10.778801210+00:00”} |
||
| results | bytea | 2147483647 | null |
|
|
{“what”:“Serialized result set for the query, in application-specific format.”,“why”:“Without it, the cache would hold no data to return.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:10.826887930+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| query_cache_pkey | Primary key | Asc | query_hash |
| idx_query_cache_updated_at | Performance | Asc | updated_at |