How to log the queries executed by Spring Data MongoDB?

Question

Is there a way to find the query that was run against the database in spring data mongodb?

I know this is possible in case of JPA. So was just wondering if there was something similar in Spring data MongoDB?

Possible duplicate of how to show query while using query annotations with MongoRepository with spring data — pvpkiran
– pvpkiran, Commented Mar 7, 2018 at 9:02
Check out this Stackoverflow answer: stackoverflow.com/questions/39217351/… — Kihats
– Kihats, Commented Oct 23, 2018 at 8:09

Oliver Drotbohm · Accepted Answer · 2018-03-07 07:12:30Z

10

The easiest way is to set the log level to DEBUG for org.springframework.data.mongodb.

answered Mar 7, 2018 at 7:12

Oliver Drotbohm

83.6k19 gold badges236 silver badges219 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

I tried executing repository.findAll(predicate, sort) but the log only shows the filters but not the sort. Is there anyway I can see the sort query?

@user1955934 Yeah, also found this, in MongoTemplate class only find queries do not log sort part for unknown reasons

Dylan · Accepted Answer · 2019-12-04 18:28:51Z

6

logging:
  level:
    org.springframework.data.mongodb.core.MongoTemplate: DEBUG

To clarify Oliver's answer add that to the application.yml file or properties file.

answered Dec 4, 2019 at 18:28

Dylan

2,2294 gold badges32 silver badges54 bronze badges

Thanks! logging.level.org.springframework.data.mongodb.core.MongoTemplate=DEBUG worked for me in application.properties