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

Class RealTableScanStatistics

java.lang.Object

org.apache.derby.impl.sql.execute.rts.RealTableScanStatistics

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

public class RealTableScanStatistics
extends java.lang.Object

ResultSetStatistics implemenation for TableScanResultSet.

Field Summary

Fields

Modifier and Type	Field and Description
long	closeTime
boolean	coarserLock
long	constructorTime
int	fetchSize
java.lang.String	indexName
java.lang.String	inspectDesc
long	inspectNum
long	inspectOverall
boolean	isConstraint
java.lang.String	isolationLevel
java.lang.String	lockString
long	nextTime
int	numOpens
long	openTime
double	optimizerEstimatedCost
double	optimizerEstimatedRowCount
java.lang.String	qualifiers
int	resultSetNumber
int	rowsFiltered
int	rowsSeen
FormatableProperties	scanProperties
java.lang.String	startPosition
java.lang.String	stopPosition
java.lang.String	tableName
java.lang.String	userSuppliedOptimizerOverrides

Constructor Summary

Constructors

Constructor and Description

RealTableScanStatistics(int numOpens, int rowsSeen, int rowsFiltered, long constructorTime, long openTime, long nextTime, long closeTime, int resultSetNumber, java.lang.String tableName, java.lang.String userSuppliedOptimizerOverrides, java.lang.String indexName, boolean isConstraint, java.lang.String qualifiers, java.util.Properties scanProperties, java.lang.String startPosition, java.lang.String stopPosition, java.lang.String isolationLevel, java.lang.String lockString, int fetchSize, boolean coarserLock, double optimizerEstimatedRowCount, double optimizerEstimatedCost)

Method Summary

Modifier and Type	Method and Description
void	accept(XPLAINVisitor visitor) This method gets called to let a visitor visit this XPLAINable object.
java.util.Vector<ResultSetStatistics>	getChildren() Get the objects to be displayed when this tree object is expanded.
long	getChildrenTime() Return the time for all operations performed by the children of this node.
double	getEstimatedRowCount() Get the estimated row count for the number of rows returned by the associated query or statement.
java.lang.String	getNodeName() Format for display, a name for this node.
java.lang.String	getNodeOn() If this node is on a database item (like a table or an index), then provide a string that describes the on item.
long	getNodeTime() Return the time for all operations performed by this node, but not the time for the children of this node.
java.lang.Object	getResultSetDescriptor(java.lang.Object rsID, java.lang.Object parentID, java.lang.Object scanID, java.lang.Object sortID, java.lang.Object stmtID, java.lang.Object timingID)
java.lang.Object	getResultSetTimingsDescriptor(java.lang.Object timingID)
java.lang.String	getRSXplainDetails()
java.lang.String	getRSXplainType()
java.lang.Object	getScanPropsDescriptor(java.lang.Object scanPropsID)
java.lang.String	getScanStatisticsText(java.lang.String tableName, int depth) Return information on the scan nodes from the statement execution plan as a String.
java.lang.Object	getSortPropsDescriptor(java.lang.Object UUID)
java.lang.String	getStatementExecutionPlanText(int depth) Return the statement execution plan as a String.
long	getTotalTime() Return the time for all operations performed by this node, and the children of this node.
java.lang.String	toString()

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

isConstraint

public boolean isConstraint

coarserLock

public boolean coarserLock

fetchSize

public int fetchSize

isolationLevel

public java.lang.String isolationLevel

tableName

public java.lang.String tableName

userSuppliedOptimizerOverrides

public java.lang.String userSuppliedOptimizerOverrides

indexName

public java.lang.String indexName

lockString

public java.lang.String lockString

qualifiers

public java.lang.String qualifiers

startPosition

public java.lang.String startPosition

stopPosition

public java.lang.String stopPosition

scanProperties

public FormatableProperties scanProperties

resultSetNumber

public int resultSetNumber

numOpens

public int numOpens

rowsSeen

public int rowsSeen

rowsFiltered

public int rowsFiltered

constructorTime

public long constructorTime

openTime

public long openTime

nextTime

public long nextTime

closeTime

public long closeTime

inspectOverall

public long inspectOverall

inspectNum

public long inspectNum

inspectDesc

public java.lang.String inspectDesc

optimizerEstimatedRowCount

public double optimizerEstimatedRowCount

optimizerEstimatedCost

public double optimizerEstimatedCost

Constructor Detail

RealTableScanStatistics

public RealTableScanStatistics(int numOpens,
                               int rowsSeen,
                               int rowsFiltered,
                               long constructorTime,
                               long openTime,
                               long nextTime,
                               long closeTime,
                               int resultSetNumber,
                               java.lang.String tableName,
                               java.lang.String userSuppliedOptimizerOverrides,
                               java.lang.String indexName,
                               boolean isConstraint,
                               java.lang.String qualifiers,
                               java.util.Properties scanProperties,
                               java.lang.String startPosition,
                               java.lang.String stopPosition,
                               java.lang.String isolationLevel,
                               java.lang.String lockString,
                               int fetchSize,
                               boolean coarserLock,
                               double optimizerEstimatedRowCount,
                               double optimizerEstimatedCost)

Method Detail

getStatementExecutionPlanText

public java.lang.String getStatementExecutionPlanText(int depth)

Return the statement execution plan as a String.

Parameters:

depth - Indentation level

Returns:

String The statement executio plan as a String.

getScanStatisticsText

public java.lang.String getScanStatisticsText(java.lang.String tableName,
                                              int depth)

Return information on the scan nodes from the statement execution plan as a String.

Parameters:

depth - Indentation level.

tableName - if not NULL then print information for this table only

Returns:

String The information on the scan nodes from the statement execution plan as a String.

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

getNodeName

public java.lang.String getNodeName()

Format for display, a name for this node.

getNodeOn

public java.lang.String getNodeOn()

If this node is on a database item (like a table or an index), then provide a string that describes the on item.

accept

public void accept(XPLAINVisitor visitor)

Description copied from interface: XPLAINable

This method gets called to let a visitor visit this XPLAINable object. The general contract is to implement pre-order, depth-first traversal to produce a predictable traversal behaviour.

getRSXplainType

public java.lang.String getRSXplainType()

getRSXplainDetails

public java.lang.String getRSXplainDetails()

Specified by:

getRSXplainDetails in interface XPLAINable

getScanPropsDescriptor

public java.lang.Object getScanPropsDescriptor(java.lang.Object scanPropsID)

Specified by:

getScanPropsDescriptor in interface XPLAINable

getResultSetDescriptor

public java.lang.Object getResultSetDescriptor(java.lang.Object rsID,
                                               java.lang.Object parentID,
                                               java.lang.Object scanID,
                                               java.lang.Object sortID,
                                               java.lang.Object stmtID,
                                               java.lang.Object timingID)

Specified by:

getResultSetDescriptor in interface XPLAINable

getChildren

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

java.util.Vector A vector of objects.

getTotalTime

public long getTotalTime()

Return the time for all operations performed by this node, and the children of this node. The times included open, next, and close.

getChildrenTime

public long getChildrenTime()

Return the time for all operations performed by the children of this node.

getNodeTime

public long getNodeTime()

Return the time for all operations performed by this node, but not the time for the children of this node.

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 ResultSetStatistics

Returns:

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

getResultSetTimingsDescriptor

public java.lang.Object getResultSetTimingsDescriptor(java.lang.Object timingID)

Specified by:

getResultSetTimingsDescriptor in interface XPLAINable

getSortPropsDescriptor

public java.lang.Object getSortPropsDescriptor(java.lang.Object UUID)

Specified by:

getSortPropsDescriptor in interface XPLAINable