如何记录Spring Data JPA存储库方法的执行时间？

Question

我有一个简单的Spring Data JPA仓库。

public interface UserRepository extends JpaRepository<UserEntity, Serializable>{ … }

有没有办法监控Spring生成的方法（例如findOne(…)）的执行时间？

- luke

Answer 1

最简单的方法是使用 CustomizableTraceInterceptor，方法如下：

@Configuration
@EnableAspectJAutoProxy
public class SpringDataExecutionLoggingConfiguration {

  @Bean
  public CustomizableTraceInterceptor customizableTraceInterceptor() {

    CustomizableTraceInterceptor customizableTraceInterceptor = new CustomizableTraceInterceptor();
    customizableTraceInterceptor.setUseDynamicLogger(true);
    customizableTraceInterceptor.setExitMessage("Executed $[methodName] in $[invocationTime]");
    return customizableTraceInterceptor;
  }

  @Bean
  public Advisor advisor() {

    AspectJExpressionPointcut pointcut = new AspectJExpressionPointcut();
    pointcut.setExpression("execution(public * org.springframework.data.repository.CrudRepository+.*(..))");
    return new DefaultPointcutAdvisor(pointcut, customizableTraceInterceptor());
  }
}

- Oliver Drotbohm

---

切入点不应该是："execution(public * org.springframework.data.repository.Repository+.*(..))"吗？ - peceps

无法运行，收到以下错误信息：java.lang.IllegalArgumentException: warning no match for this type name: org.springframework.data.jpa.repository.CrudRepository [Xlint:invalidAbsoluteTypeName]。 - Kamil Nękanowicz

execution(public * org.springframework.data.repository.CrudRepository+.*(..)) - zhaozhi

Answer 2

另外一个可行的解决方案：

@Aspect
@Component
public class ProfilerAspect {
    Logger logger = LoggerFactory.getLogger(this.getClass());

    @Pointcut("execution(public * org.springframework.data.repository.Repository+.*(..))")
    public void monitor() {}

    @Around("monitor()")
    public Object profile(ProceedingJoinPoint pjp) {
        long start = System.currentTimeMillis();
        logger.debug("JVM memory in use = "+ (Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory()));
        Object output = null;
        try {
            output = pjp.proceed();
        } catch (Throwable e) {
            logger.error(e.getMessage(), e);
        }
        long elapsedTime = System.currentTimeMillis() - start;
        logger.debug(pjp.getTarget()+"."+pjp.getSignature()+": Execution time: " + elapsedTime + " ms. ("+ elapsedTime/60000 + " minutes)");

        return output;
    }
}

- luke

---

除了它会吞掉异常并返回 null，这可能不是期望的行为之外，这很酷。 - TiGz