Packages

ecto_psql_extras

0.1.2
0.8.8 0.8.7 0.8.6 0.8.5 0.8.4 0.8.3 0.8.2 0.8.1 0.8.0 0.7.15 0.7.14 0.7.13 0.7.12 0.7.11 0.7.10 0.7.9 0.7.8 0.7.7 0.7.6 0.7.5 0.7.4 0.7.3 0.7.2 0.7.1 0.7.0 0.6.5 0.6.4 0.6.3 0.6.2 0.6.1 0.6.0 0.4.4 0.4.3 0.4.2 0.4.1 0.4.0 0.3.4 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.4 0.1.3 0.1.2 0.0.2 0.0.1

Ecto PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

HexDocs

Current section

Files

Jump to
Readme
47 Versions
2 Dependencies
Dependants
Files
Activity
ecto_psql_extras lib queries total_index_size.ex
Raw

lib/queries/total_index_size.ex 

defmodule EctoPSQLExtras.TotalIndexSize do

  def title do

    "Total size of all indexes in MB"

  end



  def query do

"""

/* Total size of all indexes in MB */



SELECT pg_size_pretty(sum(c.relpages::bigint*8192)::bigint) AS size

FROM pg_class c

LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace)

WHERE n.nspname NOT IN ('pg_catalog', 'information_schema')

AND n.nspname !~ '^pg_toast'

AND c.relkind='i';

"""

  end

end