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 |
|
|
{“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”} |
|||||
| 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 |