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

Class RealSetOpResultSetStatistics

java.lang.Object

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

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

public class RealSetOpResultSetStatistics
extends java.lang.Object

ResultSetStatistics implementation for SetOpResultSet.

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
long	openTime
double	optimizerEstimatedCost
double	optimizerEstimatedRowCount
int	opType
int	resultSetNumber
ResultSetStatistics	rightResultSetStatistics
int	rowsFiltered
int	rowsReturned
int	rowsSeen
int	rowsSeenLeft
int	rowsSeenRight

Constructor Summary

Constructors

Constructor and Description

RealSetOpResultSetStatistics(int opType, int numOpens, int rowsSeen, int rowsFiltered, long constructorTime, long openTime, long nextTime, long closeTime, int resultSetNumber, int rowsSeenLeft, int rowsSeenRight, int rowsReturned, double optimizerEstimatedRowCount, double optimizerEstimatedCost, ResultSetStatistics leftResultSetStatistics, ResultSetStatistics rightResultSetStatistics) Constructs a new RealSetOpResultSetStatistics object to represent the runtime statistics for SetOpResultSet.

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() Retrieves the children runtime statistics of this RealSetOpResultSetStatistics object
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 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() Return the runtime statistics of this object in textual representation

Methods inherited from class java.lang.Object

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

Field Detail

opType

public int opType

rowsSeenLeft

public int rowsSeenLeft

rowsSeenRight

public int rowsSeenRight

rowsReturned

public int rowsReturned

leftResultSetStatistics

public ResultSetStatistics leftResultSetStatistics

rightResultSetStatistics

public ResultSetStatistics rightResultSetStatistics

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

RealSetOpResultSetStatistics

public RealSetOpResultSetStatistics(int opType,
                                    int numOpens,
                                    int rowsSeen,
                                    int rowsFiltered,
                                    long constructorTime,
                                    long openTime,
                                    long nextTime,
                                    long closeTime,
                                    int resultSetNumber,
                                    int rowsSeenLeft,
                                    int rowsSeenRight,
                                    int rowsReturned,
                                    double optimizerEstimatedRowCount,
                                    double optimizerEstimatedCost,
                                    ResultSetStatistics leftResultSetStatistics,
                                    ResultSetStatistics rightResultSetStatistics)

Constructs a new RealSetOpResultSetStatistics object to represent the runtime statistics for SetOpResultSet.

Parameters:

opType - set operation type

numOpens - number of open

rowsSeen - rows seen

rowsFiltered - rows filtered

constructorTime - the time for construction

openTime - the time for open operation

nextTime - the time for next operation

closeTime - the time for close operation

resultSetNumber - the result set number

rowsSeenLeft - rows seen by left source input

rowsSeenRight - rows seen by right source input

rowsReturned - rows returned

optimizerEstimatedRowCount - optimizer estimated row count

optimizerEstimatedCost - optimizer estimated cost

leftResultSetStatistics - left source runtime statistics

rightResultSetStatistics - right source runtime statistics

See Also:

SetOpResultSet

Method Detail

getStatementExecutionPlanText

public java.lang.String getStatementExecutionPlanText(int depth)

Return the statement execution plan as a String.

Parameters:

depth - Indentation level.

Returns:

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()

Return the runtime statistics of this object in textual representation

Overrides:

toString in class java.lang.Object

Returns:

the runtime statistics of this object in textual representation as a String.

getChildren

public java.util.Vector<ResultSetStatistics> getChildren()

Retrieves the children runtime statistics of this RealSetOpResultSetStatistics object

Returns:

the children runtime statistics of this RealSetOpResultSetStatistics object stored in a Vector.

getNodeName

public java.lang.String getNodeName()

Format for display, a name for this node.

Returns:

the name of the node as a String.

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

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

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.

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

getScanPropsDescriptor

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

Specified by:

getScanPropsDescriptor in interface XPLAINable