Storing doctrine queries in a file log with symfony

23/10/2015 - DOCTRINE, SYMFONY

If you want to see what queries have been run in your application, you can use example below to record the log.


Configuration


# app/config/config_test.yml

monolog:
    handlers:
        ...
        ...
        doctrine:
            action_level: debug
            type:  stream
            path:  %kernel.logs_dir%/%kernel.environment%_doctrine.log
            channels: doctrine
        ...
        ...

Listing logs


You can run tail -f app/logs/test_doctrine.log command.