Sha256: b41aa788e6edea04495c72392bd366251b6f00830d6a2bcd09c5fedb683af4c8
Contents?: true
Size: 781 Bytes
Versions: 28
Compression:
Stored size: 781 Bytes
Contents
module ArJdbc
module SQLite3
module ExplainSupport
def supports_explain?
true
end
def explain(arel, binds = [])
sql = "EXPLAIN QUERY PLAN #{to_sql(arel, binds)}"
result = exec_query(sql, "EXPLAIN", binds)
ExplainPrettyPrinter.new.pp result
end
class ExplainPrettyPrinter # :nodoc:
# Pretty prints the result of a EXPLAIN QUERY PLAN in a way that resembles
# the output of the SQLite shell:
#
# 0|0|0|SEARCH TABLE users USING INTEGER PRIMARY KEY (rowid=?) (~1 rows)
# 0|1|1|SCAN TABLE posts (~100000 rows)
#
def pp(result)
result.rows.map do |row|
row.join('|')
end.join("\n") + "\n"
end
end
end
end
end
Version data entries
28 entries across 28 versions & 2 rubygems