Sha256: 6164a1f1f4b4433edfe8b228825635ad55379c482d09ec55991db0b893f0ea3d
Contents?: true
Size: 653 Bytes
Versions: 9
Compression:
Stored size: 653 Bytes
Contents
/* 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", 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_locks.mode IN ('ExclusiveLock', 'AccessExclusiveLock', 'RowExclusiveLock') AND pg_stat_activity.pid <> pg_backend_pid() order by query_start;
Version data entries
9 entries across 9 versions & 1 rubygems