SELECT table_schema AS "Database", SUM(data_length + index_length) / 1024 / 1024 / 1024 AS "Size (GB)" FROM information_schema.TABLES
Read moreSELECT relname AS "relation", pg_size_pretty ( pg_total_relation_size (C .oid) ) AS "total_size" FROM pg_class C
Read moreGet a list of active queries and runtime on PostgreSQL
Read moreFind Objects in Postgres owned by a specific role/user
Read more