I was faced with interesting problem. Which schema, in my DB, uses the most disk space? Theoretically it's trivial, we have set of helpful functions:
- pg_column_size
- pg_database_size
- pg_indexes_size
- pg_relation_size
- pg_table_size
- pg_tablespace_size
- pg_total_relation_size
But in some cases it becomes more of a problem. For example – when you have thousands of tables …