Telemetry
When you operate a complex database system, you often need to know what is happening under the hood of the database engine, so you can optimize your queries and so on. Telemetry is a toolset that helps you to understand how your actions are planned and executed.
Query telemetry
The query telemetry object represents a single executed operation with possibly nested other operations and consists of the following data:
- operation
- start
Date and time of the start of this step in nanoseconds.
- steps
Internal steps of this telemetry step (operation decomposition). Same structure as the parent telemetry object.
- arguments
Arguments of the processing phase.
- spentTime
Duration in nanoseconds.
To demonstrate the information the query telemetry is providing, we will use the following query that filters and sorts entities:
The result contains query telemetry and some products (which we omitted here for brevity):