Sha256: 2bf6bf8c3d2f6d80bb3934cac907bc440f3e5b9a95600d30fd9aabaa749dfcd8
Contents?: true
Size: 507 Bytes
Versions: 53
Compression:
Stored size: 507 Bytes
Contents
/* Queries with active 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_stat_activity.pid <> pg_backend_pid() order by query_start;
Version data entries
53 entries across 53 versions & 3 rubygems