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

Class RealHashLeftOuterJoinStatistics

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

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

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

public class RealHashLeftOuterJoinStatistics
extends RealNestedLoopLeftOuterJoinStatistics

ResultSetStatistics implemenation for HashLeftOuterJoinResultSet.

Field Summary

Fields

Modifier and Type	Field and Description
long	closeTime
long	constructorTime
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.RealNestedLoopLeftOuterJoinStatistics

emptyRightRowsReturned

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

RealHashLeftOuterJoinStatistics(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.Object	getSortPropsDescriptor(java.lang.Object UUID)
long	getTotalTime() Return the time for all operations performed by this node, and the children of this node.

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

getScanStatisticsText, getStatementExecutionPlanText, 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

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

RealHashLeftOuterJoinStatistics

public RealHashLeftOuterJoinStatistics(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

getRSXplainType

public java.lang.String getRSXplainType()

Specified by:

getRSXplainType in interface XPLAINable

Overrides:

getRSXplainType in class RealNestedLoopLeftOuterJoinStatistics

getRSXplainDetails

public java.lang.String getRSXplainDetails()

Specified by:

getRSXplainDetails in interface XPLAINable

Overrides:

getRSXplainDetails in class RealNestedLoopLeftOuterJoinStatistics

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 RealNestedLoopLeftOuterJoinStatistics

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