#i18n{module.jpa.hibernate.monitor.stats.title}

<#if stats_state> #i18n{module.jpa.hibernate.monitor.jmx.activated} <#else> #i18n{module.jpa.hibernate.monitor.jmx.notActivated}

<#if !stats_state>

<#else>

#i18n{module.jpa.hibernate.monitor.jmx.title}

<#if jmx_state> #i18n{module.jpa.hibernate.monitor.jmx.activated} <#else> #i18n{module.jpa.hibernate.monitor.jmx.notActivated}

<#if !jmx_state>
<#list list_stats as stat>

#i18n{module.jpa.hibernate.monitor.stats.pool} : ${stat.poolName}

<#if stat.stats.statisticsEnabled> <#-- Uncomment when freemarker is upgrade to provide number_to_datetime

${stat.stats.startTime?number_to_datetime}

-->

#i18n{module.jpa.hibernate.monitor.stats.sessions}

${stat.stats.connectCount?default("N/A")}

${stat.stats.sessionCloseCount?default("N/A")}

${stat.stats.sessionOpenCount?default("N/A")}

${stat.stats.flushCount?default("N/A")}

${stat.stats.successfulTransactionCount?default("N/A")}

${stat.stats.transactionCount?default("N/A")}

${stat.stats.optimisticFailureCount?default("N/A")}

#i18n{module.jpa.hibernate.monitor.stats.entities}

${stat.stats.entityDeleteCount?default("N/A")}

${stat.stats.entityLoadCount?default("N/A")}

${stat.stats.entityFetchCount?default("N/A")}

<#if stat.stats.entityNames?has_content> <#list stat.stats.entityNames as entity> <#assign entity_stats = stat.stats.getEntityStatistics(entity) />
Entite loadCount fetchCount optimisticFailureCount insertCount updateCount deleteCount
${entity} ${entity_stats.loadCount?default("N/A")} ${entity_stats.fetchCount?default("N/A")} ${entity_stats.optimisticFailureCount?default("N/A")} ${entity_stats.insertCount?default("N/A")} ${entity_stats.updateCount?default("N/A")} ${entity_stats.deleteCount?default("N/A")}

#i18n{module.jpa.hibernate.monitor.stats.queries}

${stat.stats.queryExecutionCount?default("N/A")}

${stat.stats.queryExecutionMaxTime!?default("N/A")}

${stat.stats.queryExecutionMaxTimeQueryString?default("N/A")}

<#if stat.stats.queries?has_content> <#list stat.stats.queries as query> <#assign query_stats = stat.stats.getQueryStatistics(query) />
query executionCount executionAvgTime executionMaxTime cacheHitCount cacheMissCount cachePutCount
${query}${query_stats.executionCount?default("N/A")} ${query_stats.executionAvgTime?default("N/A")} ${query_stats.executionMaxTime?default("N/A")} ${query_stats.cacheHitCount?default("N/A")} ${query_stats.cacheMissCount?default("N/A")} ${query_stats.cachePutCount?default("N/A")}
<#else> N/A

#i18n{module.jpa.hibernate.monitor.stats.cache}

${stat.stats.queryCacheHitCount?default("N/A")}

${stat.stats.queryCacheMissCount?default("N/A")}

${stat.stats.queryCachePutCount?default("N/A")}

${stat.stats.secondLevelCacheHitCount?default("N/A")}

${stat.stats.secondLevelCacheMissCount?default("N/A")}

${stat.stats.secondLevelCachePutCount?default("N/A")}

<#if stat.stats.secondLevelCacheRegionNames?has_content> <#list stat.stats.secondLevelCacheRegionNames as region> <#assign region_stats=stat.stats.getSecondLevelCacheStatistics(region) />
Region hitCount missCount putCount elementCountInMemory elementCountOnDisk sizeInMemory
${region}${region_stats.hitCount?default("N/A")} ${region_stats.missCount?default("N/A")} ${region_stats.putCount?default("N/A")} ${region_stats.elementCountInMemory?default("N/A")} ${region_stats.elementCountOnDisk?default("N/A")} ${region_stats.sizeInMemory?default("N/A")}
<#else> <#-- statistics disabled-->

#i18n{module.jpa.hibernate.monitor.stats.disabled}