query_execution

{“what”:“Unique numeric identifier for each execution record.”,“why”:“Without it, rows cannot be uniquely referenced or joined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:57.997912096+00:00”}

{“what”:“Binary digest of the query text, used to detect duplicate executions.”,“why”:“Without it, identical queries cannot be grouped for performance analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.011268355+00:00”}

{“what”:“UTC timestamp when the query execution began.”,“why”:“Without it, cannot measure execution time or order events.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.029643191+00:00”}

{“what”:“Duration of execution in milliseconds.”,“why”:“Without it, performance regressions cannot be identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.042527849+00:00”}

{“what”:“Number of rows returned by the query.”,“why”:“Without it, cannot assess result size or validate expected row counts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.070651267+00:00”}

{“what”:“True if the query is raw SQL, false if built with the query builder.”,“why”:“Without it, cannot distinguish user-written SQL from generated queries for debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.083137709+00:00”}

{“what”:“Free-form string describing the execution context (e.g., source, environment).”,“why”:“Without it, the origin of the query cannot be traced beyond explicit foreign keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.104986278+00:00”}

{“what”:“Error message if execution failed, otherwise null.”,“why”:“Without it, failed executions cannot be diagnosed or alerted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.167523442+00:00”}

{“what”:“ID of the user or service that executed the query.”,“why”:“Without it, cannot attribute executions to specific users for auditing or quotas.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.187248990+00:00”}

{“what”:“ID of the saved question (card) that triggered this execution.”,“why”:“Without it, cannot link executions to specific saved questions for usage analytics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.204822458+00:00”}

{“what”:“ID of the dashboard that triggered this execution.”,“why”:“Without it, cannot attribute executions to dashboards for performance monitoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.220077582+00:00”}

{“what”:“ID of the pulse (scheduled report) that triggered this execution.”,“why”:“Without it, cannot track executions from scheduled alerts or reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.239294325+00:00”}

{“what”:“ID of the database the query ran against.”,“why”:“Without it, cannot filter or aggregate executions per database.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.272970560+00:00”}

{“what”:“True if the result was served from cache, false if executed.”,“why”:“Without it, cannot measure cache effectiveness or identify cache misses.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.288893129+00:00”}

{“what”:“ID of the action (e.g., button) that triggered this execution.”,“why”:“Without it, cannot attribute executions to interactive actions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.316361296+00:00”}

{“what”:“True if the query ran with row-level security sandboxing.”,“why”:“Without it, cannot distinguish sandboxed executions for security audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.341869739+00:00”}

{“what”:“Binary hash of the cached result set, if cached.”,“why”:“Without it, cannot verify cache integrity or match results to cache entries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.355021367+00:00”}

{“what”:“Identifier of the embedding client (e.g., app name) that initiated the query.”,“why”:“Without it, cannot track usage from embedded analytics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.370741972+00:00”}

{“what”:“Version string of the embedding client.”,“why”:“Without it, cannot correlate issues with specific embedding versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.388009809+00:00”}

{“what”:“True if the query used parameters, false if literal values.”,“why”:“Without it, cannot distinguish parameterized queries for caching or security analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:58.415567700+00:00”}