Hello guys - I'm looking at anything that could he...
# orm-help
k
Hello guys - I'm looking at anything that could help with Idle connection management I'm running off Digital Ocean managed PGSQL db and whenever I use
$transaction
it leaves an idle connection afterwards. Code looks like that:
Copy code
const [items, count] = await this.prisma.$transaction([
      this.prisma.user.findMany({ ...args, include: userIncludes }),
      this.prisma.user.count({ where: computedWhere }),
    ]);
👀 1
n
Hello @Kevin Lanthier 👋 Can you enable prisma metrics and check the number of idle connections? This should give insights on how many connections are idle/open/active, this should be helpful in further debugging this.
k
here's some details
I use PGBouncer and I have a pool size of 30. Sounds like i'm always capped in open/idle
v
👋 Hello @Kevin Lanthier - this is just to let us know if we haven't forgotten about this. @Nurul is still actively working on this and we'll get back to you asap. Thank you for your patience! 🙏 😊