CONSTRUCTOR_TIME
Derby Reference Manual
250
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_RESULTSET_TIMINGS
system table.
Table 65.
SYSXPLAIN_RESULTSET_TIMINGS system table
Column Name
Type
Length
Nullable
Contents
TIMING_ID
CHAR
36
false
A unique ID for this
particular row. This
column can be used
to join against the
TIMING_ID column
in the SYSXPLAIN_RESULTSETS
table.
CONSTRUCTOR_TIME
BIGINT
20
true
The time it took to
construct this instance
of this result set, in
milliseconds.
OPEN_TIME
BIGINT
20
true
The time it took to
open this instance
of this result set, in
milliseconds. Note that
if this result set was
opened multiple times,
this column is the sum
of all the individual
open times.
NEXT_TIME
BIGINT
20
true
The accumulated
time for all the calls
to fetch the next row
from this result set, in
milliseconds, for all the
opens of this result set.
CLOSE_TIME
BIGINT
20
true
The time it took to
close this instance
of the result set, in
milliseconds.
EXECUTE_TIME
BIGINT
20
true
The time for all
operations performed
by this result set,
excluding the time
taken by all the children
result sets of this result
set, in milliseconds.
AVG_NEXT_TIME_PER_ROW
BIGINT
20
true
If there was at least
one row returned
from this result set,
then this value is the
NEXT_TIME value
divided by the number