Files
mtusi2026lab2-fork/scripts/benchmark.sh
2026-10-15 12:52:25 +03:00

73 lines
2.5 KiB
Bash
Executable File

#!/bin/bash
set -e
BASE_URL="http://localhost:8080"
echo "Генерация тестовых данных"
echo "[1/5] Creating user..."
curl -sf -X POST $BASE_URL/api/v1/users \
-H "Content-Type: application/json" \
-d '{"username": "bench_user", "display_name": "Bench", "password": "bench"}' > /dev/null
TOKEN=$(curl -sf -X POST $BASE_URL/api/v1/auth/sessions -u bench_user:bench \
| python3 -c "import sys,json; print(json.load(sys.stdin)['token'])")
echo "✓ Got token"
USER_ID=$(curl -sf $BASE_URL/api/v1/users/me -H "Authorization: Bearer $TOKEN" \
| python3 -c "import sys,json; print(json.load(sys.stdin)['id'])")
echo "[2/5] Creating chat..."
CHAT_ID=$(curl -sf -X POST $BASE_URL/api/v1/chats \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $TOKEN" \
-d "{\"title\": \"Bench Chat\", \"member_ids\": [\"$USER_ID\"]}" \
| python3 -c "import sys,json; print(json.load(sys.stdin)['id'])")
echo " Chat ID: $CHAT_ID"
echo "[3/5] Generating 10000 messages (это займёт ~30 сек)..."
for i in $(seq 1 10000); do
curl -sf -X POST $BASE_URL/api/v1/chats/$CHAT_ID/messages \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $TOKEN" \
-d "{\"text\": \"Message number $i\"}" > /dev/null
# Прогресс каждые 1000
if [ $((i % 1000)) -eq 0 ]; then
echo " ... $i / 10000"
fi
done
echo " 10000 messages created"
COUNT=$(docker compose exec -T postgres psql -U lab2 -d lab2 -tAc "SELECT COUNT(*) FROM messages WHERE chat_id = '$CHAT_ID';")
echo "[4/5] Messages in DB: $COUNT"
echo ""
echo " EXPLAIN (ANALYZE, BUFFERS) для первой страницы "
docker compose exec -T postgres psql -U lab2 -d lab2 <<EOF
EXPLAIN (ANALYZE, BUFFERS)
SELECT id, chat_id, sender_id, text, created_at
FROM messages
WHERE chat_id = '$CHAT_ID'
ORDER BY created_at, id
LIMIT 50;
EOF
echo ""
echo " EXPLAIN (ANALYZE, BUFFERS) для пагинации с курсором "
CURSOR=$(docker compose exec -T postgres psql -U lab2 -d lab2 -tAc \
"SELECT id FROM messages WHERE chat_id = '$CHAT_ID' ORDER BY created_at, id LIMIT 1 OFFSET 50;")
CURSOR_CREATED=$(docker compose exec -T postgres psql -U lab2 -d lab2 -tAc \
"SELECT created_at FROM messages WHERE id = '$CURSOR';")
docker compose exec -T postgres psql -U lab2 -d lab2 <<EOF
EXPLAIN (ANALYZE, BUFFERS)
SELECT id, chat_id, sender_id, text, created_at
FROM messages
WHERE chat_id = '$CHAT_ID' AND (created_at, id) > ('$CURSOR_CREATED', '$CURSOR')
ORDER BY created_at, id
LIMIT 50;
EOF
echo ""
echo "Benchmark completed"