The date and time when the query was started.

The name of the Data Vault repository targeted by the query.

The user authorization that executed the query.

The internal identifier for the query.

The total number of rows in the query result set.

The total number of rows from the query result set that were sent to the client.

The amount of time (in seconds, rounded from milliseconds) from when the query fetching starts to when the first data file is selected. Between these two points, a list of all the data files affected by the query is assembled from the metadata information.

The amount of time (in seconds, rounded from milliseconds) from when the first compressed data file is selected to when the first row (or block of rows, depending on the manner of fetching) is received by the client.

The total amount of time (in seconds, rounded from milliseconds) spent fetching data from compressed data files.

The total amount of time (in seconds, rounded from milliseconds) from when the query fetching starts to when the last data file is selected.

The total amount of time (in seconds, rounded from milliseconds) from when the first data file is selected to when the result set is complete.

The total number of data files accessed by the query.

The total number of processes started during the query execution. The number of processes is equal to the number of data files accessed by the query.

The maximum amount of disk space (in bytes) required by the query for temporary result set data.

The text of the SQL command for the query, split across multiple SQL

n

fields if necessary. That is, if the SQL statement exceeds the length of the

SQL1

field (4056 bytes), the first 4056 characters are put in

SQL1

and the rest is put in the

SQL2

field; if the rest of the SQL statement does not fit in

SQL2

, that field is filled and the rest is put in

SQL3

; and so on until the

SQL9

field is filled.

If the full SQL statement exceeds 36,504 characters, then the query text will be truncated at the end of the

SQL9

field.

The error code returned, if the query did not complete successfully.

The error message associated with the error code above.