MiniProfiler icon indicating copy to clipboard operation
MiniProfiler copied to clipboard

Ruby SQL not showing up

Open ksheurs opened this issue 12 years ago • 6 comments

hi there,

i've added the gem 'rack-mini-profiler' per http://samsaffron.com/archive/2012/07/12/miniprofiler-ruby-edition. i can see render durations, client stats, etc, but no sql logging is happening?

the only queries that sometime show up are schema queries.

i'm using the following: ruby 1.9.3 rails 3.2.8 postgres

mini_profiler.rb: http://cl.ly/image/191c1O1L0p1l

thanks!

ksheurs avatar Dec 14 '12 23:12 ksheurs

can you please include your Gemfile

SamSaffron avatar Dec 31 '12 02:12 SamSaffron

I have a similar issue in a large project with ruby 1.8.7, rails 3.0.20, and mysql.

There are 130 gems in my Gemfile, but when the Gemfile is applied to a basic blog example running on the same stack, MiniProfiler logs sql fine.

jamesgecko avatar Mar 13 '13 14:03 jamesgecko

I've also encountered this issue. Realized that just by having the following in Gemfile isn't sufficient:

gem 'activerecord-postgresql-adapter'
...
gem 'rack-mini-profiler'

I need to explicitly do:

gem 'pg'
gem 'activerecord-postgresql-adapter'
...
gem 'rack-mini-profiler'

Otherwise, miniprofiler wont be able to patch PG::Result & PG::Connection to yield the sql logging.

ngty avatar Apr 24 '13 04:04 ngty

I added a note about this in the install doc, I guess we could defer the monkey patching till the first request. Open to a PR with it.

In the mean time I added a note in the readme

SamSaffron avatar Jul 30 '13 01:07 SamSaffron

Hey Sam. I've got the rack-mini-profiler gem under pg and active-record-postgresql-adapter and still not seeing any sql in my profiling results.. any idea what to look for?

uriklar avatar Apr 10 '14 09:04 uriklar

Really not sure what is going on, maybe try sourcing it from a directory and add a few puts statements around the area that does the monkey patching.

On Thu, Apr 10, 2014 at 7:29 PM, Uri Klar [email protected] wrote:

Hey Sam. I've got the rack-mini-profiler gem under pg and active-record-postgresql-adapter and still not seeing any sql in my profiling results.. any idea what to look for?

— Reply to this email directly or view it on GitHubhttps://github.com/SamSaffron/MiniProfiler/issues/98#issuecomment-40058964 .

SamSaffron avatar Apr 24 '14 03:04 SamSaffron