#!/usr/bin/env bash
set -euo pipefail
ssh -o BatchMode=yes eventhub-ift bash -s <<'REMOTE'
set -euo pipefail
cd /opt/ai-router-stack
set -a; source .env; set +a
PG=$(docker ps -q -f name=ai-router_postgres | head -1)
docker exec -e PGPASSWORD="$POSTGRES_PASSWORD" "$PG" \
  psql -U "${POSTGRES_USER:-litellm}" -d "${POSTGRES_DB:-litellm}" -c "
SELECT \"startTime\", status, model, call_type,
       left(coalesce(metadata::text,''), 400) AS metadata,
       left(coalesce(response::text,''), 300) AS response
FROM \"LiteLLM_SpendLogs\"
ORDER BY \"startTime\" DESC
LIMIT 15;
"
REMOTE