1 files changed, 3 insertions, 1 deletions
diff --git a/sql/lock.sql b/sql/lock.sql
index 3e6492b1..595ce205 100644
--- a/sql/lock.sql
+++ b/sql/lock.sql
@@ -5,10 +5,12 @@ SELECT
     transactionid AS tid,
     virtualtransaction AS vtid,
     pid,
-    granted
+    granted,
+    application_name
 FROM
     pg_catalog.pg_locks l
     LEFT JOIN pg_catalog.pg_database db ON db.oid = l.database
+    LEFT JOIN pg_stat_activity a USING (pid)
 WHERE (db.datname = 'dawndb'
     OR db.datname IS NULL)
 AND NOT pid = pg_backend_pid();