Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this usage row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.836308970+00:00”} |
||||
| field_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the field that was used in the query.”,“why”:“Without it, you cannot know which field the usage record applies to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.858166963+00:00”} |
|||||
| query_execution_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the query execution in which the field was used.”,“why”:“Without it, you cannot associate the usage with a specific query run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.883618674+00:00”} |
|||||
| used_in | varchar | 25 | null |
|
|
{“what”:“Query section where the field appears: filter, aggregation, breakout, etc.”,“why”:“Without it, you cannot distinguish which part of the query the field influenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.904099343+00:00”} |
|||||
| filter_op | varchar | 25 | √ | null |
|
|
{“what”:“Comparison operator used when the field is in a filter, e.g., =, >, contains.”,“why”:“Without it, filter usage lacks the operator, so you cannot analyze filter patterns or replicate the condition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.927021128+00:00”} |
||||
| aggregation_function | varchar | 25 | √ | null |
|
|
{“what”:“Aggregate function applied to the field, e.g., sum, avg, count.”,“why”:“Without it, you cannot know how the field was aggregated, making usage analysis incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.948334403+00:00”} |
||||
| breakout_temporal_unit | varchar | 25 | √ | null |
|
|
{“what”:“Temporal unit for a breakout, e.g., day, week, month.”,“why”:“Without it, you cannot know the time granularity of a breakout, losing query intent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.975831818+00:00”} |
||||
| breakout_binning_strategy | varchar | 25 | √ | null |
|
|
{“what”:“Binning strategy for a breakout, e.g., equal width, quantile.”,“why”:“Without it, you cannot know how numeric values were grouped, affecting analysis of usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.004176244+00:00”} |
||||
| breakout_binning_num_bins | int4 | 10 | √ | null |
|
|
{“what”:“Number of bins used in the binning strategy.”,“why”:“Without it, the binning configuration is incomplete, so you cannot reproduce the breakout.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.029176846+00:00”} |
||||
| breakout_binning_bin_width | int4 | 10 | √ | null |
|
|
{“what”:“Width of each bin in the binning strategy.”,“why”:“Without it, the binning configuration is incomplete, so you cannot reproduce the breakout.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.058812251+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“UTC timestamp of when the usage was recorded.”,“why”:“Without it, you cannot know when the usage occurred, losing temporal context for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.093586527+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| field_usage_pkey | Primary key | Asc | id |
| idx_field_usage_field_id | Performance | Asc | field_id |
| idx_field_usage_query_execution_id | Performance | Asc | query_execution_id |