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

Class RealDistinctScanStatistics

java.lang.Object

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

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

All Implemented Interfaces:

ResultSetStatistics, XPLAINable

public class RealDistinctScanStatistics
extends RealHashScanStatistics

ResultSetStatistics implemenation for DistinctScanResultSet.

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.RealHashScanStatistics

hashKeyColumns, hashtableSize, indexName, isConstraint, isolationLevel, lockString, nextQualifiers, scanProperties, scanQualifiers, startPosition, stopPosition, tableName

Constructor Summary

Constructors

Constructor and Description

RealDistinctScanStatistics(int numOpens, int rowsSeen, int rowsFiltered, long constructorTime, long openTime, long nextTime, long closeTime, int resultSetNumber, java.lang.String tableName, java.lang.String indexName, boolean isConstraint, int hashtableSize, int[] hashKeyColumns, java.lang.String scanQualifiers, java.lang.String nextQualifiers, java.util.Properties scanProperties, java.lang.String startPosition, java.lang.String stopPosition, java.lang.String isolationLevel, java.lang.String lockString, 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	getResultSetTimingsDescriptor(java.lang.Object timingID)
java.lang.String	getRSXplainType()
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.RealHashScanStatistics

getResultSetDescriptor, getRSXplainDetails, getScanPropsDescriptor

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

RealDistinctScanStatistics

public RealDistinctScanStatistics(int numOpens,
                                  int rowsSeen,
                                  int rowsFiltered,
                                  long constructorTime,
                                  long openTime,
                                  long nextTime,
                                  long closeTime,
                                  int resultSetNumber,
                                  java.lang.String tableName,
                                  java.lang.String indexName,
                                  boolean isConstraint,
                                  int hashtableSize,
                                  int[] hashKeyColumns,
                                  java.lang.String scanQualifiers,
                                  java.lang.String nextQualifiers,
                                  java.util.Properties scanProperties,
                                  java.lang.String startPosition,
                                  java.lang.String stopPosition,
                                  java.lang.String isolationLevel,
                                  java.lang.String lockString,
                                  double optimizerEstimatedRowCount,
                                  double optimizerEstimatedCost)

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 RealHashScanStatistics

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.

Specified by:

getScanStatisticsText in interface ResultSetStatistics

Overrides:

getScanStatisticsText in class RealHashScanStatistics

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 RealHashScanStatistics

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.

Overrides:

getNodeOn in class RealHashScanStatistics

getNodeName

public java.lang.String getNodeName()

Format for display, a name for this node.

Overrides:

getNodeName in class RealHashScanStatistics

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.

Specified by:

accept in interface XPLAINable

Overrides:

accept in class RealHashScanStatistics

getRSXplainType

public java.lang.String getRSXplainType()

Specified by:

getRSXplainType in interface XPLAINable

Overrides:

getRSXplainType in class RealHashScanStatistics

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