#!/bin/sh

set -eux

trap "rm -f *.png" EXIT

# pick the latest extension version installed (might not match the latest PG version installed)
extension=$(ls /usr/share/postgresql/*/extension/pg_statviz.control | tail -n 1)
version=${extension#/usr/share/postgresql/}
version=${version%/extension/pg_statviz.control}

pg_virtualenv -v $version -i '-Atrust' << EOF
  set -eux
  psql -c "create extension pg_statviz" postgres
  psql -c "select pgstatviz.snapshot()" postgres
  psql -c "select pgstatviz.snapshot()" postgres
  psql -c "select pgstatviz.snapshot()" postgres
  pg_statviz -d postgres -h \$PGHOST -p \$PGPORT -U \$PGUSER
EOF

ls -l *.png
