#368 MiniProfiler

Big thanks Ryan, for the excellent Railscast!

This is a great little gem to see what overheads you are getting in your app due to not slim lining your SQL statements +1

Thanks Ryan, for Great Tutorial.

I tried with your example_before application. But, it doesn't show the small Profiler box on left side.

I just added this gem 'rack-mini-profiler' on my Gemfile (example_before).

Is it enough?. Or need to make any additional configuration.

Hi,ryan i couldn't create a SCAFFOLD...?
It throws error
`require': no such file to load --
json (LoadError)
Only when i include gem 'rack-mini-profiler' or else it's fine...
Help me to come out...

Hmm.. I installed the gem and the profiler tab shows up and displays the amount of time that loading took for a page, but it reports 0 sql queries for all pages. Any idea what's going on? I'm using postgres, but that shouldn't matter.

Thanks for tutorial, just installed gem and nothing happened. FireBug console shows that every request POST http://0.0.0.0:3000/mini-profiler-resources/results is failed without any additional information =/

Very nice Ryan! Thanks!

@Sam, as a suggestion, a post about the .net->ruby conversion would be awesome. And thanks for the great job!

My unicorn workers die if I add rack-mini-profiler to my Gemfile. Ryan, do you know why this is happening?
At the moment I am profiling with thin, because I did not get it to run with Unicorn, but for better estimating performance problems, I would really like to profile with my production web server (unicorn)

Would be glad about any hints.

Anyway, great episode!

Thanks for the introduction to MiniProfiler. I'm trying to use this on a 3.0.14 rails / 1.9.3-p194 ruby app without success.

NoMethodError: undefined method `bytesize' for #ActionDispatch::Response:0x000001035561b8

Could not find any documentation about minimal requirements. Anyone having the same issue?

@dup2, have not tested 3.0.14, will test it out and reply on the community tracker.

Others, will try to respond to all the requests here today, but it would be mighty handy if you can post bugs/questions at http://community.miniprofiler.com

Hi @Sam - it works fine on my development machine but not on my production server, I get an 'Internal Server Error' and my production log shows:

Filter chain halted as #<Proc:0x000000059a2f68@/my_apps/apps/app_name/shared/bundle/ruby/1.9.1/gems/actionpack-3.2.6/lib/action_controller/metal/http_authentication.rb:112> rendered or redirected

Any ideas what's going on?

EDIT: I removed the http_basic_authenticate_with but it's still not working and there are no other clues in the log file :/

@Sam
This is very promising. I am following Ryan's screencast and everything works fine on my dev machine, but I do not see the Profiler Tab in my production environment on my local machine. Is there something different in your local gem?
Thanks.
Bharat

Try to clearing all browsing cache. It should work fine.

Is there a plan to support mongoid?

I installed miniprofiler as Ryan said. But, the miniprofiler don`t show itself in the index.

My Rails version is 3.0.15 and Ruby version is 1.9.2p180.

When running the rails with server mode, it gives me a

Internal Server Error

undefined method `bytesize' for #<ActionDispatch::Response:0x000008079989f0>
WEBrick/1.3.1 (Ruby/1.9.2/2011-02-18) 

and the console log.

[2012-07-27 11:02:49] ERROR NoMethodError: undefined method `bytesize' for #<ActionDispatch::Response:0x0000080409add8>
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-mini-profiler-0.1.7/lib/mini_profiler/body_add_proxy.rb:18:in `method_missing'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/utils.rb:276:in `bytesize'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/content_length.rb:22:in `block in call'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/content_length.rb:22:in `each'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/content_length.rb:22:in `inject'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/content_length.rb:22:in `call'
        /usr/local/rvm/gems/ruby-1.9.2-p180@global/gems/rack-1.2.5/lib/rack/handler/webrick.rb:52:in `service'
        /usr/local/rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'
        /usr/local/rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'
        /usr/local/rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread'

