Yah, i thought about that too, but verified I am in the correct DB. Just for clarity sake:
SELECT relation::regclass
FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) and mode = 'AccessExclusiveLock';
relation
------------
3245508214
3245508273
3245508272
3245508257
3245508469
3245508274
3245508373
3245508468
3245508210
3245508463
3245508205
3245508260
3245508265
3245508434
(16 rows)