quota


Description

{“what”:“Snapshot of service quota state at a given timestamp.”,“why”:“Without it, historical quota usage and limits are unknown, preventing trend analysis and limit forecasting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:49.119131664+00:00”}

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

Relationships