Forums

Application Response Slow down suddenly with multiple app

there are 5 apps running on Python anywhere, and they are almost slow for the last 20 minutes. what can be the reason??

its looks like that issue with the database Postgres SQL because when we are loading a page without data then there is no delay but when we try to get any record even a single one from the database then the response is too slow

FATAL: sorry, too many clients already

It sounds like you have lots of open connections to your server, and perhaps that is bogging it down. A quick "fix" to clear those down would be to reload the website using the button on the "Web" page, but in the longer term you'd need to check your code to see if you've got some places where you are opening database connections and not closing them, because that would cause issues like the one you're seeing.

I have the same issue on my instance i think the problem is global not only on smarsoft instance (i'm not the same client)

there were only two console open at the time I just close them but application's response is not as in past

@intuition I don't think it can be the same problem with you -- your Postgres server is on a completely different machine to @smartssoft, and your server is almost completely idle.

@smartssoft if your website code is connecting to Postgres, then it will have connections open too. Have you tried reloading it?