Search code examples
elixirphoenix-frameworkecto

How can I see the SQL executed during an Ecto test?

When running an Ecto test with mix test ..., the SQL executed is not shown. As far as I can tell, it is not logged to any file, either. How can I see it? (I am using Ecto as part of a Phoenix application.)

Solution

  • Ecto logs the SQL queries with the level :debug. By default, the Logger level is set to :warn in config/test.exs, which will completely ignore :debug level logs. You can lower the level to :debug to see the SQL queries executed by Ecto. In config/test.exs, change:

    config :logger, level: :warn

    to

    config :logger, level: :debug

    and then run mix test.

    You can also change the level with which Ecto logs the queries by following the :loggers instructions here.