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 = "    SELECT \n      locktype,\n      database,\n      relation,\n      page,\n      tuple,\n      virtualxid,\n      transactionid,\n      classid,\n      objid,\n      objsubid,\n      virtualtransaction,\n      pid,\n      mode,\n      granted,\n      fastpath,\n      waitstart\n    FROM pg_locks;\n  SQL\n\n  result = DBConnection.connection.exec(query)\n  result.map { |row| row }\nend\n"