[Backend] pg-pool.ts does not expose pool metrics (total/idle/waiting) to the admin metrics endpoint

[grantfox-oss]

Join our community: https://t.me/+DOylgFv1jyJlNzM0

Why this matters

backend/src/lib/pg-pool.ts creates the raw pg.Pool used alongside Prisma, but its connection metrics are never surfaced anywhere, making it hard to diagnose connection exhaustion in production without shelling into the box.

Acceptance criteria

• Expose pool.totalCount/idleCount/waitingCount via a small getter
• Surface these values in the existing admin metrics response

Files to touch

• backend/src/lib/pg-pool.ts
• backend/src/routes/v1/admin.routes.ts

Out of scope

Does not add a new monitoring/alerting integration.

[altbigdom]

@altbigdom has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

hi, i would love to work on this

ℹ️ Repo Maintainers: To accept this application, review their application or assign @altbigdom to this issue.

[Smartdevs17]

@Smartdevs17 has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

can I work on this?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Smartdevs17 to this issue.

[drips-wave]

Congratulations, @Smartdevs17! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @Smartdevs17: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Official Campaign | FWC26 campaign!

@Smartdevs17's PR #1130 was approved and merged by @ogazboiz.

🏆 @Smartdevs17: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (834 total points). Track your full progress on GrantFox.

👏 Great work, @Smartdevs17! Keep contributing to LabsCrypt.

[drips-wave]

This issue has been completed by @Smartdevs17 as part of the Stellar Wave Program's 7th Wave 🥳

😎 @Smartdevs17: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.