Prisma•2w ago

Postgresql freezing, have to restart the app to unfreeze

Hello, I am using NestJS + Prisma + PostgreSQL to develop my app, I am having problems which I can't find cause of issues yet, my app is freezing Postgresql so I have to restart the app to unfreeze, how can I avoid it atleast it must not freeze PostgreSQL

3 Replies

RaphaelEtim•2w ago

Hi @brain.implode Do you have any long running queries in your app? Can you run this code to see running queries and active connections?

SELECT * FROM pg_stat_activity WHERE state != 'idle';

SELECT * FROM pg_stat_activity WHERE state != 'idle';

brain.implodeOP•2w ago

Hello, the problem is while it is occurring I can't access postgresql (by adminer), so I can't do it, not sure that I can do it with psql I will try it.

RaphaelEtim•2w ago

It may be possible to connect using psql. Let me know if you can

Gaming

Programming

Postgresql freezing, have to restart the app to unfreeze