How to log all the queries in a log file in a java application with mongodb?

I have a java application which use morphia to work with mongodb.

I want to log al开发者_运维技巧l the queries sent to mongodb in a file, which I can analyze them to improve the performance. But I don't find a way to log them.

I know mongodb can log the queries in system.profile collection, but I still want a log file.

How to do that?

---

Do you use SLF4J or Logback/Log4J? Add Morphias' SLF4JExtension to your CLASSPATH.

Then simply enable com.google.code.morphia logger and log it wherever you want.

---

I'm using Morphia (version 1.3.2) on top of Java MongoDB driver (version 3.9.1), and I was able to enable the actual query logging (using Log4j2) by setting org.mongodb.morphia logger level to trace. That is, in my log4j2.xml:

<Loggers>
    ...
    <Logger name="org.mongodb.morphia" level="trace" />
    ...
</Loggers>