Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.sql.execute.rts.RunTimeStatisticsImpl

Modifier and Type	Field and Description
public Timestamp	beginCompilationTimestamp
public Timestamp	beginExecutionTimestamp
public long	bindTime
public long	compileTime
public Timestamp	endCompilationTimestamp
public Timestamp	endExecutionTimestamp
public long	executeTime
public long	generateTime
public long	optimizeTime
public long	parseTime
public String	spsName
public String	statementName
public String	statementText
public ResultSetStatistics[]	subqueryTrackingArray
public ResultSetStatistics	topResultSetStatistics

Access	Constructor and Description
public	RunTimeStatisticsImpl(String spsName, String statementName, String statementText, long compileTime, long parseTime, long bindTime, long optimizeTime, long generateTime, long executeTime, Timestamp beginCompilationTimestamp, Timestamp endCompilationTimestamp, Timestamp beginExecutionTimestamp, Timestamp endExecutionTimestamp, ResultSetStatistics[] subqueryTrackingArray, ResultSetStatistics topResultSetStatistics)

Method Summary

Modifier and Type	Method and Description
public void	acceptFromTopResultSet(XPLAINVisitor the visitor that wishes to visit the tree. v) Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.acceptFromTopResultSet. initiate a visit of an XPLAINVisitor from the top of the RS tree
public Timestamp	Returns: java.sql.Timestamp The timestamp for the beginning of query compilation. getBeginCompilationTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginCompilationTimestamp. Get the timestamp for the beginning of query compilation.
public Timestamp	Returns: java.sql.Timestamp The timestamp for the beginning of query execution. getBeginExecutionTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginExecutionTimestamp. Get the timestamp for the beginning of query execution.
public long	Returns: long The bind time for the associated query in milliseconds. getBindTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBindTimeInMillis. Get the bind time for the associated query in milliseconds.
public Vector<ResultSetStatistics>	Returns: java.util.Vector A vector of objects. getChildren() Get the objects to be displayed when this tree object is expanded.
public long	Returns: long The total compile time for the associated query in milliseconds. getCompileTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getCompileTimeInMillis. Get the total compile time for the associated query in milliseconds.
public Timestamp	Returns: java.sql.Timestamp The timestamp for the end of query compilation. getEndCompilationTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndCompilationTimestamp. Get the timestamp for the end of query compilation.
public Timestamp	Returns: java.sql.Timestamp The timestamp for the end of query execution. getEndExecutionTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndExecutionTimestamp. Get the timestamp for the end of query execution.
public double	Returns: The estimated number of rows returned by the associated query or statement. getEstimatedRowCount() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEstimatedRowCount. Get the estimated row count for the number of rows returned by the associated query or statement.
public long	Returns: long The execute time for the associated query in milliseconds. getExecuteTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getExecuteTimeInMillis. Get the execute time for the associated query in milliseconds.
public long	Returns: long The generate time for the associated query in milliseconds. getGenerateTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getGenerateTimeInMillis. Get the generate time for the associated query in milliseconds.
public long	Returns: long The optimize time for the associated query in milliseconds. getOptimizeTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getOptimizeTimeInMillis. Get the optimize time for the associated query in milliseconds.
public long	Returns: long The parse time for the associated query in milliseconds. getParseTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getParseTimeInMillis. Get the parse time for the associated query in milliseconds.
public String	Returns: java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement. getScanStatisticsText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText. Get the information on the nodes relating to table and index scans from the execution plan for the associated query or statement as a String.
public String	Returns: java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement for tableName. getScanStatisticsText(String table for which user seeks statistics. tableName) Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText. Get the information on the nodes relating to table and index scans for table tableName from the execution plan for the associated query or statement as a String.
public String	Returns: java.lang.String The SPS name of the associated query or statement. getSPSName() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getSPSName. Get the name of the Stored Prepared Statement for the statement.
public String	Returns: java.lang.String The execution plan for the associated query or statement. getStatementExecutionPlanText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementExecutionPlanText. Get the execution plan for the associated query or statement as a String.
public String	Returns: java.lang.String The name of the associated query or statement. getStatementName() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementName. Get the name of the associated query or statement.
public String	Returns: java.lang.String The text for the associated query or statement. getStatementText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementText. Get the text for the associated query or statement.
public String	toString() Overrides java.lang.Object.toString. Returns a string representation of the object.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll wait wait wait

beginCompilationTimestamp	back to summary
public Timestamp beginCompilationTimestamp

beginExecutionTimestamp	back to summary
public Timestamp beginExecutionTimestamp

bindTime	back to summary
public long bindTime

compileTime	back to summary
public long compileTime

endCompilationTimestamp	back to summary
public Timestamp endCompilationTimestamp

endExecutionTimestamp	back to summary
public Timestamp endExecutionTimestamp

executeTime	back to summary
public long executeTime

generateTime	back to summary
public long generateTime

optimizeTime	back to summary
public long optimizeTime

parseTime	back to summary
public long parseTime

spsName	back to summary
public String spsName

statementName	back to summary
public String statementName

statementText	back to summary
public String statementText

