Class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::ExplainTest < ActiveRecord::TestCase

# File activerecord/test/cases/adapters/postgresql/explain_test.rb, line 26
def test_dont_explain_for_set_search_path
  queries = Thread.current[:available_queries_for_explain] = []
  ActiveRecord::Base.connection.schema_search_path = "public"
  assert queries.empty?
end

# File activerecord/test/cases/adapters/postgresql/explain_test.rb, line 10
def test_explain_for_one_query
  explain = Developer.where(:id => 1).explain
  assert_match %Q(EXPLAIN for: SELECT "developers".* FROM "developers"  WHERE "developers"."id" = 1), explain
  assert_match %Q(QUERY PLAN), explain
  assert_match %Q(Index Scan using developers_pkey on developers), explain
end

# File activerecord/test/cases/adapters/postgresql/explain_test.rb, line 17
def test_explain_with_eager_loading
  explain = Developer.where(:id => 1).includes(:audit_logs).explain
  assert_match %Q(QUERY PLAN), explain
  assert_match %Q(EXPLAIN for: SELECT "developers".* FROM "developers"  WHERE "developers"."id" = 1), explain
  assert_match %Q(Index Scan using developers_pkey on developers), explain
  assert_match %Q(EXPLAIN for: SELECT "audit_logs".* FROM "audit_logs"  WHERE "audit_logs"."developer_id" IN (1)), explain
  assert_match %Q(Seq Scan on audit_logs), explain
end