Secondly I see a lot of ClientRead Idle connections in my postgres db. The query has been idle for 2 to 26 hours, wait_event is clientread. They are select which i run using queryRawUnsafe

Prisma Client opens connections (up to the connection pool size), and then keeps them around as long as they are healthy so they are ready to use as fast as possible.