header_probes


Description

{“what”:“One row per HTTP probe request, holding response headers and timing.”,“why”:“Enables per-request analysis of rate-limit headers, server identity, and latency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.123210855+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()

{“what”:“Unique identifier for the probe row; generated UUID.”,“why”:“Provides a stable primary key for referencing probe records.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.137567181+00:00”}

assessment_id uuid 2147483647 null
assessments.id header_probes_assessment_id_fkey R

{“what”:“UUID of the assessment this probe belongs to.”,“why”:“Groups probes under an assessment; without it probes cannot be linked to a test run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.186854871+00:00”}

request_url text 2147483647 null

{“what”:“Full URL that was probed.”,“why”:“Identifies the endpoint tested; needed to correlate results with specific URLs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.333684352+00:00”}

status_code int4 10 null

{“what”:“HTTP status code returned by the server (e.g., 200, 429).”,“why”:“Indicates request success or rate limiting; essential for evaluating probe outcome.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.549379799+00:00”}

rate_limit_limit text 2147483647 √ null

{“what”:“Value of the RateLimit-Limit header, if present.”,“why”:“Shows the allowed request quota; without it rate limit enforcement cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.618104365+00:00”}

rate_limit_remaining text 2147483647 √ null

{“what”:“Value of the RateLimit-Remaining header, if present.”,“why”:“Shows remaining quota; needed to track consumption against the limit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.647559619+00:00”}

rate_limit_reset text 2147483647 √ null

{“what”:“Value of the RateLimit-Reset header, if present; typically a timestamp or seconds.”,“why”:“Indicates when the rate limit window resets; critical for scheduling retries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.662133321+00:00”}

retry_after text 2147483647 √ null

{“what”:“Value of the Retry-After header, if present; seconds or date.”,“why”:“Tells how long to wait before retrying; without it retry logic is blind.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.675228029+00:00”}

server text 2147483647 √ null

{“what”:“Value of the Server header, if present; identifies server software.”,“why”:“Helps detect server identity or version changes across probes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.691893775+00:00”}

all_headers jsonb 2147483647 null

{“what”:“Complete set of response headers as a JSON object.”,“why”:“Preserves all headers for future analysis; without it unmodeled headers are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.755389106+00:00”}

cookies jsonb 2147483647 √ null

{“what”:“Set-Cookie headers parsed into a JSON object, if any.”,“why”:“Captures cookie state for session or stateful behavior analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:24.793847576+00:00”}

response_time_ms int4 10 null

{“what”:“Time taken to receive the response, in milliseconds.”,“why”:“Measures latency; essential for performance monitoring and anomaly detection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:25.103607098+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the probe was recorded, in UTC.”,“why”:“Provides chronological ordering; without it time-based analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:25.205016563+00:00”}

Indexes

Constraint Name Type Sort Column(s)
header_probes_pkey Primary key Asc id
idx_headers_assessment Performance Asc assessment_id

Relationships