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 locks.ex
Raw

lib/queries/locks.ex 

defmodule EctoPSQLExtras.Locks do

  def title do

    "Queries with active exclusive locks"

  end



  def query do

"""

/* Queries with active exclusive locks */



SELECT

  pg_stat_activity.pid,

  pg_class.relname,

  pg_locks.transactionid,

  pg_locks.granted,

  pg_locks.mode,

  pg_stat_activity.query AS query_snippet,

  age(now(),pg_stat_activity.query_start) AS "age"

FROM pg_stat_activity,pg_locks left

OUTER JOIN pg_class

  ON (pg_locks.relation = pg_class.oid)

WHERE pg_stat_activity.query <> '<insufficient privilege>'

  AND pg_locks.pid = pg_stat_activity.pid

  AND pg_locks.mode IN ('ExclusiveLock', 'AccessExclusiveLock', 'RowExclusiveLock')

  AND pg_stat_activity.pid <> pg_backend_pid() order by query_start;

"""

  end

end