Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| socket_path | text | 2147483647 | null |
|
|
{“what”:“Absolute filesystem path of the Unix socket used for SSH multiplexing.”,“why”:“Without it, sockets cannot be uniquely referenced or deduplicated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.517238081+00:00”} |
||
| host | text | 2147483647 | null |
|
|
{“what”:“Hostname or IP address the socket connects to.”,“why”:“Without it, sockets for different hosts are indistinguishable, causing cross-host cleanup errors.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.529232683+00:00”} |
||
| owner_pid | int4 | 10 | √ | null |
|
|
{“what”:“Process ID of the SSH client that created the socket.”,“why”:“Without it, orphaned sockets cannot be attributed to a dead process for cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.548666320+00:00”} |
|
| status | text | 2147483647 | 'active'::text |
|
|
{“what”:“Lifecycle state, default ‘active’.”,“why”:“Without it, unusable or closed sockets would be treated as active, breaking connection logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.561048541+00:00”} |
||
| session_count | int4 | 10 | √ | 0 |
|
|
{“what”:“Number of active sessions currently using the socket.”,“why”:“Without it, idle sockets cannot be identified for closing, wasting resources.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.577754289+00:00”} |
|
| first_seen | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this socket was first recorded.”,“why”:“Without it, socket age is unknown, preventing time-based cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.598684441+00:00”} |
||
| last_checked | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last health or liveness check.”,“why”:“Without it, stale sockets cannot be detected, risking connections to dead sockets.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.627338324+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ssh_mux_sockets_pkey | Primary key | Asc | socket_path |