LOCALEXECUTIONSTATS System Table Description
Description
A pseudo table that presents aggregate execution statistics for the Transaction Engine (TE) to which the client is connected. This is used for internal performance analysis.
Fields
| Field | Type | Description |
|---|---|---|
COMPILATIONTIME |
bigint |
The total compilation time, in microseconds, for all queries executed by this TE. |
EXECUTIONTIME |
bigint |
The total execution time, in microseconds, for all queries executed by this TE. |
REOPTIMIZATIONCOUNT |
bigint |
The total number of query reoptimzations performed by this TE. |
DISTRIBUTED_QUERY_COUNT |
bigint |
The total number of distributed queries executed by this TE. |
EXECUTION_COUNT |
bigint |
The total number of queries executed on the TE. |