ssh_mux_sockets


Description

{“what”:“Registry of SSH multiplexing control sockets, keyed by socket path.”,“why”:“Without it, no central record of which sockets exist, their status, or session usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:39.483635570+00:00”}

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

Relationships