Symfony 2 and Doctrine: log SQL query execution time

Question

Is there any way to log SQL query execution time with queries? Currently only queries and their params are logged (into doctrine.DEBUG channel).

Symfony 2 (actually 2.0, cannot be updated) and Doctrine 2.2

Goku · Accepted Answer · 2014-03-13 14:41:52Z

1

From a container aware object, such as your controllers or commands, you can enable logging like this.

$this
    ->get('doctrine')
    ->getConnection()
    ->getConfiguration()
    ->setSQLLogger(new \Doctrine\DBAL\Logging\EchoSQLLogger());

This will set up EchoSQLLogger to do your logging for you, which results in every query and its parameters being printed with echo and var_dump().

answered Mar 13, 2014 at 14:41

Goku

2,1372 gold badges16 silver badges32 bronze badges

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

2 Comments

Sadly, this doesn't log the execution time which is what the questioner asked for.

Try with DebugStack as described here