org.apache.derby.impl.sql.execute.rts
Class RunTimeStatisticsImpl

java.lang.Object
  org.apache.derby.impl.sql.execute.rts.RunTimeStatisticsImpl

All Implemented Interfaces:

RunTimeStatistics

public final class RunTimeStatisticsImpl
extends java.lang.Object
implements RunTimeStatistics

RunTimeStatistics implemenation.

Field Summary

java.sql.Timestamp	beginCompilationTimestamp
java.sql.Timestamp	beginExecutionTimestamp
long	bindTime
long	compileTime
java.sql.Timestamp	endCompilationTimestamp
java.sql.Timestamp	endExecutionTimestamp
long	executeTime
long	generateTime
long	optimizeTime
long	parseTime
java.lang.String	spsName
java.lang.String	statementName
java.lang.String	statementText
ResultSetStatistics[]	subqueryTrackingArray
ResultSetStatistics	topResultSetStatistics

Constructor Summary

RunTimeStatisticsImpl(java.lang.String spsName, java.lang.String statementName, java.lang.String statementText, long compileTime, long parseTime, long bindTime, long optimizeTime, long generateTime, long executeTime, java.sql.Timestamp beginCompilationTimestamp, java.sql.Timestamp endCompilationTimestamp, java.sql.Timestamp beginExecutionTimestamp, java.sql.Timestamp endExecutionTimestamp, ResultSetStatistics[] subqueryTrackingArray, ResultSetStatistics topResultSetStatistics)

Method Summary

void	acceptFromTopResultSet(XPLAINVisitor v) initiate a visit of an XPLAINVisitor from the top of the RS tree
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.
java.util.Vector	getChildren() Get the objects to be displayed when this tree object is expanded.
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 the information on the nodes relating to table and index scans from the execution plan for the associated query or statement as a String.
java.lang.String	getScanStatisticsText(java.lang.String tableName) 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.
java.lang.String	getSPSName() Get the name of the Stored Prepared Statement for the statement.
java.lang.String	getStatementExecutionPlanText() Get the execution plan for the associated query or statement as a String.
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.
java.lang.String	toString()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

statementText

public java.lang.String statementText

statementName

public java.lang.String statementName

spsName

public java.lang.String spsName

parseTime

public long parseTime

bindTime

public long bindTime

optimizeTime

public long optimizeTime

generateTime

public long generateTime

compileTime

public long compileTime

executeTime

public long executeTime

beginCompilationTimestamp

public java.sql.Timestamp beginCompilationTimestamp

endCompilationTimestamp

public java.sql.Timestamp endCompilationTimestamp

beginExecutionTimestamp

public java.sql.Timestamp beginExecutionTimestamp

endExecutionTimestamp

public java.sql.Timestamp endExecutionTimestamp

topResultSetStatistics

public ResultSetStatistics topResultSetStatistics

subqueryTrackingArray

public ResultSetStatistics[] subqueryTrackingArray

Constructor Detail

RunTimeStatisticsImpl

public RunTimeStatisticsImpl(java.lang.String spsName,
                             java.lang.String statementName,
                             java.lang.String statementText,
                             long compileTime,
                             long parseTime,
                             long bindTime,
                             long optimizeTime,
                             long generateTime,
                             long executeTime,
                             java.sql.Timestamp beginCompilationTimestamp,
                             java.sql.Timestamp endCompilationTimestamp,
                             java.sql.Timestamp beginExecutionTimestamp,
                             java.sql.Timestamp endExecutionTimestamp,
                             ResultSetStatistics[] subqueryTrackingArray,
                             ResultSetStatistics topResultSetStatistics)

Method Detail

getCompileTimeInMillis

public long getCompileTimeInMillis()

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

Specified by:

getCompileTimeInMillis in interface RunTimeStatistics

Returns:

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

getParseTimeInMillis

public long getParseTimeInMillis()

Get the parse time for the associated query in milliseconds.

Specified by:

getParseTimeInMillis in interface RunTimeStatistics

Returns:

long The parse time for the associated query in milliseconds.

getBindTimeInMillis

public long getBindTimeInMillis()

Get the bind time for the associated query in milliseconds.

Specified by:

getBindTimeInMillis in interface RunTimeStatistics

Returns:

long The bind time for the associated query in milliseconds.

getOptimizeTimeInMillis

public long getOptimizeTimeInMillis()

Get the optimize time for the associated query in milliseconds.

Specified by:

getOptimizeTimeInMillis in interface RunTimeStatistics

Returns:

long The optimize time for the associated query in milliseconds.

getGenerateTimeInMillis

public long getGenerateTimeInMillis()

Get the generate time for the associated query in milliseconds.

Specified by:

getGenerateTimeInMillis in interface RunTimeStatistics

Returns:

long The generate time for the associated query in milliseconds.

getExecuteTimeInMillis

public long getExecuteTimeInMillis()

Get the execute time for the associated query in milliseconds.

Specified by:

getExecuteTimeInMillis in interface RunTimeStatistics

Returns:

long The execute time for the associated query in milliseconds.

getBeginCompilationTimestamp

public java.sql.Timestamp getBeginCompilationTimestamp()

Get the timestamp for the beginning of query compilation.

Specified by:

getBeginCompilationTimestamp in interface RunTimeStatistics

Returns:

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

getEndCompilationTimestamp

public java.sql.Timestamp getEndCompilationTimestamp()

Get the timestamp for the end of query compilation.

Specified by:

getEndCompilationTimestamp in interface RunTimeStatistics

Returns:

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

getBeginExecutionTimestamp

public java.sql.Timestamp getBeginExecutionTimestamp()

Get the timestamp for the beginning of query execution.

Specified by:

getBeginExecutionTimestamp in interface RunTimeStatistics

Returns:

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

getEndExecutionTimestamp

public java.sql.Timestamp getEndExecutionTimestamp()

Get the timestamp for the end of query execution.

Specified by:

getEndExecutionTimestamp in interface RunTimeStatistics

Returns:

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

getStatementName

public java.lang.String 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.)

Specified by:

getStatementName in interface RunTimeStatistics

Returns:

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

getSPSName

public java.lang.String getSPSName()

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

Specified by:

getSPSName in interface RunTimeStatistics

Returns:

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

getStatementText

public java.lang.String getStatementText()

Get the text for the associated query or statement.

Specified by:

getStatementText in interface RunTimeStatistics

Returns:

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

getEstimatedRowCount

public double getEstimatedRowCount()

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

Specified by:

getEstimatedRowCount in interface RunTimeStatistics

Returns:

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

getStatementExecutionPlanText

public java.lang.String getStatementExecutionPlanText()

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

Specified by:

getStatementExecutionPlanText in interface RunTimeStatistics

Returns:

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

getScanStatisticsText

public java.lang.String 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.

Specified by:

getScanStatisticsText in interface RunTimeStatistics

Returns:

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

getScanStatisticsText

public java.lang.String getScanStatisticsText(java.lang.String tableName)

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.

Specified by:

getScanStatisticsText in interface RunTimeStatistics

Parameters:

tableName - table for which user seeks statistics.

Returns:

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

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getChildren

public java.util.Vector 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:

java.util.Vector A vector of objects.

acceptFromTopResultSet

public void acceptFromTopResultSet(XPLAINVisitor v)

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

Specified by:

acceptFromTopResultSet in interface RunTimeStatistics

Parameters:

v - the visitor that wishes to visit the tree.