Postgres 查询在通过 shell 脚本执行时获得锁定

Question

通过 perl 执行以下查询被锁定

ALTER TABLE base_table
   DETACH PARTITION part_table;

通过使用此查询

  select pid,state, 
       usename, 
       pg_blocking_pids(pid) as blocked_by, 
       query as blocked_query
from pg_stat_activity
where cardinality(pg_blocking_pids(pid)) > 0;

  pid  | state  | usename  | blocked_by |           blocked_query            
-------+--------+----------+------------+------------------------------------
 20521 | active | parttest | {20306}    |         ALTER TABLE BASE        +
       |        |          |            |    DETACH PARTITION part_table
       |        |          |            | 
(1 row)

您能否建议我如何解决此问题？