hm ok, thank you Tom. As you mentioned, I think it is not really possible to find out which of the sessions should be there and which not. Also, as it is a Cloud SQL instance in GCP, I don't have access to a user with superuser attributes.
Best regards, Tobias On Wed, 3 Mar 2021 at 17:33, Tom Lane <t...@sss.pgh.pa.us> wrote: > Tobias Lott <tobias.l...@devoteam.com> writes: > > There were no crashes of the instance, but some issues with the connected > > application, resulting in 'could not receive data from client: Connection > > reset by peer' and 'unexpected EOF on client connection with an open > > transaction'. > > No, that sort of thing would still allow the backend to shut down cleanly. > > > So if this might have left behind temp tables causing the errors, should > I > > try to delete these pg_temp tables? > > It would definitely be worth looking around to see if you have any temp > tables that shouldn't be there. I think you can just do > \dt pg_temp_*.* > in psql (as superuser) to see what's out there. Figuring out which ones > are live sessions' temp tables might be harder, though. > > regards, tom lane > -- Tobias Lott Technical Consultant Region South West +49 151 23649035 <+49+151+23649035> tobias.l...@devoteam.com [image: Banner EVP Intelligence] [image: Devoteam at Linkedin] <https://www.linkedin.com/company/devoteam> [image: Devoteam at Youtube] <https://www.youtube.com/watch?v=Lrk4lQJ82bI&t=3s> [image: Devoteam at Twitter] <https://twitter.com/devoteam>
