SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS system function

The SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function returns a VARCHAR(32672) value representing the query execution plan and runtime statistics for a java.sql.ResultSet.

A query execution plan is a tree of execution nodes. There are a number of possible node types. Statistics are accumulated during execution at each node. The types of statistics include the amount of time spent in specific operations, the number of rows passed to the node by its children, and the number of rows returned by the node to its parent. (The exact statistics are specific to each node type.) SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS is most meaningful for DML statements such as SELECT, INSERT, DELETE and UPDATE.

Syntax

VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS() 

Execute privileges

By default, all users have execute privileges on this function.

Example

VALUES SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()
Related reference
SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure