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

Class RealNestedLoopLeftOuterJoinStatistics

java.lang.Object

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

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

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

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

Direct Known Subclasses:

RealHashLeftOuterJoinStatistics

public class RealNestedLoopLeftOuterJoinStatistics
extends RealNestedLoopJoinStatistics

ResultSetStatistics implemenation for NestedLoopLeftOuterJoinResultSet.

Field Summary

Fields

Modifier and Type	Field and Description
long	closeTime
long	constructorTime
int	emptyRightRowsReturned
java.lang.String	inspectDesc
long	inspectNum
long	inspectOverall
long	nextTime
int	numOpens
long	openTime
double	optimizerEstimatedCost
double	optimizerEstimatedRowCount
int	resultSetNumber
int	rowsFiltered
int	rowsSeen

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

leftResultSetStatistics, oneRowRightSide, resultSetName, rightResultSetStatistics

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

restrictionTime, rowsReturned, rowsSeenLeft, rowsSeenRight, userSuppliedOptimizerOverrides

Constructor Summary

Constructors

Constructor and Description

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

Method Summary

Modifier and Type	Method and Description
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	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.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.RealNestedLoopJoinStatistics

accept, getChildren, getNodeName

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

getResultSetTimingsDescriptor

Methods inherited from class java.lang.Object

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

Field Detail

emptyRightRowsReturned

public int emptyRightRowsReturned

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

RealNestedLoopLeftOuterJoinStatistics

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

Method Detail

getStatementExecutionPlanText

public java.lang.String getStatementExecutionPlanText(int depth)

Return the statement execution plan as a String.

Specified by:

getStatementExecutionPlanText in interface ResultSetStatistics

Overrides:

getStatementExecutionPlanText in class RealNestedLoopJoinStatistics

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.

Specified by:

getScanStatisticsText in interface ResultSetStatistics

Overrides:

getScanStatisticsText in class RealNestedLoopJoinStatistics

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 RealNestedLoopJoinStatistics

getRSXplainType

public java.lang.String getRSXplainType()

Specified by:

getRSXplainType in interface XPLAINable

Overrides:

getRSXplainType in class RealNestedLoopJoinStatistics

getRSXplainDetails

public java.lang.String getRSXplainDetails()

Specified by:

getRSXplainDetails in interface XPLAINable

Overrides:

getRSXplainDetails in class RealNestedLoopJoinStatistics

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

Overrides:

getResultSetDescriptor in class RealJoinResultSetStatistics

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