dir_observed


Description

{“what”:“Snapshot of a directory’s contents on a device at a point in time.”,“why”:“Without it, no record of directory state for historical comparison or drift detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.112245220+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
device text 2147483647 null

{“what”:“Identifier of the host device, e.g., hostname or UUID.”,“why”:“Without it, observations from different devices are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.156760935+00:00”}

dir_path text 2147483647 null

{“what”:“Absolute path of the directory on the device.”,“why”:“Without it, cannot know which directory the metrics refer to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.363195539+00:00”}

file_count int4 10 √ null

{“what”:“Total number of files directly inside the directory (not recursive).”,“why”:“Without it, cannot track growth or compare directory sizes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.391408560+00:00”}

subdir_count int4 10 √ null

{“what”:“Number of immediate subdirectories within the directory.”,“why”:“Without it, cannot assess directory structure complexity or changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.412237767+00:00”}

loose_file_count int4 10 √ null

{“what”:“Number of files not inside any subdirectory (i.e., directly in the directory).”,“why”:“Without it, cannot distinguish files from subdirectory contents.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.632106610+00:00”}

ext_profile jsonb 2147483647 √ null

{“what”:“JSON object mapping file extensions to counts or frequencies.”,“why”:“Without it, cannot analyze extension distribution or detect unexpected file types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.732053413+00:00”}

dominant_ext text 2147483647 √ null

{“what”:“File extension with the highest count in the directory.”,“why”:“Without it, cannot quickly identify the primary file type without parsing ext_profile.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.916720834+00:00”}

dominant_frac float4 8,8 √ null

{“what”:“Fraction (0-1) of files having the dominant extension.”,“why”:“Without it, cannot gauge how dominant the dominant extension is.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:21.963449268+00:00”}

sampled_at timestamptz 35,6 √ now()

{“what”:“UTC timestamp when the observation was taken.”,“why”:“Without it, cannot order observations or detect changes over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:22.132899354+00:00”}

Indexes

Constraint Name Type Sort Column(s)
dir_observed_pkey Primary key Asc/Asc device + dir_path

Relationships