首先我们通过查询锁表SQLselect * from gp_toolkit.gp_locks_on_relation WHERE lorrelname like '%wpp_cdefect_glass_f%';
,如下图所示,找到lorrelation栏位。下图中查询分区表锁表原因
上图中分区表锁表的lorrelation 是 19908395
select pid from pg_locks where relation='19908395';
查出对应的pid,如下图
再查询pg_stat_activity表查看对应的ip,current_query select *from pg_stat_activity WHERE procpid = '43432'
GreenPlum table lock原因查询,来自那一条SQL
最新推荐文章于 2023-11-21 10:12:06 发布