#!/bin/sh

if [ "$1" == "-u" ] ; then
	psql -A -l -t | grep -v template0 | awk -F'|' '{print $1}' | xargs -i psql -t -A -F" " -c "select sum(pg_class.relpages), '{}', pg_user.usename from pg_class inner join pg_user on pg_user.usesysid=pg_class.relowner group by pg_user.usename order by sum(pg_class.relpages) desc limit 1" {} | sort -k1,1 -n -r
else
	psql -A -l -t -F: | grep -v template0 | cut -d: -f1 | xargs -i psql -t -A -F" " -c "select sum(relpages),'{}' from pg_class" {} | sort -n -r
fi