Re: INSERT statement going in IPC Wait_event

2023-03-11 Thread Samed YILDIRIM
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 wr

Re: INSERT statement going in IPC Wait_event

2023-03-01 Thread Andrew Dunstan
On 2023-03-01 We 15:40, aditya desai 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='I

INSERT statement going in IPC Wait_event

2023-03-01 Thread aditya desai
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 Webserv