Hello Aditya,
How many connections do you have on your PostgreSQL cluster? And, do your webserver and database service run on the same machine/VM?
I would check system logs on the server on which PostgreSQL cluster run.
Best regards.
Samed YILDIRIM
On Wed, 1 Mar 2023 at 22:40, aditya desai <admad123@xxxxxxxxx> wrote:
Hi All,Unfortunately I am unable to share a query plan or query.I have a SQL which is getting called from a web service. At a certain point where it inserts data in the table . Process is going in a hung state. pg_stat_activity shows wait_even='IPC' , wait_even_type=MessageQueueSend. In Webservice log we see I/O error occurred message.Surprisingly when I run it from PSQL or pgadmin it runs fine.Has anyone come across this issue? Could you please help?Regards,Aditya.