cleanup_log


Description

{“what”:“One row per cleanup run, with timing, trigger, and byte counts.”,“why”:“Needed to audit cleanup activity and track disk-space recovery over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:36.802235434+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null

{“what”:“Unique numeric identifier for each cleanup run.”,“why”:“Ensures each log row can be uniquely addressed; without it, updates or deletes would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:36.940230005+00:00”}

session_uuid text 2147483647 null

{“what”:“UUID of the session that triggered the cleanup, as a text string.”,“why”:“Ties each cleanup to the originating session for audit and debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.181216287+00:00”}

agent_name text 2147483647 √ null

{“what”:“Name of the cleanup agent or component that performed the run.”,“why”:“Allows filtering by agent to compare behavior; without it, runs from different agents are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.239104077+00:00”}

files_deleted int4 10 null

{“what”:“Count of files removed during the cleanup run.”,“why”:“Quantifies the cleanup impact; without it, the number of deleted files is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.277926160+00:00”}

tmp_bytes_freed int8 19 null

{“what”:“Bytes freed from temporary storage, in bytes.”,“why”:“Measures temporary space reclaimed; without it, tmp capacity planning is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.304752332+00:00”}

mirror_bytes_kept int8 19 null

{“what”:“Bytes retained in mirror storage after cleanup, in bytes.”,“why”:“Shows remaining mirror usage; without it, mirror growth cannot be tracked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.343621635+00:00”}

cleaned_at timestamptz 35,6 now()

{“what”:“Timestamp (with time zone) when the cleanup completed, defaulting to current time.”,“why”:“Provides chronological ordering and time-based analysis; without it, run timing is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.405570409+00:00”}

trigger text 2147483647 null

{“what”:“Reason or event that initiated the cleanup, e.g., ‘manual’ or ‘scheduled’.”,“why”:“Distinguishes cleanup sources; without it, the cause of each run is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:21:37.599416102+00:00”}

Indexes

Constraint Name Type Sort Column(s)
cleanup_log_pkey Primary key Asc id

Relationships