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 |