forked from mtusi2026/mtusi2026lab2
73 lines
2.5 KiB
Bash
Executable File
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" |