SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps |
Individual processing steps executed by Invantive's UniversalSQL engine during the execution of SQL statements, their relationships and their statistics.
Catalog: DataDictionary
Schema: Invantive
Alias: sep
Label: SQL Execution Steps
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMSQLEXECUTIONSTEPS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ALIAS |
string(240) |
Alias |
☐ |
Alias of the result set. |
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. |
DEPTH |
int32 |
Depth |
☑ |
Depth of the step. |
DESCRIPTION |
string(240) |
Description |
☐ |
Description of the step. |
DURATION_CPU_MS |
int64 |
|
☐ |
Duration in milliseconds of CPU usage on this step. |
DURATION_IO_MS |
int64 |
|
☐ |
Duration in milliseconds of the I/O on this step. |
DURATION_MS |
int64 |
Duration (ms) |
☐ |
Duration in milliseconds of the step. |
DURATION_SLEEP_MS |
int64 |
|
☐ |
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). |
EXECUTION_ID |
guid |
Execution ID |
☑ |
Unique ID of the SQL statement execution. |
EXECUTION_OPTIONS_ID |
guid |
Execution Options ID |
☐ |
Execution options ID. |
FINGER_PRINT |
string(240) |
Finger Print |
☑ |
Unique finger print |
ID |
int64 |
ID |
☑ |
Unique ID of the step. |
MANAGED_THREAD_ID |
int32 |
Managed Thread ID |
☐ |
Managed thread ID. |
PARAMETERS |
string(1000) |
Parameters |
☐ |
Parameters of the step. |
PARENT_ID |
int64 |
Parent ID |
☐ |
ID of the parent step. |
REQUEST_ID |
string(60) |
Request ID |
☐ |
Request ID. |
ROOT_ID |
int64 |
Root ID |
☑ |
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. |
START_TIME_UTC |
datetime |
Start Time |
☐ |
Time at which the SQL execution step was started (UTC). |
STATEMENT_ID |
guid |
Statement ID |
☑ |
Unique ID of the SQL statement. |
STEP_DURATION_CLOCK_MS |
int64 |
Step Duration Clock (ms) |
☐ |
Duration in milliseconds of the step (excluding children). |
STEP_DURATION_CPU_MS |
int64 |
|
☐ |
Duration in milliseconds of CPU usage on this step (excluding children). |
STEP_DURATION_IO_MS |
int64 |
|
☐ |
Duration in milliseconds of the I/O on this step (excluding children). |
STEP_DURATION_SLEEP_MS |
int64 |
Step Duration Sleeping (ms) |
☐ |
Duration in milliseconds of the sleep on this step (excluding children). |
TASK_ID |
int32 |
Task ID |
☐ |
Task ID. |
18-10-2024 06:49 Version 24.0.345-PROD+4945