mccun934 · February 7, 2018 16:14
diff --git a/object-sizes.bash b/object-sizes.bash
 #!/bin/bash


 SIZES="SELECT relname AS objectname,
   relkind AS objecttype,
   reltuples AS "entries", pg_size_pretty(relpages::bigint*8*1024) AS size
   FROM pg_class
   WHERE relpages >= 8
   ORDER BY relpages DESC;"
   
 echo $SIZES | sudo -i -u postgres psql -d foreman
	#!/bin/bash


	SIZES="SELECT relname AS objectname,
	relkind AS objecttype,
	reltuples AS "entries", pg_size_pretty(relpages::bigint81024) AS size
	FROM pg_class
	WHERE relpages >= 8
	ORDER BY relpages DESC;"

	echo $SIZES \| sudo -i -u postgres psql -d foreman