Sha256: 309f1077eb834083300dcc9cd9571a5822db7a6edab12c133b877703468193e0
Contents?: true
Size: 601 Bytes
Versions: 16
Compression:
Stored size: 601 Bytes
Contents
/* Queries with active locks */ SELECT pg_stat_activity.pid, pg_class.relname, pg_locks.transactionid, pg_locks.locktype, pg_locks.database, pg_locks.granted, pg_locks.mode, pg_stat_activity.query AS query_snippet, age(now(),pg_stat_activity.query_start) AS "age", pg_stat_activity.application_name AS application 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
16 entries across 16 versions & 1 rubygems