Individual processing steps executed by the Invantive SQL 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 SQL 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.
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. |
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_MS |
int64 |
Duration (ms) |
|
Duration in milliseconds of the 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). |
ID |
int32 |
ID |
|
Unique ID of the step. |
PARAMETERS |
string(240) |
Parameters |
☐ |
Parameters of the step. |
PARENT_ID |
int32 |
Parent ID |
|
ID of the parent step. |
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). |
17-05-2021 11:57 Version 20.1.419-BETA+3191