SYSXPLAIN_STATEMENT_TIMINGS system table The SYSXPLAIN_STATEMENT_TIMINGS table captures information about statement timings which occurred during statements that were executed using RUNTIMESTATISTICS with XPLAIN style. system tablesSYSXPLAIN_STATEMENT_TIMINGS XPLAIN style statisticsSYSXPLAIN_STATEMENT_TIMINGS system table SYSXPLAIN_STATEMENT_TIMINGS system table

See "Working with RunTimeStatistics" in for information on how to configure this. Note in particular that you must call SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1) to enable timing information to be captured. Rows in this table are typically joined with rows in SYSXPLAIN_STATEMENTS and SYSXPLAIN_RESULTSETS during analysis. For example:

select s.stmt_text, st.execute_time from my_stats.sysxplain_statements s, my_stats.sysxplain_statement_timings st where s.timing_id = st.timing_id order by st.execute_time desc

Rows in this table are added automatically when 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_STATEMENT_TIMINGS system table.

SYSXPLAIN_STATEMENT_TIMINGS system tableFor each column in the SYSXPLAIN_STATEMENT_TIMINGS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. Column Name Type Length Nullable Contents TIMING_ID CHAR 36 false A unique identifier for this particular row. This column can be used to join with the TIMING_ID column in SYSXPLAIN_STATEMENTS to match statement timings with their corresponding statements. PARSE_TIME BIGINT 20 false The time in milliseconds that took to parse this statement. BIND_TIME BIGINT 20 false The time in milliseconds that took to bind this statement. Binding a statement is the process of resolving table and column references in the statement against the table and column definitions in the system catalogs. OPTIMIZE_TIME BIGINT 20 false The time in milliseconds that took to optimize this statement. During optimization, considers the various possible execution plans that could be used for the statement, and chooses the one it thinks will be best. GENERATE_TIME BIGINT 20 false The time in milliseconds that took to generate code for this statement. COMPILE_TIME BIGINT 20 false The time in milliseconds that took to compile this statement. Overall statement time is divided into compile time and execute time, and the compile time is further sub-divided into parse, bind, optimize, and generate time. EXECUTE_TIME BIGINT 20 false The time in milliseconds that took to execute this statement. BEGIN_COMP_TIME TIMESTAMP 29 false The time at which began to compile this statement. END_COMP_TIME TIMESTAMP 29 false The time at which finished compiling this statement. BEGIN_EXE_TIME TIMESTAMP 29 false The time at which began to execute this statement. END_EXE_TIME TIMESTAMP 29 false The time at which finished executing this statement.