Selecto v0.3.12

Selecto.Diagnostics (Selecto v0.3.12)

Query diagnostics helpers (EXPLAIN / EXPLAIN ANALYZE).

Link to this section Summary

Types

explain_result()

Functions

build_explain_sql(query_sql, opts \\ [])

Build the explain SQL wrapper.

explain(selecto, opts \\ [])

Run EXPLAIN for a Selecto query.

explain_analyze(selecto, opts \\ [])

Run EXPLAIN ANALYZE for a Selecto query.

Link to this section Types

Link to this type

explain_result()

@type explain_result() :: %{
  explain_sql: String.t(),
  query_sql: String.t(),
  params: list(),
  columns: [String.t()],
  rows: list(),
  plan_lines: [String.t()]
}

Link to this section Functions

Link to this function

build_explain_sql(query_sql, opts \\ [])

@spec build_explain_sql(
  String.t(),
  keyword()
) :: String.t()

Build the explain SQL wrapper.

Link to this function

explain(selecto, opts \\ [])

@spec explain(
  Selecto.t(),
  keyword()
) :: {:ok, explain_result()} | {:error, Selecto.Error.t()}

Run EXPLAIN for a Selecto query.

Link to this function

explain_analyze(selecto, opts \\ [])

@spec explain_analyze(
  Selecto.t(),
  keyword()
) :: {:ok, explain_result()} | {:error, Selecto.Error.t()}

Run EXPLAIN ANALYZE for a Selecto query.