subqueryTrackingArray	back to summary
public ResultSetStatistics[] subqueryTrackingArray

topResultSetStatistics	back to summary
public ResultSetStatistics topResultSetStatistics

RunTimeStatisticsImpl	back to summary
public RunTimeStatisticsImpl(String spsName, String statementName, String statementText, long compileTime, long parseTime, long bindTime, long optimizeTime, long generateTime, long executeTime, Timestamp beginCompilationTimestamp, Timestamp endCompilationTimestamp, Timestamp beginExecutionTimestamp, Timestamp endExecutionTimestamp, ResultSetStatistics[] subqueryTrackingArray, ResultSetStatistics topResultSetStatistics)

Method Detail

acceptFromTopResultSet	back to summary
public void acceptFromTopResultSet(XPLAINVisitor v) Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.acceptFromTopResultSet. initiate a visit of an XPLAINVisitor from the top of the RS tree Parameters v:XPLAINVisitor Doc from org.apache.derby.iapi.sql.execute.RunTimeStatistics.acceptFromTopResultSet. the visitor that wishes to visit the tree.

acceptFromTopResultSet

back to summary

public void acceptFromTopResultSet(XPLAINVisitor v)

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.acceptFromTopResultSet.

initiate a visit of an XPLAINVisitor from the top of the RS tree

Parameters

v:XPLAINVisitor

Doc from org.apache.derby.iapi.sql.execute.RunTimeStatistics.acceptFromTopResultSet.

the visitor that wishes to visit the tree.

getBeginCompilationTimestamp	back to summary
public Timestamp getBeginCompilationTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginCompilationTimestamp. Get the timestamp for the beginning of query compilation. Returns:Timestamp java.sql.Timestamp The timestamp for the beginning of query compilation.

getBeginCompilationTimestamp

back to summary

public Timestamp getBeginCompilationTimestamp()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginCompilationTimestamp.

Get the timestamp for the beginning of query compilation.

Returns:Timestamp: java.sql.Timestamp The timestamp for the beginning of query compilation.

getBeginExecutionTimestamp	back to summary
public Timestamp getBeginExecutionTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginExecutionTimestamp. Get the timestamp for the beginning of query execution. Returns:Timestamp java.sql.Timestamp The timestamp for the beginning of query execution.

getBeginExecutionTimestamp

back to summary

public Timestamp getBeginExecutionTimestamp()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBeginExecutionTimestamp.

Get the timestamp for the beginning of query execution.

Returns:Timestamp: java.sql.Timestamp The timestamp for the beginning of query execution.

getBindTimeInMillis	back to summary
public long getBindTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBindTimeInMillis. Get the bind time for the associated query in milliseconds. Returns:long long The bind time for the associated query in milliseconds.

getBindTimeInMillis

back to summary

public long getBindTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getBindTimeInMillis.

Get the bind time for the associated query in milliseconds.

Returns:long: long The bind time for the associated query in milliseconds.

getChildren	back to summary
public Vector<ResultSetStatistics> getChildren() Get the objects to be displayed when this tree object is expanded. The objects returned can be of any type, including addtional Inspectables. Returns:Vector<ResultSetStatistics> java.util.Vector A vector of objects.

getChildren

back to summary

public Vector<ResultSetStatistics> getChildren()

Get the objects to be displayed when this tree object is expanded.

The objects returned can be of any type, including addtional Inspectables.

Returns:Vector<ResultSetStatistics>: java.util.Vector A vector of objects.

getCompileTimeInMillis	back to summary
public long getCompileTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getCompileTimeInMillis. Get the total compile time for the associated query in milliseconds. Compile time can be divided into parse, bind, optimize and generate times. Returns:long long The total compile time for the associated query in milliseconds.

getCompileTimeInMillis

back to summary

public long getCompileTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getCompileTimeInMillis.

Get the total compile time for the associated query in milliseconds. Compile time can be divided into parse, bind, optimize and generate times.

Returns:long: long The total compile time for the associated query in milliseconds.

getEndCompilationTimestamp	back to summary
public Timestamp getEndCompilationTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndCompilationTimestamp. Get the timestamp for the end of query compilation. Returns:Timestamp java.sql.Timestamp The timestamp for the end of query compilation.

getEndCompilationTimestamp

back to summary

public Timestamp getEndCompilationTimestamp()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndCompilationTimestamp.

Get the timestamp for the end of query compilation.

Returns:Timestamp: java.sql.Timestamp The timestamp for the end of query compilation.

getEndExecutionTimestamp	back to summary
public Timestamp getEndExecutionTimestamp() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndExecutionTimestamp. Get the timestamp for the end of query execution. Returns:Timestamp java.sql.Timestamp The timestamp for the end of query execution.

getEndExecutionTimestamp

back to summary

public Timestamp getEndExecutionTimestamp()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEndExecutionTimestamp.

Get the timestamp for the end of query execution.

Returns:Timestamp: java.sql.Timestamp The timestamp for the end of query execution.

getEstimatedRowCount	back to summary
public double getEstimatedRowCount() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEstimatedRowCount. Get the estimated row count for the number of rows returned by the associated query or statement. Returns:double The estimated number of rows returned by the associated query or statement.

