# How to change log level of SQL queries?

**URL:** <https://discourse.rom-rb.org/t/how-to-change-log-level-of-sql-queries/457>\
**Category:** Issues\
**Created:** [April 29, 2021, 10:13am UTC](https://discourse.rom-rb.org/t/how-to-change-log-level-of-sql-queries/457 "2021-04-29T10:13:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![paddor](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/paddor/32/231_2.png) [@paddor](https://discourse.rom-rb.org/u/paddor)\
**Post date:** [April 29, 2021, 10:13am UTC](https://discourse.rom-rb.org/t/how-to-change-log-level-of-sql-queries/457/1 "2021-04-29T10:13:20Z")

</div>

Instead of INFO, I want to have them logged as DEBUG.

Since I guess it’s Sequel doing the logging, I guess I have to access the `Sequel::Database` object used, to call `.sql_log_level = :debug` on it. Where is that database object?

Thanks.

---

<div class="post-metadata">

**Author:** ![apohllo](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/apohllo/32/86_2.png) [@apohllo](https://discourse.rom-rb.org/u/apohllo)\
**Post date:** [April 29, 2021, 4:02pm UTC](https://discourse.rom-rb.org/t/how-to-change-log-level-of-sql-queries/457/2 "2021-04-29T16:02:51Z")

</div>

I guess `rom.gateways[:default].connection` is the easiest way to access Sequel DB object.  
But I also have the following setup to get debug level messages from Sequel:

```auto
logger = Logger.new($stdout)
# logger.level = Logger::INFO # define your logger level
rom_config.gateways[:default].use_logger(logger)

```

This is turned on by ENV variable, since by default there are lots of messages generated by Sequel.

---

<div class="post-metadata">

**Author:** ![paddor](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/paddor/32/231_2.png) [@paddor](https://discourse.rom-rb.org/u/paddor)\
**Post date:** [April 30, 2021, 8:57pm UTC](https://discourse.rom-rb.org/t/how-to-change-log-level-of-sql-queries/457/3 "2021-04-30T20:57:13Z")

</div>

> [@apohllo](#):
>
> `rom.gateways[:default].connection`

Thanks! That was it.