#! /bin/bash

DBNAME="test"
TABLE="test_table"
OUTPUT="patched_collect_visibility_data_no_OS_cache_wip.txt"
N=100

psql -c "CREATE EXTENSION IF NOT EXISTS pg_visibility;" ${DBNAME}
psql -c "DROP TABLE IF EXISTS ${TABLE}; CREATE TABLE ${TABLE} as select repeat('a', 100) || i || repeat('b', 500) as filler from generate_series(1, 9000000) as i;" ${DBNAME}
rm -f ${OUTPUT}

for i in $( seq 1 ${N} )
do
    # drop_OS_cache;
    psql -c "SELECT * FROM pg_visibility('${TABLE}'::regclass) where blkno = -1;" ${DBNAME} | grep 'Time' | awk -F ' ' '{print $2}' >> ${OUTPUT};
done