#!/bin/bash
# Time archive_command_jobs clearing a WAL backlog.
#
# Usage: PGBIN=/path/to/bin ./archive_jobs_bench.sh [rounds] [points]
#   rounds  default 3
#   points  delay_ms/jobs list, default "500/1 500/2 500/4 500/8"
# Env: PGBIN WORKDIR KEEP FILES PORT
set -eu -o pipefail
rounds=${1:-3}
if [ $# -ge 2 ]; then
  shift
  points="$*"
else
  points="500/1 500/2 500/4 500/8"
fi
FILES=${FILES:-16}
PORT=${PORT:-56789}
if [ -n "${PGBIN:-}" ]; then export PATH=$PGBIN:$PATH; fi
for b in initdb pg_ctl postgres psql; do
  command -v $b >/dev/null || { echo "$b not found (set PGBIN)" >&2; exit 1; }
done

if [ -n "${WORKDIR:-}" ]; then
  R=$WORKDIR
  mkdir -p "$R"
else
  R=$(mktemp -d "$PWD/archjobs.XXXXXX")
fi
S=$R/sock
A=$R/archive
mkdir -p "$S" "$A"
export PGOPTIONS="-c client_min_messages=warning"
q() { psql -X -q -At -h "$S" -p "$PORT" -d postgres -v ON_ERROR_STOP=1 "$@"; }
stop() {
  pg_ctl -D "$R/data" -m immediate stop >/dev/null 2>&1 || true
  if [ "${KEEP:-0}" = 1 ]; then echo "# kept $R"; else rm -rf "$R"; fi
}
trap stop EXIT

cat >"$R/arch.sh" <<'EOF'
#!/bin/bash
set -eu
DELAY=$1; DEST=$2; SRC=$3; NAME=$4
if [ "$DELAY" != 0 ] && [ "$DELAY" != 0.0 ]; then sleep "$DELAY"; fi
exec cp -- "$SRC" "$DEST/$NAME"
EOF
chmod +x "$R/arch.sh"

initdb -A trust -N -D "$R/data" >/dev/null
cat >>"$R/data/postgresql.conf" <<EOF
port = $PORT
unix_socket_directories = '$S'
listen_addresses = ''
archive_mode = on
archive_command = ''
archive_command_jobs = 1
wal_level = replica
max_wal_senders = 0
fsync = off
synchronous_commit = off
full_page_writes = off
autovacuum = off
EOF
pg_ctl -D "$R/data" -l "$R/pg.log" -w start >/dev/null
if ! q -c 'SHOW archive_command_jobs' >/dev/null 2>&1; then
  echo "server lacks archive_command_jobs (wrong PGBIN?)" >&2; exit 1
fi
q -c 'CREATE TABLE t(i int)'
echo "# $(postgres --version); $(nproc) CPUs; rounds=$rounds FILES=$FILES"
echo "# workdir $R"

drain() {
  local delay_ms=$1 jobs=$2
  local delay_sec before want t0 t1 failed n
  delay_sec=$(awk -v m="$delay_ms" 'BEGIN { printf "%.3f", m / 1000 }')

  q -c "ALTER SYSTEM SET archive_command TO ''"
  q -c "SELECT pg_reload_conf()" >/dev/null
  sleep 0.1
  rm -f "$A"/*
  before=$(q -c 'SELECT archived_count FROM pg_stat_archiver')
  n=0
  while [ "$n" -lt "$FILES" ]; do
    q -c 'INSERT INTO t VALUES (1); SELECT pg_switch_wal()' >/dev/null
    n=$((n + 1))
  done

  q -c "ALTER SYSTEM SET archive_command TO \$\$$R/arch.sh $delay_sec $A %p %f\$\$"
  q -c "ALTER SYSTEM SET archive_command_jobs TO $jobs"
  q -c "SELECT pg_reload_conf()" >/dev/null
  until [ "$(q -c "SELECT count(*) FROM pg_stat_activity WHERE backend_type = 'archiver'")" = 1 ]
  do sleep 0.05; done

  want=$((before + FILES))
  t0=$(date +%s.%N)
  while :; do
    if [ "$(q -c 'SELECT archived_count FROM pg_stat_archiver')" -ge "$want" ]; then
      break
    fi
    failed=$(q -c 'SELECT failed_count FROM pg_stat_archiver')
    if [ "$failed" -gt 0 ]; then
      echo "drain failed (failed_count=$failed). See $R/pg.log" >&2
      exit 1
    fi
    sleep 0.05
  done
  t1=$(date +%s.%N)

  awk -v r="$round" -v d="$delay_ms" -v j="$jobs" -v a="$t0" -v b="$t1" -v n="$FILES" 'BEGIN {
    printf "DRAIN round=%d delay_ms=%d jobs=%d files=%d secs=%.3f files_per_s=%.2f\n",
           r, d, j, n, b - a, n / (b - a) }'
}

pts=($points)
out=$R/drains.txt
: >"$out"
for round in $(seq "$rounds"); do
  order=("${pts[@]}")
  if [ $((round % 2)) = 0 ]; then
    order=()
    for ((i = ${#pts[@]} - 1; i >= 0; i--)); do order+=("${pts[$i]}"); done
  fi
  for pt in "${order[@]}"; do
    delay_ms=${pt%%/*}
    jobs=${pt##*/}
    drain "$delay_ms" "$jobs" | tee -a "$out"
  done
done

echo "# summary"
python3 - "$out" <<'PY'
import sys
from collections import defaultdict
from statistics import median

rows = defaultdict(list)
for line in open(sys.argv[1]):
    if not line.startswith('DRAIN'):
        continue
    parts = dict(p.split('=', 1) for p in line.split()[1:])
    key = (int(parts['delay_ms']), int(parts['jobs']))
    rows[key].append(float(parts['secs']))

for delay, jobs in sorted(rows):
    vals = rows[(delay, jobs)]
    med = median(vals)
    base_vals = rows.get((delay, 1))
    if base_vals and med > 0:
        speedup = f'{median(base_vals) / med:.2f}x'
    else:
        speedup = 'n/a'
    print(
        f'delay_ms={delay} jobs={jobs} '
        f'median={med:.3f}s n={len(vals)} vs jobs=1={speedup}'
    )
PY
