擅长:python、mysql、java
<p>就这么做</p>
<pre><code>SELECT pid, relname
FROM pg_locks l
JOIN pg_class t ON l.relation = t.oid AND t.relkind = 'r'
WHERE t.relname = 'Bill';
</code></pre>
<p>然后通过</p>
<pre><code>kill 1234
</code></pre>
<p>其中1234是查询结果中的实际pid。</p>
<p>您可以像这样将其全部管道化(这样就不必手动复制粘贴每个pid):</p>
<pre><code>psql -c "SELECT pid FROM pg_locks l
JOIN pg_class t ON l.relation = t.oid AND t.relkind = 'r'
WHERE t.relname = 'Bill';" | tail -n +3 | head -n -2 | xargs kill
</code></pre>