|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface RunTimeStatistics
A RunTimeStatistics object is a representation of the query execution plan and run time 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 (if STATISTICS TIMING is SET ON), the number of rows passed to the node by its child(ren) and the number of rows returned by the node to its parent. (The exact statistics are specific to each node type.)
RunTimeStatistics is most meaningful for DML statements (SELECT, INSERT, DELETE and UPDATE).
Method Summary | |
---|---|
void |
acceptFromTopResultSet(XPLAINVisitor v)
Initiate a visit of the ResultSetStatistics tree from the top. |
java.sql.Timestamp |
getBeginCompilationTimestamp()
Get the timestamp for the beginning of query compilation. |
java.sql.Timestamp |
getBeginExecutionTimestamp()
Get the timestamp for the beginning of query execution. |
long |
getBindTimeInMillis()
Get the bind time for the associated query in milliseconds. |
long |
getCompileTimeInMillis()
Get the total compile time for the associated query in milliseconds. |
java.sql.Timestamp |
getEndCompilationTimestamp()
Get the timestamp for the end of query compilation. |
java.sql.Timestamp |
getEndExecutionTimestamp()
Get the timestamp for the end of query execution. |
double |
getEstimatedRowCount()
Get the estimated row count for the number of rows returned by the associated query or statement. |
long |
getExecuteTimeInMillis()
Get the execute time for the associated query in milliseconds. |
long |
getGenerateTimeInMillis()
Get the generate time for the associated query in milliseconds. |
long |
getOptimizeTimeInMillis()
Get the optimize time for the associated query in milliseconds. |
long |
getParseTimeInMillis()
Get the parse time for the associated query in milliseconds. |
java.lang.String |
getScanStatisticsText()
Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement. |
java.lang.String |
getScanStatisticsText(java.lang.String tableName)
Get a String representation of the information on the nodes relating to table and index scans from the execution plan for the associated query or statement for a particular table. |
java.lang.String |
getSPSName()
Get the name of the Stored Prepared Statement used for the statement. |
java.lang.String |
getStatementExecutionPlanText()
Get a String representation of the execution plan for the associated query or statement. |
java.lang.String |
getStatementName()
Get the name of the associated query or statement. |
java.lang.String |
getStatementText()
Get the text for the associated query or statement. |
Method Detail |
---|
long getCompileTimeInMillis()
0 is returned if STATISTICS TIMING is not SET ON.
long getParseTimeInMillis()
0 is returned if STATISTICS TIMING is not SET ON.
long getBindTimeInMillis()
long getOptimizeTimeInMillis()
0 is returned if STATISTICS TIMING is not SET ON.
long getGenerateTimeInMillis()
0 is returned if STATISTICS TIMING is not SET ON.
long getExecuteTimeInMillis()
0 is returned if STATISTICS TIMING is not SET ON.
java.sql.Timestamp getBeginCompilationTimestamp()
A null is returned if STATISTICS TIMING is not SET ON.
java.sql.Timestamp getEndCompilationTimestamp()
A null is returned if STATISTICS TIMING is not SET ON.
java.sql.Timestamp getBeginExecutionTimestamp()
A null is returned if STATISTICS TIMING is not SET ON.
java.sql.Timestamp getEndExecutionTimestamp()
A null is returned if STATISTICS TIMING is not SET ON.
java.lang.String getStatementName()
java.lang.String getSPSName()
Note that the name is returned in the schema.name format (e.g. APP.MYSTMT).
java.lang.String getStatementText()
java.lang.String getStatementExecutionPlanText()
java.lang.String getScanStatisticsText()
java.lang.String getScanStatisticsText(java.lang.String tableName)
tableName
- The table for which user desires statistics.
double getEstimatedRowCount()
void acceptFromTopResultSet(XPLAINVisitor v)
v
- the visitor that wishes to visit the tree.
|
Built on Thu 2011-03-10 11:54:14+0000, from revision ??? | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |