collect-wait-events.sh

#!/bin/bash

while /bin/true; do

	psql -t -A -c 'select extract(epoch from now()), wait_event_type, wait_event, count(*) from pg_stat_activity group by 1, 2, 3' test

	psql -t -A -c 'select pg_sleep(0.1)' test > /dev/null 2>&1

done