Top Description Inners Fields Constructors Methods

org.h2.engine

public Class QueryStatisticsData

Class Inheritance

extends Object

java.lang.Object
org.h2.engine.QueryStatisticsData

Imports

java.util.ArrayList, .Comparator, .HashMap, .HashSet, .Iterator, .List, .Map.Entry

Maintains query statistics.

Nested and Inner Type Summary

Modifier and Type	Class and Description
public static class	QueryStatisticsData.QueryEntry The collected statistics for one query.

Field Summary

Modifier and Type	Field and Description
private final HashMap<String, QueryStatisticsData.QueryEntry>	map
private int	maxQueryEntries
private static final Comparator<QueryStatisticsData.QueryEntry>	QUERY_ENTRY_COMPARATOR

Constructor Summary

Access	Constructor and Description
public	QueryStatisticsData(int maxQueryEntries)

Method Summary

Modifier and Type	Method and Description
public synchronized List<QueryStatisticsData.QueryEntry>	getQueries()
public synchronized void	setMaxQueryEntries(int maxQueryEntries)
public synchronized void	update(String the statement being executed sqlStatement, long the time in nanoseconds the query/update took to execute executionTimeNanos, long the query or update row count rowCount) Update query statistics.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

map	back to summary
private final HashMap<String, QueryStatisticsData.QueryEntry> map

maxQueryEntries	back to summary
private int maxQueryEntries

QUERY_ENTRY_COMPARATOR	back to summary
private static final Comparator<QueryStatisticsData.QueryEntry> QUERY_ENTRY_COMPARATOR

Constructor Detail

QueryStatisticsData	back to summary
public QueryStatisticsData(int maxQueryEntries)

Method Detail

getQueries	back to summary
public synchronized List<QueryStatisticsData.QueryEntry> getQueries()

setMaxQueryEntries	back to summary
public synchronized void setMaxQueryEntries(int maxQueryEntries)

update

back to summary

public synchronized void update(String sqlStatement, long executionTimeNanos, long rowCount)

Update query statistics.

Parameters

sqlStatement:String: the statement being executed
executionTimeNanos:long: the time in nanoseconds the query/update took to execute
rowCount:long: the query or update row count

org.h2.engine back to summary

public final Class QueryStatisticsData.QueryEntry

Class Inheritance

extends Object

java.lang.Object
org.h2.engine.QueryStatisticsData.QueryEntry

The collected statistics for one query.

Field Summary

Modifier and Type	Field and Description
public int	count The number of times the statement was executed.
public long	executionTimeCumulativeNanos The total execution time.
private double	executionTimeM2Nanos
public long	executionTimeMaxNanos The maximum execution time, in nanoseconds.
public double	executionTimeMeanNanos The mean execution time.
public long	executionTimeMinNanos The minimum execution time, in nanoseconds.
public long	lastUpdateTime The last time the statistics for this entry were updated, in milliseconds since 1970.
public long	rowCountCumulative The total number of rows.
private double	rowCountM2
public long	rowCountMax The maximum number of rows.
public double	rowCountMean The mean number of rows.
public long	rowCountMin The minimum number of rows.
public final String	sqlStatement The SQL statement.

Constructor Summary

Access	Constructor and Description
public	QueryEntry(String sql)

Method Summary

Modifier and Type	Method and Description
public double	getExecutionTimeStandardDeviation()
public double	getRowCountStandardDeviation()
pack-priv void	update(long the execution time in nanos timeNanos, long the number of rows rows) Update the statistics entry.

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

count	back to summary
public int count The number of times the statement was executed.

executionTimeCumulativeNanos	back to summary
public long executionTimeCumulativeNanos The total execution time.

executionTimeM2Nanos	back to summary
private double executionTimeM2Nanos

executionTimeMaxNanos	back to summary
public long executionTimeMaxNanos The maximum execution time, in nanoseconds.

executionTimeMeanNanos	back to summary
public double executionTimeMeanNanos The mean execution time.

executionTimeMinNanos	back to summary
public long executionTimeMinNanos The minimum execution time, in nanoseconds.

lastUpdateTime	back to summary
public long lastUpdateTime The last time the statistics for this entry were updated, in milliseconds since 1970.

rowCountCumulative	back to summary
public long rowCountCumulative The total number of rows.

rowCountM2	back to summary
private double rowCountM2

rowCountMax	back to summary
public long rowCountMax The maximum number of rows.

rowCountMean	back to summary
public double rowCountMean The mean number of rows.

rowCountMin	back to summary
public long rowCountMin The minimum number of rows.

sqlStatement	back to summary
public final String sqlStatement The SQL statement.

Constructor Detail

QueryEntry	back to summary
public QueryEntry(String sql)

Method Detail

getExecutionTimeStandardDeviation	back to summary
public double getExecutionTimeStandardDeviation()

getRowCountStandardDeviation	back to summary
public double getRowCountStandardDeviation()

update

back to summary

pack-priv void update(long timeNanos, long rows)

Update the statistics entry.

Parameters

timeNanos:long: the execution time in nanos
rows:long: the number of rows