List of usage examples for org.hibernate.stat Statistics getEntityStatistics
EntityStatistics getEntityStatistics(String entityName);
From source file:com.francetelecom.clara.cloud.scalability.helper.StatisticsHelper.java
License:Apache License
private static void entityStats(Statistics stats, Class cl) { String name = cl.getName();// ww w . j a v a 2 s . c om EntityStatistics eStats = stats.getEntityStatistics(name); String fetched = ""; if (eStats.getFetchCount() > 0) { fetched = " Fetched=" + eStats.getFetchCount(); } String loaded = ""; if (eStats.getLoadCount() > 0) { loaded = " Loaded=" + eStats.getLoadCount(); } String inserted = ""; if (eStats.getInsertCount() > 0) { inserted = " Inserted= " + eStats.getInsertCount(); } String deleted = ""; if (eStats.getDeleteCount() > 0) { deleted = " Deleted= " + eStats.getDeleteCount(); } String updated = ""; if (eStats.getUpdateCount() > 0) { updated = " Updated= " + eStats.getUpdateCount(); } String allStats = loaded + fetched + inserted + deleted + updated; if (!allStats.isEmpty()) { logger.info("Statistics for " + name + allStats); } }
From source file:com.francetelecom.clara.cloud.scalability.impl.ManageStatisticsImpl.java
License:Apache License
private Map<String, Long> getStatsValues(Collection<Class> entities) { Statistics stats = getStats(); Map<String, Long> statistics = new HashMap<String, Long>(); statistics.put("Number of connection requests", stats.getConnectCount()); statistics.put("Sessions opened", stats.getSessionOpenCount()); // statistics.put("Sessions closed", stats.getSessionCloseCount()); statistics.put("Transactions", stats.getTransactionCount()); // statistics.put("Successful transactions", stats.getSuccessfulTransactionCount()); // statistics.put("Successful transactions", stats.getSuccessfulTransactionCount()); statistics.put("Queries executed", stats.getQueryExecutionCount()); for (Class entity : entities) { EntityStatistics eStats = stats.getEntityStatistics(entity.getName()); statistics.put(entity.getSimpleName() + " Fetched", eStats.getFetchCount()); statistics.put(entity.getSimpleName() + " Loaded", eStats.getLoadCount()); statistics.put(entity.getSimpleName() + " Inserted", eStats.getInsertCount()); statistics.put(entity.getSimpleName() + " Deleted", eStats.getDeleteCount()); statistics.put(entity.getSimpleName() + " Updated", eStats.getUpdateCount()); }/* ww w . j a v a 2s.c o m*/ return statistics; }
From source file:com.medigy.persist.util.HibernateUtil.java
License:Open Source License
public static void logEntityStatistics(final Class entityClass) { Statistics stats = HibernateUtil.sessionFactory.getStatistics(); EntityStatistics entityStats = stats.getEntityStatistics(entityClass.getName()); long changes = entityStats.getInsertCount() + entityStats.getUpdateCount() + entityStats.getDeleteCount(); log.info(entityClass.getName() + " changed " + changes + "times"); }
From source file:com.openkm.servlet.admin.HibernateStatsServlet.java
License:Open Source License
/** * Refresh stats/*w w w. j av a 2 s. c o m*/ */ private synchronized void refresh() { Statistics statistics = HibernateUtil.getSessionFactory().getStatistics(); generalStatistics.set(0, statistics.getConnectCount()); generalStatistics.set(1, statistics.getFlushCount()); generalStatistics.set(2, statistics.getPrepareStatementCount()); generalStatistics.set(3, statistics.getCloseStatementCount()); generalStatistics.set(4, statistics.getSessionCloseCount()); generalStatistics.set(5, statistics.getSessionOpenCount()); generalStatistics.set(6, statistics.getTransactionCount()); generalStatistics.set(7, statistics.getSuccessfulTransactionCount()); generalStatistics.set(8, statistics.getOptimisticFailureCount()); queryStatistics.clear(); String[] names = statistics.getQueries(); if (names != null && names.length > 0) { for (int i = 0; i < names.length; i++) { queryStatistics.put(names[i], statistics.getQueryStatistics(names[i])); } } entityStatistics.clear(); names = statistics.getEntityNames(); if (names != null && names.length > 0) { for (int i = 0; i < names.length; i++) { entityStatistics.put(names[i], statistics.getEntityStatistics(names[i])); } } collectionStatistics.clear(); names = statistics.getCollectionRoleNames(); if (names != null && names.length > 0) { for (int i = 0; i < names.length; i++) { collectionStatistics.put(names[i], statistics.getCollectionStatistics(names[i])); } } secondLevelCacheStatistics.clear(); names = statistics.getSecondLevelCacheRegionNames(); if (names != null && names.length > 0) { for (int i = 0; i < names.length; i++) { secondLevelCacheStatistics.put(names[i], statistics.getSecondLevelCacheStatistics(names[i])); } } }
From source file:com.thoughtworks.go.server.service.support.HibernateInformationProvider.java
License:Apache License
@Override public Map<String, Object> asJson() { LinkedHashMap<String, Object> json = new LinkedHashMap<>(); Statistics statistics = sessionFactory.getStatistics(); if (!statistics.isStatisticsEnabled()) { return json; }/*from ww w. j a v a 2 s .c o m*/ json.put("EntityDeleteCount", statistics.getEntityDeleteCount()); json.put("EntityInsertCount", statistics.getEntityInsertCount()); json.put("EntityLoadCount", statistics.getEntityLoadCount()); json.put("EntityFetchCount", statistics.getEntityFetchCount()); json.put("EntityUpdateCount", statistics.getEntityUpdateCount()); json.put("QueryExecutionCount", statistics.getQueryExecutionCount()); json.put("QueryExecutionMaxTime", statistics.getQueryExecutionMaxTime()); json.put("QueryExecutionMaxTimeQueryString", statistics.getQueryExecutionMaxTimeQueryString()); json.put("QueryCacheHitCount", statistics.getQueryCacheHitCount()); json.put("QueryCacheMissCount", statistics.getQueryCacheMissCount()); json.put("QueryCachePutCount", statistics.getQueryCachePutCount()); json.put("FlushCount", statistics.getFlushCount()); json.put("ConnectCount", statistics.getConnectCount()); json.put("SecondLevelCacheHitCount", statistics.getSecondLevelCacheHitCount()); json.put("SecondLevelCacheMissCount", statistics.getSecondLevelCacheMissCount()); json.put("SecondLevelCachePutCount", statistics.getSecondLevelCachePutCount()); json.put("SessionCloseCount", statistics.getSessionCloseCount()); json.put("SessionOpenCount", statistics.getSessionOpenCount()); json.put("CollectionLoadCount", statistics.getCollectionLoadCount()); json.put("CollectionFetchCount", statistics.getCollectionFetchCount()); json.put("CollectionUpdateCount", statistics.getCollectionUpdateCount()); json.put("CollectionRemoveCount", statistics.getCollectionRemoveCount()); json.put("CollectionRecreateCount", statistics.getCollectionRecreateCount()); json.put("StartTime", statistics.getStartTime()); json.put("SecondLevelCacheRegionNames", statistics.getSecondLevelCacheRegionNames()); json.put("SuccessfulTransactionCount", statistics.getSuccessfulTransactionCount()); json.put("TransactionCount", statistics.getTransactionCount()); json.put("PrepareStatementCount", statistics.getPrepareStatementCount()); json.put("CloseStatementCount", statistics.getCloseStatementCount()); json.put("OptimisticFailureCount", statistics.getOptimisticFailureCount()); LinkedHashMap<String, Object> queryStats = new LinkedHashMap<>(); json.put("Queries", queryStats); String[] queries = statistics.getQueries(); for (String query : queries) { queryStats.put(query, statistics.getQueryStatistics(query)); } LinkedHashMap<String, Object> entityStatistics = new LinkedHashMap<>(); json.put("EntityStatistics", entityStatistics); String[] entityNames = statistics.getEntityNames(); for (String entityName : entityNames) { entityStatistics.put(entityName, statistics.getEntityStatistics(entityName)); } LinkedHashMap<String, Object> roleStatistics = new LinkedHashMap<>(); json.put("RoleStatistics", roleStatistics); String[] roleNames = statistics.getCollectionRoleNames(); for (String roleName : roleNames) { roleStatistics.put(roleName, statistics.getCollectionStatistics(roleName)); } return json; }
From source file:net.sf.ehcache.hibernate.management.impl.HibernateStatsImpl.java
License:Apache License
/** * {@inheritDoc}//from w w w . ja va2s . c o m * * @see net.sf.ehcache.hibernate.management.api.HibernateStats#getEntityStats() */ public TabularData getEntityStats() { List<CompositeData> result = new ArrayList<CompositeData>(); Statistics statistics = getStatistics(); for (String entity : statistics.getEntityNames()) { EntityStats entityStats = new EntityStats(entity, statistics.getEntityStatistics(entity)); result.add(entityStats.toCompositeData()); } TabularData td = EntityStats.newTabularDataInstance(); td.putAll(result.toArray(new CompositeData[result.size()])); return td; }
From source file:org.bedework.calcore.hibernate.DbStatistics.java
License:Apache License
private static void entityStats(Collection<StatsEntry> c, Statistics dbStats, Class cl) { String name = cl.getName();//from w w w. j a va 2 s .c o m c.add(new StatsEntry("Statistics for " + name)); EntityStatistics eStats = dbStats.getEntityStatistics(name); c.add(new StatsEntry("Fetched", eStats.getFetchCount())); c.add(new StatsEntry("Loaded", eStats.getLoadCount())); c.add(new StatsEntry("Inserted", eStats.getInsertCount())); c.add(new StatsEntry("Deleted", eStats.getDeleteCount())); c.add(new StatsEntry("Updated", eStats.getUpdateCount())); }
From source file:org.jboss.as.jpa.hibernate4.management.HibernateStatisticsResource.java
License:Open Source License
private boolean hasEntity(PathElement element) { boolean result = false; final Statistics stats = getStatistics(); if (stats != null) { final String emtityName = element.getValue(); result = stats.getEntityStatistics(emtityName) != null; }// w ww . j a va 2 s .c om return result; }
From source file:org.keycloak.connections.jpa.HibernateStatsReporter.java
License:Apache License
protected void logEntities(StringBuilder builder, String lineSep, Statistics stats) { builder.append("Important entities statistics: ").append(lineSep); for (String entity : stats.getEntityNames()) { EntityStatistics entityStats = stats.getEntityStatistics(entity); if (entityStats.getInsertCount() > LIMIT || entityStats.getDeleteCount() > LIMIT || entityStats.getUpdateCount() > LIMIT || entityStats.getLoadCount() > LIMIT || entityStats.getFetchCount() > LIMIT) { builder.append(entity).append(" - ").append("inserted: ").append(entityStats.getInsertCount()) .append(", updated: ").append(entityStats.getUpdateCount()).append(", removed: ") .append(entityStats.getDeleteCount()).append(", loaded: ") .append(entityStats.getLoadCount()).append(", fetched: ") .append(entityStats.getFetchCount()).append(lineSep); }/* w w w. j a va 2 s . co m*/ } builder.append(lineSep); }
From source file:org.unitime.commons.hibernate.stats.StatsProvider.java
License:Open Source License
/** * Format statistics in HTML/*from w w w . j a v a2s. c o m*/ * @param sessionFactory Hibernate Session Factory * @param summaryOnly true - Display only summary info * @return HTML String */ public String getStatsHtml(SessionFactory sessionFactory, boolean summaryOnly) { StringBuffer hibStats = new StringBuffer(); try { // Get statistics Statistics stats = sessionFactory.getStatistics(); // Checks statistics enabled if (!stats.isStatisticsEnabled()) { return "<font color='red'><b>Hibernate statistics is not enabled.</b></font>"; } // Row Color for even numbered rows String evenRowColor = "#FAFAFA"; // Generate HTML table Table table = new Table(); table.setWidth("100%"); table.setBorder(0); table.setCellSpacing(0); table.setCellPadding(3); // Links StringBuffer links = new StringBuffer(""); links.append("<A class=\"l7\" href=\"#Entity\">Entity</A>"); if (!summaryOnly) links.append(" - <A class=\"l7\" href=\"#EntityDetail\">Detail</A>"); links.append(" | <A class=\"l7\" href=\"#Collection\">Collection</A>"); if (!summaryOnly) links.append(" - <A class=\"l7\" href=\"#CollectionDetail\">Detail</A>"); links.append(" | <A class=\"l7\" href=\"#SecondLevelCache\">Second Level Cache</A>"); if (!summaryOnly) links.append(" - <A class=\"l7\" href=\"#SecondLevelCacheDetail\">Detail</A>"); links.append(" | <A class=\"l7\" href=\"#Query\">Query</A>"); if (!summaryOnly) links.append(" - <A class=\"l7\" href=\"#QueryDetail\">Detail</A>"); TableRow row = new TableRow(); row.addContent(cell(links.toString(), 1, 2, true, "center", "middle")); table.addContent(row); // Link to top TableRow linkToTop = new TableRow(); linkToTop.addContent( cell("<A class=\"l7\" href=\"#BackToTop\">Back to Top</A>", 1, 2, true, "right", "middle")); // ---------------------- Overall Stats ------------------------ row = new TableRow(); row.addContent(headerCell("<A name=\"BackToTop\">Metric</A>", 1, 1)); row.addContent(headerCell("Value", 1, 1)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Start Time", 1, 1, true)); row.addContent(cell(new Date(stats.getStartTime()).toString(), 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Connect Count", 1, 1, true)); row.addContent(cell(stats.getConnectCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Flush Count", 1, 1, true)); row.addContent(cell(stats.getFlushCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Session Open Count", 1, 1, true)); row.addContent(cell(stats.getSessionOpenCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Session Close Count", 1, 1, true)); row.addContent(cell(stats.getSessionCloseCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Transaction Count", 1, 1, true)); row.addContent(cell(stats.getTransactionCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Successful Transaction Count", 1, 1, true)); row.addContent(cell(stats.getSuccessfulTransactionCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Prepare Statement Count", 1, 1, true)); row.addContent(cell(stats.getPrepareStatementCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Close Statement Count", 1, 1, true)); row.addContent(cell(stats.getCloseStatementCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Optimistic Failure Count", 1, 1, true)); row.addContent(cell(stats.getOptimisticFailureCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); // ---------------------- Entity Stats ------------------------ row = new TableRow(); row.addContent(headerCell("<A name=\"Entity\">Entity</A>:", 1, 2)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Fetch Count", 1, 1, true)); row.addContent(cell(stats.getEntityFetchCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Load Count", 1, 1, true)); row.addContent(cell(stats.getEntityLoadCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Insert Count", 1, 1, true)); row.addContent(cell(stats.getEntityInsertCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Update Count", 1, 1, true)); row.addContent(cell(stats.getEntityUpdateCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Delete Count", 1, 1, true)); row.addContent(cell(stats.getEntityDeleteCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); // ---------------------- Detailed Entity Stats ------------------------ if (!summaryOnly) { row = new TableRow(); row.addContent(headerCell("<A name=\"EntityDetail\">Entity Statistics Detail</A>:", 1, 2)); table.addContent(row); String[] cEntityNames = stats.getEntityNames(); if (cEntityNames == null || cEntityNames.length == 0) { row = new TableRow(); row.addContent(cell("No entity names found", 1, 2, false)); table.addContent(row); } else { Table subTable = new Table(); subTable.setCellSpacing(1); subTable.setCellPadding(3); row = new TableRow(); row.addContent(headerCell(" ", 1, 1)); row.addContent(headerCell(" Fetches ", 1, 1)); row.addContent(headerCell(" Loads ", 1, 1)); row.addContent(headerCell(" Inserts ", 1, 1)); row.addContent(headerCell(" Updates ", 1, 1)); row.addContent(headerCell(" Deletes ", 1, 1)); subTable.addContent(row); for (int i = 0; i < cEntityNames.length; i++) { String entityName = cEntityNames[i]; EntityStatistics eStats = stats.getEntityStatistics(entityName); row = new TableRow(); if (i % 2 == 0) row.setBgColor(evenRowColor); row.addContent(cell(entityName + " ", 1, 1, true)); row.addContent(cell(eStats.getFetchCount() + "", 1, 1, false)); row.addContent(cell(eStats.getLoadCount() + "", 1, 1, false)); row.addContent(cell(eStats.getInsertCount() + "", 1, 1, false)); row.addContent(cell(eStats.getUpdateCount() + "", 1, 1, false)); row.addContent(cell(eStats.getDeleteCount() + "", 1, 1, false)); subTable.addContent(row); } row = new TableRow(); row.addContent(cell(subTable.toHtml(), 1, 2, true)); table.addContent(row); } row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); } // ---------------------- Collection Stats ------------------------ row = new TableRow(); row.addContent(headerCell("<A name=\"Collection\">Collection</A>:", 1, 2)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Fetch Count", 1, 1, true)); row.addContent(cell(stats.getCollectionFetchCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Load Count", 1, 1, true)); row.addContent(cell(stats.getCollectionLoadCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Update Count", 1, 1, true)); row.addContent(cell(stats.getCollectionUpdateCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Remove Count", 1, 1, true)); row.addContent(cell(stats.getCollectionRemoveCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Recreate Count", 1, 1, true)); row.addContent(cell(stats.getCollectionRecreateCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); // ---------------------- Detailed Collection Stats ------------------------ if (!summaryOnly) { row = new TableRow(); row.addContent(headerCell("<A name=\"CollectionDetail\">Collection Statistics Detail</A>:", 1, 2)); table.addContent(row); String[] cRoleNames = stats.getCollectionRoleNames(); if (cRoleNames == null || cRoleNames.length == 0) { row = new TableRow(); row.addContent(cell("No collection roles found", 1, 2, false)); table.addContent(row); } else { Table subTable = new Table(); subTable.setCellSpacing(1); subTable.setCellPadding(3); row = new TableRow(); row.addContent(headerCell(" ", 1, 1)); row.addContent(headerCell(" Fetches ", 1, 1)); row.addContent(headerCell(" Loads ", 1, 1)); row.addContent(headerCell(" Updates ", 1, 1)); row.addContent(headerCell(" Removes ", 1, 1)); row.addContent(headerCell(" Recreates ", 1, 1)); subTable.addContent(row); for (int i = 0; i < cRoleNames.length; i++) { String roleName = cRoleNames[i]; CollectionStatistics cStats = stats.getCollectionStatistics(roleName); row = new TableRow(); if (i % 2 == 0) row.setBgColor(evenRowColor); row.addContent(cell(roleName + " ", 1, 1, true)); row.addContent(cell(cStats.getFetchCount() + "", 1, 1, false)); row.addContent(cell(cStats.getLoadCount() + "", 1, 1, false)); row.addContent(cell(cStats.getUpdateCount() + "", 1, 1, false)); row.addContent(cell(cStats.getRemoveCount() + "", 1, 1, false)); row.addContent(cell(cStats.getRecreateCount() + "", 1, 1, false)); subTable.addContent(row); } row = new TableRow(); row.addContent(cell(subTable.toHtml(), 1, 2, true)); table.addContent(row); } row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); } // ---------------------- Second Level Cache Stats ------------------------ row = new TableRow(); row.addContent(headerCell("<A name=\"SecondLevelCache\">Second Level Cache</A>:", 1, 2)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Hit Count", 1, 1, true)); row.addContent(cell(stats.getSecondLevelCacheHitCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Miss Count", 1, 1, true)); row.addContent(cell(stats.getSecondLevelCacheMissCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Put Count", 1, 1, true)); row.addContent(cell(stats.getSecondLevelCachePutCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); // ---------------------- Detailed Second Level Cache Stats ------------------------ if (!summaryOnly) { row = new TableRow(); row.addContent(headerCell( "<A name=\"SecondLevelCacheDetail\">Second Level Cache Statistics Detail</A>:", 1, 2)); table.addContent(row); String[] cRegionNames = stats.getSecondLevelCacheRegionNames(); if (cRegionNames == null || cRegionNames.length == 0) { row = new TableRow(); row.addContent(cell("No region names found", 1, 2, false)); table.addContent(row); } else { Table subTable = new Table(); subTable.setCellSpacing(1); subTable.setCellPadding(3); row = new TableRow(); row.addContent(headerCell(" ", 1, 1)); row.addContent(headerCell(" Entities ", 1, 1)); row.addContent(headerCell(" Hits ", 1, 1)); row.addContent(headerCell(" Misses ", 1, 1)); row.addContent(headerCell(" Puts ", 1, 1)); row.addContent(headerCell(" In Memory ", 1, 1)); row.addContent(headerCell(" On Disk ", 1, 1)); row.addContent(headerCell(" Memory ", 1, 1)); subTable.addContent(row); long elementsInMem = 0, elementsOnDisk = 0, putCnt = 0, missCnt = 0, hitCnt = 0, size = 0; for (int i = 0; i < cRegionNames.length; i++) { String cRegionName = cRegionNames[i]; SecondLevelCacheStatistics sStats = stats.getSecondLevelCacheStatistics(cRegionName); row = new TableRow(); if (i % 2 == 0) row.setBgColor(evenRowColor); row.addContent(cell(cRegionName + " ", 1, 1, true)); row.addContent(cell( String.valueOf(sStats.getElementCountInMemory() + sStats.getElementCountOnDisk()), 1, 1, false)); //sStats.getEntries().size() row.addContent(cell(sStats.getHitCount() + "", 1, 1, false)); row.addContent(cell(sStats.getMissCount() + "", 1, 1, false)); row.addContent(cell(sStats.getPutCount() + "", 1, 1, false)); row.addContent(cell(sStats.getElementCountInMemory() + "", 1, 1, false)); row.addContent(cell(sStats.getElementCountOnDisk() + "", 1, 1, false)); row.addContent(cell(sStats.getSizeInMemory() + " bytes", 1, 1, false)); elementsInMem += sStats.getElementCountInMemory(); elementsOnDisk += sStats.getElementCountOnDisk(); putCnt += sStats.getPutCount(); missCnt += sStats.getMissCount(); hitCnt += sStats.getHitCount(); size += sStats.getSizeInMemory(); subTable.addContent(row); } row = new TableRow(); row.addContent(headerCell("Total ", 1, 1)); row.addContent(headerCell("" + (elementsInMem + elementsOnDisk), 1, 1)); row.addContent(headerCell("" + hitCnt, 1, 1)); row.addContent(headerCell("" + missCnt, 1, 1)); row.addContent(headerCell("" + putCnt, 1, 1)); row.addContent(headerCell("" + elementsInMem, 1, 1)); row.addContent(headerCell("" + elementsOnDisk, 1, 1)); row.addContent(headerCell(size + " bytes", 1, 1)); subTable.addContent(row); row = new TableRow(); row.addContent(cell(subTable.toHtml(), 1, 2, true)); table.addContent(row); } row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); } // ---------------------- Query Stats ------------------------ row = new TableRow(); row.addContent(headerCell("<A name=\"Query\">Query</A>:", 1, 2)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Execution Count", 1, 1, true)); row.addContent(cell(stats.getQueryExecutionCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Execution Max Time", 1, 1, true)); row.addContent(cell(stats.getQueryExecutionMaxTime() + " ms", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Cache Hit Count", 1, 1, true)); row.addContent(cell(stats.getQueryCacheHitCount() + " ms", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Cache Miss Count", 1, 1, true)); row.addContent(cell(stats.getQueryCacheMissCount() + " ms", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell(" Cache Put Count", 1, 1, true)); row.addContent(cell(stats.getQueryCachePutCount() + "", 1, 1, false)); table.addContent(row); row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); // ---------------------- Detailed Query Stats ------------------------ if (!summaryOnly) { row = new TableRow(); row.addContent(headerCell("<A name=\"QueryDetail\">Query Statistics Detail</A>:", 1, 2)); table.addContent(row); String[] cQueryStrings = stats.getQueries(); if (cQueryStrings == null || cQueryStrings.length == 0) { row = new TableRow(); row.addContent(cell("No query strings found", 1, 2, false)); table.addContent(row); } else { Table subTable = new Table(); subTable.setCellSpacing(1); subTable.setCellPadding(3); row = new TableRow(); row.addContent(headerCell(" ", 1, 1)); row.addContent(headerCell(" Execs ", 1, 1)); row.addContent(headerCell(" Rows ", 1, 1)); row.addContent(headerCell(" Max Time ", 1, 1)); row.addContent(headerCell(" Min Time ", 1, 1)); row.addContent(headerCell(" Avg Time ", 1, 1)); row.addContent(headerCell(" Cache Hits ", 1, 1)); row.addContent(headerCell(" Cache Misses ", 1, 1)); row.addContent(headerCell(" Cache Puts ", 1, 1)); subTable.addContent(row); for (int i = 0; i < cQueryStrings.length; i++) { String cQueryString = cQueryStrings[i]; QueryStatistics qStats = stats.getQueryStatistics(cQueryString); row = new TableRow(); if (i % 2 == 0) row.setBgColor(evenRowColor); row.addContent(cell(cQueryString + " ", 1, 1, false)); row.addContent(cell(qStats.getExecutionCount() + "", 1, 1, false)); row.addContent(cell(qStats.getExecutionRowCount() + "", 1, 1, false)); row.addContent(cell(qStats.getExecutionMaxTime() + " ms", 1, 1, false)); row.addContent(cell(qStats.getExecutionMinTime() + " ms", 1, 1, false)); row.addContent(cell(qStats.getExecutionAvgTime() + " ms", 1, 1, false)); row.addContent(cell(qStats.getCacheHitCount() + "", 1, 1, false)); row.addContent(cell(qStats.getCacheMissCount() + "", 1, 1, false)); row.addContent(cell(qStats.getCachePutCount() + "", 1, 1, false)); subTable.addContent(row); } row = new TableRow(); row.addContent(cell(subTable.toHtml(), 1, 2, true)); table.addContent(row); } row = new TableRow(); row.addContent(cell("<hr>", 1, 2, false)); table.addContent(row); table.addContent(linkToTop); } // Add to generated HTML hibStats.append(table.toHtml()); } catch (Exception e) { hibStats.append("Exception occured: " + e.getMessage()); e.printStackTrace(); } return hibStats.toString(); }