All odoo http workers stuck in the below query suddenly for a long time

SELECT "ir_mail_server"."id" as "id","ir_mail_server"."name" as "name","ir_mail_server"."smtp_host" as
"smtp_host","ir_mail_server"."smtp_port" as "smtp_port","ir_mail_server"."smtp_user" as "smtp_user","ir_mail_server"."smtp_pass" as "smtp_pass","ir_mail_server"."smtp_encryption" as "smtp_encryption","ir_mail_server"."smtp_debug" as
"smtp_debug","ir_mail_server"."sequence" as "sequence","ir_mail_server"."active" as "active","ir_mail_server"."smtp_from" as "smtp_from","ir_mail_server"."domain_whitelist" as "domain_whitelist","ir_mail_server"."company_id" as "company_id","ir_mail_server"."reply_to"
as "reply_to","ir_mail_server"."create_uid" as "create_uid","ir_mail_server"."create_date" as "create_date","ir_mail_server"."write_uid" as "write_uid","ir_mail_server"."write_date" as "write_date" FROM "ir_mail_server" WHERE "ir_mail_server".id IN (2)

PG logs shows that the query in ClientRead and it is idle in trans.

Webclient is not accesible during this. I had to restart odoo to get services resumed. Not sure about the right approach in fixing this issue.

I'd appreciate any help