showing locks from all postgres relations
You can only resolve names from the current database. This is because the pg_class table, which is what the ::reglass operator uses to resolve the names, is local to each database.