Misuring execution time of queries with spring aop and spring jdbc in spring boot

LoggingExecutionTimeQueryAspect.java

@Component
@Aspect
@Slf4j
public class LoggingExecutionTimeQueryAspect {
	//replace <> with your own repository class info for tracing execution time of queries of that Repository
	private Temporal startTime;

    @Before("execution(* <PACKAGE>.<RESPOSITORY_CLASS_NAME>.*(..))")
    public void logBeforeQueryInvocation(JoinPoint joinPoint){
    	startTime = Instant.now();
    }
    
    @After("execution(* <PACKAGE>.<RESPOSITORY_CLASS_NAME>.*(..))")
    public void logAfterQueryInvocation(JoinPoint joinPoint){
    	Duration d = Duration.between(startTime, Instant.now());
        log.info("Execution time: " + DurationFormatUtils.formatDurationHMS(d.toMillis()) + " Method: " + joinPoint.getSignature());
    }
}

pom.xml

		<dependency>
		  <groupId>org.springframework.boot</groupId>
		  <artifactId>spring-boot-starter-aop</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jdbc</artifactId>
		</dependency>