SYSTEMSQLEXECUTIONSLEEPS: Data Dictionary SQL Execution Sleeps |
Sleeps executed by Invantive's UniversalSQL engine during the execution of SQL statements.
Catalog: DataDictionary
Schema: Invantive
Alias: slp
Label: SQL Execution Sleeps
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 SYSTEMSQLEXECUTIONSLEEPS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACTUAL_DURATION_MS |
int64 |
Actual Duration (ms) |
|
Actual duration in milliseconds of the sleep. |
END_TIME_UTC |
datetime |
End Time |
☑ |
Time at which the sleep was completed (UTC). |
EXECUTION_ID |
guid |
SQL Execution ID |
|
ID of the SQL execution. |
EXECUTION_STEP_ID |
int64 |
SQL Execution Step ID |
|
ID of the SQL execution step. |
EXPECTED_DURATION_MS |
int64 |
Expected Duration (ms) |
|
Expected duration in milliseconds of the sleep. |
ID |
int64 |
ID |
|
Unique ID of the sleep. |
MESSAGE_CODE |
string(30) |
Message Code |
☐ |
Code of the message to indicate the origin. |
PARTITION |
string(30) |
Partition |
☐ |
Specific partition on which the sleep was executed. |
START_TIME_UTC |
datetime |
Start Time |
☑ |
Time at which the sleep was started (UTC). |
STATEMENT_ID |
guid |
SQL Statement ID |
|
ID of the SQL statement. |
TABLE_NAME |
string |
Table Name |
☐ |
Name of the table. |
18-10-2024 06:49 Version 24.0.345-PROD+4945