getEstimatedRowCount

back to summary

public double getEstimatedRowCount()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getEstimatedRowCount.

Get the estimated row count for the number of rows returned by the associated query or statement.

Returns:double: The estimated number of rows returned by the associated query or statement.

getExecuteTimeInMillis	back to summary
public long getExecuteTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getExecuteTimeInMillis. Get the execute time for the associated query in milliseconds. Returns:long long The execute time for the associated query in milliseconds.

getExecuteTimeInMillis

back to summary

public long getExecuteTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getExecuteTimeInMillis.

Get the execute time for the associated query in milliseconds.

Returns:long: long The execute time for the associated query in milliseconds.

getGenerateTimeInMillis	back to summary
public long getGenerateTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getGenerateTimeInMillis. Get the generate time for the associated query in milliseconds. Returns:long long The generate time for the associated query in milliseconds.

getGenerateTimeInMillis

back to summary

public long getGenerateTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getGenerateTimeInMillis.

Get the generate time for the associated query in milliseconds.

Returns:long: long The generate time for the associated query in milliseconds.

getOptimizeTimeInMillis	back to summary
public long getOptimizeTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getOptimizeTimeInMillis. Get the optimize time for the associated query in milliseconds. Returns:long long The optimize time for the associated query in milliseconds.

getOptimizeTimeInMillis

back to summary

public long getOptimizeTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getOptimizeTimeInMillis.

Get the optimize time for the associated query in milliseconds.

Returns:long: long The optimize time for the associated query in milliseconds.

getParseTimeInMillis	back to summary
public long getParseTimeInMillis() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getParseTimeInMillis. Get the parse time for the associated query in milliseconds. Returns:long long The parse time for the associated query in milliseconds.

getParseTimeInMillis

back to summary

public long getParseTimeInMillis()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getParseTimeInMillis.

Get the parse time for the associated query in milliseconds.

Returns:long: long The parse time for the associated query in milliseconds.

getScanStatisticsText	back to summary
public String getScanStatisticsText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText. Get the information on the nodes relating to table and index scans from the execution plan for the associated query or statement as a String. Returns:String java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement.

getScanStatisticsText

back to summary

public String getScanStatisticsText()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText.

Get the information on the nodes relating to table and index scans from the execution plan for the associated query or statement as a String.

Returns:String: java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement.

getScanStatisticsText	back to summary
public String getScanStatisticsText(String tableName) Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText. Get the information on the nodes relating to table and index scans for table tableName from the execution plan for the associated query or statement as a String. Parameters tableName:String table for which user seeks statistics. Returns:String java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement for tableName.

getScanStatisticsText

back to summary

public String getScanStatisticsText(String tableName)

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getScanStatisticsText.

Get the information on the nodes relating to table and index scans for table tableName from the execution plan for the associated query or statement as a String.

Parameters

tableName:String: table for which user seeks statistics.

Returns:String

java.lang.String The nodes relating to table and index scans from the execution plan for the associated query or statement for tableName.

getSPSName	back to summary
public String getSPSName() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getSPSName. Get the name of the Stored Prepared Statement for the statement. Returns:String java.lang.String The SPS name of the associated query or statement.

getSPSName

back to summary

public String getSPSName()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getSPSName.

Get the name of the Stored Prepared Statement for the statement.

Returns:String: java.lang.String The SPS name of the associated query or statement.

getStatementExecutionPlanText	back to summary
public String getStatementExecutionPlanText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementExecutionPlanText. Get the execution plan for the associated query or statement as a String. Returns:String java.lang.String The execution plan for the associated query or statement.

getStatementExecutionPlanText

back to summary

public String getStatementExecutionPlanText()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementExecutionPlanText.

Get the execution plan for the associated query or statement as a String.

Returns:String: java.lang.String The execution plan for the associated query or statement.

getStatementName	back to summary
public String getStatementName() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementName. Get the name of the associated query or statement. (This will be an internally generated name if the user did not assign a name.) Returns:String java.lang.String The name of the associated query or statement.

getStatementName

back to summary

public String getStatementName()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementName.

Get the name of the associated query or statement. (This will be an internally generated name if the user did not assign a name.)

Returns:String: java.lang.String The name of the associated query or statement.

getStatementText	back to summary
public String getStatementText() Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementText. Get the text for the associated query or statement. Returns:String java.lang.String The text for the associated query or statement.

getStatementText

back to summary

public String getStatementText()

Implements org.apache.derby.iapi.sql.execute.RunTimeStatistics.getStatementText.

Get the text for the associated query or statement.

Returns:String: java.lang.String The text for the associated query or statement.

toString back to summary

toString	back to summary
public String toString() Overrides java.lang.Object.toString. Doc from java.lang.Object.toString. Returns a string representation of the object. Satisfying this method's contract implies a non-`null` result must be returned. Returns:String a string representation of the object

public String toString()

Overrides java.lang.Object.toString.

Doc from java.lang.Object.toString.

Returns a string representation of the object. Satisfying this method's contract implies a non-null result must be returned.

Returns:String: a string representation of the object

public final Class RunTimeStatisticsImpl

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail