# 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()

Parent topic: Built-in system functions
Related reference
SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure