Module: PgMonitor::PGLocks

Defined in:
lib/pg_monitor/pg_locks.rb

Class Method Summary collapse

Class Method Details

.fetch ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
# File 'lib/pg_monitor/pg_locks.rb', line 7

def fetch
  query = <<~SQL
    SELECT 
      locktype,
      database,
      relation,
      page,
      tuple,
      virtualxid,
      transactionid,
      classid,
      objid,
      objsubid,
      virtualtransaction,
      pid,
      mode,
      granted,
      fastpath,
      waitstart
    FROM pg_locks;
  SQL

  result = DBConnection.connection.exec(query)
  result.map { |row| row }
end