Torus.QueryInspector (Torus v0.3.0)
View SourceHelpers to debug your SQL queries. You can this module both while creating the queries and directly in your running production shell once deployed, so that the explain analyze returns more accurate results.
Summary
Functions
Substitutes the params into the SQL.
Runs explain analyze on the query and prints it to the console. Returns the query.
Converts the query to SQL and prints it to the console. Returns the query.
Substitutes the parameters in the query and prints the SQL to the console. Returns the query. The SQL is in its raw form and can be directly executed by postgres.
Functions
@spec substituted_sql(Ecto.Query.t(), Ecto.Repo.t(), :all | :update_all | :delete_all) :: String.t()
Substitutes the params into the SQL.
Examples
iex> Post |> where(id: 1) |> Torus.QueryInspector.substituted_sql(Torus.Test.Repo)
"SELECT p0."id", p0."title", p0."body", p0."author_id" FROM "posts" AS p0 WHERE (p0."id" = 1)"@spec tap_explain_analyze( Ecto.Query.t(), Ecto.Repo.t(), :all | :update_all | :delete_all ) :: Ecto.Query.t()
Runs explain analyze on the query and prints it to the console. Returns the query.
Runs the query!
@spec tap_sql(Ecto.Query.t(), Ecto.Repo.t(), :all | :update_all | :delete_all) :: Ecto.Query.t()
Converts the query to SQL and prints it to the console. Returns the query.
Substitutes the parameters in the query and prints the SQL to the console. Returns the query. The SQL is in its raw form and can be directly executed by postgres.
Example
iex> Post
...> |> where(id: 1)
...> # ... Your complex query
...> |> Torus.QueryInspector.tap_substituted_sql(Torus.Test.Repo)
...> |> Repo.all()