#!/bin/bash
# Check open connections on postgres-shared

echo "=== PostgreSQL Connection Summary ==="
docker exec postgres-shared psql -U postgres -c "SELECT count(*) AS total_connections FROM pg_stat_activity;"

echo "=== Connections by Database/User/State ==="
docker exec postgres-shared psql -U postgres -c "SELECT datname AS database, usename AS user, state, count(*) FROM pg_stat_activity GROUP BY datname, usename, state ORDER BY count DESC;"