Postgresql-为什么DROP VIEW命令挂起？

我想做一个简单的表演DROP VIEW ...但它挂了。

我已经运行了这个查询SELECT * FROM pg_locks WHERE NOT granted摘自锁监控页面。

但是，他们建议的以下查询不会返回任何结果：

SELECT bl.pid     AS blocked_pid,
     a.usename  AS blocked_user,
     kl.pid     AS blocking_pid,
     ka.usename AS blocking_user,
     a.query    AS blocked_statement
FROM  pg_catalog.pg_locks         bl
JOIN pg_catalog.pg_stat_activity a  ON a.pid = bl.pid
JOIN pg_catalog.pg_locks         kl ON kl.transactionid = bl.transactionid AND kl.pid != bl.pid
JOIN pg_catalog.pg_stat_activity ka ON ka.pid = kl.pid
WHERE NOT bl.granted;

我现在应该去哪里？