diff options
author | Xavier Noria <fxn@hashref.com> | 2011-09-20 10:50:08 -0700 |
---|---|---|
committer | Xavier Noria <fxn@hashref.com> | 2011-11-05 18:30:19 -0700 |
commit | e7b7b4412380e7ce2d8e6ae402cb7fe02d7666b8 (patch) | |
tree | 00d94c919f9a3e4e4551a5a47e5a6d048b45335b /activerecord/test/cases/adapters/postgresql | |
parent | 89d7372dac7357134af6877ded159b16a8d3bc9b (diff) | |
download | rails-e7b7b4412380e7ce2d8e6ae402cb7fe02d7666b8.tar.gz rails-e7b7b4412380e7ce2d8e6ae402cb7fe02d7666b8.tar.bz2 rails-e7b7b4412380e7ce2d8e6ae402cb7fe02d7666b8.zip |
implements AR::Relation#explain
This is a first implementation, EXPLAIN is highly
dependent on the database and I have made some
compromises.
On one hand, the method allows you to run the most
common EXPLAIN and that's it. If you want EXPLAIN
ANALYZE in PostgreSQL you need to do it by hand.
On the other hand, I've tried to construct a string
as close as possible to the ones built by the
respective shells. The rationale is that IMO the
user should feel at home with the output and
recognize it at first sight. Per database.
I don't know whether this implementation is going
to work well. Let's see whether people like it.
Diffstat (limited to 'activerecord/test/cases/adapters/postgresql')
-rw-r--r-- | activerecord/test/cases/adapters/postgresql/explain_test.rb | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/activerecord/test/cases/adapters/postgresql/explain_test.rb b/activerecord/test/cases/adapters/postgresql/explain_test.rb new file mode 100644 index 0000000000..0d599ed37f --- /dev/null +++ b/activerecord/test/cases/adapters/postgresql/explain_test.rb @@ -0,0 +1,25 @@ +require "cases/helper" +require 'models/developer' + +module ActiveRecord + module ConnectionAdapters + class PostgreSQLAdapter + class ExplainTest < ActiveRecord::TestCase + fixtures :developers + + def test_explain_for_one_query + explain = Developer.where(:id => 1).explain + assert_match %(QUERY PLAN), explain + assert_match %(Index Scan using developers_pkey on developers), explain + end + + def test_explain_with_eager_loading + explain = Developer.where(:id => 1).includes(:audit_logs).explain + assert_match %(QUERY PLAN), explain + assert_match %(Index Scan using developers_pkey on developers), explain + assert_match %(Seq Scan on audit_logs), explain + end + end + end + end +end |