---
title: "SYSTEMSQLEXECUTIONSTEPS (Data Dictionary)"
description: "SQL Execution Steps"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps

`read only`

- Catalog: `DataDictionary`
- Schema: `Invantive`
- Label: SQL Execution Steps

Individual processing steps executed by Invantive's UniversalSQL engine during the execution of SQL statements, their relationships and their statistics.

Can only retrieve data.

## Table Columns

The columns of the table `SYSTEMSQLEXECUTIONSTEPS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ALGORITHM` | `varchar2(240)` | Algorithm | [ ] |  | How the step went about its work where it had a choice: what a join chose, such as an index join on columns or a nested loop, and for a nested loop why no index was taken. Empty where the step had no choice. |
| `ALIAS` | `varchar2(240)` | Alias | [ ] |  | Alias of the result set. |
| `API_CALLS_ACTUAL` | `int64` | API Calls Actual | [x] |  | API Calls Actual |
| `API_CALLS_FROM_DISK_CACHE` | `int64` | API Calls from Disk Cache | [x] |  | API Calls From Disk Cache |
| `API_CALLS_FROM_MEMORY_CACHE` | `int64` | API Calls from Memory Cache | [x] |  | API Calls From Memory Cache |
| `API_ROWS_ACTUAL` | `int64` | API Rows Actual | [x] |  | API Rows Actual |
| `API_ROWS_FROM_DISK_CACHE` | `int64` | API Rows from Disk Cache | [x] |  | API Rows From Disk Cache |
| `API_ROWS_FROM_MEMORY_CACHE` | `int64` | API Rows from Memory Cache | [x] |  | API Rows From Memory Cache |
| `BYTES_IN` | `int64` | Bytes In | [ ] |  | Number of bytes input. |
| `BYTES_OUT` | `int64` | Bytes Out | [ ] |  | Number of bytes output. |
| `COLUMNS_IN` | `int32` | Columns In | [ ] |  | Number of columns input. |
| `COLUMNS_OUT` | `int32` | Columns Out | [ ] |  | Number of columns output. |
| `COUNTERS` | `varchar2(4000)` | Counters | [ ] |  | What the step itself did, counted, as a JSON object of the counts which are not zero, such as {"PlanBuilds":1,"PairsEvaluated":12}: plans built, expressions found in or added to the expression cache, the algorithm a join chose, pairs a join evaluated, rows sorted. The counts of a statement are the sum over its steps. Empty when the step counted nothing. |
| `DEPTH` | `int32` | Depth | [x] |  | Depth of the step. |
| `DESCRIPTION` | `varchar2(240)` | Description | [ ] |  | Description of the step. |
| `DURATION_CPU_MS` | `double` | CPU Duration (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step. |
| `DURATION_IO_MS` | `double` | I/O Duration (ms) | [ ] |  | Duration in milliseconds of the I/O on this step. |
| `DURATION_MS` | `double` | Duration (ms) | [ ] |  | Duration in milliseconds of the step. |
| `DURATION_SLEEP_MS` | `double` | Sleep Duration (ms) | [ ] |  | Duration in milliseconds of the sleep on this step. |
| `DURATION_TICKS` | `int64` | Duration (Ticks) | [ ] |  | Duration in ticks of the step. |
| `END_TIME_UTC` | `datetime` | End Time | [ ] |  | Time at which the SQL execution was ended (UTC). |
| `ESTIMATED_ROWS` | `int64` | Estimated Rows | [ ] |  | Rows of the table read by the step as its data container declares them, before any filter; compare with ROWS_OUT. Empty where nothing is declared. |
| `EXECUTION_ID` | `guid` | Execution ID | [x] |  | Unique ID of the SQL statement execution. |
| `EXECUTION_OPTIONS_ID` | `guid` | Execution Options ID | [ ] |  | Execution options ID. |
| `FINGER_PRINT` | `varchar2(240)` | Finger Print | [x] |  | Unique finger print |
| `GC_COLLECTIONS_GENERATION_0` | `int32` | Generation 0 Garbage Collections in Process | [ ] |  | Number of garbage collections of generation 0 in the whole process while the step ran, not counting those of generation 1 and 2. The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections. Empty while the step runs. |
| `GC_COLLECTIONS_GENERATION_1` | `int32` | Generation 1 Garbage Collections in Process | [ ] |  | Number of garbage collections of generation 1 in the whole process while the step ran, not counting those of generation 2. The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections. Empty while the step runs. |
| `GC_COLLECTIONS_GENERATION_2` | `int32` | Generation 2 Garbage Collections in Process | [ ] |  | Number of full garbage collections, of generation 2, in the whole process while the step ran. The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections. Empty while the step runs. |
| `GC_PAUSE_MS` | `double` | Garbage Collection Pause in Process (ms) | [ ] |  | Milliseconds in which the garbage collector paused the whole process while the step ran. A pause stops every statement running at that moment, so it is not time lost by the step alone, and a step and its children count the same pauses. Empty while the step runs and on .NET Framework, which does not measure it. |
| `HEAP_BYTES_ALLOCATED` | `int64` | Heap Bytes Allocated | [ ] |  | Number of bytes allocated on the managed heap by the thread of the step, from its start until its end. Counts bytes allocated rather than bytes retained, so it never decreases; a step and its children on one thread both count the same bytes, as they both count the same milliseconds. Empty when the step ended on another thread than the one which started it. |
| `ID` | `int64` | ID | [x] |  | Unique ID of the step. |
| `KIND` | `varchar2(30)` | Kind of Step | [ ] |  | What the step does, such as DataContainerRead, Join, Filter or Sort; empty where the code which made the step did not state it. |
| `MANAGED_THREAD_ID` | `int32` | Managed Thread ID | [ ] |  | Managed thread ID. |
| `PARAMETERS` | `varchar2(1000)` | Parameters | [ ] |  | Parameters of the step. |
| `PARENT_ID` | `int64` | Parent ID | [ ] |  | ID of the parent step. |
| `REQUEST_ID` | `varchar2(60)` | Request ID | [ ] |  | Request ID. |
| `ROOT_ID` | `int64` | Root ID | [x] |  | Unique ID of the step at the root of the tree. |
| `ROWS_IN` | `int64` | Rows In | [ ] |  | Number of rows input. |
| `ROWS_OUT` | `int64` | Rows Out | [ ] |  | Number of rows output. |
| `SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Shared Objects Bytes Add Count | [x] |  | Shared Objects Bytes Add Count |
| `SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Shared Objects Bytes Add Length | [x] |  | Shared Objects Bytes Add Length |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Shared Objects Bytes Already Shared Count | [x] |  | Shared Objects Bytes Already Shared Count |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Shared Objects Bytes Already Shared Length | [x] |  | Shared Objects Bytes Already Shared Length |
| `SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Shared Objects Bytes Reuse Count | [x] |  | Shared Objects Bytes Reuse Count |
| `SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Shared Objects Bytes Reuse Length | [x] |  | Shared Objects Bytes Reuse Length |
| `SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Shared Objects String Add Count | [x] |  | Shared Objects Text Add Count |
| `SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Shared Objects String Add Length | [x] |  | Shared Objects Text Add Length |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Shared Objects String Already Shared Count | [x] |  | Shared Objects Text Already Shared Count |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Shared Objects String Already Shared Length | [x] |  | Shared Objects Text Already Shared Length |
| `SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Shared Objects String Reuse Count | [x] |  | Shared Objects Text Reuse Count |
| `SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Shared Objects String Reuse Length | [x] |  | Shared Objects Text Reuse Length |
| `START_TIME_UTC` | `datetime` | Start Time | [ ] |  | Time at which the SQL execution step was started (UTC). |
| `STATEMENT_ID` | `guid` | Statement ID | [x] |  | Unique ID of the SQL statement. |
| `STEP_DURATION_CLOCK_MS` | `double` | Step Duration Clock (ms) | [ ] |  | Duration in milliseconds of the step (excluding children). |
| `STEP_DURATION_CPU_MS` | `double` | Step CPU Duration (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step (excluding children). |
| `STEP_DURATION_IO_MS` | `double` | Step I/O Duration (ms) | [ ] |  | Duration in milliseconds of the I/O on this step (excluding children). |
| `STEP_DURATION_SLEEP_MS` | `double` | Step Duration Sleeping (ms) | [ ] |  | Duration in milliseconds of the sleep on this step (excluding children). |
| `TASK_ID` | `int32` | Task ID | [ ] |  | Task ID. |
| `THREAD_CPU_TIME_NS` | `int64` | Thread CPU Time (ns) | [ ] |  | CPU time in nanoseconds, kernel plus user, which the operating system charged to the thread of the step while it ran. A measurement, where DURATION_CPU_MS beside it is the wall clock minus the measured I/O and sleep and therefore also absorbs every wait nobody measured. A step and its children on one thread both count the same time. Empty when the step ended on another thread than the one which started it, or on a platform without a cheap per-thread clock. The resolution of the figure is the resolution of the per-thread clock of the platform, which is coarser than a nanosecond on some of them; a step short enough may therefore report zero rather than a small number. |
| `TOTAL_API_CALLS_ACTUAL` | `int64` | Total API Calls Actual | [x] |  | Total API Calls Actual |
| `TOTAL_API_CALLS_FROM_DISK_CACHE` | `int64` | Total API Calls from Disk Cache | [x] |  | Total API Calls From Disk Cache |
| `TOTAL_API_CALLS_FROM_MEMORY_CACHE` | `int64` | Total API Calls from Memory Cache | [x] |  | Total API Calls From Memory Cache |
| `TOTAL_API_ROWS_ACTUAL` | `int64` | Total API Rows Actual | [x] |  | Total API Rows Actual |
| `TOTAL_API_ROWS_FROM_DISK_CACHE` | `int64` | Total API Rows from Disk Cache | [x] |  | Total API Rows From Disk Cache |
| `TOTAL_API_ROWS_FROM_MEMORY_CACHE` | `int64` | Total API Rows from Memory Cache | [x] |  | Total API Rows From Memory Cache |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Total Shared Objects Bytes Add Count | [x] |  | Total Shared Objects Bytes Add Count |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Total Shared Objects Bytes Add Length | [x] |  | Total Shared Objects Bytes Add Length |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Total Shared Objects Bytes Already Shared Count | [x] |  | Total Shared Objects Bytes Already Shared Count |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Total Shared Objects Bytes Already Shared Length | [x] |  | Total Shared Objects Bytes Already Shared Length |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Total Shared Objects Bytes Reuse Count | [x] |  | Total Shared Objects Bytes Reuse Count |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Total Shared Objects Bytes Reuse Length | [x] |  | Total Shared Objects Bytes Reuse Length |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Total Shared Objects String Add Count | [x] |  | Total Shared Objects Text Add Count |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Total Shared Objects String Add Length | [x] |  | Total Shared Objects Text Add Length |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Total Shared Objects String Already Shared Count | [x] |  | Total Shared Objects Text Already Shared Count |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Total Shared Objects String Already Shared Length | [x] |  | Total Shared Objects Text Already Shared Length |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Total Shared Objects String Reuse Count | [x] |  | Total Shared Objects Text Reuse Count |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Total Shared Objects String Reuse Length | [x] |  | Total Shared Objects Text Reuse Length |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `SYSTEMSQLEXECUTIONSTEPS_EXECUTION_ID_SYSTEMSQLEXECUTIONS_fk` | `EXECUTION_ID` | [SYSTEMSQLEXECUTIONS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_PARENT_ID_SYSTEMSQLEXECUTIONSTEPS_fk` | `PARENT_ID` | [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_ROOT_ID_SYSTEMSQLEXECUTIONSTEPS_fk` | `ROOT_ID` | [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_STATEMENT_ID_SYSTEMSQLAREA_fk` | `STATEMENT_ID` | [SYSTEMSQLAREA](DataDictionary.Invantive.SYSTEMSQLAREA)`.ID` | Key |  |

## Referenced By

- [SESSIONIOS](DataDictionary.Invantive.SESSIONIOS) `EXECUTION_STEP_ID` (Textual)
- [SYSTEMSQLEXECUTIONSLEEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSLEEPS) `EXECUTION_STEP_ID` (Key)
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS) `PARENT_ID` (Key)
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS) `ROOT_ID` (Key)



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Data Dictionary](/en/release-notes/drivers?driver=data-dictionary)

