SYSTEMSQLAREA: Data Dictionary SQL Statements Executed |
All SQL statements executed by Invantive's UniversalSQL engine.
Catalog: DataDictionary
Schema: Invantive
Alias: saa
Label: SQL Statements Executed
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 SYSTEMSQLAREA are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
EXECUTIONS |
int32 |
Executions |
☑ |
Number of executions. |
FINGER_PRINT |
string(240) |
Finger Print |
☑ |
Unique finger print |
FIRST_END_TIME |
datetime |
First End Time |
☑ |
Time at which the SQL was first executed (UTC). |
FIRST_START_TIME |
datetime |
First Start Time |
☑ |
Time at which the SQL was first executed (UTC). |
ID |
guid |
ID |
☑ |
Unique ID. |
LAST_END_TIME |
datetime |
Last End Time |
☑ |
Time at which the SQL was last executed (UTC). |
LAST_START_TIME |
datetime |
Last Start Time |
☑ |
Time at which the SQL was last executed (UTC). |
MANAGED_THREAD_ID |
int32 |
Managed Thread ID |
☐ |
Managed thread ID. |
NUMBER_OF_FIELDS |
int32 |
Number of Fields |
☑ |
Number of fields in the result set. |
NUMBER_OF_MANAGED_THREADS |
int32 |
Number of Managed Threads |
☑ |
Number of managed threads. |
NUMBER_OF_REQUESTS |
int32 |
Number of Requests |
☑ |
Number of requests. |
NUMBER_OF_TASKS |
int32 |
Number of Tasks |
☑ |
Number of tasks. |
PARAMETER_VALUES |
string(4000) |
Parameter Values |
☐ |
Parameter values. |
REQUEST_ID |
string(60) |
Request ID |
☐ |
Request ID. |
ROW_COUNT |
int64 |
Rows |
☑ |
Number of rows retrieved. |
SQL_STATEMENT |
string(4000) |
SQL Statement |
☑ |
SQL statement. |
TASK_ID |
int32 |
Task ID |
☐ |
Task ID. |
18-10-2024 06:49 Version 24.0.345-PROD+4945