metabase_fieldvalues


Description

{“what”:“Cached distinct values for a field, keyed by field_id and hash_key.”,“why”:“Without it, filter dropdowns would need live queries, causing slow UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.150342639+00:00”}

Columns

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

{“what”:“Unique integer assigned to each row.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.161239380+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when the row was inserted.”,“why”:“Without it, cannot determine age of cached values.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.196208590+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last update to this row.”,“why”:“Without it, cannot know if cached values are stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.215510331+00:00”}

values text 2147483647 √ null

{“what”:“Serialized representation of the field’s distinct values.”,“why”:“Without it, the cache cannot provide the value list, forcing a recompute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.230711281+00:00”}

human_readable_values text 2147483647 √ null

{“what”:“Serialized mapping of raw values to display labels.”,“why”:“Without it, only raw values are shown, losing user-friendly labels.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.249985089+00:00”}

field_id int4 10 null
metabase_field.id fk_fieldvalues_ref_field_id C

{“what”:“Identifier of the field these values belong to.”,“why”:“Without it, cannot associate cached values with a specific field.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.263256562+00:00”}

has_more_values bool 1 √ false

{“what”:“Flag indicating whether additional values exist beyond those stored.”,“why”:“Without it, the UI cannot show a ‘load more’ option or know the list is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.281270627+00:00”}

type varchar 32 'full'::character varying

{“what”:“Category of the cached value set, defaulting to ‘full’.”,“why”:“Without it, consumers cannot distinguish a complete list from a truncated one.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.291923997+00:00”}

hash_key text 2147483647 √ null

{“what”:“Hash of the query parameters that produced this value set.”,“why”:“Without it, cannot distinguish cached results for different filter conditions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.302950766+00:00”}

last_used_at timestamptz 35,6 now()

{“what”:“Timestamp of the last time this cache entry was accessed.”,“why”:“Without it, cannot implement LRU eviction or know which entries are unused.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.317812302+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metabase_fieldvalues_pkey Primary key Asc id
idx_fieldvalues_field_id Performance Asc field_id

Relationships