Locked workerq table
While trying to revive my hub, I see workerq table getting locked while executing those queries:
update workerq set workerq_reservationid = null where workerq_processtimeout < now() at time zone 'UTC';
select distinct workerq_reservationid from workerq;
Not sure what should I look for ot fix it, but I would love to get some directions.
My workerq is 7354 big.