Total objects per tablespace

Owner Object's type Count
guillaume index 90
guillaume table 47
guillaume table TOAST 16
guillaume view 76
postgres index 46
postgres sequence 13
postgres table 21
postgres table TOAST 2
postgres view 7

SELECT rolname, CASE WHEN relkind='r' THEN 'table' WHEN relkind='i' THEN 'index' WHEN relkind='S' THEN 'sequence' WHEN relkind='v' THEN 'view' WHEN relkind='c' THEN 'type composite' WHEN relkind='t' THEN 'table TOAST' ELSE '' END AS kind, COUNT(*) AS total FROM pg_class, pg_roles WHERE pg_roles.oid=relowner GROUP BY 1, 2 ORDER BY 1, 2