LASTPARALLELSTATEMENT System Table Description

Description

The LASTPARALLELEDSTATEMENT table provides statistics for the last parallel execution query statement executed by the current client. These statistics are overridden with the execution of every parallel statement, but they are preserved when a non-parallel query is executed.

The table includes one row with statistics for the coordinator connection and a row with statistics for each worker that has contributed to the parallel query. The list of statistics includes the LASTSTATEMENT statistics and several additional ones described below.

Fields

Field Type Description

NODEID

bigint

Represents the identifier for the Transaction Engine (TE) where the coordinator or worker executed the query.

Deprecated in NuoDB 7.0 and later. Use STARTID instead.

STARTID

bigint

Represents the identifier for the Transaction Engine (TE) where the coordinator or worker executed the query. See Start ID.

CONNID

bigint

Represents the connection identifier where the coordinator or worker executed the query.

RECORDSDECODINGTIME

bigint

Indicates the duration in microseconds that the query coordinator spent decoding the results received from workers.
This field is NULL for workers.

WAITFORWORKERSTIME

bigint

Indicates the duration in microseconds that the query coordinator waited to receive results from workers.
This field is NULL for workers.

DISTRIBUTEQUERYTIME

bigint

Denotes the overall duration in microseconds dedicated to coordinating the workers and handling their results during the execution of the parallel query.
This field is NULL for workers.

RECORDSENCODINGTIME

bigint

Specifies the duration in microseconds that the workers spent encoding intermediate results.
This field is NULL for the coordinator.

RETURNEDSIZE

bigint

Indicates the total size of encoded intermediate results.
This fields is NULL for the cooridnator.

RETURNEDBATCHES

bigint

Denotes the number of result batches sent by the worker. This fields is NULL for the cooridnator.

WAITFORCOORDTIME

bigint

Specifies the duration in microseconds that the worker spent waiting for the coordinator to request additional results.

Example

SELECT STARTID, CONNID, DISTRIBUTEQUERYTIME, RETURNEDSIZE, EXECTIME, EXHAUSTIVEFETCHES
FROM SYSTEM.LASTDISTRIBUTEDSTATEMENT;

 STARTID CONNID  DISTRIBUTEQUERYTIME  RETURNEDSIZE  EXECTIME  EXHAUSTIVEFETCHES
 ------- ------- -------------------- ------------- --------- ------------------
    4       1          1123152           <null>      1126574             0
    3       5           <null>              190      1034131       1443840
    3       4           <null>              190      1067770       1484800
    4       4           <null>              190      1080134       1516095
    4       3           <null>              190      1112416       1556480