compaction_history


Description

{“what”:“History of compaction runs, each row one operation.”,“why”:“Without it, no audit trail of when and how compaction changed data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.099248647+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“UUID that uniquely identifies this history row.”,“why”:“Without it, duplicate or ambiguous history entries cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.130911887+00:00”}

job_id uuid 2147483647 null
compaction_jobs.id compaction_history_job_id_fkey R

{“what”:“UUID of the compaction job that produced this history entry.”,“why”:“Without it, cannot associate history with the originating job or filter by job.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.144629563+00:00”}

input_snapshot jsonb 2147483647 null

{“what”:“JSON document capturing the pre-compaction state of the affected data.”,“why”:“Without it, cannot compare before/after or roll back to previous state.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.155524617+00:00”}

output_snapshot jsonb 2147483647 null

{“what”:“JSON document capturing the post-compaction state of the affected data.”,“why”:“Without it, cannot verify compaction result or audit changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.170582260+00:00”}

pinned_content jsonb 2147483647 √ null

{“what”:“JSON document listing content explicitly kept unchanged during compaction.”,“why”:“Without it, cannot know which items were protected from compaction or reproduce the same pinning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.181216665+00:00”}

outcome text 2147483647 √ null

{“what”:“Text describing the result of the compaction, such as success or failure reason.”,“why”:“Without it, cannot tell if compaction succeeded or failed, or diagnose errors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.213712484+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp of when the compaction history entry was recorded.”,“why”:“Without it, cannot order events or know when compaction occurred.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:12.223910358+00:00”}

Indexes

Constraint Name Type Sort Column(s)
compaction_history_pkey Primary key Asc id
idx_history_job Performance Asc job_id

Relationships