@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics( getEntityManagerFactory( args ), getQueryName( args ) ); return Long.valueOf( statistics != null ? statistics.getExecutionRowCount() : 0 ); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getStatisticName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
assertNotNull( "stats were null", continentStats ); assertEquals( "unexpected execution count", 1, continentStats.getExecutionCount() ); assertEquals( "unexpected row count", results, continentStats.getExecutionRowCount() ); long maxTime = continentStats.getExecutionMaxTime(); assertEquals( maxTime, sf.getStatistics().getQueryExecutionMaxTime() ); assertEquals( "unexpected row count", results, continentStats.getExecutionRowCount() ); Hibernate.close( itr ); assertEquals( "unexpected row count", results, continentStats.getExecutionRowCount() ); assertEquals( "unexpected row count", results, localityStats.getExecutionRowCount() ); maxTime = localityStats.getExecutionMaxTime(); assertEquals( maxTime, sf.getStatistics().getQueryExecutionMaxTime() ); assertNotNull( "sql stats were null", sqlStats ); assertEquals( "unexpected execution count", 1, sqlStats.getExecutionCount() ); assertEquals( "unexpected row count", results, sqlStats.getExecutionRowCount() ); maxTime = sqlStats.getExecutionMaxTime(); assertEquals( maxTime, sf.getStatistics().getQueryExecutionMaxTime() );
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getExecutionRowCount(); } }
/** * Convenience method to print out the hibernate cache usage stats to the log */ private void showUsageStatistics() { if (sessionFactory.getStatistics().isStatisticsEnabled()) { log.debug("Getting query statistics: "); Statistics stats = sessionFactory.getStatistics(); for (String query : stats.getQueries()) { log.info("QUERY: " + query); QueryStatistics qstats = stats.getQueryStatistics(query); log.info("Cache Hit Count : " + qstats.getCacheHitCount()); log.info("Cache Miss Count: " + qstats.getCacheMissCount()); log.info("Cache Put Count : " + qstats.getCachePutCount()); log.info("Execution Count : " + qstats.getExecutionCount()); log.info("Average time : " + qstats.getExecutionAvgTime()); log.info("Row Count : " + qstats.getExecutionRowCount()); } } }
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getQueryName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
@Override protected void handle(QueryStatistics statistics, OperationContext context, String attributeName, String originalQueryName) { long count = statistics.getExecutionRowCount(); context.getResult().set(count); } };
@Override public Object invoke(Object... args) { org.hibernate.stat.QueryStatistics statistics = getStatistics(getEntityManagerFactory(args), getStatisticName(args)); return Long.valueOf(statistics != null ? statistics.getExecutionRowCount() : 0); } };
public static String[] getQueryStatistics(final SessionFactory sessionFactory, final String queryString) { if (isNull(sessionFactory)) throw new NullPointerException("Parameter sessionFactory is null"); if (isNull(queryString)) throw new NullPointerException("Parameter queryString is null"); if (queryString.isEmpty()) throw new IllegalArgumentException("Parameter queryString is a empty String"); final Statistics sfstats = sessionFactory.getStatistics(); if (!ArrayUtils.contains(sfstats.getQueries(), queryString)) throw new IllegalArgumentException("Query " + queryString + " was not executed by given SessionFactory"); final QueryStatistics stats = sfstats.getQueryStatistics(queryString); return new String[] { "+ Query Statistics: " + queryString, "+", "+ Exec Count: " + stats.getExecutionCount(), "+ Avg Exec Time: " + stats.getExecutionAvgTime() + "ms", "+ Max Exec Time: " + stats.getExecutionMaxTime() + "ms", "+ Min Exec Time: " + stats.getExecutionMinTime() + "ms", "+ Exec Row Count: " + stats.getExecutionRowCount(), "+", "+ Cache Puts: " + stats.getCachePutCount(), "+ Cache Hits: " + stats.getCacheHitCount(), "+ Cache Misses: " + stats.getCacheMissCount(), "+ Hit Ratio: " + ((double) stats.getCacheHitCount()) / (stats.getCacheHitCount() + stats.getCacheMissCount()), "+", "+" }; }
public QueryStats(String name, QueryStatistics src) { this(name); this.cacheHitCount = src.getCacheHitCount(); this.cacheMissCount = src.getCacheMissCount(); this.cachePutCount = src.getCachePutCount(); this.executionCount = src.getExecutionCount(); this.executionRowCount = src.getExecutionRowCount(); this.executionAvgTime = src.getExecutionAvgTime(); this.executionMaxTime = src.getExecutionMaxTime(); this.executionMinTime = src.getExecutionMinTime(); }
public QueryStats(String name, QueryStatistics src) { this(name); this.cacheHitCount = src.getCacheHitCount(); this.cacheMissCount = src.getCacheMissCount(); this.cachePutCount = src.getCachePutCount(); this.executionCount = src.getExecutionCount(); this.executionRowCount = src.getExecutionRowCount(); this.executionAvgTime = src.getExecutionAvgTime(); this.executionMaxTime = src.getExecutionMaxTime(); this.executionMinTime = src.getExecutionMinTime(); }
public QueryStats(String name, QueryStatistics src) { this(name); this.cacheHitCount = src.getCacheHitCount(); this.cacheMissCount = src.getCacheMissCount(); this.cachePutCount = src.getCachePutCount(); this.executionCount = src.getExecutionCount(); this.executionRowCount = src.getExecutionRowCount(); this.executionAvgTime = src.getExecutionAvgTime(); this.executionMaxTime = src.getExecutionMaxTime(); this.executionMinTime = src.getExecutionMinTime(); }