1 files changed, 14 insertions, 0 deletions
diff --git a/sql/lock.sql b/sql/lock.sql
new file mode 100644
index 00000000..3e6492b1
--- /dev/null
+++ b/sql/lock.sql
@@ -0,0 +1,14 @@
+SELECT
+    locktype,
+    relation::regclass,
+    mode,
+    transactionid AS tid,
+    virtualtransaction AS vtid,
+    pid,
+    granted
+FROM
+    pg_catalog.pg_locks l
+    LEFT JOIN pg_catalog.pg_database db ON db.oid = l.database
+WHERE (db.datname = 'dawndb'
+    OR db.datname IS NULL)
+AND NOT pid = pg_backend_pid();