This article assumes a general understanding of how databases, Ruby, and Rails work - the examples below use the ActiveRecord library to map databa...
For further actions, you may consider blocking this person and/or reporting abuse
Was looking more for an interactive parser similar to the above that does a good job of breaking down each join and which ones stand out as larger problems from everything else (visually). Even with Query Plan Analyzer / DBMS_XPLAN it can get pretty hectic, especially when it starts introducing bitmap and hash joins, and if you have a lot of tables even the indented table tree view can be unwieldy after a certain depth.
Depesz's tool for explaining EXPLAIN output looks fantastic for PostgreSQL -- is there a similar tool for Oracle plans?
Good solution for when you are stuck with using an orm. But why not just make the sql query in-line and map the results set directly to json.Skip activerecord entirely.
Ah! This is cool!!