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

Class RealNestedLoopJoinStatistics

java.lang.Object

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

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

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

Direct Known Subclasses:

RealHashJoinStatistics, RealNestedLoopLeftOuterJoinStatistics

public class RealNestedLoopJoinStatistics
extends RealJoinResultSetStatistics

ResultSetStatistics implemenation for NestedLoopJoinResultSet.

Field Summary

Fields

Modifier and Type	Field and Description
long	closeTime
long	constructorTime
java.lang.String	inspectDesc
long	inspectNum
long	inspectOverall
ResultSetStatistics	leftResultSetStatistics
long	nextTime
int	numOpens
boolean	oneRowRightSide
long	openTime
double	optimizerEstimatedCost
double	optimizerEstimatedRowCount
java.lang.String	resultSetName
int	resultSetNumber
ResultSetStatistics	rightResultSetStatistics
int	rowsFiltered
int	rowsSeen

Fields inherited from class org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics

restrictionTime, rowsReturned, rowsSeenLeft, rowsSeenRight, userSuppliedOptimizerOverrides

Constructor Summary

Constructors

Constructor and Description

RealNestedLoopJoinStatistics(int numOpens, int rowsSeen, int rowsFiltered, long constructorTime, long openTime, long nextTime, long closeTime, int resultSetNumber, int rowsSeenLeft, int rowsSeenRight, int rowsReturned, long restrictionTime, boolean oneRowRightSide, double optimizerEstimatedRowCount, double optimizerEstimatedCost, java.lang.String userSuppliedOptimizerOverrides, ResultSetStatistics leftResultSetStatistics, ResultSetStatistics rightResultSetStatistics)

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.String	getRSXplainDetails()
java.lang.String	getRSXplainType()
java.lang.Object	getScanPropsDescriptor(java.lang.Object UUID)
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 org.apache.derby.impl.sql.execute.rts.RealJoinResultSetStatistics

getResultSetDescriptor, getResultSetTimingsDescriptor

Methods inherited from class java.lang.Object

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

Field Detail

oneRowRightSide

public boolean oneRowRightSide

leftResultSetStatistics

public ResultSetStatistics leftResultSetStatistics

rightResultSetStatistics

public ResultSetStatistics rightResultSetStatistics

resultSetName

public java.lang.String resultSetName

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

RealNestedLoopJoinStatistics

public RealNestedLoopJoinStatistics(int numOpens,
                                    int rowsSeen,
                                    int rowsFiltered,
                                    long constructorTime,
                                    long openTime,
                                    long nextTime,
                                    long closeTime,
                                    int resultSetNumber,
                                    int rowsSeenLeft,
                                    int rowsSeenRight,
                                    int rowsReturned,
                                    long restrictionTime,
                                    boolean oneRowRightSide,
                                    double optimizerEstimatedRowCount,
                                    double optimizerEstimatedCost,
                                    java.lang.String userSuppliedOptimizerOverrides,
                                    ResultSetStatistics leftResultSetStatistics,
                                    ResultSetStatistics rightResultSetStatistics)

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 execution 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

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.

getNodeName

public java.lang.String getNodeName()

Format for display, a name for this node.

Overrides:

getNodeName in class RealJoinResultSetStatistics

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

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.

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.

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.

getSortPropsDescriptor

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

Specified by:

getSortPropsDescriptor in interface XPLAINable

getScanPropsDescriptor

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

Specified by:

getScanPropsDescriptor in interface XPLAINable