Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| query_hash | bytea | 2147483647 | null |
|
|
{“what”:“Binary hash of the query text; unique identifier for a query.”,“why”:“Without it, identical queries cannot be grouped or looked up efficiently.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:03.891120059+00:00”} |
||
| average_execution_time | int4 | 10 | null |
|
|
{“what”:“Average execution time of the query, in the unit used by the application.”,“why”:“Without it, query performance trends cannot be analyzed or compared.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:03.953871201+00:00”} |
||
| query | text | 2147483647 | √ | null |
|
|
{“what”:“The full SQL query text.”,“why”:“Without it, the hash cannot be mapped back to the actual query for review or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:11:03.987855731+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| query_pkey | Primary key | Asc | query_hash |