@Override
    public List<JVMGCDataPo> queryAvg(MDataPaginationReq request) {
        return new SelectSql(getSqlTemplate())
                .select()
                .columns("timestamp",
                        "AVG(young_gc_collection_count) AS young_gc_collection_count",
                        "AVG(young_gc_collection_time) AS young_gc_collection_time",
                        "AVG(full_gc_collection_count) AS full_gc_collection_count",
                        "AVG(full_gc_collection_time) AS full_gc_collection_time",
                        "AVG(span_young_gc_collection_count) AS span_young_gc_collection_count",
                        "AVG(span_young_gc_collection_time) AS span_young_gc_collection_time",
                        "AVG(span_full_gc_collection_count) span_full_gc_collection_count",
                        "AVG(span_full_gc_collection_time) span_full_gc_collection_time")
                .from()
                .table(getTableName())
                .whereSql(buildWhereSql(request))
                .groupBy(" timestamp ASC ")
                .limit(request.getStart(), request.getLimit())
                .list(RshHandler.JVM_GC_SUM_M_DATA_RSH);
    }
@author Robert HG (254963746@qq.com) on 3/10/16.
lts-admin/src/main/java/com/github/ltsopensource/admin/access/mysql/MysqlBackendJVMGCAccess.java