#!/bin/bash
pgwork_setup
set -e
bs -l /tmp/benchmark.run.log
psql -d postgres -t < setup.sql

# Need production build for benchmarking
setbuild prod

cdpg
# Run benchmarks on each commit
git rebase -i --exec "$WorkScriptDir/mesonpg.py $Bug" \
				--exec "$BinDir/pg_ctl restart -D $DataDir -l /tmp/benchmark.run.log" \
				--exec "$ReproDir/benchmark.sh <replace codetag here>"

psql -d postgres -c "copy msmts to '/tmp/pwj_mem_measurements.csv' WITH (format 'csv', header, force_quote (query,time_stamp), delimiter ',');"
psql -d postgres -c "copy (select pwj, num_parts, num_joins, code_tag, avg(plan_mem_used_kb)::bigint avg_planning_memory, avg(planning_time_ms) avg_planning_time, stddev(planning_time_ms) stddev_planning_time, stddev(planning_time_ms)/avg(planning_time_ms) stddev_as_perc_of_avg from msmts group by pwj, code_tag, num_joins, num_parts order by pwj, num_parts, num_joins, code_tag) to '/tmp/avg_numbers.csv' with ( format 'csv', header, delimiter ',');"

ss