supabase / supavisor / 23350707006

82%

Build Type

push

github

Committed by web-flow

Commit Message

feat: add pool connection metrics for idle and checked-out connections (#885)

## Summary
- Adds new Prometheus metrics to track pool connection states per tenant
- Tracks both idle and checked-out (busy) connections across all pool
workers
- Provides better visibility into pool utilization and connection health

## Changes
- Added `concurrent_pool_connections/1` polling metric with two gauges:
  - `supavisor_pool_connections_checked_out`: count of busy connections
  - `supavisor_pool_connections_idle`: count of available connections
- Implemented `execute_pool_metrics/0` to aggregate connection states
from all pool workers
- Added `emit_pool_telemetry/1` to emit telemetry events with tenant
metadata
- Comprehensive test coverage for transaction mode (idle and checked-out
states) and session mode

🤖 Generated with [Claude Code](https://claude.com/claude-code)

---------

Co-authored-by: Claude Sonnet 4.5 <noreply@anthropic.com>
Co-authored-by: Copilot <175728472+Copilot@users.noreply.github.com>

Run Details

13 of 13 new or added lines in 1 file covered. (100.0%)

1 existing line in 1 file now uncovered.

2566 of 3114 relevant lines covered (82.4%)

59247.59 hits per line