---
title: "SYSTEMSQLEXECUTIONSTEPS (Data Dictionary)"
description: "SQL Execution Steps"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
updated: 2026-11-16T20:45:39Z
license: https://documentation.invantive.eu/nl/
---

# SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps

`read only`

- Catalogus: `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.

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `SYSTEMSQLEXECUTIONSTEPS` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | 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` | Werkelijke API-aanroepen | [x] |  | Werkelijke API-aanroepen |
| `API_CALLS_FROM_DISK_CACHE` | `int64` | API-aanroepen vanuit de schijfcache | [x] |  | API Calls From Disk Cache |
| `API_CALLS_FROM_MEMORY_CACHE` | `int64` | API-aanroepen vanuit de cache | [x] |  | API Calls From Memory Cache |
| `API_ROWS_ACTUAL` | `int64` | API-rijen (werkelijk) | [x] |  | API-rijen (werkelijk) |
| `API_ROWS_FROM_DISK_CACHE` | `int64` | API-rijen uit de schijfcache | [x] |  | API Rows From Disk Cache |
| `API_ROWS_FROM_MEMORY_CACHE` | `int64` | API-rijen uit de Cache | [x] |  | API Rows From Memory Cache |
| `BYTES_IN` | `int64` | Bytes In | [ ] |  | Number of bytes input. |
| `BYTES_OUT` | `int64` | Bytes Uit | [ ] |  | Number of bytes output. |
| `COLUMNS_IN` | `int32` | Kolommen In | [ ] |  | Number of columns input. |
| `COLUMNS_OUT` | `int32` | Kolommen Uit | [ ] |  | 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-duur (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step. |
| `DURATION_IO_MS` | `double` | I/O-duur (ms) | [ ] |  | Duration in milliseconds of the I/O on this step. |
| `DURATION_MS` | `double` | Duur (ms) | [ ] |  | Duration in milliseconds of the step. |
| `DURATION_SLEEP_MS` | `double` | Slaapduur (ms) | [ ] |  | Duration in milliseconds of the sleep on this step. |
| `DURATION_TICKS` | `int64` | Duur (tikken) | [ ] |  | Duration in ticks of the step. |
| `END_TIME_UTC` | `datetime` | Eindtijd | [ ] |  | Time at which the SQL execution was ended (UTC). |
| `ESTIMATED_ROWS` | `int64` | Geschat aantal rijen | [ ] |  | 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` | Uitvoerings-ID | [x] |  | Unique ID of the SQL statement execution. |
| `EXECUTION_OPTIONS_ID` | `guid` | Uitvoeringsopties-ID | [ ] |  | Execution options ID. |
| `FINGER_PRINT` | `varchar2(240)` | Vingerafdruk | [x] |  | Unique finger print |
| `GC_COLLECTIONS_GENERATION_0` | `int32` | Garbage collections van generatie 0 zijn bezig | [ ] |  | 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` | Garbage collections van generatie 1 zijn bezig | [ ] |  | 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` | Garbage collections van generatie 2 zijn bezig | [ ] |  | 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` | Pauze bij het ophalen van afval in het proces (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` | Toegewezen heap-bytes | [ ] |  | 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)` | Soort stap | [ ] |  | 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` | Beheerde Thread-ID | [ ] |  | Managed thread ID. |
| `PARAMETERS` | `varchar2(1000)` | Parameters | [ ] |  | Parameters of the step. |
| `PARENT_ID` | `int64` | Ouder ID | [ ] |  | ID of the parent step. |
| `REQUEST_ID` | `varchar2(60)` | Verzoek ID | [ ] |  | Request ID. |
| `ROOT_ID` | `int64` | Wortel-ID | [x] |  | Unique ID of the step at the root of the tree. |
| `ROWS_IN` | `int64` | Rijen In | [ ] |  | Number of rows input. |
| `ROWS_OUT` | `int64` | Rijen Uit | [ ] |  | Number of rows output. |
| `SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Aantal gedeelde objecten Bytes Totaal | [x] |  | Aantal gedeelde objecten Bytes Totaal |
| `SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Gedeelde objecten Bytes Toevoegen Lengte | [x] |  | Gedeelde objecten Bytes Toevoegen Lengte |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Gedeelde objecten Bytes Aantal reeds gedeelde objecten | [x] |  | Gedeelde objecten Bytes Aantal reeds gedeelde objecten |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Gedeelde objecten Bytes Reeds gedeeld Lengte | [x] |  | Gedeelde objecten Bytes Reeds gedeeld Lengte |
| `SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Gedeelde objecten Bytes Aantal hergebruiken | [x] |  | Gedeelde objecten Bytes Aantal hergebruiken |
| `SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Gedeelde objecten Bytes Hergebruik Lengte | [x] |  | Gedeelde objecten Bytes Hergebruik Lengte |
| `SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Aantal toegevoegde strings in gedeelde objecten | [x] |  | Shared Objects Text Add Count |
| `SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Shared Objects: lengte van een tekenreeks toevoegen | [x] |  | Shared Objects Text Add Length |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Gedeelde objecten: tekenreeks al gedeeld, aantal | [x] |  | Shared Objects Text Already Shared Count |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Gedeelde objecten Tekst Reeds gedeeld Lengte | [x] |  | Shared Objects Text Already Shared Length |
| `SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Aantal hergebruikte strings in gedeelde objecten | [x] |  | Shared Objects Text Reuse Count |
| `SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Lengte van hergebruikte strings in gedeelde objecten | [x] |  | Shared Objects Text Reuse Length |
| `START_TIME_UTC` | `datetime` | Starttijd | [ ] |  | 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` | Stapklokduur (ms) | [ ] |  | Duration in milliseconds of the step (excluding children). |
| `STEP_DURATION_CPU_MS` | `double` | Stap CPU-duur (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step (excluding children). |
| `STEP_DURATION_IO_MS` | `double` | Stap I/O-duur (ms) | [ ] |  | Duration in milliseconds of the I/O on this step (excluding children). |
| `STEP_DURATION_SLEEP_MS` | `double` | Stapslaapduur (ms) | [ ] |  | Duration in milliseconds of the sleep on this step (excluding children). |
| `TASK_ID` | `int32` | Taak ID | [ ] |  | Task ID. |
| `THREAD_CPU_TIME_NS` | `int64` | CPU-tijd per thread (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` | Totaal aantal API-aanroepen (werkelijk) | [x] |  | Totaal aantal API-aanroepen (werkelijk) |
| `TOTAL_API_CALLS_FROM_DISK_CACHE` | `int64` | Totaal aantal API-aanroepen vanuit de schijfcache | [x] |  | Total API Calls From Disk Cache |
| `TOTAL_API_CALLS_FROM_MEMORY_CACHE` | `int64` | Totaal aantal API-aanroepen vanuit de geheugencache | [x] |  | Total API Calls From Memory Cache |
| `TOTAL_API_ROWS_ACTUAL` | `int64` | Totaal aantal API-rijen (werkelijk) | [x] |  | Totaal aantal API-rijen (werkelijk) |
| `TOTAL_API_ROWS_FROM_DISK_CACHE` | `int64` | Totaal aantal API-rijen uit de schijfcache | [x] |  | Total API Rows From Disk Cache |
| `TOTAL_API_ROWS_FROM_MEMORY_CACHE` | `int64` | Totaal aantal API-rijen uit de Cache | [x] |  | Total API Rows From Memory Cache |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Totaal aantal gedeelde objecten in bytes, aantal toevoegingen | [x] |  | Totaal aantal gedeelde objecten in bytes, aantal toevoegingen |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Totaal aantal gedeelde objecten in bytes + lengte | [x] |  | Totaal aantal gedeelde objecten in bytes + lengte |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Totaal aantal gedeelde objecten in bytes; aantal reeds gedeelde objecten | [x] |  | Totaal aantal gedeelde objecten in bytes; aantal reeds gedeelde objecten |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Totaal aantal gedeelde objecten Bytes Reeds gedeeld Lengte | [x] |  | Totaal aantal gedeelde objecten Bytes Reeds gedeeld Lengte |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Totaal aantal gedeelde objecten, bytes, aantal hergebruiken | [x] |  | Totaal aantal gedeelde objecten, bytes, aantal hergebruiken |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Totaal Aantal gedeelde objecten Bytes Hergebruikslengte | [x] |  | Totaal Aantal gedeelde objecten Bytes Hergebruikslengte |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Totaal aantal toegevoegde strings in gedeelde objecten | [x] |  | Total Shared Objects Text Add Count |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Totaal aantal gedeelde objecten – Lengte toegevoegde tekenreeks | [x] |  | Total Shared Objects Text Add Length |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Totaal aantal gedeelde objecten Aantal reeds gedeelde strings | [x] |  | Total Shared Objects Text Already Shared Count |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Totaal Aantal gedeelde objecten Tekst Reeds gedeeld Lengte | [x] |  | Total Shared Objects Text Already Shared Length |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Totaal aantal hergebruikte strings in gedeelde objecten | [x] |  | Total Shared Objects Text Reuse Count |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Totale lengte van hergebruikte strings in gedeelde objecten | [x] |  | Total Shared Objects Text Reuse Length |

## Toetsen

| Key | Column | Verwijst naar | 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 |  |

## Geciteerd door

- [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

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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