Top area of the window
The top area of any window that shows function statistics contains general
information about the function.
The columns in the window show both those statistics that were gathered at
the time of the explain, and those that currently exist in the system catalog
tables.
Rows in the windows showing function statistics
The following information is contained in the rows of the windows showing
function statistics:
- IOS_PER_INVOC
- The estimated number of read/write requests executed each time a function
is executed.
- INSTS_PER_INVOC
- The estimated number of machine instructions executed each time a function
is executed.
- IOS_PER_ARGBYTE
- The estimated number of read/write requests executed per input argument
byte.
- INSTS_PER_ARGBYTE
- The estimated number of machine instructions executed per input argument
byte.
- INITIAL_IOS
- The estimated number of read/write requests executed only the first or
last time the function is invoked.
- INITIAL_INSTS
- The estimated number of machine instructions executed only the first or
last time the function is invoked.
- PERCENT_ARGBYTE
- The estimated average percent of input argument bytes that the function
will actually process.