Redshift - Table rows by schema

tablerowsbyschema.sql

SELECT trim(pgdb.datname) AS DATABASE
	,trim(pgn.nspname) AS SCHEMA
	,trim(a.NAME) AS TABLE
	,b.mbytes
	,a.rows
FROM (
	SELECT db_id
		,id
		,NAME
		,sum(rows) AS rows
	FROM stv_tbl_perm a
	GROUP BY db_id
		,id
		,NAME
	) AS a
JOIN pg_class AS pgc ON pgc.oid = a.id
JOIN pg_namespace AS pgn ON pgn.oid = pgc.relnamespace
JOIN pg_database AS pgdb ON pgdb.oid = a.db_id
JOIN (
	SELECT tbl
		,count(*) AS mbytes
	FROM stv_blocklist
	GROUP BY tbl
	) b ON a.id = b.tbl
WHERE trim(pgn.nspname) = 'sat'
ORDER BY mbytes DESC
	,a.db_id
	,a.NAME;