SYSXPLAIN_STATEMENTS system table

The SYSXPLAIN_STATEMENTS table captures information about statements which have been executed using RUNTIMESTATISTICS with XPLAIN style.

See "Working with RunTimeStatistics" in Tuning Derby for information on how to configure this.

Each row in this table describes a single statement which has been captured. Depending on the precise configuration of the RUNTIMESTATISTICS and XPLAIN features, there may be additional rows in the other XPLAIN system tables with additional information; the STMT_ID and TIMING_ID columns in this table are used to join against those tables.

Rows in this table are added automatically when Derby has been configured appropriately. The rows remain in the table until you delete them or drop the table.

The following table shows the contents of the SYSXPLAIN_STATEMENTS system table.

Table 1. SYSXPLAIN_STATEMENTS system table
Column Name Type Length Nullable Contents
STMT_ID CHAR 36 false A unique identifier for this particular captured statement.
STMT_NAME VARCHAR 128 true The name of the associated query or statement. This value is NULL if the user did not assign a name (by calling java.sql.Statement.setCursorName()).
STMT_TYPE CHAR 3 false A code indicating what type of statement this is: 'S' for SELECT, 'I' for INSERT, 'U' for UPDATE, 'D' for DELETE, 'C' for CALL, 'DDL' for Data Definition (such as CREATE TABLE), 'SA' for SELECT (Approximate), or blank, indicating the statement was a comment.
STMT_TEXT VARCHAR 32,672 false The text of the statement.
JVM_ID VARCHAR 32,672 false A code indicating what version of the JVM was running when this statement was captured: '4' for J2SE_14 (JDK 1.4.0 or 1.4.1), '5' for J2SE_142 (JDK 1.4.2), '6' for J2SE_15 (JDK 1.5), or '7' for J2SE_16 (JDK 1.6).
OS_IDENTIFIER VARCHAR 32,672 false Contains information about the operating system which was being used when this statement was captured.
XPLAIN_MODE CHAR 1 true A code indicating the XPLAIN mode which was in use when this statement was captured: 'F' for FULL, or 'O' for ONLY.
XPLAIN_TIME TIMESTAMP 29 true Contains the date and time when this statement was captured.
XPLAIN_THREAD_ID VARCHAR 32,672 false The JVM thread which was running when this statement was captured
TRANSACTION_ID VARCHAR 32,672 false An internal identifier for the transaction which was active when this statement was captured.
SESSION_ID VARCHAR 32,672 false An internal identifier for the session which was active when this statement was captured.
DATABASE_NAME VARCHAR 128 false Contains the name of the database which was being used when this statement was captured.
DRDA_ID VARCHAR 32,672 true In a network environment, this column contains an internal identifier for the network connection which was active when this statement was captured. In an embedded environment, this column is null.
TIMING_ID CHAR 36 true This field will be NULL unless SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING has been called to enable statistics timing. If statistics timings are being captured, then this column will contain the ID of the row in SYSXPLAIN_STATEMENT_TIMINGS which records the statement timing for this statement.