Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('quota_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each quota snapshot row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.225711736+00:00”} |
|
| ts | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp when this quota snapshot was recorded.”,“why”:“Without it, the order and timing of quota changes is unknown, breaking time-series analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.247611431+00:00”} |
||
| from_service | text | 2147483647 | 'unknown'::text |
|
|
{“what”:“Name of the service the quota applies to, e.g. ‘openai’.”,“why”:“Without it, quota data from different services cannot be distinguished, mixing limits and usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.328660404+00:00”} |
||
| rolling_5h_remaining | int8 | 19 | √ | null |
|
|
{“what”:“Remaining quota units in the rolling 5-hour window.”,“why”:“Without it, current headroom for the 5-hour window is unknown, so requests may be rejected unexpectedly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.387671865+00:00”} |
|
| rolling_5h_max | int8 | 19 | √ | null |
|
|
{“what”:“Maximum quota units allowed in the rolling 5-hour window.”,“why”:“Without it, the limit for the 5-hour window is unknown, so remaining percentage cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.426606030+00:00”} |
|
| rolling_5h_limited | bool | 1 | √ | null |
|
|
{“what”:“Whether the 5-hour window is currently rate-limited.”,“why”:“Without it, it’s unknown if requests are being throttled, causing confusion about failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.507814356+00:00”} |
|
| subscription_limit | int8 | 19 | √ | null |
|
|
{“what”:“Total quota units allowed per subscription period.”,“why”:“Without it, the overall cap for the subscription is unknown, so usage cannot be compared to the plan.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.614118480+00:00”} |
|
| subscription_requests | int8 | 19 | √ | null |
|
|
{“what”:“Number of requests counted against the subscription limit.”,“why”:“Without it, subscription usage is unknown, so remaining quota cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.640492630+00:00”} |
|
| weekly_percent_remaining | float8 | 17,17 | √ | null |
|
|
{“what”:“Percentage of weekly quota remaining, from 0 to 100.”,“why”:“Without it, the weekly usage ratio is unknown, making it hard to plan spending.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.663769707+00:00”} |
|
| weekly_remaining_credits | text | 2147483647 | √ | null |
|
|
{“what”:“Remaining weekly credits as a string, possibly with unit suffix.”,“why”:“Without it, the exact remaining credit amount is unknown, and the string format may include units.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.690786183+00:00”} |
|
| weekly_max_credits | text | 2147483647 | √ | null |
|
|
{“what”:“Maximum weekly credits as a string, possibly with unit suffix.”,“why”:“Without it, the weekly cap is unknown, so remaining percentage cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.709133585+00:00”} |
|
| raw | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Raw JSON payload from the quota API for this snapshot.”,“why”:“Without it, fields not captured in columns are lost, preventing future extraction of new metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.737527174+00:00”} |
|
| next_tick_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the next quota reset or tick is scheduled.”,“why”:“Without it, the time until quota refresh is unknown, so scheduling of requests cannot be optimized.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.753867335+00:00”} |
|
| tick_percent | float8 | 17,17 | √ | null |
|
|
{“what”:“Percentage of quota used at the next tick, likely 0-100.”,“why”:“Without it, the expected usage at reset is unknown, so proactive adjustments are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.802510614+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| quota_pkey | Primary key | Asc | id |
| quota_remaining_ts_idx | Performance | Asc | ts |
| quota_ts_idx | Performance | Desc | ts |