queryStats.put(query, statistics.getQueryStatistics(query));
private org.hibernate.stat.QueryStatistics getStatistics( EntityManagerFactory entityManagerFactory, String displayQueryName) { if ( entityManagerFactory == null ) { return null; } SessionFactory sessionFactory = entityManagerFactory.unwrap( SessionFactory.class ); // convert displayed (transformed by QueryNames) query name to original query name to look up query statistics if ( sessionFactory != null ) { String[] originalQueryNames = sessionFactory.getStatistics().getQueries(); if ( originalQueryNames != null ) { for ( String originalQueryName : originalQueryNames ) { if ( QueryName.queryName( originalQueryName ).getDisplayName().equals( displayQueryName ) ) { return sessionFactory.getStatistics().getQueryStatistics( originalQueryName ); } } } } return null; }
private org.hibernate.stat.QueryStatistics getStatistics(EntityManagerFactory entityManagerFactory, String displayQueryName) { if (entityManagerFactory == null) { return null; } SessionFactory sessionFactory = entityManagerFactory.unwrap(SessionFactory.class); // convert displayed (transformed by QueryNames) query name to original query name to look up query statistics if (sessionFactory != null) { String[] originalQueryNames = sessionFactory.getStatistics().getQueries(); if (originalQueryNames != null) { for (String originalQueryName : originalQueryNames) { if (QueryName.queryName(originalQueryName).getDisplayName().equals(displayQueryName)) { return sessionFactory.getStatistics().getQueryStatistics(originalQueryName); } } } } return null; }
private org.hibernate.stat.QueryStatistics getStatistics(EntityManagerFactory entityManagerFactory, String displayQueryName) { if (entityManagerFactory == null) { return null; } SessionFactory sessionFactory = entityManagerFactory.unwrap(SessionFactory.class); // convert displayed (transformed by QueryNames) query name to original query name to look up query statistics if (sessionFactory != null) { String[] originalQueryNames = sessionFactory.getStatistics().getQueries(); if (originalQueryNames != null) { for (String originalQueryName : originalQueryNames) { if (QueryName.queryName(originalQueryName).getDisplayName().equals(displayQueryName)) { return sessionFactory.getStatistics().getQueryStatistics(originalQueryName); } } } } return null; }
private org.hibernate.stat.QueryStatistics getStatistics(EntityManagerFactory entityManagerFactory, String displayQueryName) { if (entityManagerFactory == null) { return null; } HibernateEntityManagerFactory entityManagerFactoryImpl = (HibernateEntityManagerFactory) entityManagerFactory; SessionFactory sessionFactory = entityManagerFactoryImpl.getSessionFactory(); // convert displayed (transformed by QueryNames) query name to original query name to look up query statistics if (sessionFactory != null) { String[] originalQueryNames = sessionFactory.getStatistics().getQueries(); if (originalQueryNames != null) { for (String originalQueryName : originalQueryNames) { if (QueryName.queryName(originalQueryName).getDisplayName().equals(displayQueryName)) { return sessionFactory.getStatistics().getQueryStatistics(originalQueryName); } } } } return null; }
private org.hibernate.stat.QueryStatistics getStatistics(EntityManagerFactory entityManagerFactory, String displayQueryName) { if (entityManagerFactory == null) { return null; } HibernateEntityManagerFactory entityManagerFactoryImpl = (HibernateEntityManagerFactory) entityManagerFactory; SessionFactory sessionFactory = entityManagerFactoryImpl.getSessionFactory(); // convert displayed (transformed by QueryNames) query name to original query name to look up query statistics if (sessionFactory != null) { String[] originalQueryNames = sessionFactory.getStatistics().getQueries(); if (originalQueryNames != null) { for (String originalQueryName : originalQueryNames) { if (QueryName.queryName(originalQueryName).getDisplayName().equals(displayQueryName)) { return sessionFactory.getStatistics().getQueryStatistics(originalQueryName); } } } } return null; }
private void assertQueryStatistics(String hql, int hitCount) { QueryStatistics queryStatistics = statistics.getQueryStatistics( hql ); assertEquals( hitCount, queryStatistics.getPlanCacheHitCount() ); assertEquals( 1, queryStatistics.getPlanCacheMissCount() ); assertTrue( queryStatistics.getPlanCompilationTotalMicroseconds() > 0 ); }
final String continents = "from Continent"; int results = s.createQuery( continents ).list().size(); QueryStatistics continentStats = sf.getStatistics().getQueryStatistics( continents ); assertNotNull( "stats were null", continentStats ); assertEquals( "unexpected execution count", 1, continentStats.getExecutionCount() ); final String localities = "from Locality"; results = s.createQuery( localities ).list().size(); QueryStatistics localityStats = sf.getStatistics().getQueryStatistics( localities ); assertNotNull( "stats were null", localityStats ); final String sql = "select id, name from Country"; results = s.createSQLQuery( sql ).addEntity( Country.class ).list().size(); QueryStatistics sqlStats = sf.getStatistics().getQueryStatistics( sql ); assertNotNull( "sql stats were null", sqlStats ); assertEquals( "unexpected execution count", 1, sqlStats.getExecutionCount() );
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getExecutionRowCount(); } }
@Override public double getValue(Statistics statistics, String query) { return toSeconds(statistics.getQueryStatistics(query) .getExecutionMinTime()); } }
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getCacheHitCount(); } }
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getCacheMissCount(); } }
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getExecutionCount(); } }
@Override public double getValue(Statistics statistics, String query) { return statistics.getQueryStatistics(query) .getCachePutCount(); } }
@Override public double getValue(Statistics statistics, String query) { return toSeconds(statistics.getQueryStatistics(query) .getExecutionMaxTime()); } }
@Override public double getValue(Statistics statistics, String query) { return toSeconds(statistics.getQueryStatistics(query) .getExecutionTotalTime()); } }
QueryStatistics queryStats = stats.getQueryStatistics( "from Event" ); assertThat( "Cache Miss Count", queryStats.getCacheMissCount(), equalTo( 1L ) ); assertThat( "Cache Hit Count", queryStats.getCacheHitCount(), equalTo( 0L ) );
/** * {@inheritDoc} * * @see net.sf.ehcache.hibernate.management.api.HibernateStats#getQueryStats() */ public TabularData getQueryStats() { List<CompositeData> result = new ArrayList<CompositeData>(); Statistics statistics = getStatistics(); for (String query : statistics.getQueries()) { QueryStats queryStats = new QueryStats(query, statistics.getQueryStatistics(query)); result.add(queryStats.toCompositeData()); } TabularData td = QueryStats.newTabularDataInstance(); td.putAll(result.toArray(new CompositeData[result.size()])); return td; }
/** * 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()); } } }
public QueryStatistics getQueryStatistics() { return getStatistics().getQueryStatistics(currentQuery); }