ecto_psql_extras v0.4.3

EctoPSQLExtras behaviour (ecto_psql_extras v0.4.3) View Source

The entry point for each function.

Link to this section Summary

Functions

all_locks(repo, format \\ :ascii)

Run all_locks query on repo, in the given format.

bloat(repo, format \\ :ascii)

Run bloat query on repo, in the given format.

blocking(repo, format \\ :ascii)

Run blocking query on repo, in the given format.

cache_hit(repo, format \\ :ascii)

Run cache_hit query on repo, in the given format.

calls(repo, format \\ :ascii)

Run calls query on repo, in the given format.

extensions(repo, format \\ :ascii)

Run extensions query on repo, in the given format.

index_cache_hit(repo, format \\ :ascii)

Run index_cache_hit query on repo, in the given format.

index_size(repo, format \\ :ascii)

Run index_size query on repo, in the given format.

index_usage(repo, format \\ :ascii)

Run index_usage query on repo, in the given format.

kill_all(repo, format \\ :ascii)

Run kill_all query on repo, in the given format.

locks(repo, format \\ :ascii)

Run locks query on repo, in the given format.

long_running_queries(repo, format \\ :ascii)

Run long_running_queries query on repo, in the given format.

mandelbrot(repo, format \\ :ascii)

Run mandelbrot query on repo, in the given format.

outliers(repo, format \\ :ascii)

Run outliers query on repo, in the given format.

queries(repo \\ nil)

Returns all queries and their modules.

query(name, repo, format \\ :ascii)

Run a query with name, on repo, in the given format.

records_rank(repo, format \\ :ascii)

Run records_rank query on repo, in the given format.

seq_scans(repo, format \\ :ascii)

Run seq_scans query on repo, in the given format.

table_cache_hit(repo, format \\ :ascii)

Run table_cache_hit query on repo, in the given format.

table_indexes_size(repo, format \\ :ascii)

Run table_indexes_size query on repo, in the given format.

table_size(repo, format \\ :ascii)

Run table_size query on repo, in the given format.

total_index_size(repo, format \\ :ascii)

Run total_index_size query on repo, in the given format.

total_table_size(repo, format \\ :ascii)

Run total_table_size query on repo, in the given format.

unused_indexes(repo, format \\ :ascii)

Run unused_indexes query on repo, in the given format.

vacuum_stats(repo, format \\ :ascii)

Run vacuum_stats query on repo, in the given format.

Callbacks

info()
query()

Link to this section Functions

Link to this function

all_locks(repo, format \\ :ascii)

View Source

Run all_locks query on repo, in the given format.

format is either :ascii or :raw

Link to this function

bloat(repo, format \\ :ascii)

View Source

Run bloat query on repo, in the given format.

format is either :ascii or :raw

Link to this function

blocking(repo, format \\ :ascii)

View Source

Run blocking query on repo, in the given format.

format is either :ascii or :raw

Link to this function

cache_hit(repo, format \\ :ascii)

View Source

Run cache_hit query on repo, in the given format.

format is either :ascii or :raw

Link to this function

calls(repo, format \\ :ascii)

View Source

Run calls query on repo, in the given format.

format is either :ascii or :raw

Link to this function

extensions(repo, format \\ :ascii)

View Source

Run extensions query on repo, in the given format.

format is either :ascii or :raw

Link to this function

index_cache_hit(repo, format \\ :ascii)

View Source

Run index_cache_hit query on repo, in the given format.

format is either :ascii or :raw

Link to this function

index_size(repo, format \\ :ascii)

View Source

Run index_size query on repo, in the given format.

format is either :ascii or :raw

Link to this function

index_usage(repo, format \\ :ascii)

View Source

Run index_usage query on repo, in the given format.

format is either :ascii or :raw

Link to this function

kill_all(repo, format \\ :ascii)

View Source

Run kill_all query on repo, in the given format.

format is either :ascii or :raw

Link to this function

locks(repo, format \\ :ascii)

View Source

Run locks query on repo, in the given format.

format is either :ascii or :raw

Link to this function

long_running_queries(repo, format \\ :ascii)

View Source

Run long_running_queries query on repo, in the given format.

format is either :ascii or :raw

Link to this function

mandelbrot(repo, format \\ :ascii)

View Source

Run mandelbrot query on repo, in the given format.

format is either :ascii or :raw

Link to this function

outliers(repo, format \\ :ascii)

View Source

Run outliers query on repo, in the given format.

format is either :ascii or :raw

Link to this function

queries(repo \\ nil)

View Source

Returns all queries and their modules.

If a repository is given, it will be queried for extensions support and special queries will be included if available.

Link to this function

query(name, repo, format \\ :ascii)

View Source

Run a query with name, on repo, in the given format.

format is either :ascii or :raw.

Link to this function

records_rank(repo, format \\ :ascii)

View Source

Run records_rank query on repo, in the given format.

format is either :ascii or :raw

Link to this function

seq_scans(repo, format \\ :ascii)

View Source

Run seq_scans query on repo, in the given format.

format is either :ascii or :raw

Link to this function

table_cache_hit(repo, format \\ :ascii)

View Source

Run table_cache_hit query on repo, in the given format.

format is either :ascii or :raw

Link to this function

table_indexes_size(repo, format \\ :ascii)

View Source

Run table_indexes_size query on repo, in the given format.

format is either :ascii or :raw

Link to this function

table_size(repo, format \\ :ascii)

View Source

Run table_size query on repo, in the given format.

format is either :ascii or :raw

Link to this function

total_index_size(repo, format \\ :ascii)

View Source

Run total_index_size query on repo, in the given format.

format is either :ascii or :raw

Link to this function

total_table_size(repo, format \\ :ascii)

View Source

Run total_table_size query on repo, in the given format.

format is either :ascii or :raw

Link to this function

unused_indexes(repo, format \\ :ascii)

View Source

Run unused_indexes query on repo, in the given format.

format is either :ascii or :raw

Link to this function

vacuum_stats(repo, format \\ :ascii)

View Source

Run vacuum_stats query on repo, in the given format.

format is either :ascii or :raw

Link to this section Callbacks

Link to this callback

info()

View Source

Specs

info() :: %{
  :title => binary(),
  :columns => [%{name: atom(), type: atom()}],
  optional(:order_by) => [{atom(), :asc | :desc}],
  optional(:limit) => pos_integer()
}
Link to this callback

query()

View Source

Specs

query() :: binary()