org.keycloak.connections.jpa.HibernateStatsReporter.java Source code

Introduction

Here is the source code for org.keycloak.connections.jpa.HibernateStatsReporter.java

Source

/*
 * Copyright 2016 Red Hat, Inc. and/or its affiliates
 * and other contributors as indicated by the @author tags.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.keycloak.connections.jpa;

import org.hibernate.SessionFactory;
import org.hibernate.internal.SessionFactoryImpl;
import org.hibernate.stat.CollectionStatistics;
import org.hibernate.stat.EntityStatistics;
import org.hibernate.stat.QueryStatistics;
import org.hibernate.stat.Statistics;
import org.jboss.logging.Logger;
import org.keycloak.models.KeycloakSession;
import org.keycloak.timer.ScheduledTask;

import javax.persistence.EntityManagerFactory;

/**
 * @author <a href="mailto:mposolda@redhat.com">Marek Posolda</a>
 */
public class HibernateStatsReporter implements ScheduledTask {

    private static final int LIMIT = 100; // Just hardcoded for now

    private final EntityManagerFactory emf;
    private static final Logger logger = Logger.getLogger(HibernateStatsReporter.class);

    public HibernateStatsReporter(EntityManagerFactory emf) {
        this.emf = emf;
    }

    @Override
    public void run(KeycloakSession session) {
        SessionFactory sessionFactory = ((SessionFactoryImpl) emf);
        Statistics stats = sessionFactory.getStatistics();

        logStats(stats);

        stats.clear(); // For now, clear stats after each iteration
    }

    protected void logStats(Statistics stats) {
        String lineSep = System.getProperty("line.separator");
        StringBuilder builder = new StringBuilder(lineSep).append(stats.toString()).append(lineSep).append(lineSep);

        logEntities(builder, lineSep, stats);
        logCollections(builder, lineSep, stats);
        logQueries(builder, lineSep, stats);

        logger.infof(builder.toString());
    }

    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);
            }
        }
        builder.append(lineSep);
    }

    protected void logCollections(StringBuilder builder, String lineSep, Statistics stats) {
        builder.append("Important collections statistics: ").append(lineSep);
        for (String col : stats.getCollectionRoleNames()) {
            CollectionStatistics collectionStats = stats.getCollectionStatistics(col);
            if (collectionStats.getRecreateCount() > LIMIT || collectionStats.getUpdateCount() > LIMIT
                    || collectionStats.getRemoveCount() > LIMIT || collectionStats.getLoadCount() > LIMIT
                    || collectionStats.getFetchCount() > LIMIT) {
                builder.append(col).append(" - ").append("recreated: ").append(collectionStats.getRecreateCount())
                        .append(", updated: ").append(collectionStats.getUpdateCount()).append(", removed: ")
                        .append(collectionStats.getRemoveCount()).append(", loaded: ")
                        .append(collectionStats.getLoadCount()).append(", fetched: ")
                        .append(collectionStats.getFetchCount()).append(lineSep);
            }
        }
        builder.append(lineSep);
    }

    protected void logQueries(StringBuilder builder, String lineSep, Statistics stats) {
        builder.append("Important queries statistics: ").append(lineSep).append(lineSep);
        for (String query : stats.getQueries()) {
            QueryStatistics queryStats = stats.getQueryStatistics(query);

            if (queryStats.getExecutionCount() > LIMIT
                    || (queryStats.getExecutionCount() * queryStats.getExecutionAvgTime() > LIMIT)) {
                builder.append(query).append(lineSep).append("executionCount=")
                        .append(queryStats.getExecutionCount()).append(lineSep).append("executionAvgTime=")
                        .append(queryStats.getExecutionAvgTime()).append(" ms").append(lineSep).append(lineSep)
                        .append(lineSep);
            }
        }
    }

}