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 |