SQL queries are not showing when opening request details

[AliOsm]

As shown in the image, I can't see SQL queries details, and I'm pretty sure at least 1 request should be listed, any thought on this?

[igorkasyanchuk]

@AliOsm the best would be if you can clone repo, connect it in the your app and with binding.pry test see why it's not working

[AliOsm]

The weird thing is in development I can see SQL queries and detailed views rendering times, but in production I can't. I'm saving data for 24 hours, could this be a reason?

[igorkasyanchuk]

dont know, try to run locally in prod mode with binding.pry, try to change range of data, not sure what can be the reason

[AliOsm]

I found the reason (hopefully :3). When I set RAILS_LOG_LEVEL to debug, SQL queries start showing in production. Is this required? I can see the extension is tracing SQL payload from the event, but I'm not sure if the event will contain the SQL payload in production without RAILS_LOG_LEVEL set to debug or not.

[igorkasyanchuk]

@AliOsm oh I really don't remember, please continue investigation

[AliOsm]

So can you just check if debug logging is enabled in one of your applications that is using the gem in production 😅

[igorkasyanchuk]

it's not enabled

[AliOsm]

I think this issue is related to this one:
#31

What is the Rails version you are using in your application?

[igorkasyanchuk]

yeah, looks like the best is to switch from "logger" to "instrumentation" to capture details

this will require some investigation. if someone ready to help I would appreciate it.