After that, i running the system from apache/passenger, but still, i couldn`t see the profiler in index, i see the index page source, it give me

</html>
<script type="text/javascript">    
    (function(){
        var init = function() {        
                var load = function(s,f){
                    var sc = document.createElement('script');
                    sc.async = 'async';
                    sc.type = 'text/javascript';
                    sc.src = s;
                    var l = false;
                    sc.onload = sc.onreadystatechange  = function(_, abort) {
                        if (!l && (!sc.readyState || /loaded|complete/.test(sc.readyState))) {
                            if (!abort){l=true; f();}
                        }
                    };

                    document.getElementsByTagName('head')[0].appendChild(sc);
                };                
                
                var initMp = function(){
                    load('/mini-profiler-resources/includes.js?v=104',function(){
                        MiniProfiler.init({
                            ids: ["p5a937ewxrrubs0tac38","qey8rl644x2an5x5d6p4","j5um9hugszmuwqk2ohos","7yowrrf5jgiuyr1qay8b","1t75jjzqgolxrdfwh84r","tm9zo7oshjqbvotg9bkm","i4fta5g96t7bfhmi2ifn","xvrw6jdradhpjepdjtb9","dv8soit19h1xro0s0kij","opbu5ya5fgt5mbhbjies","optspv3v29mlw0go62q7"],
                            path: '/mini-profiler-resources/',
                            version: '104',
                            renderPosition: 'left',
                            showTrivial: false,
                            showChildrenTime: false,
                            maxTracesToShow: 10,
                            showControls: false,
                            currentId: 'p5a937ewxrrubs0tac38',
                            authorized: true
                        });
                    });
                };
                if (false) {
                    jQueryMP = jQuery;
                    initMp();
                } else {
                    load('/mini-profiler-resources/jquery.1.7.1.js?v=104', initMp);
                }
                
        };

        var w = 0;        
        var f = false;
        var deferInit = function(){ 
            if (f) return;
            if (window.performance && window.performance.timing && window.performance.timing.loadEventEnd == 0 && w < 10000){
                setTimeout(deferInit, 100);
                w += 100;
            } else {
                f = true;
                init();
            }
        };
        if (document.addEventListener) {
            document.addEventListener('DOMContentLoaded',deferInit);
        }
        var o = window.onload;
        window.onload = function(){if(o)o; deferInit()};
    })();
</script>

Profiler, javascript code after the

</html> 

tag..

So, i could not still see the profile.. bad.. so bad.

All those who were having trouble, can you test again on 0.1.8, quite a few important fixes there

Looks like a great app!

I couldn't get it to work in my development environment, described in short the problem here:

http://community.miniprofiler.com/permalinks/85/rails-no-such-file-to-load----rack-mini-profiler-loaderror

Any hint?

Thanks for the wonderful gem!

Ruby 1.9.2p290, Rails 3.2.7, Windows 7 here.

Shows load times but the SQL column is empty.

The dev database is on sqlite.

I've installed MiniProfiler with no problems, however I'm unable to find the configuration to allow more then 10 traces in the top left corder. The actual useful requests are getting "swallowed" by later smaller requests... (I can't precompile assets in order to reduce number of requests yet as I am on 3.0.x). Is such config option available?

I was trying the caching techniques from episode #321 and pulling my hair out trying to figure out why I wasn't get etag headers in my responses. Turns out that MiniProfiler strips the etag headers. It also rewrites the Cache-Control header.

From MiniProfiler source: mini-profiler/profiler.rb

# mini profiler is meddling with stuff, we can not cache cause we will get incorrect data
# Rack::ETag has already inserted some nonesense in the chain
headers.delete('ETag')
headers.delete('Date')
headers['Cache-Control'] = 'must-revalidate, private, max-age=0'
[status, headers, body]

Probably isn't a big deal because the profiler is disabled in production. But makes things trickier on the development side. Just wanted to share this in case anyone hits the same issue.

Hi there,

first of all thanks to Ryan for a great RailsCast again and thanks to Sam for this wonderful gem.

No problem with installing the gem as expected. But I also do not see any SQL query times while profiling in development mode. Here's my setup:

ruby-1.9.3-p194 [ x86_64 ]
Using rails (3.2.8)
Using rack (1.4.1)
Using sqlite3 (1.3.6) for development
Using pg (0.14.1) for production (no MySQL gem)
Using newrelic_rpm (3.4.2)
Using thin (1.4.1)

Any progress in examining this issue? Do you want me to post this question / issue on http://community.miniprofiler.com ?

Thanks a lot

Andy

Hi I am getting the following error when starting rails server after installing the gem using bundle install. Has anyone seen this and know how to resolve it. I am using ruby 1.8.7 and rails 3.2

ankur@ankurmac ~/D/c/b/openslot> rails s
/Users/ankur/.rvm/gems/ruby-1.8.7-p370/gems/activesupport-3.2.0/lib/active_support/dependencies.rb:251:in `require': /Users/ankur/.rvm/gems/ruby-1.8.7-p370/gems/rack-mini-profiler-0.1.18/lib/mini_profiler/profiler.rb:375: syntax error, unexpected ')', expecting '=' (SyntaxError)

After deploying in production it gave a 'Bad Gateway' error in browser. The corresponding error in the nginx error.log was "upstream prematurely closed connection while reading response header from upstream, client:" Any Ideas?

Very useful, thank you!

How can you tell how much loading time is too much?
For example, my home page takes ~340 ms to load in dev environment.
Is it too long or not?

I understand that it all depends on the complexity of my app, but I'm struggling with this because this's my first rails project and I simply doesn't know what performance time is OK.

Miniprofiler is showing many queries selecting from pg_attribute and pg_class. These queries are not in the development log. 14 of the 20 queries on one of my pages are these pg queries. Do these queries have to be run? If not how can I prevent them from running?

I reloaded my page and it seems these are not run again, so it must be some kind of 'first time the server loads' type queries.

In order for authorize_request and deauthorize_request to work, you have to set the authorize mode to whitelist.

application.rb
Rack::MiniProfiler.config.authorization_mode = :whitelist

Hi I am trying to add miniprofiler to mysite: https://wikigurus.com/.

First I tried in my local. I am getting below error
http://localhost:53506/mini-profiler-resources/includes.js?v=ySF6M98CBehTtL86BbiEmys9yxR1HKazhe2sznfdUWQ= 404 not found.

I also added the below code to web.config

        <add path="mini-profiler-resources/*" verb="*" type="System.Web.Routing.UrlRoutingModule"  />

Why it is throwing 404 error?

Awesome, keep going.

Do you think these are helpful?