Files
qrtx c1fec73ccc perf(bench): add scaling experiments and saturation diagnostics
Compare API and PostgreSQL CPU budgets and connection pool limits. Collect repeatable measurements and generate report aggregates and graphs.
2026-10-29 11:49:51 +03:00

71 lines
2.8 KiB
Bash
Executable File

#!/bin/sh
# One persistent docker exec per service; stdout contains only numeric diagnostics.
set -eu
role=$1
stop=$2
watch_pid=''
cleanup() {
if [ -n "$watch_pid" ]; then
kill "$watch_pid" 2>/dev/null || true
wait "$watch_pid" 2>/dev/null || true
fi
}
trap cleanup EXIT
trap 'exit 0' TERM INT
printf '{"kind":"observer","version":3,"time_ms":%s000}\n' "$(date +%s)"
if [ "$role" = postgres ]; then
PGAPPNAME=scaling-observer psql -X -qAt -v ON_ERROR_STOP=1 -U "$POSTGRES_USER" -d "$POSTGRES_DB" > "${stop}.pg.jsonl" <<'SQL' &
SELECT json_build_object(
'kind', 'postgres', 'time_ms', (extract(epoch FROM clock_timestamp())*1000)::bigint,
'activity', (SELECT coalesce(json_agg(a), '[]'::json) FROM (
SELECT state, wait_event_type, wait_event, count(*) AS count,
max(extract(epoch FROM clock_timestamp()-query_start)) FILTER (WHERE state = 'active') AS max_active_seconds
FROM pg_stat_activity WHERE datname=current_database() AND backend_type='client backend'
AND application_name <> 'scaling-observer'
GROUP BY state,wait_event_type,wait_event
) a),
'db', (SELECT row_to_json(d) FROM (
SELECT xact_commit,xact_rollback,blks_read,blks_hit,temp_files,temp_bytes,deadlocks,stats_reset
FROM pg_stat_database WHERE datname=current_database()
) d)
)::jsonb
\watch 2
SQL
watch_pid=$!
fi
while [ ! -f "$stop" ]; do
stamp="$(date +%s)000"
awk -v stamp="$stamp" '
BEGIN {printf "{\"kind\":\"cgroup\",\"time_ms\":%s", stamp}
FILENAME ~ /cpu.stat$/ {printf ",\"cpu_%s\":%s", $1, $2}
FILENAME ~ /memory.events$/ {printf ",\"memory_%s\":%s", $1, $2}
FILENAME ~ /memory.current$/ {printf ",\"memory_bytes\":%s", $1}
END {print "}"}
' /sys/fs/cgroup/cpu.stat /sys/fs/cgroup/memory.events /sys/fs/cgroup/memory.current
if [ "$role" = postgres ]; then
awk -v stamp="$stamp" '
BEGIN {printf "{\"kind\":\"host\",\"time_ms\":%s", stamp}
FILENAME ~ /pressure\// {
name=FILENAME; sub(/^.*\//,"",name)
for (i=2;i<=NF;i++) {
split($i,value,"=")
if (value[1] == "total") printf ",\"%s_%s_total_usec\":%s",name,$1,value[2]
}
}
FILENAME ~ /meminfo$/ && ($1 == "MemAvailable:" || $1 == "SwapFree:" || $1 == "SwapTotal:") {
name=$1; sub(/:$/,"",name); printf ",\"%s_kib\":%s",name,$2
}
END {print "}"}
' /proc/pressure/cpu /proc/pressure/memory /proc/pressure/io /proc/meminfo
fi
if [ "$role" = nginx ]; then
awk -v stamp="$stamp" '
BEGIN {printf "{\"kind\":\"upstream\",\"time_ms\":%s,\"servers\":[", stamp; sep=""}
/^server .*:8080 / {printf "%s\"%s\"", sep, $2; sep=","}
END {print "]}"}
' /etc/nginx/ready-upstreams.conf
fi
sleep 2
done
rm -f "$stop"