forked from mtusi2026/mtusi2026lab2
27 lines
1.5 KiB
Bash
Executable File
27 lines
1.5 KiB
Bash
Executable File
#!/usr/bin/env bash
|
|
# Сидирует >=10 000 сообщений и снимает EXPLAIN (ANALYZE, BUFFERS) запроса истории.
|
|
# Запуск до и после миграции b7e1f3a9c2d4 даёт сравнение "до/после" для REPORT.md.
|
|
set -euo pipefail
|
|
cd "$(dirname "$0")/.."
|
|
mkdir -p evidence
|
|
OUT="${1:-evidence/explain_history.txt}"
|
|
PSQL="docker compose exec -T db psql -U postgres -d messenger_db"
|
|
CHAT="00000000-0000-0000-0000-0000000000c1"
|
|
|
|
$PSQL < scripts/seed_explain.sql >/dev/null
|
|
|
|
# Курсор из середины истории: сообщение №6000 целевого чата
|
|
MID=$($PSQL -At -c "SELECT created_at || '|' || id FROM messages WHERE chat_id='$CHAT' ORDER BY created_at, id OFFSET 5999 LIMIT 1")
|
|
TS="${MID%%|*}"; ID="${MID##*|}"
|
|
|
|
{
|
|
echo "== $(date -u +%FT%TZ) =="
|
|
echo "== версия миграции =="; $PSQL -At -c "SELECT version_num FROM alembic_version"
|
|
echo "== индексы messages =="; $PSQL -c "\d messages"
|
|
echo "== сообщений по чатам =="; $PSQL -c "SELECT chat_id, count(*) FROM messages GROUP BY 1"
|
|
echo "== первая страница =="
|
|
$PSQL -c "EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM messages WHERE chat_id='$CHAT' ORDER BY created_at, id LIMIT 51"
|
|
echo "== страница из середины (keyset, как в API) =="
|
|
$PSQL -c "EXPLAIN (ANALYZE, BUFFERS) SELECT * FROM messages WHERE chat_id='$CHAT' AND (created_at, id) > ('$TS'::timestamptz, '$ID'::uuid) ORDER BY created_at, id LIMIT 51"
|
|
} | tee "$OUT"
|